John_Dickey
Reputable Poster
RE: Close Fiscal Year with Job Cost Active - anyone had problems
What we did is this. For income statement accounts, if no activity in the
year and balance forward not equal to 0, we purged out of the F0902 file.
For balance sheet accounts, I wrote a program that said if work order
subledger type, balance forward, and no activity for the year, add the
balance forward to the main G/L account, subledger and type blank, then
delete the F0902 record (have to move the balance forward somewhere to keep
the balance sheet in balance). Should, in my mind, be a processing option
on year end close to do something like this (roll balance for account with
no activity to another (consolidated) account.
John Dickey
JDE Financial Systems
Administrator/Programmer/Analyst
White-Rodgers, Division of Emerson
St. Louis, MO
314-577-1466
What we did is this. For income statement accounts, if no activity in the
year and balance forward not equal to 0, we purged out of the F0902 file.
For balance sheet accounts, I wrote a program that said if work order
subledger type, balance forward, and no activity for the year, add the
balance forward to the main G/L account, subledger and type blank, then
delete the F0902 record (have to move the balance forward somewhere to keep
the balance sheet in balance). Should, in my mind, be a processing option
on year end close to do something like this (roll balance for account with
no activity to another (consolidated) account.
John Dickey
JDE Financial Systems
Administrator/Programmer/Analyst
White-Rodgers, Division of Emerson
St. Louis, MO
314-577-1466
