A blog on Dynamics 365 for Operations – Retail

Category: Dynamics 365 for Operations

Purchase Order status changing automatically

End users (Operations team and Purchase) started reporting that the Purchase Order status is changing automatically without them changing anything. The environment on which this issue was reported is Platform Update 32 – 10.0.08.

The purchase order status was changing from Confirmed to Approved and when Operations tried to GRN the order it caused an error –

“Purchase order is no longer confirmed. Posting of the order has been cancelled”.

I was trying to backtrack and check what was the code deployed in the last few packages that could have caused it, but found no code that could have caused this issue.

Finally I suspected that its a bug in the standard itself. I searched LCS and found the following issue-

https://fix.lcs.dynamics.com/Issue/Details?bugId=412804&dbType=3&qc=42d3ca380a11a4462acb824e890db0689172d2f8766d8724f3cc6f5231393a29

If you are facing the same issue, do visit the above link and subscribe to be notified for the fix

Hope this helps

-Hitesh Manglani

Dyn365FO Excel Add-In Issues Troubleshooting

If you are facing any issues with your Dyn365FO excel add-in please go to below link and you have done the necessary troubleshooting

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/office-integration/office-integration-troubleshooting

If you face the following error despite following the above troubleshooting steps, please follow the remaining steps in this blog post below to unblock.

  1. Go to below link
https://store.office.com/addinsinstallpage.aspx?rs=en-001&assetid=WA104379629
  1. Click on Open in Excel on below prompt.
  1. Click on Open in Excel 2016 to get below prompt
  1. Click Yes and the add-in should open on the right window pane within excel. Click on Add server information.
  1. Enter the url to the Dyn365FO environment. Then click Ok to receive below prompt.

Note: You may need to sign in if after clicking Yes a sign in prompt appears, else you should be able to use the add-in already.

Hope this helps

-Hitesh Manglani

Export X++ and Binary Hotfixes description from LCS

As it stands, I have spent quite some time painfully extracting X++ and Binary hotfixes description one at a time from LCS preparing release notes for my clients. This is because there is no feature in LCS (yet) which can allow export of this information.

If you are in the same boat, and you need to prepare release notes urgently, here is a tool by Tomek Melissa that you must try. Please note that its not a Microsoft supported release so you need to try it at your own risk.

https://github.com/Microsoft/2LCS/releases

 

PS: I have tried it and it works like a charm! Its not limited to just what I mentioned in this post.

-Hitesh Manglani

 

A process serving application pool ‘AOSService’ suffered a fatal communication error with the Windows Process Activation Service.

When trying to host the Demo VM in the company’s data centre (host) we came across the below error-

A process serving application pool ‘AOSService’ suffered a fatal communication error with the Windows Process Activation Service. The process id was ‘3680’. The data field contains the error number.

One thing I attempted to do, based on some suggestions on the web, was to “Enable 32-Bit applications” in the app pool.

This simply changed the error message to below-

Could not load file or assembly ‘Microsoft.Dynamics.AX.Security.SidGenerator’ or one of its dependencies. An attempt was made to load a program with an incorrect format.

I tried all the usual tools to try to troubleshoot the issue-Fiddler, Procmon, but no lead. Finally reached out to my mentor Brandon Ahmad . He was quick to point out to check the time zone on the Demo VM which may not be matching the host machine.

The demo VM was set on US Time Zone and the host was set to Singapore Time Zone, once I changed the timezone in the demo VM to match the host, that fixed the issue!

 

-Hitesh  Manglani

The significance of being in the zone, time zone that is.

This is a post with respect to how combined date/time fields is handled in AX/Dynamics 365 for Operations (Dyn365FO). For more information on the type of date and time fields in AX visit the following link from docs.microsoft.com.

Date/time data and time zones

Dyn365FO stores combined date/time fields internally in the SQL database based on UTC time zone. Whenever the date is to be displayed to the user, an offset based on the user preferred time zone is applied and then shown to the user.

This preferred time zone is set in the following section in Dyn365FO.

System Administration-> Users -> Users

User Options

Options-> Preferences

Time Zone

An excellent post that take a deeper dive on the subject along with the X++ code is found in the below link

Working with utcDateTime Functionality in Dynamics AX 2012 – StoneRidge Software

 

-Hitesh Manglani

 

© 2023 Dynamics Journal

Theme by Anders NorenUp ↑