Best answer by Laura02
View original
+18
Hello
Inventory Items with transactions/quantity on hand cannot be deleted from Acumatica.
We can only import what we can manually type in the screen. If you select item 92000101 to the Stock Items screen and press delete manually, do you see the same error: Item cannot be deleted because of non-zero quantity in the WIST warehouse?
If you have a long list of Items to be deleted, my suggestion is to Unselect ‘stop on error’ and allow the import to delete items that may be deleted. The remaining items can be inactivated.
Userlevel 1
+18
On Import by Scenario screen, unselect ‘Stop on Error’ and allow your scenario to Process all the way through. Acumatica will delete all the stock items where they don’t have balances and transactions. Then, You can export from the Import by Scenario screen all the lines that do not have ‘Processed’ selected on, to Excel. This is the list of stock items that you want to change Status on. Make a second import to change Status to Inactive for only the items that could not be deleted.
Userlevel 7
+12
Hi
Make the item as Inactive once the Import scenario is completed.
To run the import scenario by disabling both checkboxes with errors, the process will perform the other records ( Skipping the Problematic items)
Thanks
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.