Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Jill Dryfhout]

I recently set up a second AP account using a separate checkbook. However when I run the reconcile to GL it’s pulling in the first AND the second AP account. Do I have to reconcile them as a whole or can I do it separately? Also, when I run a historical aged TB in payables module it pulls in both there also. Any thoughts?

——————————
Jill Dryfhout
Illinois Credit Union System
Naperville IL
——————————

[Lou Spevack]

You are using two control accounts for payables transactions.  For all your vouchers, the PAY transaction type will apply the transaction to your PM Aged Trial Balance regardless of which control account you use.  You will then need to reconcile the PM HATB report to the sum of both control accounts.

Here is a trick you can use to be able to run separate aging reports for the two control accounts.  When you have an account that goes to the second control account, change the voucher number to a have a different prefix.  You can then use the document number restriction.  If the second control account is specific to certain vendors and there is no overlap, you can assign a vendor class to those vendors and a different vendor class to all other vendors. Then run the PM HATB report by vendor class.

‘Hope this helps.

——————————
Lou Spevack
Systems Accountant | Dynamics Credentialed Professional
American Council on Education
Washington DC
————————————————————————-