Announcements
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
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'
That is exactly the script you need, McGuire.
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.
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.
Then the only solution is to change the data in the tables, Mr. McGuire. Can you do that or have someone assist?
Enter a JE to reduce the balance by last year's amounts. Post it in the first period of your fiscal year.
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
