Extract Inventory Balance To Delete Zero Quantity Records
To maintain a clean and relevant dataset, you have the option to flush out or purge records with zero quantities during the extraction process. This ensures that your inventory data remains concise and up-to-date.
We've added the following Scheduled Jobs:
Scheduled Job | Description |
---|---|
Extract Inventory Balance Snapshot | This job will now include zero quantity records for the specified SKU/BATCH/EXP_DATE/INVENTORY ATTRIBUTE combinations. You can choose to retain or purge these records based on your preferences. |
Generate Inventory Balance Snapshot | The extraction rule can be configured to handle zero quantity records. You can select whether to include or exclude these records in the generated snapshot. |
Delete Zero Quantity Records Extracted Parameter
You can manage including ERP buckets with zero quantity from the previous run using the delete_zero_qty_records_extractedparameter in the Extract Inventory Snapshot scheduled job.
- The parameter accepts values "Yes" or "No".
- By default, it is left blank, ensuring zero quantity records are not flushed out.
- If set to "Yes", the system will delete zero quantity records for the specified SKU/Inventory combinations after the extraction process, keeping your data tidy.
- If set to "No", all records, including zero and non-zero quantities, will be extracted without purging.
You can access and configure this parameter in the Item Summary Generation Rule View UI for extraction rule types, ensuring a seamless and controlled inventory management experience.