on 2020 Feb 13 4:06 PM
Hi Experts,
is there an AR report that will show me all of the AR collections that happened between a specific time? Something kind of like the example below:
AR Collections Report
AR Collections Between 1/1/2020 - 2/14/2020
Customer Invoice Number PO Number Invoice date Due Date Amount Due Amount Collected Amount Open Collection Date
ABC 123 PO123 11/15/2019 12/15/2019 1,000 -950.00 50.00 2/5/2020
XYZ 321 PO 321 12/15/2019 1/14/2020 2,000 -2,000 0.00 1/15/2020
Thanks for your time.
Kind Regards,
-Mark-
Request clarification before answering.
Hi Mark,
Depending on how sales order information is populated on FI line items, it may be possible to get a sales order wise (XBLNR?) summarized report in FBL3H. After exporting to excel, with some pivot tools, the desired collections report can be prepared.
Thanks
Manoj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
122 | |
8 | |
8 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.