Share
Report
69Hi
i am new to FinOps. I have imported custtrans, custsettlement and generaljournalaccountentry(ledgertrans) entities into my sql db.
I am joining custtrans and ledgertrans on voucher and getting a dimension value(product).
so, custtrans will have multiple rows for each ledger posting.
I am deriving invoicetype in custtrans based on product code. There are 2 invoice types(1. GEN and 2. CHG(charges))
But, payments doesn’t have product codes and is derived as GEN by default in invoicetype.
I need to create a report for each account, invoice, settle date and settlement amounts by GEN and CHGBasically, I need to identify how much revenue I have made for each invoice type and how much payment received for each invoice type.
how can I split payments by invoicetype corresponding to custtrans invoice.
I don’t know how can I split especially when the payment cycle is monthly and exchgadjustments.
Any idea? I am struck here. How can I achieve my results
Thanks in advance
All responses (
Answers (
