No, because it's active.  You must first purge out all transactions from that warehouse.

Dawn

Thank you, is there an easy way to purge the transactions?

Yes but note you cannot or should not delete the default warehouse of "000" or bad things will happen.

Note that I have helped people do this by dumping the transaction history out to a file, then clearing the file in MAS and re-importing in all records but what they wanted to get rid of.

Dawn

I decorate various types of trade shows, I set up each show as a warehouse to keep them seperate. I do not put in an inventory, so i use the negative numbers for my counts, I have done this for the past 13 or so years, it works fine. But after all these years my warehouse list is very large. When i try to delete them, i cannot because they are active. Years ago (when we had money) i had my reseller write a program that removed them, i did that every time i upgraded, finally we ran out of money. I have warehouses from 10 years ago, we are running out of numbers and letters that aren't used  I just need to know how to make the warehouse inactive but do not know how to purge them out. Thanks in advance. 

So what are you tracking?  items used during the show?  Do you also have sales orders?  If you are on a recent version of MAS (later than v4.1), you could add a line UDF to the SO order and or the SO invoice detail lines.  Code this UDF to be the tradeshow that you used the item at.  The design a Sales history report to pull items based on this UDF value.  You could even create a UDT to ensure that the proper codes are used by everyone.

Have you ever considered the Job Cost module? As for the warehouse part when you purge the IM5, Item Transaction file it summarizes the transactions so that it still ties to the GL. Since you setup each show as a warehouse I am guessing that warehouses/shows from years ago can be done away without having any effect on current shows.  I would suggest purging everything prior to say 01/01/2008.  Once this is done you should be able to delete the warehouses.

I would like to contact my reseller to make things easy, unfortunately i can't afford it at the present time. As each show is used for a warehouse we do not need to keep them in the system once i run a stock status report and print it. I do use sales order. I do need to know how to purge the IM5 Item Transaction Flie? is this done through DFDM?

1. Create a test company using Copy in Company Maintenance.

2. Go into Inventory

3. Go into Period End Processing.

4. Select Purge Transaction Detail

5. Set date

6. Purge

7. Attempt to delete old warehouses.

8. Run your normal inventory reports to check.

hmeyer,

You have a couple issues:

(1)  Cleaning up what has been done in the past

(2)  Doing things correctly going forward.

On #1, you can go under Inventory Management --> Period End --> Period End Processing --> Only remove transaction detail option to remove data from IM5.  Make sure to change your IM date prior to doing this as to where you want to purge through.

On #2, I have another customer that does shows and their best choice is to use the job cost module because they can accumulate costs for the shows such as hotels, meals expense, travel costs, etc. as well as the materials and labor allocated to the show.  As far as the job number you have 7 characters so you can use the last 2 characters as the show year which will accomodate you for 99 years.  You can use Crystal to do a multi-year comparison report to see how a show does year by year.

Plus, by using job cost, you can enter budgets for the show, track actuals, see the variances, and record change orders to the shows increasing the contract amount.

The only concern would be if you don't have much money to spend, if you do not have the job cost module you would have to purchase it, get it installed, get trained on it, and implement it.  Plus, if you are not current on maintenance you would have to get current with Sage before you could buy it.

Dawn