Jasper,
Wow, that is a very detailed example for what appears to be a carpentry shop. Guess your real application is much higher up the capital equipment tree to make this effort necessary.
You can create just about any number of general ledger accounts to the lowest level of detail required. As long as you can fit it in the Div-Department-Chart (various combinations are possible) heirarchy. The accounts don't even need to be set-up in a logical manner, e.g. consecutive chart numbers, although that would certainly help.
Each individual chart item is assigned to an Account Category. An account category can be assigned to a higher parent Account Category. You can have a chart item for Hammers assigned to category Handtools assigned to category Workshop Tools assigned to category Miscellaneous Capital, etc. Define Account Category in G/L Master File Maintenance.
Use the Financial Report Designer in G/L Master File Maintenance to create reports that aggregate the G/L accounts anywhich way you want. This allows aggregation by individual accounts & account category. The categories do not retain any value in the system. The values are calculated from the individual G/L account entries when a Financial Report is generated.
HTH,
Gil Amilbangsa
Australian Healthcare Equipment - Murphy Furniture
gil.amilbangsa@...
-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Wednesday, 11 December 2002 1:23 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Sub Accounts
Hi all,
This may be a very simple question but I'm very new to Vantage.
Is it possible to create a General Ledger sub accounts and to create sub
accounts of the sub accounts?
For example, we would like a General Account of Tools. Then, there
would be sub accounts of Drills, Saws, hammers and nails. Then a sub
account of under Drills for cordless and corded. A sub account under
Saws for cordless and corded, Etc....
We are trying to improve the detail of our Tools and materials
purchases. We would like to be able to pull reports of the different
sub accounts and the sub accounts above it in the hierarchy.
Does this make sense or is there other options?
Any suggestions would be greatly appreciated!
Jasper Recto
Director of Information Technology
LOC Performance
734.453.2300
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Wow, that is a very detailed example for what appears to be a carpentry shop. Guess your real application is much higher up the capital equipment tree to make this effort necessary.
You can create just about any number of general ledger accounts to the lowest level of detail required. As long as you can fit it in the Div-Department-Chart (various combinations are possible) heirarchy. The accounts don't even need to be set-up in a logical manner, e.g. consecutive chart numbers, although that would certainly help.
Each individual chart item is assigned to an Account Category. An account category can be assigned to a higher parent Account Category. You can have a chart item for Hammers assigned to category Handtools assigned to category Workshop Tools assigned to category Miscellaneous Capital, etc. Define Account Category in G/L Master File Maintenance.
Use the Financial Report Designer in G/L Master File Maintenance to create reports that aggregate the G/L accounts anywhich way you want. This allows aggregation by individual accounts & account category. The categories do not retain any value in the system. The values are calculated from the individual G/L account entries when a Financial Report is generated.
HTH,
Gil Amilbangsa
Australian Healthcare Equipment - Murphy Furniture
gil.amilbangsa@...
-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Wednesday, 11 December 2002 1:23 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Sub Accounts
Hi all,
This may be a very simple question but I'm very new to Vantage.
Is it possible to create a General Ledger sub accounts and to create sub
accounts of the sub accounts?
For example, we would like a General Account of Tools. Then, there
would be sub accounts of Drills, Saws, hammers and nails. Then a sub
account of under Drills for cordless and corded. A sub account under
Saws for cordless and corded, Etc....
We are trying to improve the detail of our Tools and materials
purchases. We would like to be able to pull reports of the different
sub accounts and the sub accounts above it in the hierarchy.
Does this make sense or is there other options?
Any suggestions would be greatly appreciated!
Jasper Recto
Director of Information Technology
LOC Performance
734.453.2300
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]