Hello Travis,
I understand you have run through some steps to zero out the stock of an item in order to delete it. You would want to make sure you run through all the following steps:
1. On the Inquiry menu, point to Inventory , and then click Item .
2. In the Quantities area, verify that the following fields have a quantity of 0 :
• On Hand
• Allocated
• On Order
• Returned
• In Use
• In Service
• Damaged
If any of these have a quantity, you will be unable to delete the item. You must first process the transaction that has a quantity.
3. Make a full backup.
4. Remove history for the item.
Note This step removes the detailed information about transactions that were posted in Inventory Control or that were posted in other modules that affect Inventory Control.
In Microsoft Dynamics GP 10.0, follow these steps:
a. On the Microsoft Dynamics GP menu, point to Tools, point to Utilities, point to Inventory, and then click Remove Transaction History.
b. In the From field, type the item number that you want to delete.
c. In the To field, type the item number that you want to delete.
d. Click Insert to insert the restriction.
e. Click Process.
In Microsoft Dynamics GP 9.0 and in Microsoft Business Solutions – Great Plains 8.0, follow these steps:
a. On the Tools menu, point to Utilities, point to Inventory, and then click Remove Transaction History.
b. In the From field, type the item number that you want to delete.
c. In the To field, type the item number that you want to delete.
d. Click Insert to insert the restriction.
e. Click Process.
5. On the Cards menu, point to Inventory, and then click Item.
6. In the Item Number field, type the item that you want to delete.
7. Click Delete.
If you have run through all of the above and you are still not able to delete the item. Run through these next steps. The reason why is because the system thinks there is still of the criteria still out there:
***Make a full backup***
1. Run Check Links. Please make sure that your backup is still intact and that all other users are logged out of Great Plains before running this process.
Go to (File | Maintenance | Check Links). Insert the following in the Selected Tables frames:
From Series: 'Sales'
Insert the Logical Tables:
- Invoice Distribution
- Invoice History
- Invoice Work
- Sales Distribution
- Sales History
- Sales Work
From Series: 'Purchasing'
- Purchasing History
- Purchasing Transactions
From Series: 'Inventory'
- Inventory Transaction Work
- Item Master
After all these tables are selected, click on the OK button and print the report to see Error Log.
2. Redo the steps for deleting Inventory Item. Start by making sure that quantities are zeroed out for all the Inventory Items you are trying to remove.
3. Run Remove Trx History.
- Go to (Utilities | Inventory | Remove Trx History).
- Choose Item Number.
- Specify one Inventory Item number in the From and To fields.
- Click Insert.
- Make sure that the 'Remove', 'Print' and 'Remove Distributions' checkboxes are all marked.
- Click on Process.
- Print the report and see if anything history was removed.
- Go to (Utilities | Inventory | Remove Distribution).
- Choose Item Number in the Ranges dropdown and specify the Item Number in the From and To fields.
- Click on the Insert button.
- Mark the Remove checkbox and click on Process.
4. Go to the Item Master Card (Cards | Inventory | Item) click on the Delete button.
Does it let you delete the items this time? If it does not then I would recommend submitting a support incident so that a Microsoft Dynamis Support engineer can take a more detailed look at your issue.
Thanks!
Best regards,
Dan Moore
Customer Online Technical Community
-----------------------------------------------------------------------------------------
We hope you get value from our new forums platform! Tell us what you think:
social.microsoft.com/.../threads
------------------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights
