Forum Discussion

Rocky2121's avatar
Rocky2121
Frequent Visitor
2 years ago

Accounts Receivable Report

I am pulling in data from SAP and the ACDOCA table in Power Bi via Synapse. The purpose of the report is to compile all Customer Invoices and related entries from SAP. I have Customer, Document Number, Document Type, Clearing Date, Net Due Date and Document Date. I want to create a similar view to the t-code FB03 in SAP. This captures customer invoice, payments applied, dispute items, etc. The goal would be to see the original customer invoice rolled up with all the other related documents to see the outstanding balance.

 

The issue I am facing is I am not sure what field I can use in power BI to that would allow me to tie the original Customer to the payments and dispute documents. If anyone has experience with something similar, any advice would be helpful.

1 Reply

  • Rocky2121 , I think this is more a functional SAP question, than Power BI. Your Internal functional SAP consultant should be able to tell that.