Skip to Content
0
Former Member
Aug 09, 2010 at 09:00 AM

Single invoice and multi line itms sum total qty/net value grp by material

83 Views

Hi Experts,

Would appreciate anyone advice me

My user wanted to display in VF01 and printout invoice sum up all the material quantity and net value group by material number from multiple sales order and delivery order at item level.

example :

Qty Net Value

Material A 1 10.00

Material B 2 40.00

Material A 3 30.00

Material B 4 80.00

RESULT

Qty Net Value

Material A 4 40.00

Material B 6 120.00

1) I am able to display in VF01 by entering my D/O and S/O numbers in document number column.

2) I click billing document overview button then i am able to view all line items.

How to configure? where i had tried the billing configuration

Copying control: Delivery document to billing document F2-->LF

ZTAD

Copying requirements 004 Deliv-related item

Data VBRK/VBRP 001 Inv.split (sample)

TAN

Copying requirements 004 Deliv-related item

Data VBRK/VBRP 007 Inv.Split (Rec/Div)

Thanks & Regards,

Yong Kok Wah