Solved
While deleting the stock item through import scenario getting the below error
Best answer by Laura02
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.
+19Hello
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.
+19On 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.
Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
+13debas56 wrote:
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
Acumatica Functional Consultant & Customer Experience Supervisor
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.