Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Costing concern, Items fully received at "lower" price,

Posted on by 3,795
Item valuation = Average Perpetual


Scenario:

    Purchase Order for
    100 units                              @ RM 50/unit                  = RM 500

Because of the project is still on-going,

                Vendor bill TMS for the 100 units shipment
                100 units received           @ RM 20/unit                    = RM 200


Then the Vendor bill for the Remaining amout of                    = RM 300


Because of a specific reason (the project is still on-going), the vendor “adjust” all those items at a “lower” unit price, even if all inventory item have been fully received. So, if the receiving shipment recorded at the “lower” unit cost, so those transactions is affecting the item cost.

We would like to know the best way to handle/record those transactions. Many thanks in advance.

*This post is locked for comments

  • William Kow Profile Picture
    William Kow 3,795 on at
    Re: Re: Costing concern, Items fully received at "lower" price,

    Many thanks for your reply.

    Hmmm...entry for the shipping quantity recorded different than the actual quantity received, then we can have a problem of stock quantity available for resell those item.

    Referring to your suggested entries, assuming starting with zero stock balance, and we received 100 units at RM20, but we enter as 40 units  at RM50 in order to get the billing amount as RM 200 but actual received is 100 units, what if we need to sell it more than than the recorded quantity (eg. 50 units), anyway we will never able to know the customer order quantity. What if during the period we need to do stock count.

    Thanks

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: Costing concern, Items fully received at "lower" price,

    To maintain accurate costing, I would match the first invoice to 40 units of the shipment receipt and the second invoice to the remaining 60 units.  That way, the unit cost will be accurate in both cases.

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans