Overview

This article will explain what frozen fields are, why they are frozen, and how to manage them effectively in the Item Master.

What Are Frozen Fields?

Frozen fields are fields in the Item master that become read-only after certain actions are taken, such as creating stock ledger entries. Once frozen, these fields cannot be edited unless specific steps are taken to unlock them. The primary frozen fields in iVendNext include:

1. Maintain Stock: Indicates whether stock is maintained for the item.

2. Has Batch No.: Indicates whether the item is tracked by batch numbers.

3. Has Serial No.: Indicates whether the item is tracked by serial numbers.

Why Are Fields Frozen?

Fields are frozen to prevent inconsistencies in your inventory data. Once stock transactions are created for an item, changing these fields could lead to mismatches between the actual stock and the stock levels recorded in the system. Here’s why each field is frozen:

1. Maintain Stock

• Once stock ledger entries are created for an item, the Maintain Stock field is frozen to ensure that stock levels are accurately tracked. If this field were editable, users could accidentally disable stock tracking, leading to discrepancies.

2. Has Batch No.

• For items tracked by batch numbers, the Has Batch No. field is frozen to maintain the integrity of batch-based stock calculations. Changing this field mid-way could break the sync between batch records and stock levels.

3. Has Serial No.

• For serialized items, the Has Serial No. field is frozen because stock levels are calculated based on the count of available serial numbers. If this field were changed, the system would lose track of serial numbers, leading to inaccurate stock reports.

When Do Fields Become Frozen?

Fields become frozen under the following conditions:

• Stock Ledger Entries: Once a stock ledger entry is created for an item, the Maintain Stock, Has Batch No., and Has Serial No. fields are frozen.

• Batch or Serial Number Records: For items tracked by batch or serial numbers, these fields are frozen as soon as the first batch or serial number record is created.

How to Make Frozen Fields Editable Again

If you need to edit a frozen field, you must first delete all related stock transactions and records. Here’s how:

1. Delete Stock Transactions

• Go to the Stock Ledger and delete all transactions related to the item.

• For batch or serialized items, ensure that all batch and serial number records are also deleted.

2. Unfreeze the Fields

• Once all related transactions and records are deleted, the frozen fields will become editable again.

• You can now modify the Maintain Stock, Has Batch No., or Has Serial No. fields as needed.

Example Scenario

Let’s consider an example where you have an item "Blood Pressure Monitor":

1. Initial Setup:

• You set Maintain Stock to Yes and Has Serial No. to Yes because the item is serialized.

• You create stock ledger entries and serial number records for the item.

2. Fields Frozen:

• The Maintain Stock and Has Serial No. fields are now frozen.

3. Need to Change Settings:

• If you decide to stop tracking serial numbers for this item, you must first delete all serial number records and stock transactions.

• Once deleted, the Has Serial No. field will become editable, and you can set it to No.