cancel
Showing results for 
Search instead for 
Did you mean: 

AR Payments Received

former_member637448
Discoverer
0 Kudos
130

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-

Accepted Solutions (0)

Answers (1)

Answers (1)

manoj_vm_desai
Participant
0 Kudos

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