We have a situation where erronous product IDs have been created, and to comply wuith standard we need to change product id on several hundred installed items. Anybody know of an import for this, or if it is easy to make one ourselves?
Solved
Astea 15.4: Update product ID on installed items with import
+11Best answer by Phil Seifert
Hi Bjørn,
These installed items were only generated with an import, right? No logistics transactions involving these specific items within Alliance?
The bpart_id is now available in the database (what happened to the old bpart_id)?
They are not already part of the contracts?
One option for handling this would be:
- Import to delete them with the Installed Item
-
And then import them again with the correct Product ID’s. This will result in new item.item_id values so if you had these on contracts already there is more work to be done to modify the contract lines which also refer to the item_id as well as the bpart_id.
Hopefully, you caught all this in an early enough stage. If the contracts have been created, you may consider canceling them and create new ones.
Just my thinking.
+23Hi Bjørn,
These installed items were only generated with an import, right? No logistics transactions involving these specific items within Alliance?
The bpart_id is now available in the database (what happened to the old bpart_id)?
They are not already part of the contracts?
One option for handling this would be:
- Import to delete them with the Installed Item
-
And then import them again with the correct Product ID’s. This will result in new item.item_id values so if you had these on contracts already there is more work to be done to modify the contract lines which also refer to the item_id as well as the bpart_id.
Hopefully, you caught all this in an early enough stage. If the contracts have been created, you may consider canceling them and create new ones.
Just my thinking.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.