How to make your Customer collection report using SAP standard procedure:
Without doing any additional ABAP development we can still do it in standard SAP using FBL5N report and its every easy way to identify all the entries at a single report which will helpful in daily business activities.
Please find the below step by step guide for tracking the customer payments against allocation of receipts.
Steep 1. Post FI customer invoice t.code FB70:
Step 2: Document overview display in FB03:
(Post the same way 2 more invoices in FB70)
Step 3: display customer line item display FBL5N:
step 4: Update assignment for the open invoices:
Give any unique text in the assignment field.
Post incoming payment F-28:
select other option and click on process open item:
here will get a pop new screen with below details, select Assignment here.
click on process open item:
Give assignment text in the from tab and select process open item tab as showed in below:
make partial payment or full payment as per your requirement and assign for all the invoices or we can assign individually also:
Go to document–>select simulate:
Save and display the same.
display Customer all items in FBL5N:
In the below screen you can see the receipt invoices got allocated to the associated invoices partially.
the same way you can clear the pending due balances. then the clearing document will generate for all the invoices:
make one more payment for all the due balance f–28:
save and open customer all item display: FBL5N
In the above screen we can see the clearing document number will be assigned to all the allocated invoices.
Similar way you can test the other scenarios like bellow:
1. Single partial payment against multiple open invoices in collection report
2. FBL5N report will match as per the collections
3. Multiple partial payment against multiple open invoices in the customer account
4. Balance written off with multiple partial payments
5. Partial written off with multiple invoices
6. Excess payment against the invoice which is already settled fully.
7. Full cancellation.
your comments are appreciated and this is my first blog.