LIS Credit Memo

[Former Member]

In MCSI we have our own customized info structure S991.In the present system, Credit Memo values are getting updated in Gross Credit Memo column. Our client wants the Credit Memo value to be updated in Gross Inv sales Column. In Gross invoice column we will find all invoice value including debit memo value.

In the same way we need to map the credit memo values in Gross Inv sales column instead of Gross Credit Memo field.

The purpose of the above requirement is to find the sum off total invoice Value in one column. Presently all invoice values and debit memo values it getting captured in Sales Invoice sales Column, in the same way credit memo value should also be captured on the same.

Please through some light if any one come across

Babu

[gilmarluiz_puntel · Accepted solution]

Hi,

One of the characteristic (key table) of your structure is the invoice number?

[Former Member · Accepted solution]

yes . Credit memos gross is MCVBRK (source table) and VBELN (source feild).

[gilmarluiz_puntel]

Hi,

You need to create you SIS Formula with an abaper:

Logistics - General -> Logistics Information System (LIS) -> Logistcs Data Warehouse -> Updating -> Updating Definition -> Specific Definition Using Update Rules -> Maintain Formulas.

Then, you need to associate it to your info structure:

Logistics - General -> Logistics Information System (LIS) -> Logistcs Data Warehouse -> Updating -> Updating Definition -> Specific Definition Using Update Rules -> Maintain Update Rules.

Regards,

[SmileZhang]

Hi Babu,

You need to adjust the updating rules and creating your own requirement routine to make difference between different blling documents.

Best regards,

Smile