T/B by Bsns Unit problem

[Diana_Apple]

Hi,

I hope someone can help me (I have a call into JDE on this, but my boss is breathing down my neck).

The Trial Balance by Business Unit program is treating one of our P&L accts as if it were a Balance Sheet account - it is including prior year balances in this year's balance. I don't know if it's happening on other accts. I do know that our other inquiry programs/reports show the correct balance on this account.

According to our AAI's, our being Revenue account is 040009 and our ending P&L 099910. The account in error is 099901. It has a zero balance for this year, but is being displayed with the total of all transactions ever posted against it.

Can anyone help me? Thanks in advance.

Diana Apple
Quikrete
AS/400 JDE A7.3 cum 6

 

[chazman]

check your AAI for the GLG5 and see if it is showing 099901. If could be
caused by your YTD Income or Loss AAI being inadvertenly being set to
099901. Or take a look at the AAI for the "FS"

 

[brian]

Could this be a 0 vs O ?

I've also seen a problem where the user actually keyed in an uderscore -
i.e. _099901 (invisible on a green screen).

Either of these could cause the problem you are describing.

Brian Whitney
ODBCFace.com
http://www.odbcface.com

----- Original Message -----
From: "chazman" <[email protected]>
To: <[email protected]>
Sent: Wednesday, March 20, 2002 2:22 PM
Subject: RE: T/B by Bsns Unit problem


http://www.jdelist.com/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=3
1009

 

[Diana_Apple]

Re: RE: T/B by Bsns Unit problem

GLG5 is set to 039999. And I checked the "FS" and did not see this account set up anywhere in it.

This is a Tax Provision account, that we only post to once at year end.

My understanding is that we close the books for the year end to figure the tax, then reopen them to post this tax and then we close the books again. Does this make any sense.

Diana Apple
Quikrete
AS/400 JDE A7.3 cum 6

 

[chazman]

RE: RE: T/B by Bsns Unit problem

It am assuming that this is on the inquiry screen? could the account's level
of detail changed causing it to total on the screen?

 

[John_Dickey]

RE: RE: T/B by Bsns Unit problem

Diana,
Hmmm, an interesting problem. The basic premise is that if the 14
character combination of Object account and Subsidiary account is LT the
GLG6 AAI OR is GT the GLG12 AAI, treat it as if it is a balance sheet
account and add in that carryover balance field in the F0902 file.
Is your trial balance data range for day 1 of a month to last day of a
month? If midmonth, may go to the F0911, which might cause you some
trouble. That would be one thing to check.
Another thing to check is in your AAI's do you have mutiple entries for
GLG6 and GLG12 by company? If so, what company is this problem account in?

If everything is in order per above, the only thing I can think to do is
go into debug mode and watch the program. The actual program to retrieve
the balance is X0902, but the account type is determined in P09210 and
passed to X0902.

John Dickey
JDE Financial Systems Administrator/Programmer/Analyst
White-Rodgers, Division of Emerson
St. Louis, MO
314-577-1466

 

[Diana_Apple]

Re: RE: RE: T/B by Bsns Unit problem

I found it! It's a program bug in P09210. The fields $GLG6 and $GLG12 are defined as 12 character fields. They should be 14 characters. The last two characters of the object was being replaced by the first two characters of the subsidiary (which in our case was blanks). I checked the P04940 pgm and those fields are defined as 14 characters. We are at CUM 6, so JDE may have fixed this problem after that.

Thanks so much to all of you for your help. I could not have found this on my own so quickly (if at all).

Diana

Diana Apple
Quikrete
AS/400 JDE A7.3 cum 6

 

[JohnSchiff]

RE: RE: RE: T/B by Bsns Unit problem

This was fixed on SAR 3708899 back in June of 2000 for A7.3 cume 12 and A8.1
cume 4.



Director Solutions Delivery
WolrdSoftware Division
J.D.Edwards