Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Unit Accounts balance ...
Finance | Project Operations, Human Resources, ...
Suggested answer

Unit Accounts balance incorrect in Analytical Accounting tables

(0) ShareShare
ReportReport
Posted on by lly 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.

Categories:
Microsoft Dynamics GP
  • Suggested answer
    Cheryl Waswick Profile Picture
    Cheryl Waswick on at
    RE: Unit Accounts balance incorrect in Analytical Accounting tables

    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

  • lly Profile Picture
    lly 50 on at
    RE: Unit Accounts balance incorrect in Analytical Accounting tables

    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

  • Suggested answer
    agaber Profile Picture
    agaber on at
    RE: Unit Accounts balance incorrect in Analytical Accounting tables

    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:  

    Administration >> Setup >> Company >> Analytical Accounting >> Options

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans