Is there an efficient way to delete all of the posted, serialized inventory form a site in GP?
It was all imported using econnect as an adjustment, and was posted. It's been discovered that the serial numbers were incorrect. We have 70K items to clear out, so mass deletion is required.
Thanks!
*This post is locked for comments
Okay, we are clearer about this issue now.
I believe you could then record a macro, and use an excel to utilize the functionality of it in making your data entry more dynamic.
The macro should simply go through all the incorrect serials for all the items in this specific site. There is no other way to withdraw all the incorrect serial for one site other than "adjustment out' with several line items.
Mahmoud,
I unfortunately don't have database access to this installation. Your method looks sound, but I need a front-end solution sadly.
That really depends on what is your end target of the correction. Let me go through several scenarios with my personal assumption on each of them
First scenario, supposing that you want to remove those "incorrect" serial number for a specific item/s, and re-enter the correct serial number;
Another scenario, supposing that you want to remove both the tracking option and the incorrect serial number, and leave the item/s with "None" tracking option.
You could go through the steps above, and never run the final update statement which returns the tracking option to "serial", which will leave your item with "None" tracking option.
Most importantly, I never recommend running such update or delete on live environment . As long as such a suggestion is derived from my own experience, you could run them on a test environment to ensure their validity. As always, back up is a must.
Hope this helps,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156