Our client is not able to get full month report in D365 called "Potential conflicts - inventory and general ledger"

A properly configured inventory value report showed the customer's difference between Inventory and the General ledger.

In such cases client used to run the report "Potential conflicts - inventory and general ledger" and search for problematic transactions.

Since the new version of the system some changes was made by Microsoft and the report which had generated 1 hour and contained 15k lines in excel - now generates over 28 hours and ends with an error.

Microsoft workaround is to run it with filters to split full month to smaller parts.

OUR suggestion is - to prepare by Microsoft option to get aggregated version of the "Potential conflicts - inventory and general ledger" report.

Now, detailed version has such columns: Item number, Date, Lot ID, Reference, Value, Comment

Aggregate data to columns: Reference, Value, Comment

Of course, we are open to get any other working report like "Inventory to ledger reconciliation".