I have had this query a few times before & just recently had it again.
For clients contemplating upgading from 6.xx to 7.xx many if them have obsolete and/or deleted inventory.
When they upgrade, they do not want these items to come across.
Whilst it is easy to DELETE FROM IN_Main where STATUS IN (2,4) I have a few questions prior to doing this
1. Would it be best to remove them from the table(s) prior to upgrading or after?
2. What would be the impact with regards to referential integrity, mainly for the transactional tables such as SO_Lines, QO_Lines, PO_Lines, WH_TransferLines, IN_StockTakeLines, IN_TransferLines and so on? Should I also delete the records from those tables? The client(s) wouldn't care because they'd be really old transactions from several years ago.
3. Obviously I would also need to delete from the following tables also.
IN_SellingPrices
IN_OnBackOrder
IN_DebtorSpecificPrices
IN_DebtorClassificationSpecificPrices
IN_Creditor
IN_SupplierWarehouse
IN_GroupLink
IN_Upsell
IN_OrderLevels
are there other tables I've missed?
Are there other consequences I should be aware of?