You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL Receivables Accounting Period

Accepted answer
27
Views
3
Comments
edited Mar 25, 2020 4:28PM in Receivables & Collections 3 comments

Summary

I need to report on receipts, and link to the appropriate accounting period in bi publisher.

Content

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!