NATIONAL ACCOUNTS - AR

[swabunn]

Great Plains 8
server: SQL

we have set up customers for each location and have separate AR GL account for different location customers and these customer have assigned as child to an parent customer account.

Now the problem arises when after posting and applied fully. When user go back and reapply cash to invoices to other locations customers.

The AR subledger works fine but it does not change AR GL account.

Any idea to resolve this or this is a great plains bug?

Thanks

-swabunn

 

[VictoriaYudin]

GP was not designed to work the way you want to use it. It's only meant to have 1 AR control account. So it's not a bug, it's working as designed.

Sorry :-(

Victoria
Flexible Solutions, Inc.

 

[swabunn]

Thanks for your reply. if somebody has to reconcile each location (class)AR subledger with GL Then how would they do that.

Thanks

-swabunn

 

[VictoriaYudin]

Usually if you have multiple AR control accounts, you would reconcile ALL of them in total. So add up the balances for all AR accounts in the GL, then compare to AR subledger TOTAL...if all is well, then run the individual AR reports by class and reclass the GL accounts if needed. For example, if the GL total is $1,000,000 and the AR subledger total is $1,000,000, then the first step is satisfied - you tie to the GL. Then you rely on the AR subledger to have the correct details, so if Class A has $400,000 and Class B has $600,000 and the GL shows $500,000 in each, you reclass the GL to show what the AR subledger shows.

I'm not saying this is the best or only way to do this, but since GP is not meant to have more than 1 control account for AR, this is one option. Same logic applies to AP, by the way.

If you wanted to do some more research, Binary Stream has a product that may do what you want (not 100% sure, it's been a while since I saw it):

http://www.binarystream.com/CentralizedProcessing_GL.asp

- but it may also be overkill for what you're looking to do.

Hope all my ramblings help.


Victoria
Flexible Solutions, Inc.

 

[swabunn]

Thanks again for a very satisfactorily reply.I did the same as you suggested but during the audit the auditor gave very hard time to find the reasons.

Thanks

Swabunn