Generate a consolidated billing document for many transaction done per day

[Former Member]

Hello everyone,

This is the first time I am working in SD module, otherwise I have worked in HR module only.My requirement is like this :

Currently billing document is created per shipment. A customer can receive multiple billing documents per day when there are multiple shipments happened for the day. My requirement is to combine multiple shipments per Bill-To customer partner per day with the same payment terms and create one financial billing document.

Plz tell me how I should proceed. Plz give the detail ideas as first time I am working in SD module. If possible plz suggest me how I can learn to work in SD module.

[Former Member · Accepted solution]

Invoice Lists sounds like It'll fulfill your requirement:

http://help.sap.com/erp2005_ehp_04/helpdata/EN/dd/561129545a11d1a7020000e829fd11/frameset.htm

[Former Member]

Hi,

As per my understanding of your requirement, you may opt for a report from standard tables VBRK, VBFA and VBPA, get all the billing documents created on a particular date from VBRK along with necessary data like terms of payment details, pass the billing document number in VBFA to fetch the preceding sales document number, and with the help of the sales document number in vBPA get the Bill to party.

Create an output for the report so as to map your requirement.

Cheers

Chandra