Skip to main content

Notifications

Microsoft Dynamics GP forum
Suggested answer

Current Cost and Inventory Adjustments

Posted on by 3,480

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:
  • Suggested answer
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans