AR Control Override
We use the AP Control Override field fairly frequently to enable us to track several different kinds of AP. It would help us to have a similar "AR Control Override" field on Billing, because it would help us track the AR arising from several different lines of business.
What we have seen customers do is create a picklist on the account object and name it something like "debtor class". You can then run an AR aging by the picklist value. Also Account Level Glavs are coming tin the next release of Accounting Seed where you can tag the Account to GLAV values. This will allow you to default GLAV values in all transactions from the account as well as run reports by these variables on the account.
I have been waiting for an answer to that question for a while. So, thank you Tony for pitching in. I did create a picklist on the account object to differentiate my Accounts Receivable sources BUT I am still stuck. How do I push that picklist to Accounting Report Definitions/Report so that they can be reflected in the Balance Sheet by source? I already have GL Accounts for the different AR sources.
Also, when an account has multiple AR source type how do I differentiate the ARs? (For instance:- Pledges Receivable and Conventions Reg. Receivable)
As always, THANKS.
In terms of getting these different AR accounts to be listed on your balance sheet there would really be 2 options for you:
- Use one of the accounting variables to track the source. Create a custom financial report definition breaking out each combination of the AR GL Account plus the accounting variable as separate rows on the balance sheet.
- Run a report using the historical aged balances for billings by your picklist and use the report to create a reclassifying journal entry to break out the AR balances into separate GL accounts each month. You can automatically reverse the entry in the following accounting period and repeat each month.
If you want to track individual AR records from the same Account from different sources you would need to create a picklist on the billing object to track this. You could then run AR and billing reports by your source pick list.
Please sign in to leave a comment.