Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Inventory - Adding & removing items at average cost

Posted on by Microsoft Employee

Hi,

I'm fairly new to GP so please forgive what might seem to be a simple question.

Here is my scenario: I mistakenly took into inventory the wrong item whose value was $2,244.00. The average cost of that item is $2,288.20.
How do I remove that item with the different in cost?

Please reply with steps in detail.

Thanks!

Faye

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Inventory - Adding & removing items at average cost

    Hi,

    The system will create the journal entry for you. I'm sorry but I am not familiar with Studio Enterprise by Donor Direct. As far as Adjustment vs Variance - the only difference is the default offset account. One side of the entry is inventory, the other side of the entry is whatever is set for that document type. The effect on inventory is identical.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory - Adding & removing items at average cost

    Hi Leslie,

    Thanks for your reply.

    I haven't sold any of the items, so is there a need to make a journal entry? Why or why not?

    Thanks,

    faye

    PS. I work for a non-profit and the items in inventory are donated medical items. After adding the items into inventory on GP, then there are entries against the donor's profile for giving/revenue purposes. Any chance you're familiar with Studio Enterprise by Donor Direct and could advise how this error in inventory affects that?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory - Adding & removing items at average cost

    Hi Ray,

    Thanks for your reply.

    I did the original transaction as an Inventory Adjustment.

    So to remove the item, I again use Inventory Adjustment but with a negative number, and at the avg cost?

    And, just to be clear, why not a Variance instead of an Adjustment?

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Inventory - Adding & removing items at average cost

    Hi Faye

    The Adjust Costs utility will change the cost of that layer of your inventory and recalculate average cost as if that cost had been used originally. It's exactly what the tool was designed to do. The utility will print reports and you may need to make a journal entry to adjust sales if any of the those items have been sold.

    Kind regards,

    Leslie

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory - Adding & removing items at average cost

    Hi Faye,

    what how did you do the original transaction ? through inventory adjustment or receiving PO.

    If it is PO receiving then do return for the same item then receive it with the correct cost.

    Case 2 if it was inventory adjustment just do the same thing with -1 to remove it but it will be removed with Avg cost at this point.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans