Consolidating Deliveries to an Invoice

[Former Member]

My customer is looking to consolidate all deliveries to the same BP in a single monthly invoice.  Yes, this is fairly simple using the Draw Document Wizard.

However, when consolidating in this manner, a few of their BP's are requiring that the Item No be consolidated, also.  For example, if Item A was delivered on 3 different delivery notes, they are requiring that Item A show up in only 1 line (Qty 3) on the invoice. The Draw Document Wizard appears to just copy the rows from each DN to the Invoice--which potentially results in multiple lines with the same Item No.

I realize this is probably due to a requirement to keep relationships between document rows straight, but is there an SAP workaround that will allow my customer to fulfill their BP's requirements?

SAP version 9.1 PL 4

Randy

[frank_wang6 · Accepted solution]

Not possible, all invoice lines has to have one base delivery line. it can not have multiple base lines.

Frank

[former_member212181]

Hi Ranbdy,

As Frank and Nagarajan said, consolidation of various rows of Delivery to a single row in AR Invoice is not possible by keeping relation ship.

As a work around, you can do grouping of Item code in print layout design, if law permits.

Thanks

Unnikrishnan

[kothandaraman_nagarajan]

Hi,

Yes your reason is correct. You may need SDK help to meet above requirement.

Thanks.

[frank_wang6]

It is even not possible through SDK, unless u dont want to keep the link the delivery and invoice.

Frank