Unit accounts

(0) Share

Report

Posted on by Mcguire

235

The unit accounts in my reporting have the previous year in the ytd balance. When they were originally set up, they were not marked to clear at year end. I want to know how to fix this problem so that last years unit account balances do not show up in my current year balances.

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Enter a JE to reduce the balance by last year's amounts. Post it in the first period of your fiscal year.

Was this reply helpful? Yes No
Mcguire 235 on at

Like (0)

Report

Making that entry will correct my ytd problem, but it will make my month to date numbers incorrect

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Then the only solution is to change the data in the tables, Mr. McGuire. Can you do that or have someone assist?

Was this reply helpful? Yes No
Mcguire 235 on at

Like (0)

Report

I can do it but I am not sure how to change the data tables. I have only a few months of GP experience.

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Okay, in SQL Server Management Studio, you're going to need to find the ACTINDX value for your unit accounts. Query GL00100 (Account Master), where ACCTTYPE = 2.

Once you know your unit account indexes, run a delete statement on GL30000 (GL History), deleting any records where ACTINDX = your unit account indexes.

Of course, try this in a test company first and make sure you backup production prior to deleting any records.

Let us know how it goes.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

There's a function IT runs for me each year to zero them out. Here's the kb article:

support.microsoft.com/.../857582

We are on 2010 but I hear this issue is resolved in GP2013.

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

That is exactly the script you need, McGuire.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

I believe you could change the posting period to period 0 (make the posting date 12/31) and it will act like your closing entries and just change the beginning balance without disturbing your history.

Kind regards,

Leslie

Was this reply helpful? Yes No
Suggested answer

cynthia dappah 1,065 on at

Like (0)

Report

If I understand this query well it clears the balance for any unit account with "BBF' as the source document, what if you would like to target a specific "ACTINDX" not all. Can you please help with how the query should be modified to achieve that

delete GL20000 from GL00100, GL20000
where GL00100.ACTINDX = GL20000.ACTINDX and GL00100.ACCTTYPE = 2 and GL20000.SOURCDOC = 'BBF'

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Here is a link to a KB

support.microsoft.com/.../857582

Was this reply helpful? Yes No