Split Trade Debtors/Creditors

[Cathy_Fox]

We currently have our trade debtors & trade creditors balance in two separate accounts. We have been asked to break down our Balance Sheet into our three sites. I am just looking at how to set the AAI's up to point the creditors liability into three different accounts and so too the debtors. I can see issues, for example, where a supplier is used and costed by one, two or all three of the sites. Has anyone encountered the same issue and have any work arounds?

 

[martin_thomas]

Cathy

By giving suppliers and customers different G/L Class Codes per site , you can use AAI's to book them to different control accounts on the Balance Sheet. You would create AAI PCxxxx where xxxx is the G/L Class Code assigned to the supplier in the Supplier Master record. The same would apply to RCxxxx for Customers. These can also be overwritten at the invoice/voucher entry stage if the invoice/voucher was for a different site than the norm. However, this would mean the user remembering to do so.

Regards

Martin Thomas