170
Hi.
Dynamics GP2018 V 18.4.1384
We just got Purchase Order Generator to begin to work for us, but now we have to input the PRIMARY VENDOR in the ITEM MAINTENANCE > QUANTITIES AND SITES screen.
We have about 7000 Inventory Items that we need to do this for.
I don't see anything in UTILITIES (I looked at Price List Utilities, but that has nothing for this task).
Is there a quick way to do this? Perhaps a SQL Table (copy pasts thing) or something like that?
Thank You.
Clay
Joseph, thank you for your answer,
I built a quick integration, it ran for 33 minutes (did about 5000 items for us).
Now Purchase Order Generator is work nicely (when compared to the huge spreadsheet that I ran previously and then would copy past from the spreadsheet to get the items to order into a manual PO).
Thanks again.
Clay
Hi Clay-
It would all depend on the vendors that need to be assigned to the items. In SQL, you can get all of the records from IV00102 (this is all the data that shows on the Item Quantities Maintenance screen), by this query:
SELECT * FROM IV00102 where RCRDTYPE=2 and PRIMVNDR=''
This is going to give you all the inventory items (including any inactive or discontinued ones) that are assigned to your inventory Site IDs with no Primary Vendor ID entered. You can copy/paste these results to Excel.
The field you will need to fill in is the PRIMVNDR field -- this is the vendor ID number.
Obviously, this is getting slightly complicated now because the safest way to import this data back to GP is using an integration tool like Integration Manager or SmartConnect. It will follow all the data validation rules.
You can go the SQL route to update the items, but again it would depend on what vendor needs to be assigned to what item.
Joe
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 (