Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Michelle Jarrell]

We are using GP 2016 or 2016 R2 with AIT.  I just recently found out that most of our employees were not utilizing the AIT when processing AP, AR or General Ledger transactions if the locations were all included in the same main company/database.  We provide financial statements per location, so the consolidated company statements are balanced, but not each individual location.

We have trained all employees to process all transaction that include multiple locations to utilize AIT.

What is the best process to go backwards and fix all the transactions not processed with AIT to balance the financial statements?

Any help is appreciated!

——————————
Michelle Jarrell
Senior Accountant
Purple Square Management
——————————

[Kimberly Lomax]

We don’t use AIT, but use Binary Stream’s Multi-Entity Management for the balancing of our entries within a database.  There is, on occasion, an entry that doesn’t balance for whatever reason.  In order to find what entries made our entities are out of balance, we run a SmartList showing all the entries in a period for each company (starting with the company with the least amount of activity).  You’ll need to exclude Unit Accounts for this exercise.  Then export the transactions to Excel and throw a pivot table on the data grouping by JE number and you can pin point which entries didn’t balance and post the appropriate intercompany journal entry to balance them.  This may not be the most efficient way, but it’s now we do it.

——————————
Kimberly Lomax
Manager, Financial Systems
Rayonier
Jacksonville FL
——————————
——————————————-

[Michelle Jarrell]

Hi ,

Thank you so much!  It is a long process for me, but it worked and I have 1 month balanced!?

——————————
Michelle Jarrell
Senior Accountant
Purple Square Management
——————————
——————————————-