Current Cost and Inventory Adjustments

(0) Share

Report

Posted on by john.ellis

3,482

Hi:

A GP 2016 end user would like for the default Unit Cost for conducting Inventory Adjustments to "pull from" the Last Received Cost in the Unit of Measure from the receivings transaction -- not from the cost in the base unit of measure.

Instead, Unit Cost for adjustments pulls from Item Maintenance Current Cost. This Current Cost is in the cost for the base unit of measure.

The end user does not own Modifier with VBA. She does have a Customization Site License. But, we would hate to have to accommodate a customization.

Are there any workarounds that would allow for adjustments to pull from the cost that is based on the receivings unit of measure?

Thanks!

John

Categories:

Microsoft Dynamics GP

All responses (1)

Answers (0)

Suggested answer

Angela Eckman Ebens... 1,216 on at

Like (1)

Report

RE: Current Cost and Inventory Adjustments

Hi John,

The system is designed to always pull from the Unit cost on the Item card (current cost) for those perpetual items when doing an increase adjustment. The only time is pulls differently is when you sell the item in inventory (or do a decrease adjustment) and then it pulls the unit cost from the inventory layer based on the valuation method and the layer it's pulling from at the time you post.

There is no tool or option to change how it works with inventory. The only option is for POP where we have the PSTL Cost changer to default in either the Current cost or the Standard cost into the Purchase Order instead of the last originating cost of the vendor for that item. But unfortunately for inventory there is no way to change how it works without some type of customization.

Warmest Regards,

Angela Ebensteiner

Microsoft