Inventory Cleaning 2

[Borvik]

Is there a safe way to clean the inventory in GP?

We want to remove all items that we don't have in stock and haven't had any activity in 18 months.

 

[Dukester0122]

I would suggest use Inventory Utilities since this have preset stored procedures that clean the SQL tables but you still need to delete the item in item maintenance manually after running the utilities.

 

[Borvik]

Thanks for the reply Dukester.

I guess when I said cleaning - I meant more along the lines of spring cleaning, and removing those items - which I don't see anything in the Inventory Utilities that would accomplish this.

Also when you mention "delete the item in item maintenance manually" that sounds like it would have to be done one at a time. Is this correct?

I'm thinking of writing an SQL that would determine the items that meet my criteria and delete them, but I'm not sure what consequences that would leave throughout the rest of the system.

 

[Dukester0122]

You can write a SQL script to delete the item in IV00101 but after you use Inventory Utilities to delete the items history. Here's the step:
1) go to inventory utilities and delete the items history
2) use your sql script to delete thse items

Remember there are rules before you can delete an item:
1) No on-hand inventory on all sites
2) No allocated on all sites
3) No open invoices

I think there's more but you can try these rules first.

 

[Borvik]

Thanks Dukester, that's exactly what I was wondering.

 

[jazgeek]

sorry, not exactly the best idea dukester.

create yourself a query based on inventory history for your criteria. Alternativey a crystal report could be made.

take the output and update the item type flag on the IV00101 table to discontinue the item.

Then run utilities>inventory>year end and select the remove discontinued items.

Be warned that by running this utility you will effectively remove any history of the item and also will reset the opening inventory balance of the IV00102 table to the inventory level of the day you run the utiility.

When the process is done, any item you've marked as discontinued that are not on a salesorder/purchase order/inventory transaction or have a quantity will be removed.



-----------
and they wonder why they call it Great Pains!

jaz

 

[Borvik]

Excellent jazgeek - that saves me the trouble of deleting history.

I had found a "macro" way of doing it - compile a list of itemnumbers and generate a huge macro using the Item Maitenance window - but this seems a lot easier.

It seems like this might be better done at the end of the year - thanks to the Year End utility.

Thanks alot jazgeek!

 

[Dukester0122]

jaz - that's exactly why i'm giving bor the rules so he won't force the system. there are companies that don't like to sell the items once they decide to discontinue because of parts issues

 

[Dukester0122]

jaz - that's exactly why i'm giving bor the rules so he can decide whichever he wants. there are companies that don't like to sell the items once they decide to discontinue because of parts issues even though they still have them on stock.

 

[Borvik]

True Dukester - and from a programming standpoint what you've mentioned is definately good and I'm going to remember it.

We just want to remove the items so we don't have a disconglomoration of thousands upon thousands of items in there.

I'm going to use the SQL and the rules to flag items as discontinued and then remove them with Year End. If the sales people want to use the item - they'll just have to re-add it.

You've both been a big help.