# Dimension wise Trial Balance and Balance sheet

#### Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
page a complete list of our different newsletters.

#### This post has 6 Replies | 0 Followers

53 Posts
586 Points
Joined: 2009-8-17
Last Online:
2013-6-6 9:53
Location: Bangalore, India
Jaideep Ghosh Posted: 2009-12-18 6:03 | Locked

Hi,

My Client has two units – Unit 1 and Unit 2.  Both are mapped as Dimension values as “Unit” being taken as Global dimension.

My Client needs to generate a “Unit wise Trial Balance”.  To generate such a Trial balance it is encountering these problems:

Say, a sales is made by Unit1 >

Debtors X A/c ..Dr   (Dimension – Unit1)   Rs. 2000/-

Sales A/c …Cr           (Dimension- Unit1)    Rs.  2000/-

Say, for the same Debtor Unit2 makes a sale>

Debtor X A/c …Dr (dimension – Unit2)   Rs. 3000/-

Sales A/c… Cr (dimension – Unit2) Rs. 3000/-

In this regards say on a later date Debtor X makes a full payment of Rs 5000/- by a single check.

Here the only Bank Account my client has is in Unit2.

Client books the receipt by applying the two Posted invoices documents in the Receipt Journal or Receipt Voucher.  Thus The user in Unit2 will book it as :

Dr Bank A/c (Dimension – Unit2) Rs5000/-

Cr Debtors X A/c (Dimension –Unit2) Rs 5000/-

As in the receipt journal we can give only one Dimension against the Balancing Bank A/c.  The Client is not willing to enter the transaction giving two lines for Balancing bank A/c-(one for each dimension), saying it will affect his reconciliation efforts at the end of the month

In this situation the receipt will get posted with only one dimension.

Thus the Client is able to obtain Dimension wise Profit & Loss Account but he is unable to obtain dimension wise tallied Trial balance &  Balance-Sheet.

Please suggest a course of action.

109 Posts
1,138 Points
Joined: 2009-4-1
Last Online:
2013-12-5 16:26
Location: Nigeria
Gbenga Ol replied on 2009-12-23 11:49 | Locked

Hi,

Why don't u reverse the transaction on unit1 then enter the corresponding transaction with unit2 then apply the payment made in unit2(5000) to the two transaction made in unit 2(2000,3000).

95 Posts
1,999 Points
Joined: 2002-3-4
Last Online:
2013-5-22 15:37
Location: Singapore
Rajib Lochan Huzuri replied on 2009-12-23 16:25 | Locked

The receipt in the Receipt Journal can be posted as follows

Dr Bank A/c (Dimension – Unit2) Rs5000/-

Cr Debtors X A/c (Dimension –Unit1) Rs 2000/-  Applied to Invoice Unit1

Cr Debtors X A/c (Dimension –Unit2) Rs 3000/-  Applied to Invoice Unit2

Posting the above journal will create one Bank Ledger Entry, and thus it will not create any issue during bank reconciliation.

Since Unit1 does not have a bank account, the B/S for Unit1 will not show Bank account, but the same can seen on Unit2

Cheers

Rajeev

Rajib Lochan Huzuri

rlhuzuri@yahoo.com

4 Posts
26 Points
Joined: 2010-1-31
Last Online:
2013-11-14 22:55
Location: Doha, Qatar
Musthafa replied on 2012-10-22 20:13 | Locked

It will not produce accurate trail balance. There is a method that can be adopted in this situation. If you are interested to know, please reply

4 Posts
26 Points
Joined: 2010-1-31
Last Online:
2013-11-14 22:55
Location: Doha, Qatar
Musthafa replied on 2012-10-22 20:25 | Locked

In order to produce accurate trail balance and to produce a correct balance sheet, you need to adopt the following entry. To serve this, you may create a G/L Account Called Bank Control Ac, under Bank and then make the following entries

Dr. Bank Account - Unit 1         5000

Dr. Bank Control A/c- Unit 2   2000

Debtors Account   Unit 1       3000

Debtors Account   Unit 2       2000

Bank Control A/c   Unit  1      2000

So each branch will show the correct cash/bank balance  when taken in isolation and when produce combined report, it is net off automatically

4 Posts
26 Points
Joined: 2010-1-31
Last Online:
2013-11-14 22:55
Location: Doha, Qatar
Musthafa replied on 2012-10-22 20:26 | Locked

For any further query, you may contact me at <email address removed by admin>

7,620 Posts
424,472 Points
Joined: 1995-10-1
Last Online:
2013-12-6 22:56
Location: Middelfart, Denmark

Erik P. Ernst replied on 2012-10-22 21:14 | Locked

Email address removed from post. Please never post emails directly in posts. Not only for your own case as it's not secure and will result in your email ending in lots of spam databases, but also because we want to keep the full thread in the same post, full question, full answer. Otherwise it's like posting a picture of great looking cake, saying it's a recipe, but without listing the ingredients.

Best regards,
Erik P. Ernst
Webmaster

Don't forget to "Verify Solution" the post(s) that solved your problem. This credits the experts who helped, earns you points and marks your thread as Resolved so we all know you have been helped.

Page 1 of 1 (7 items) | Get this RSS feed |