LIS (Actual "Net Value")

[Former Member]

I have created a LIS. It works well. However, my customer would like me to add one more column; that value subtract between "Net inv. sales 1" and "Net crd memos 1". I looking for all standard columns in LIS. I didn't see its value. Could anyone suggest me how to get this column?

P.S

"Net inv. sales 1" -> its value is "Net Value" from Invoice and Debit Note

"Net crd memos 1" -> its value is "Net Value" from Credit Memo.

Thanks,

Prach

[Former Member · Accepted solution]

HI

Add a new column and assign a formula for the new calculated value -

note: an example formula for free of cost value -

11 *check if FOC-Item

12

13 if not ( mcvbrp-aubel is initial ) and

14 not ( mcvbrp-aupos is initial ).

15

16 select single * from vbak

17 where vbeln = mcvbrp-aubel.

18

19 if sy-subrc = 0.

20 if vbak-auart = 'KL'. "FOC

21 select single * from vbap

22 where vbeln = mcvbrp-aubel

23 and posnr = mcvbrp-aupos.

24 if sy-subrc = 0.

25 if vbap-pstyv = 'KLN' "FOC Item

26 or vbap-pstyv = 'XX'. "FOC to Cost Center

27

28 formula_value = 0. "Set Amt = 0

29 exit.

30

31 endif.

32 endif.

33 endif.

34 endif.

35 endif.

[Former Member]

Thx for sharing idea.

I have solved this problem. We can set column "Credit Memo 2" in both rule; that are, rule "1" and rule "2".

- Info structure + Rule "1" update when system process "invoice" and "debit memo"

- Info structure + Rule "2" update when system process "credit memo".

Thus, column "credit memo 2" will subtract value between "invoice" and "cn". It is gonna be "actual net value".

Thanks,

Prach