SQL Receivables Accounting Period
SummaryI need to report on receipts, and link to the appropriate accounting period in bi publisher.
I have been unable to find an appropriate table/link between AR_CASH_RECEIPTS_ALL (or any receivable table) and accounting period. I have managed to find the link in payables easily, but receivables doesn't appear to be as simple? I have attempted to link to general ledger tables to resolve this issue but i am unsure how i could filter the results down to only get the correct accounting periods.
Hopefully i have explained this well enough, and appreciate any help. Many thanks.