Thursday, March 25, 2021

D365 Finance & Operations : Clearing cache to refresh the data in tables and forms

 Recently we came across a problem where the data in the tables is not getting refreshed with the updated data (especially in master tables such as Customers, Vendors, items etc.,) . This normally happens when you have a large implementation and there are more than 10 AOS. Since D365 FO is a web based ERP it uses techniques for data caching to retrieve the data faster.


To overcome this problem, open a new tab in the browser (in the same browser where you FO instance is open) and type the below url (replace the underlined portion with your FO url). Once this is done, the caching issue should be resolved.

https://<D365FO url>/?mi=SysclassRunner&cls=SysFlushData

Sunday, September 13, 2020

Do not create Vouchers with open and closed brackets such as "(" ")" in D365 FO. These vouchers will not be allowed to be settled or be search through voucher transactions

We had a case where D365 FO allowed to create and post general journals with voucher number starting with a parenthesis (or brackets) such as (O)-123456.

Although the D365 FO allows you to post voucher with open and close bracket special characters it is currently not supporting the parenthesis while doing voucher inquiry and users will be unable to perform settlement.

Microsoft D365 FO might come out with a complete fix for this issue with their future updates, but currently this will be an issue to use special characters such as "(" or ")"

While trying to search for the voucher you will face the below error:

"Query extended range failure: Syntax error near 3."

Do not create Vouchers with open and closed brackets such as "(" ")"  in D365 FO. These vouchers will not be allowed to be settled