Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Invoice cost higher than receipt

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

We received 10 items at a cost of $10.00 each. We were invoiced at $11.00. We should have been invoiced at $10.00 which is the correct cost. The item card shows $11.00. How do I fix this issue.

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Invoice cost higher than receipt

    Thank you Mariano. We received the item at the correct cost of $10.00 so no need to adjust the cost. And yes we would do a credit memo to fix the payable. My dilemma was the item card being updated for the invoice price rather than the receipt cost (seems like a quirk of GP). I can see now that the receipt cost is what hits COGS upon sale rather than the item card cost or invoice cost.  The easiest answer is to just adjust the current cost under Item Maintenance as you suggested.

  • Verified answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Invoice cost higher than receipt

    Two ways to deal with this:

    1. You can perform a cost layer adjustment for the receipt, under Inventory > Utilities > Adjust Cost; update the current cost under Item Maintenance; and enter a credit memo in payables for the overbilling; or,

    2. If none of the items from that cost layer have been sold and an invoice has not been entered, you can enter a straight up Purchasing Return and re-receive the item against the same PO at the correct cost.

    If the items have been received, the invoice has been posted, and the items have been sold, you will want to select an Inventory with Credit type return.

    For more info on Purchasing Returns, please refer to [View:https://support.microsoft.com/en-us/help/936280/information-on-the-return-transaction-document-types-that-are-availabl]

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at
    RE: Invoice cost higher than receipt

    I am pretty sure thats how actual cost works...unless you use standard cost then the 1.00 difference would go to a variance account...the standard cost is updated when warranted...I dont know why you would pay an invoice that is more than what was agreed on...??

    We use Standard cost...and we also have a current cost which is the last invoiced price...we review this regularly and update the standard cost if it is going to be the permanent cost going forward.

    Sometimes we buy things from other vendors at a higher price due to supply and demand...the difference goes to the ppv account....but if it is a one off purchase we keep the standard cost as is

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Invoice cost higher than receipt

    The PO was $10.00, the receipt was at $10.00, but when I did the invoice match at $11.00, the current cost shows as $11.00 on the item card. The cost should have been $10.00. The vendor overbilled.

    This is just what I did in the TEST company. I'm new here and I understand that they do not receive merchandise until they get the invoice for this reason.

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at
    RE: Invoice cost higher than receipt

    isnt 11.00 the actual cost then??

    why was it received at a higher price...what price was on the PO?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Invoice cost higher than receipt

    We're not using multicurrency.

    We're using actual cost-FIFO

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at
    RE: Invoice cost higher than receipt

    Are you using multicurrency?

    Are you using Actual or Standard cost?

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

News and Announcements

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans