You’re offline. This is a read only version of the page.
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
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:
Joe
I had MS write some Dexterity code to stop the Last Originating Cost from being updated.
Yes, that is how it is designed to work. We had MS create a customization for this years ago.
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.
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.
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (