Inventory Control > Inventory Item Movement

The Warehouse Item Transfer function allows you to record the transfer of inventory items between warehouses. Transferring of inventory items facilitates the company’s need to transfer surplus quantities of an inventory item to a different warehouse to make up for the shortage in quantity of the same inventory item. It also facilitates convenient distribution of your products to the customers resulting to reduction of your delivery lead-time, handling and transportation costs. Aside from the transfer of inventory items, the Warehouse Item Transfer function allows you to perform the following:

•Repackage an inventory item into smaller or larger units to make the inventory item more saleable to the market.

•Record transferred inventory items at standard costs or actual costs by marking the At Standard Cost option or At Actual Cost option, respectively, in the IC Module Setup function.

•Record in-transit transfers of inventory items.

To transfer or repackage inventory items, perform the following procedures:

1.Access the Warehouse Item Transfer function from the Item Movement group under the Transactions menu in the Inventory Control module.

Note: Various drillable fields are available in this function screen. When you click any drillable fields in this function, the system automatically displays the corresponding Maintenance function screen.

2.Provide values in the following fields:

oSource Warehouse

Enter in this field the code of the warehouse where the inventory item you want to transfer or repackage is located.

oTarget Warehouse

Enter in this field the code of the warehouse to which you want to transfer the inventory item.

oTransfer Date

Accept or amend in this field the default date when the inventory items are being repackaged or transferred between warehouses. The default date is the current system date.

oRemarks

Enter in this field a brief description of the warehouse transfer or repackaging transaction; otherwise, AccountMate will not allow you to save the transaction.

oBarcode

You may manually enter an item's barcode or use a barcode scanner to enter values in this field. Once a valid barcode is entered in this field, a new line is activated in the Line Items grid and the corresponding item # is displayed in the Source Item # field. Successive barcode scans will automatically activate a new line in the grid and display the item's number in the Source Item # field. Note that this field is disabled if the Use Barcode Scanner is not activated. You can activate the Use Barcode Scanner feature in the IC Module Setup function.

3.Choose either of the following options in the Additional Transfer Cost Calculated By area (which default settings come from the Additional Transfer Cost Calculated By setting in IC Module Setup):

oPercentage

Choose this option if you want the additional transfer cost to be a certain percentage of the cost of the transferred inventory item.

oFlat Amount

Choose this option if you want the default additional transfer costs to be a fixed amount.

4.Specify in the Line Items grid the inventory item, bin, and quantity that will be transferred or repackaged. Perform the following steps:

4.1. Click the Append row to end button to add a line in the grid. Alternatively, click the Insert row before current button to insert a line between two inventory items in the grid.

4.2. Enter in the Source Item # field the number of the inventory item that you want to repackage or transfer to another warehouse.

4.3. If the selected inventory item is an item with specifications, the Source Specification field is enabled. Enter in this field the item specification that will be transferred or repackaged. Alternatively, click the List box button to display the available specifications for the item; then, click the option to select.

4.4. In the Source Bin field, enter the specified warehouse's bin that stores the inventory item to be repackaged or transferred to another warehouse. Alternatively, you may List box button to display the the available bins in the specified warehouse; then, click the bin to select. The default bin is the bin with an on-hand quantity and with the lowest sequence number based on the sequence of bins defined in the Inventory Maintenance's Warehouse page.

4.5. Enter in the Transfer Quantity field the quantity of the inventory item that you want to repackage or transfer from the source bin.

Be sure that you enter the correct number of units in the Transfer Quantity field. If you are transferring 100 4-pack items, enter the number of packages being transferred (i.e., 100) and not the total number of pieces included in the packages being transferred (i.e., 400).

4.6. In the Source U of M field, enter the source inventory item's stock unit of measurement.

4.7. If the inventory item being transferred is a kit, lot-controlled or serialized, this field shows the code for the corresponding special item. Click the colored code in the Special... field to display the Special nested tab in which you can select the kit, lot or serial number associated with the inventory item units to be transferred or repackaged.

4.8. If you are transferring an inventory item from one warehouse to another, enter in the Target Item # field the same inventory item number as the one provided in the Source Item # field. If you are repackaging the same item using a new inventory item number, enter in this field the number of the repackaged inventory item.

4.9. For inventory items with specification that is transferred from one warehouse to another, enter in the Target Specification field the same item specification as entered in the Source Specification field. For repackaged inventory items, enter in this field the specification for the new inventory item.

