Product Entry Count Update Report overview

Product > Entry > ICE Reports > ICEPU

Function acronym: ICEPU

Use this function to update or clear the completed runs after you complete entry and reconciliation. Post the adjustments to a specific General Ledger period, and remove the count file after updating.

When you clear the run without performing an update, you do not affect any inventory counts or General Ledger balances. The run number is cleared so that you can use it again.

Special costing products are updated to the General Ledger correctly. You are not required to make adjustment entries to offset special costs.

When inventory is increased through a receiving or return transaction, or another type of adjustment, an internal receipts record is created if these conditions are met:

  • The Support Running Fill From Navigator option in SA Administrator Options - Documents Sales Orders Back Orders is selected, or the Action to Take on Completion of Receiving option is a value other than None.
  • An internal receipts record does not already exist for the company, warehouse, and product.

The internal receipts record indicates that the On Hand balance in Product Warehouse Product Setup-Costs has been increased. The stock can potentially fill an open order when Sales Entry Processing Back Order Fill Report is run.

This function does not update FIFO records.

Inventory control

When you update a run after quantities have been entered, these Product Warehouse Product Setup fields are updated:

  • Count : The count date is updated with the system’s current date.
  • On Hand: The on hand quantity is adjusted up or down depending on the count entered.
    Note: To move a serial number from unavailable to on hand or on hand to unavailable, use Product Unavailable Inventory Entry.
  • Unavailable: Unavailable inventory is included when you perform a physical count. It is treated as a separate entity from on hand inventory. Any changes from the expected unavailable quantities are also applied to the Product Unavailable Inventory Entry balance. A change to the unavailable quantity means that there is one more or less for unavailable inventory quantities, not that inventory was transferred from unavailable to on hand.
  • Addon: When a quantity adjustment to available or unavailable inventory is negative, the cost posted to the General Ledger includes addons. When a quantity adjustment to available or unavailable inventory is positive, the cost posted to the General Ledger does not include addons. The average addon cost is recalculated, based on the change made to quantity on hand.
  • Bin Location: When you select No for the Retain IC Bin Locations? option, bin locations on count tickets in Product Count Entry are added to Product Warehouse Product Setup and Product Additional Bin Location Setup records. The bin locations that are currently associated with the warehouse product record are retained.

    For example, the warehouse product record for Product C2 shows bin location 1 as c2/bi/n00/1 and bin location 2 as c2/bi/n00/2. A count ticket shows bin location 1 as c2/bi/n00/4 and bin location 2 as blank. After the report is run, the warehouse product record shows bin location 1 as c2/bi/n00/4 and bin location 2 as c2/bi/n00/1. A Product Additional Bin Location Setup record is then created or updated for the product to include c2/bi/n00/2.

    When you select Yes for the Retain IC Bin Locations? option, the bin locations on product warehouse and records are replaced with the bins on count tickets in Product Count Entry. The bins that were previously on the warehouse product record are deleted. Additional bin records are created, updated, or deleted as required.

    For example, the warehouse product record for Product C2 shows bin location 1 as c2/bi/n00/1 and bin location 2 as c2/bi/n00/2. A count ticket shows bin location 1 as c2/bi/n00/4 and bin location 2 as blank. After the report is run, the warehouse product record shows bin location 1 as c2/bi/n00/4 and bin location 2 as blank. No additional bin records are available for the product.