Locationwise Balanced Trial Balance

 Dear All,

I have below requirement in my organization:

1. Our CoA has 9 segments:   Of which 1st segment is Company which is the balancing segment.   We have 4th segment called Location, which is used to track our Branch Transactions.  As of now we have 40 branches.

2. We are able to run the Balanced Trial Balance on Company level and it is obvious as the Company is the balancing segment.

3. But, we are unable to get the Balanced Trial Balance on Location Level due to the following reasons:

[a]  Sales happens at Branch, Location segment value:  BLR   but Cheque is received at Corporate,  Location Code: COR.   So, when you apply this receipt to the AR Invoice, the JEs are going with different Location Codes and due to which Un-Balanced entries are created at location level.