VALIDATE_RECORDS_SQL (valrecsb.pls) removal of primary_cost_pack validation and implications thereof
Good day
Our client is not using primary_cost_pack items as per base RMS 13.1.4.4.
We are in the process of purging items through the dlyprg batch but note that pack items have their associated packs specified as the ITEM_LOC.primary_cost_pack.
There are two possible solutions to have these items made eligible for purge, ie:
1. Manually update each ITEM_LOC record at packitem level and set the primary_cost_pack column = null - this will trigger a multitude of messages to store systems and tills. OR
2. Remove the VALIDATE_RECORDS_SQL C_ITEM_PRIM_PACK cursor lookup and insert into daily_purge_error_log. This will allow DELETE_ITEM_RECORDS_SQL to purge the item off of RMS when deleting from ITEM_LOC.