Would love to hear from anyone that can help. Our problem is that the average cost reported by Dynamics is way out of line with the actual cost. The cause is large Posted Values in InventSum without quantity. In this case the cost price is $4 and the average cost is $48.
On configuration we have set physical value down to location and financial at the site level. Our primary stocking location goes down to warehouse. We are also configured to close non financial inventory transfers in Inventory parameters.
The result is our perfect storm! We transferred inventory from one warehouse to another in the same site. The inventory item cost was briefly incorrect. This resulted in large amounts being added to the InventSum location record. Zeroing out the quantity with a PL still leaves $400,000 on the InventSum record with 0 quantity. The next time we use the location the huge number is back.
Since these were non financial transactions and we were tracking at the site level nothing is editable and recalculation and closing witll not touch the amount. We could kill the location but we would love to find a way to fix the value or take it to 0! The system reports for inventory do not seem to respect the financial setting of site since they return the incorrect average cost based on the bogus transaction rather than the item cost price from the item price file since we do not stock at the site level just the site / warehouse / inventory level.
How can we fix? It seems to be a large hole in the code.
I have tried to use the adjustment function in close and recalculation but the transactions do not even show up.
Regards
Konrad
*This post is locked for comments
I have the same question (0)
