Sunday, April 18, 2021

Multi-String or multi-field search using the same search/filter box (dynamic real language search) in D365 FO

In real life the searching based on multiple variables is a common requirement across all customers. For example a common requirements would be to search for works orders belonging to "Vendor A" dated 4th January 2021 using the common form filter such as this one below:


Google search for that matter allows you to add a symbol "+" and search with different strings. This is also very common across public facing applications such as LinkedIn, Facebook etc., As the D365 FO has transformed cloud based and web based solution (from the traditional Rich client/ local server based version), business wise too the several companies started adopting D365 FO as a single solution for frontend and backend operations overlayered by business specific apps for specific business needs.

Many of you are already aware that such a multi-field search (forget about the real-life dynamic searches such as the one offered by Google search) are not offered in all the forms of D365 Finance & Operations.

Wait a minute? Not all forms? which means this multi-field search exists for at least some forms? such as?

These questions would come into your mind with the above statement. We have some raw form of multi-field search using the same search /filter box in some of the forms in the D365 FO. Take for example the Main accounts form. The filter option available in the main accounts could search both the Main account and Name simultaneously.

Inorder for the framework capabilities to be enhanced and as D365 FO is transforming into a true ERP serving to every single business need (instead of the so called Back-Office solution or large scale book-keeping system or white elephant in the room), this multi-string or multi-field search using the same search filter option is vital. 

We have the new and improved grid / form functionalities released sometime in 1st half of 2020, however they are still not stable. Let us hope and wish Microsoft brings the multi-field search or dynamic real language search into D365 FO.


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