Calculate Warehouse Adjustments

jflynn

We are currently on NAV 2009 R2. In the Calculate Warehouse Adjustments report there is code that accesses the Item Unit of Measure table for the Qty. per Unit of Measure instead of using the Qty. per Unit of Measure from the Warehouse Entry table. If the Qty. per Unit of Measure in the Item Unit of Measure is changed between the time the Warehouse Entry gets created and the Calculate Warehouse Adjustment runs, the Bin and Perpetual would be out of sync. Has anyone had this issue?

ara3n

I'm assuming this is a mistake and not an ongoing task.

The way to fix this is to make sure there are no warehouse shipment/receipt/transfer and pick/putaway documents for that item.

Then write a processing report that loops through all the warehouse entries for that item/unit of measure and updates the qty per unit of measure and Quantity base to the correct value.

jflynn

Rashed,

The issue did come up because of a mistake, and I got involved because they want to remove an invalid Unit of Measure. They can't because there are Warehouse Entries with that UOM. If the code used the Qty. per Unit of Measure from the Warehouse Entry instead of the Item Unit of Measure, Calculate Warehouse Adjustments would not error due to the ItemUOM.GET not finding an Item Unit of Measure that was removed.

I am comfortable with changing the Warehouse Entry table, but I do not think Finance or our Auditors are.

ara3n

Temporary add then Item UOM record with wrong qty per and let NAV run the process and zero out the quantity. Then delete the wrong item UOM and insert the correct one and do the warehouse adjust with correct UOM.

jflynn

Rashed,

In this case, they want the Item Unit of Measure removed "forever" becasue they do not want the users using it.
It looks like I have two choices.
1. Update the warehouse entries with a valid UOM and alter the quantities accordingly.
(Would need to fix each time this happens)
2. Add "Qty. per Unit of Measure" to the Bin Content Buffer table and alter Calculate Warehouse Adjustment report to populate this field from the Warehouse Entry, remove the ItemUOM.GET, and use the Bin Content Buffer."Qty. per Unit of Measure" instead of the ItemUOM
(permanent fix)

I will propose this to Finance and let them decide.

Thanks for the suggestions.

Alex_Chow

Have you reported this to Microsoft?

jflynn

Alex,

Microsoft is a big animal. Could you point me in the right direction as to how I would do this.

Thanks,

Alex_Chow

The only place I can find where you can report this kind of thing is Microsoft Connect.