Zero values in GBAPYC (cumulative prior year-end balance) for prior fiscal years

[JBJR]

We have found many records in table F0902 - Account Balances - with zero amounts in GBAPYC for prior fiscal years. Has anyone else experienced this issue and if so, what was the cause and how did you correct the problem?

Best regards

 

[Boris G]

APYC is the beginning balances field. It is populated by running the Year-End close process in GL. What records did you find? Beginning balances only matter for the Balance Sheet accounts, not P/L. Also, what ledger are they from? AA or some other one?

 

[dschleicher]

Actually, we did find a situation where Beginning Balance not being populated did matter for P/L accounts. We created a Financial report for Inception to Date for some Revenues & Expenses, and some of the numbers were incorrect. After doing some research, I identified the issue. Amounts were posted to accounts in one year, but nothing was posted in the following year. When the Annual Close was done a "1" was not populated in the Profit/Loss processing option, so the Beginning Balance from the prior year wasn't brought forward.

For example, an amount is posted to an account in 2006, and when the Annual Close is run JDE will automatically populate the 2007 Beginning Balance field for this account, even if it is a P/L account. However, if nothing is posted to this account in 2007, unless the Profit/Loss processing option is populated with a "1", the Beginning Balance from 2007 will not be brought forward as a Beginning Balance in 2008, causing an Inception to Date report to be off (the Inception to Date smart fields use the Beginning Balance field).

I'm not sure if this is unique to our setup (based on AAIs or something), but we did encounter this.

I don't know if we came up with a resolution for this, short of running the Annual Close for prior years again, and we were hesitant to do this.

Dave
LOGIS
8.12, 8.98.2.3, Windows 2003, SQL 2005, OAS 10.1.3.1

 

[JdeInNJ]

What you observed is what is supposed to happen. The processing option is meant for JDE clients who do not need inception to date reporting for income statement accounts. For those clients, leaving the annual close processing option blank will reduce the number of rows in F0902 which could affect system response time positively.

Job Cost clients with cost types in the income statement would always want to set the processing option value to 1 so they have access to job to date data.

The way to "fix" the missing values is to rerun the annual close program for prior years with the processing option set to 1. Then the inception to date postings will be created for all accounts.