Originating invoice cost changes with Accounting Invoice matching

(0) Share

Report

Posted on by Community Member

I'm a purchasing manager in the Dominican Republic using GP2013 and since ever we've had an issue with the vendor maintenance. We're a retail company and we buy and sell final items, so our issue is just when a vendor changes a price list (up or down) I change it in the Originating invoice cost but when a vendor invoice is matched with a different price, the change I made is substituted by the Last invoice cost. Is there a way to change the way GP works? Because with all the po's we place we can't revise every order one by one and it doesn't sounds logic to change an actual cost with a past invoice cost.

Thanks in advance for your help

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

DinB 3,951 on at

Like (0)

Report

Is there any solution for this? How can we stop GP from automatically updating the Originating Invoice Cost in Item Vendor Maintenance? I am looking into SQL Trigger, but if anyone has implemented working solution please advise.

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (1)

Report

GP is working as designed. (I hate that phrase but in this case it is true). You must be using FIFO or LIFO perpetual as inventory valuation.That is the meaning of perpetual. The cost is updates as new receipts come in from the vendor. If you were using stand cost then the costs would be updated at the end of the year. You may want to consult with your accountants on this.

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

You say you are changing the cost but when a receipt is posted GP is changing it to another cost. Why aren't these two costs the same? You are fighting the logic of all ERP solutions. You order goods from a vendor and the vendor then invoices you at their current cost. This then becomes the Last Originating Cost for this item/vendor combination. This is how using current costing works(Perpetual). Now if you were to switch to standard costing(Periodic) this cost would not change but that now affects the accounting of these transactions because you introduce cost variance. There is also Average Cost but that is different as well.. Perhaps this link helps explain it.

https://community.dynamics.com/gp/f/microsoft-dynamics-gp-forum/105962/inventory-standard-cost-vs-current-cost#:~:text=Current%20Cost%20%3D%20Last%20amount%20paid%20for%20an,for%20a%20period%20of%20time%20%28usually%20a%20year%29.

Was this reply helpful? Yes No
DinB 3,951 on at

Like (0)

Report

The problem is that the Last Originating Cost becomes the default Unit Cost in new PO. So the latest vendor cost can get automatically overwritten by Unit cost in Invoice for old POs. We can change the default Unit cost to Standard Cost using PSTL, but that does not allow us to enter different currency.

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

Yes, that is how it is designed to work. We had MS create a customization for this years ago.

Was this reply helpful? Yes No
DinB 3,951 on at

Like (0)

Report

Richard, What kind of customization was it?

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (1)

Report

I had MS write some Dexterity code to stop the Last Originating Cost from being updated.

Was this reply helpful? Yes No
David Musgrave MVP ... 14,095 Most Valuable Professional on at

Like (1)

Report

Does this article help?

winthropdc.wordpress.com/.../

David

Was this reply helpful? Yes No
Joseph Markovich 3,976 on at

Like (1)

Report

This might be overkill, but there are add-ons out there that will let you store a matrix of prices for your vendors.

It will override the last originating cost issue by just reading the item/quantity combination (or more) and either prompt you to select a cost or just automatically enter the appropriate cost in PO Entry or PO Generator.

One is from Dynavistics:

www.dynavistics.com/vendor-price-management-enhancement-for-dynamics-gp

One is from ICAN Software Solutions:

icancloudapps.com/.../

Joe

Was this reply helpful? Yes No