Trouble Deleting Old Items

[lonegator21]

Running Progression 7.6.300B - 32 bit. When trying to delete some old items, keep getting error stating "Item has customer item records on file." How can I clear this out so items can be removed completely from inventory?

 

[crystalreporting]

Look in Customer Items under OE/Maintain - these records are held in the OECUSITM table. The following tables are checked when an item is deleted:

BMPRDSTR – check for component
IMORDBLD
OEORDLIN
MSSCHFIL
MSFRCFIL
BMPRDSTR – check for parent
ININVLOC – all quantities at all locations are zero
IMKITFIL – kit component
IMKITFIL – kit parent
IMINVBIN
BMFRTFIL – feature
BMOPTFIL – feature option
POITMVND
OEPRCFIL
OECUSITM
IMTAGFIL

Peter Shirley

http://www.srhconsulting.com