David_Bryant/mx
Member
Re: Subledger records in F0902
Hello - I just had cause recently to delve in to the depths of the F0902
and to my surprise find that I have tons of individual rows of balances for
inventory accounts where I used to have just one row. (One row per account
per year was my motto!) The reason is that we started work order
accounting and apparently it populates the subledger field each and every
time we close a work order. We don't use subledgers for anything else and
I don't particularly think I need them here.
Two questions:
One: Does anyone know how to turn off subledgers in work order accounting?
Two: I would like to get rid of all the individual rows in the F0902 -
basically collapse all the multiple rows caused by the subledgers and go
back. All the things I am thinking sound like dfu, global update, in other
words, dangerous. ( I always remember the tech foundation instructor many
years ago saying "When you think global update, think update your resume")
The reason this all came up is that I need to download current and prior
year numbers from the F0902 into an excel spreadsheet for the auditors -
and I don't want to do a ton of manual work. I was using queries to link
previous queries built using current and prior years balances, etc. It was
pretty slick until I ran in to the subledger problem, at which time, as you
can imagine, the file linking went totally berserk.
Any thoughts would be appreciated.
David Bryant
Maxco Supply, Inc.
Hello - I just had cause recently to delve in to the depths of the F0902
and to my surprise find that I have tons of individual rows of balances for
inventory accounts where I used to have just one row. (One row per account
per year was my motto!) The reason is that we started work order
accounting and apparently it populates the subledger field each and every
time we close a work order. We don't use subledgers for anything else and
I don't particularly think I need them here.
Two questions:
One: Does anyone know how to turn off subledgers in work order accounting?
Two: I would like to get rid of all the individual rows in the F0902 -
basically collapse all the multiple rows caused by the subledgers and go
back. All the things I am thinking sound like dfu, global update, in other
words, dangerous. ( I always remember the tech foundation instructor many
years ago saying "When you think global update, think update your resume")
The reason this all came up is that I need to download current and prior
year numbers from the F0902 into an excel spreadsheet for the auditors -
and I don't want to do a ton of manual work. I was using queries to link
previous queries built using current and prior years balances, etc. It was
pretty slick until I ran in to the subledger problem, at which time, as you
can imagine, the file linking went totally berserk.
Any thoughts would be appreciated.
David Bryant
Maxco Supply, Inc.