4.10. Enter in the Target Bin field the bin to which you want to store the transferred or repackaged inventory item. Alternatively, you may click the List box button to display the available active bins in the specified warehouse; then, click bin to select. Ensure that you enter a bin code that is assigned to the inventory item in the target warehouse and that it is assigned as a receiving bin for the selected target warehouse; otherwise, AccountMate will prevent you from saving the transaction. You may also leave this field blank.

Note: If you do not specify a value in the Target Bin field, AccountMate will treat the transferred units as being in transit, and thus, not available for use, until you record the receipt of the units at their target bin using the Receive Warehouse Item Transfer function.

4.11. Enter in the Target U of M field the unit of measurement for the transferred or repackaged inventory item. Be sure that the unit of measurement entered in this field is assigned to the target item.

If you are repackaging a unit of an inventory item to another inventory item using a different unit of measurement, the source item’s transfer quantity multiplied by its unit of measurement factor must be evenly divisible by the repackaged item’s unit of measurement factor; otherwise, you will encounter an error, “Uneven quantity conversion,” when you enter the repackaged item’s number in this function's Line Item Details tab -> Target Item area.

For example, if the source item’s and the repackaged item’s unit-of-measurements are “3-pack” and “6-pack” respectively, you must transfer even-numbered quantities of the source inventory item. Two (2) or four (4) 3-packs result in six (6) or twelve (12) pieces, respectively, that are both evenly divisible by six (6). If you transfer odd-numbered quantities such as one (1) or three (3) 3-packs of the source item, it will result in three (3) and nine (9) pieces, respectively, that are not evenly divisible by six (6).

4.12. The Unit Cost read-only field shows the source item's unit cost information.

4.13. Accept or amend in the Unit Transfer Cost field the default transfer cost assigned to each unit of the item being transferred. Depending upon the option chosen in the Inventory Transfer Transaction Controls area in IC Module Setup, the default unit transfer cost can be either the Actual Cost or Standard Cost of the item plus any transfer cost adjustment you have specified in this same function's Additional Transfer Cost Calculated By area.

4.14. The Extended Cost read-only field shows the transferred or repackaged item's transferred quantity multiplied by the item's Unit Transfer Cost.

5.Beneath the grid are read-only fields showing information about the inventory item highlighted in the grid. Review the information as necessary.

Note: If the inventory item included in this transaction is assigned with a Standard cost method, AccountMate will calculate the cost variance between the inventory item's standard cost and total cost after the transaction. The cost variance amount will be posted to the GL Account ID specified in the Cost Variance field of the Revenue Code Maintenance record assigned to the selected inventory item's warehouse.

6.To delete line items from the list of items to be transferred or repackaged, highlight the item in the grid; then, click the Delete selected rows button in the grid toolbar.

7.Enter in the Freight field the freight amount, if applicable, that is associated with the warehouse transfer.

8.When you are ready, click the Save button to display the Save Confirmation window and proceed with the warehouse item transfer process. If the User Input (Numeric) option was selected in the Inventory Transfer Transaction Controls section of the IC Module Setup function, enter in the Transfer # field the number that you want to assign to this warehouse transfer transaction. Next, click the Save Transfer button to save the transaction; otherwise, click the Cancel Save button.

Alternatively, if the Automatic Transfer Numbering option was selected in the IC Module Setup function, AccountMate will automatically provide a transfer number in the Transfer # field, and both the Save Transfer and Cancel Save buttons are disabled.

Other options available in the Save Confirmation window after the transaction is successfully saved includes:

oPreview

Click this button to preview the Inventory Transfer Slip report for the selected Transfer #.

oPrint

Click this button to print the Inventory Transfer Slip report for the selected Transfer #.

oNew

Click this button to close the Save Confirmation window and clear the fields of the Warehouse Item Transfer function screen ready for a new transaction.

oClose

Click this button to close the Save Confirmation window.

Q. When transferring inventory items from one warehouse to another, I encountered the error "Uneven Quantity Conversion." How can I correct this?

A. Ensure that the unit-of-measurement factor of the source item is equal or divisible by the unit-of-measurement factor of the target item. For example, if the unit-of-measurement factor of your source item is four (4), then the unit-of-measurement factor of your target item should either be two (2) or four (4).

Warehouse Item Transfer

Warehouse Item Transfer

See Also