18
Hello, Is there a way to update the fields standard, and current cost in bulk by vendor?
we have way too many SKU's to update manually, and I was wondering if there is a way to export a vendor to excell, update the cost and the selling price and then import it back to GP.
thank you
*This post is locked for comments
Your choices are SQL scripts or integration tools like smart connect that can be used for updating as well as importing, but these are not really an end user tool.
Alternative would be to write a Dynamics GP macro using mail merge (google it, lots of examples of how to do this online). You then run the macro and leave it to update your records, this is a relatively safe way of doing mass updates without the risk of going direct to SQL table data, the user interface still enforces the business rules when running a macro, so less chance of messing up.
Our product managers tend to use this method, it is easy to get the hang of after the first couple of goes.
Tim
Hi, We have done a similar solution for our customer, this solution will have the ability to export the Inventory list with items , SKU to excel, then the user can update the cost & then importing to GP automatically. If you are interested Please drop an email to learn.
samr(at)expsoltech(dot)com
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,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (