Payments recieved against Sale Order .
I am currently working on a BI report , which would require the payments that are recieved against a Sale order. As I am not very good in the Functional aspects, I have been struggling to find out .Request you to give me on how this can be handled .
The Business Flow is :
->Sale Order Created with a billing plan , It can be a Downpayment followed by Final Invoice.
-> Multiple sale Orders can be linked in an Invoice.
-> I am proceeding with PK 15 ,Cleared Items for Invoice releated and PK 19 Spl GL Ind A for Downpayments..But I am not able to handle clearings with cancellations and payment difference postings.
It will be really useful if I can get a technical logic to caluclate this .