From: dishborealis@yahoo.com   
      
   "Rodney Wise"  wrote in message   
   news:460d35c0$1@pnews.thedbcommunity.com...   
   > Joe,   
   >   
   > Also note... if a transaction history has been established for one of   
   > these items... such as "16L0A1061A"... then your historical reporting will   
   > be all wrong.. because the sales data was based on that item number.   
   > Your inventory values and totals will be all wrong too.   
   >   
   > Typically, it should be impossible to delete an inventory item once a   
   > transaction on it has occurred... such as purchase or sale.  Doing so will   
   > effect the entire system.   
   >   
   > If you change the item number, it will also have to be changed on every   
   > invoice, sales reciept, historical report, etc., etc., etc...   That is   
   > whay it is illadvised.   If a customer would bring one of these items back   
   > for a refund, their reciept will no longer have a valid item listed on it.   
      
      
   Fortunately, Rodney, this is a much simpler situation. These are   
   freestanding tables containing data (sometimes nice data, sometimes ugly)   
   sent to us from companies we buy from or sell to. Sole purpose, as stated by   
   our contacts: "Don't call me unless you know we carry the item. I'll send   
   you the data so you can check first".   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)