Re: Subledger records in F0902

[David_Bryant/mx]

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.

 

[sally_earnest]

Re: Subledger records in F0902

If you have run the global repost lately, you may want to look at SAR 3412271. There is a bug in A7.3 cum 11 which creates subledger records in the F0902 when the repost is run. Just FYI.

 

[dworthen]

Re: Subledger records in F0902

I can't remember off the top of my head, but isn't that governed by the posting edit code for the account (S or L)?

 

[Tymawr21]

Re: Subledger records in F0902

L as p/e code will validate data with valid a sub-ledger entry to post

 

[Patricia]

RE: Subledger records in F0902

When we ran the repost program P099102 it created duplicate records for all
sub ledger in the F0902 file has anybody else come across this problem . If
you did how did you fix this problem from happing again. Thank You Pat
A73.10

 

[Colin_Hugill]

RE: Subledger records in F0902

Patricia,

This is sounds like an old problem with no real solution as far as the
repost program design is concerned. What I suspect has happened is that the
Posting Edit Code (PEC) has been changed on some account masters, from S to
L or Blank, or, L to S or blank etc, etc, etc. The repost program does its
work based on the current setting of PEC.

One thing is certain, the repost process will create account balance records
if they don't exist. Therefore, take a save copy of F0902 then remove the
affected Fiscal Year balance records from F0902, then run the repost. You
will need to do some analysis and decide what Ledger types, what Fiscal
Year(s) etc and if the y/end close needs to be rerun to populate the "new
balance" records with opening balances. I don't know how long it will take
- I don't know how big your balances file or your transactions file is nor
do I know what your processor speed is. But the repost program is
relatively quick so I would expect you could get your reposts done inside of
a day (Saturday/Sunday).

Anyway this should give you a good start, sorry I can't be more detailed at
this time. If you have any questions then contact me direct rather than
clutter up JDEList.

Woops, you better make sure there are no users on the system when you do
this.

Regards...... Colin HUGILL

 

[rgomes5]

RE: Subledger records in F0902

Colin,

You were perfect in your explanation, however she needs to ensure that there
are not batch running on back too.

R.P.G.


From: Colin_Hugill <[email protected]>
Reply-To: [email protected]
To: [email protected]
Subject: RE: Subledger records in F0902
Date: Mon, 12 Mar 2001 18:31:35 -0800 (PST)

Patricia,

This is sounds like an old problem with no real solution as far as the
repost program design is concerned. What I suspect has happened is that the
Posting Edit Code (PEC) has been changed on some account masters, from S to
L or Blank, or, L to S or blank etc, etc, etc. The repost program does its
work based on the current setting of PEC.

One thing is certain, the repost process will create account balance records
if they don't exist. Therefore, take a save copy of F0902 then remove the
affected Fiscal Year balance records from F0902, then run the repost. You
will need to do some analysis and decide what Ledger types, what Fiscal
Year(s) etc and if the y/end close needs to be rerun to populate the "new
balance" records with opening balances. I don't know how long it will take
- I don't know how big your balances file or your transactions file is nor
do I know what your processor speed is. But the repost program is
relatively quick so I would expect you could get your reposts done inside of
a day (Saturday/Sunday).

Anyway this should give you a good start, sorry I can't be more detailed at
this time. If you have any questions then contact me direct rather than
clutter up JDEList.

Woops, you better make sure there are no users on the system when you do
this.

Regards...... Colin HUGILL





--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=7182
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +
This is the JDEList World Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
+ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - +


_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.