Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / CuryAcct, AcctHist and...
Microsoft Dynamics SL (Archived)

CuryAcct, AcctHist and GLtran

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee
Has anyone noticed a difference between the curyptdbalxx and the ptdbalxx in the curyacct table and the ptdbalxx found in the accthist table for a company that has only one currency, and has had one currency? where for the most part the curyacct curyptdbalxx is the same as the accthist? Also, the carryover amount from one year (curyytdbal12/curyptdbal13) to another (curybegbal) are not the same for the curyacct? This isn't always the case for all account/sub accounts, but a subset of accounts/subaccounts.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CuryAcct, AcctHist and GLtran

    We do occasionally know (correction)  that it happens.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CuryAcct, AcctHist and GLtran

    Ed,

    The bottom line answer is that we don't know why they two records would be different.  In a single currency database, you almost never see the values in the curyacct table and so really don't know when or how it goes wrong.

    We do occasionally now that it happens because in Cash Manager >Bank Rec, the GL balance is from the Curyacct table.  Once in a while it displays the incorrect  balance so we know that the curyacct  record is incorrect.  But we have never discovered what causes this.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CuryAcct, AcctHist and GLtran

    Thank you for your help, I will look into the article when it is available. But the rounding error you are speaking of cannot be what I am seeing, I would understand if it was a few dollars off considering there are no more than 200 to 300 transactions in a period per account/subaccount.  The difference between periods its between $100's-$10,000+ dollars off and way over $100,000+ between some years. The beginning of the issue started back in 2004 in some cases  (which is before they switched over to SL2011 from 7.0, they did this early 2013) and aggressively got worse between 2011 and 2012.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CuryAcct, AcctHist and GLtran

    Hi Ed,

    We do this see when converting the data to MR.   I really can't say why they would be different other than we know that curyacct sometimes carries floating point values that would round to zero whereas the accthist record is not created upon year end close if the balance is zero.  But we do see variances when running Diagnostics scripts for MR conversion.

    See KB 2931999 for some scripts to find the variances and to fix them.   This article is being published but I don't find it available yet but should be soon.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans