Hi Expert,
My client who required the customer statement for particular day. In SAP we get the standard customer balance statement report which is not satisfied the client requirement.
Client wants Date, Customer, Debit, Credit, and due balance in single line item. The scenario is explained by given an example as below:
For example:
1) 01.01.2009 u2013 Customer (AG0001) - SD invoice amount Rs. 10000/- - Document type u2013 R1 u2013 Open item
2) 01.01.2009 u2013 Customer (AG0001) - SD invoice amount Rs. 5000/- - Document type u2013 R1 u2013 Open item
It shows me two invoices as on date 01.01.2009. On the same date the customer give cash of Rs.12000/- & remaining of Rs.3000/- later as on 02.01.2009. For that Cash receipt (incoming payment) I had create a separate document type (DW) & made the entries.
I have received Rs.12000/- as cash against the invoice. At the time of clearing I had cleared the full amount of Rs. 10000/- from the first invoice line item & from the second line item cleared the remaining Rs.2000/- & it create one clearing document number for both the line item.
The entry display like as:
40 u2013 Cash or Bank Account (Debit)
15 u2013 Customer Account (Credit Incoming payment)
15 u2013 Customer Account (Credit Incoming payment)
It shows me posting as cash payment received with posting key 40 against customer. & I have to link the table for this cash receipt amount with customer & with the help creating customer statement. I didnu2019t get idea how to map this with customer because the Bank or Cash account which are debit balance & the amount is dumped in to the Cash or Bank GL account which is having 40 Posting key which is display in BSEG But not in BSAD table. Because of this I didnu2019t get the actual cash received amount against customer invoice.
Please help me to overcome this issue.
Warm regards,
Dhananjay Rahane.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.