You’re offline. This is a read only version of the page.
50
We have marked the checkbox on Unit Accounts to 'Clear Balance During Year-End Close' but the records in the AA table for BBF still have values after year end close.
We have manually updated the amount using below script.
update c set c.DEBITAMT = 0, c.CRDTAMNT = 0, c.ORDBTAMT = 0, c.ORCRDAMT = 0
from AAG30002 c inner join AAG30001 b
on b.aaGLHdrID = c.aaGLHdrID and
b.aaGLDistID = c.aaGLDistID
inner join GL00100 d on
b.ACTINDX = d.ACTINDX
where d.Clear_Balance = 1 and b.ACCTTYPE = 2 and b.SOURCDOC = 'BBF'
and (c.DEBITAMT <> 0 or c.CRDTAMNT <> 0 or c.ORDBTAMT <> 0 or c.ORCRDAMT <> 0)
Would like to check is there any solution for this except to update using script?
We are using Microsoft Dynamics GP 2018 version 18.4.1361.
Hello lly,
It looks like we had this issue (#86400) in the past and it was fixed in GP 2016 RTM. However, i was able to recreate the AAG30002 not clearing out again on my GP 18.4.1384 install, so it looks like this issue has reared itself again. Likely some code changes reverted it back. I will report it, but you will have to use the script to clear them out in the meantime. I apologize for this inconvenience, but thank you for letting us know. It will be considered again for a future fix.
UPDATE: ThIs issue has been logged again (#94098) and will be reviewed for a fix in an upcoming release.
Cheryl - Dynamics GP support
Hi Adam G.,
Thank you for your reply.
Yes, we have the marked the option to Include AA Dimensions in the Year-End Close.
We want to include AA dimensions in history year and balance bring forward for posting accounts with posting type balance sheet.
Thank you.
LLY
Hello-
Thank you for posting your question on the Forums. It would appear that you also have marked the option to Include AA Dimensions in the Year-End Close? Under:
Is that something you want to continue going forward? If not, be sure that is unmarked before closing the next year to avoid this issue in the future. If so, you would need to run your script to zero them out after each fiscal year-end close. Your script should work for the current unit account records with a balance, but always best to make a good restorable backup and attempt in your TEST company first just to be sure. Thanks!
Adam G.
Microsoft Dynamics GP
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (