Product Warehouse Transfer Entry overview

Product > Entry > Warehouse Transfer

Function acronym: ICEW

Use this page to make warehouse transfer entries that immediately update the Net Available and On Hand balances in Product Warehouse Product Setup for both the ship from warehouse and the ship to warehouse.

Normally, warehouse transfers are created automatically during the order entry or purchase order replenishment process. By integrating the transfer process within these functions, ties are maintained to the proper documents. Sometimes, however, you might need to manually enter a warehouse transfer to record the movement of inventory that may not be a part of the normal replenishment process. If you are adjusting inventory records after the fact, the Product Warehouse Transfer Entry function can be used. This function updates the Product Warehouse Product Setup balances immediately, and no shipping or receiving function is necessary. This may be helpful if you replaced an item in your showroom and need to record the movement of the stock item from a regular warehouse to the showroom warehouse.

To enter transactions for this function, your SA Operator Setup security must allow changes (Level 3).

Intercompany transfers cannot be made through this function, but you can make corrections to the transfers. Both the ship from warehouse and the ship to warehouse must have valid Product Warehouse Description Setup records. Products must exist with valid Product Setup and Product Warehouse Product Setup records in both the ship from warehouse and the ship to warehouse. A product's status must be active, and it cannot be a labor product or a build-on-demand kit in Product Setup. The product cannot be a labor or direct ship product in Product Warehouse Product Setup. The Control field in Product Warehouse Product Setup-General must be identical in both the ship from and ship to warehouses.

The transferred quantity cannot exceed the Net Available quantity which is displayed on the bottom of the page.

Costs

If a product contains a special costing unit, it is stored with the transaction.

A product's FIFO available is decreased for the ship from warehouse and increased for the ship to warehouse by the ship from's cost or recalculated average cost. Addons are recalculated in the ship to warehouse on each transaction when the Mark Up From-Include Addons option in SA Administrator Options-Products-Costs is selected. The addon amount is brought in from the Product FIFO Setup record, not the product record. This indicates that capitalizing addons is performed. The calculation multiplies the addon by the existing quantity before the transfer. This amount is divided by the quantity after the quantity is transferred.

For example, product W-56 is stocked in Warehouse 1 and Warehouse 2.

  Warehouse 1 Warehouse 2
Cost $20.00 $17.00
Addon $1.00 $1.00
Quantity on Hand 100 10

The inventory value in Warehouse 2 is $17.00. One unit is transferred from Warehouse 1 to Warehouse 2. The addons are re-averaged with this calculation:

  • 10 x $1.00 / 11 = $.91

The $10.00 addon cost is re-averaged for 11 units.

If the Include Addons option is not selected, the addons are not included or re-averaged. The FIFO cost on the Product FIFO Setup record which was created in the ship to warehouse should be the actual cost, plus addons, if appropriate.

If you choose Replacement or Standard cost for the Post to GL By option in SA Administrator Options-Products-Costs, and there is a different cost between the receiving warehouse and the shipping warehouse, the difference is posted to the IC Cost Adjustment GL account. Addons are not re-averaged in the receiving warehouse.

This function uses transaction types RE and IN to represent transfers in and transfers out. Serial and lot products are handled by their respective windows, which display at the appropriate times.

(IN) Invoice Inventory Control File Updates

  • Quantity On Hand is decreased (the quantity on the transaction is converted to the stocking unit before updating).
  • Average cost is recalculated for Serial/Lot/FIFO products.
  • Issues year-to-date are increased.
  • Last Invoice date is updated with the posting date.
  • The Last Stock Out date is set if this transaction caused a stock out.
  • Stock Available date is "?" if a transaction caused a stock out.

(RE) Receipt Inventory Control File Updates

  • Quantity On Hand is increased (the quantity on the transaction is converted to the stocking unit before updating).
  • Quantity On Order is decreased.
  • Average Cost is recalculated using the current line cost only, no addons are included.
  • Last Cost is updated with the cost of the transaction.
  • Receipts Year-to-Date are increased.
  • Last Receipt date is updated with the posting date.
  • An ICER (internal receipts record) is created if the option Support Running Fill from Navigator is selected in SA Administrator Options-Documents-Sales Orders-Backorders, or the Action to Take on Completion of Receiving is anything except None and an ICER record does not already exist for the company, warehouse, and product. The ICER record indicates that the Product Warehouse Product Setup On Hand balance has been increased and the stock can potentially fill an open order when the Sales Entry Processing Back Order Fill Report is generated.
  • Product Warehouse Transfer Entry does not adjust the addon cost in Product Warehouse Product Setup in either the ship from or ship to warehouses. To involve addon cost changes, you must use the Transfer module.

Product Warehouse Transfer Entry does not update usage for the ship from or the ship to warehouse. Manual adjustments must be made to account for transfers of inventory. If you want usage to be recorded, use these functions:

  • Transfer Entry
  • Transfer Shipping Feedback Entry
  • Transfer Receipt of Inventory Entry

Depending on the options you established in SA Operator Setup and Product GL Distribution Setup, General Ledger is updated. A journal is opened when you initially enter this window, enabling you to print the transactions through Product Entry Journal Print Report.

Divisionalized Accounting

If the Divisional option in SA Company Setup is selected, all postings in the system use divisional information and all journals and posting sets are forced to balance by division.

For transfers of inventory between divisions, the Product Warehouse Description Setup InterDiv Inv account number is used to transfer the value of the inventory from one division to another.

Product record conditions

This table shows the results of special conditions existing on the product and warehouse/product records. After a valid product has been entered, the record condition is displayed below the quantities. Certain record conditions are displayed as a message and you are not allowed to enter a transaction for that product.

Condition Result
Active/Stocked The majority of your products are active and regularly stocked in Inventory Control. This is considered a normal product and the Inventory Control quantities are updated appropriately by Product Unavailable Inventory Entry.
Inactive If the product's status is inactive, you will not be allowed to enter it.
Labor Labor products represent a service. Quantities are not stored in Inventory Control and you will not be allowed to enter a labor product.
Direct Only Direct ship products are not stored in your inventory.
Do Not Reorder These products are handled the same as active/stocked products. This setting is only valid in Purchase, Transfer, and Kit Production. It indicates a class 13 product that you want to sell the remaining inventory and not reorder.
Superseded Superseded products are handled the same as active/stocked products. A message is displayed and you can continue.
Kits Build on demand kit products are not allowed because they do not exist in your inventory. Prebuilt kits may be entered.
Serial/Lots You can allocate serial numbers and lots during entry through their respective functions.
Core Products You cannot transfer remanufactured core products with this function. A message is displayed if you attempt to transfer a remanufactured core product.