Balance Sheet Location Wise

[Former Member]

The company is operating in 3 states, say andhra pradesh, tamilnadu, delhi. There are several branches in each state. Tamilnadu has 2 branches and andhra pradesh has 5 branches. I've defined the locations, and added the branches as warehouses.

My requirement is, I need balance sheet, profit and loss, trial balance for each state separately. Please help me in this by providing suitable solution.

--

Rgds,

Balaji

[Former Member]

The discount will be determined at the Setup level and will not be accomplished while we post the incoming payment. This should be done by manually posting a journal entry and reconciling the same with the invoice.

[Former Member]

There are two ways of handling this.

Option 1: Use Diemensions. Create a dimenstion called location and have values like AP, TamilNadu, Delhi etc., (Each Location would be a Profit Centre). Now you should insist the user to select this profit centre in Marketing documents, Journal Entry as Mandatory.

Now you can generate TB and P&L reports based on a Profit Centre. But you cannot generate Balance Sheet Profit Centre wise.

Option 2: Use 'Account Segmentation'. Create a Segment called 'Location' and have values like AP, TN, Delhi etc.,(Each Location would be a segment).

Now you can generate Balance Sheet, TB and P&L reports Location wise.

Note here you would have a huge increase in your G/L Accounts and you have to map appropriate GL Accounts for each warehouse. This option might be little complex but really effective.

[Former Member]

Dear Mr. Sridharan,

Thanks for your input and we can generate the balance sheet location wise.

I got a problem while doing outgoing payments. While posting the outgoing payments for Tamilnadu vendor, I added a discount amount. This got posted correctly as I determined the Tamilnadu discount earned G/L account. My question is, what if I post the same for Andhra Pradesh vendor?

Please advise to proceed further.

--

Rgds,

Balaji