Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
trial balance
01-28-2012, 07:27 PM
Post: #1
trial balance
I read through alot of the manual, but couldn't figure this out. So I'm not sure if it is a bug, a feature request or a how to :-(

Now I created a whole new chart of accounts (Account Groups, Accounts).

for example

Group :
11 Fixed Assets
112 Other Assets
12 Current Assets
122 Banks
126 Inventory

Accounts :

1221 Bank 1 : Group : 122
1222 Bank2 : Group : 122
1261 Ineventory A : Group : 126

Now in TB I only see

Group 122 and Group 126 and a list of their accounts, but not the parent list 12.

Furthermore, I tried addiing an account to group 12, then it appeared in TB but didn't include 126 in its overall total.

In short, how can we get TB to show all account groups in order of parent-child hirearchy even if it doesn't have accounts? and why is it not showing totals for all accounts and sub accounts within the group?

I hope I made it clear ;-)
Find all posts by this user
Quote this message in a reply
01-29-2012, 08:13 AM
Post: #2
RE: trial balance
Is the Current Assets Group defined as having no parent group?
Is the Banks Group and Inventory Group defined as being a child of the Current Assets group?

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
01-29-2012, 02:57 PM
Post: #3
RE: trial balance
Hi.

Answer is yes to all. Thanks
Find all posts by this user
Quote this message in a reply
01-29-2012, 03:55 PM
Post: #4
RE: trial balance
Any chance of some screen shots to illustrate the issue - if you could smudge out any numbers.
We need the screen for account groups setup and a TB

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
01-29-2012, 06:19 PM (This post was last modified: 01-29-2012 06:20 PM by avocado.)
Post: #5
RE: trial balance
(01-29-2012 03:55 PM)phil Wrote:  Any chance of some screen shots to illustrate the issue - if you could smudge out any numbers.
We need the screen for account groups setup and a TB

Okay, here you see the trial balance only showing direct parents (no grand parents).
   

Here you see definition of groups:
   

Here you see the current assets showing total under 121 cash, when I expected to be under 127 Other Assets.
   
Hope this helps.
Find all posts by this user
Quote this message in a reply
01-31-2012, 07:53 PM
Post: #6
RE: trial balance
Any help?
Find all posts by this user
Quote this message in a reply
02-01-2012, 04:46 PM
Post: #7
RE: trial balance
The set up is as I expected but the output doesn't look right - I need to get into the code to figure it out.

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
02-02-2012, 07:55 PM
Post: #8
RE: trial balance
(02-01-2012 04:46 PM)phil Wrote:  The set up is as I expected but the output doesn't look right - I need to get into the code to figure it out.

But am I right in expecting that parent group totals should show for sum of all sub groups?
Find all posts by this user
Quote this message in a reply
02-03-2012, 08:03 PM
Post: #9
RE: trial balance
Yes indeed - this looks like a bug on the face of it ...

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
01-09-2013, 04:05 AM
Post: #10
RE: trial balance
Dear Phil,

Was this bug fixed?
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)