Report Name: RPT-OTC-004 AR Transactions Detail Report
Report Description: The RPT-OTC-004 Transactions Details Report will be run by the AR Manager to aid in reconciliation. It will list all applicable transactions based on the selected parameters at the transaction line level, showing all applicable related transaction details, including the total transaction amount, individual line amounts, Transaction Date, Due Date, Transaction Status, Billable Flag, Receivables Distribution Account, and Revenue Distribution Account. For Posted transactions, the Receivables and Revenue Distribution Accounts will get derived from the Accrual Ledger after the Create Accounting program has completed.
Report Data Flow: AR transactions will be created and completed outlining the items and services for which they are billing the customer for payment. This will include all lines for items and services as well as tax, freight and charges (penalty and/or interest) if applicable. Create Accounting program will run and post all applicable transactions to the ledger. During reconciliation process, AR Manager will run report and validate all transactions in report, verifying the correct amounts, statuses, and distribution accounts. Access to run this report should be restricted to those with the role of Accounts Receivable Manager or the equivalent customer role created for the State (NC AR Invoice Management, NC AR Period Management, and NC AR Supervisor job roles). If the Create Accounting program has not run, then the Receivables Distribution Account and Revenue Distribution Account will return null. However, if the program has run then the accounts will be derived from the NC Accrual Ledger.