web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / the transactions on vo...
Microsoft Dynamics AX (Archived)

the transactions on voucher do not balance as per accounting currency reporting currency error on posting a production order pick list

(0) ShareShare
ReportReport
Posted on by Mohammed Abdul Aziz 1,875

Hi,

I have upgraded from AX 2012 R2 CU7 to CU8. we are getting the following error when posting a production order pick list : "the transactions on voucher do not balance as per accounting currency reporting currency ". i did not find any hotfix to fix this problem.

This upgrade was there 2 days in production , can i just rollback the model database without restoring the business data(MicrosoftDynamicsAX).

 

Thanks in Advance.

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,051 Super User 2025 Season 2 on at

    Hi Mohammed,

    If you have upgraded and also run the upgrade checklist with several data update scripts, it is not recommended to rollback the model database. Then you can expect other issues. I would recommend to check the setup and try to debug why this error pops up.

    I do hope you first updated a test environment and did proper testing? Is this issue now in a test or your production environment? Is it related to only one or a few production orders or all?

  • Mohammed Abdul Aziz Profile Picture
    Mohammed Abdul Aziz 1,875 on at

    Hi Andre,

    The first environment was test, users reported this scenario was tested. But later realized about this. there are some issues reported in Microsoft Life cycle services but for invoice posting and other scenario. i get this error on posting a picking list.

  • ObiOne Profile Picture
    ObiOne on at

    Hi Mohammed,

    Have you checked the exchange rate on the lines? I have noticed that if you have multiple lines with different exchange rates it can cause an issue as exchange rates often work to more that 2 decimal places. with the double precision versus 3 decimal places it can cause slight differences in the overall voucher balance...

    If you personalise the screen and move the exchange rate to the main form and then export to excel (CTRL +T) you can manually work out the balances and see if there is a difference.

    Im not sure if this will help but its worth a check...

    Kind Regards,

    ObiOne

  • Mohammed Abdul Aziz Profile Picture
    Mohammed Abdul Aziz 1,875 on at

    Hi ObiOne,

    Thanks for the answer, you want me to check the GL->Main Accounts balance ?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,051 Super User 2025 Season 2 on at

    Hi Mohammed,

    I cannot reproduce the error in my environment. Possibly you need to get help from a developer to debug what causes this error. It can be data, but also application related.

  • Mohammed Abdul Aziz Profile Picture
    Mohammed Abdul Aziz 1,875 on at

    Hi Andre,

    We have upgraded from AX 2012 R2 CU7 to CU8 to fix prepayment issue. After upgrade Post Picking list error comes up.

  • Mohammed Abdul Aziz Profile Picture
    Mohammed Abdul Aziz 1,875 on at

    Andre,

    Following is the screen print :

    pickinglisterror.png\

    Thanks

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,051 Super User 2025 Season 2 on at

    Hi Mohammed,

    Do you have setup indirect costs for a costing sheet? If not, I assume you only need two rows in this voucher. In the last case I do think indeed it might be an error in your application. Like stated before it is possible to debug the scenario. You can also create a ticket for Microsoft support.

  • Verified answer
    Mohammed Abdul Aziz Profile Picture
    Mohammed Abdul Aziz 1,875 on at

    Hi Andre,

    The error was causing because of the project selected on production order. The project group associated with the project had "Balance" selected on Ledger> Journalizing for :

    1. Post Cost Hour

    2. Post Cost  Expense

    3. Post Cost Item

    I selected "Profit and Loss" for all the above options and the problem was fixed.

    Thanks for your support Andre, ObiOne

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,051 Super User 2025 Season 2 on at

    Hi Mohammed,

    Thanks for the feedback. Glad you found the problem. Can you mark your own answer? Then the thread will get the status answered.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans