930
Having an issue, which is to find a way to update costs when provide new price lists for vendors, and would like to get the field from the "Item vendors Maintenance" in GP to overwrite it in Integration Manager.
But could not found where this is related to Integration Manager.
Have someone encounter similar issue or what is the way to go about it?
Thank you for the reply
*This post is locked for comments
Could you provide a brief code sample of this operation using this specific example (originating invoice cost) and field scripts? Thanks. Jeff
Hi Leslie,
As stated in your reply, both solutions given by Richard and you have answered the concern. But your (Leslie) is more clearer and near to the situation faced.
Thank you for providing such approaches to go about this issue.
Hi Sergion,
Richard's approach is one way to do it, let me propose a different way. Neither is better than the other, it's really just a matter of which you are more comfortable with. Lot's of other solutions are out there, but not the one you want. I presume the one you want is to have the vendor price available as a destination field in the Integration Manager adapter. You aren't missing anything, it isn't there.
If you are getting price lists from your vendors, I presume you can turn that list into something, like an excel spreadsheet, that includes the Vendor ID, the item number, and the new price. What I think you want to do is update the Originating Invoice Cost field on the Item Vendors Maintenance window. No problem. It will take a little (and I do mean little) VB script, but you can use IM to accomplish your objective.
What you will want to do is add a Field Script to one of the fields in the Vendors section of the distribution mapping that will execute an update statement to change the cost in the Item Vendor Master. With this in place, you can use IM to do any other updates you need and update the vendor prices too. The field script isn't nearly as complicated as it sounds, and I think it would be a good answer for you.
Kind regards,
Leslie
Updating the cost field has a number of ramifications. If you have inventory on hand, you certainly do not want to change any of the cost fields representing the cost of that inventory. This would create differences between the Stock Status cost of inventory and the GL value and reconciling.
IF however, you only need to update the cost paid to vendors so that POs will reflect the new cost, update the fields in the Item Vendors Maintenance Screen. These cost fields are unique to the prices the vendors charge and are not related directly to the value of inventory on hand.
To do this, put your part number, the vendor part number and the new cost in a CSV file. Import this file into a new table in your company db. Write a view that links the new table to the vendor item master table for that one vendor only. Then do update statements against the view.
These instructions are vague as mistakes here can cause problems. If you know SQL and the GP tables, you can do this with the information provided. If not, call a consultant to do it for you please.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (