Product Entry Count Update Report overview
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.
If you choose to clear the run and not update it, 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 and you will not have to make adjustment entries to offset special costs.
If a product is returned to stock through a receiving transaction, a return transaction or any other adjustment to increase inventory, an internal receipts record is created when the Support Running Fill From Navigator option in SA Admin Options - Documents Sales Orders Back Orders is selected, or the Action to Take on Completion of Receiving option is anything but None and 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 and 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 either up or down depending on the count entered.
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 applied to the Product Unavailable Inventory Entry balance as well. A change to the unavailable quantity means there is one more or less for unavailable inventory quantities, not that inventory was transferred from unavailable to on hand.
Addon – This table describes how addons are handled for both available and unavailable inventory adjustments:
| If Quantity Adjustment is: | The Cost Posted to General Ledger |
|---|---|
| negative | includes addons |
| positive | does not include addons and the average addon cost is recalculated based on the change made to quantity on hand |