Transfer Inventory
Learning Objects:
• Learn how transfer Inventory
Transfer Inventory
Occasionally, you might need to move inventory from one location or warehouse to another location or
warehouse. In Acumatica ERP, a transfer is created, viewed, and modified on the Transfers screen (IN304000). You can use transfers to record two types of inventory movements.
• One-‐Step Transfer: Movement between different locations within a warehouse or between warehouses performed in one step
• Two-‐Step Transfer: Movement between different warehouses performed in two steps
A one-‐step transfer documents the movement of items from one location to another one within the same warehouse. Also, goods movement between two warehouses can be performed as a one-‐step transfer, if goods are moved immediately or very quickly (as with adjacent warehouses).
A batch generated for one-‐step transfer includes no transactions if inventory accounts and subaccounts used for the items are the same for the source and destination locations. If the accounts and subaccounts differ, the system will generate journal entries for transactions performed between the inventory account used for the item at the source location, the in-‐transit account (specified on the Inventory Preferences screen), and the inventory account used for the item at the destination location. If a transfer includes more than one line, the journal entry to the in-‐
transit account is the summary for all line items. The system selects unit costs for items automatically based on the items’ valuation methods.
Two-‐step transfers are used for transferring inventory between any two warehouses located far enough from one another that they cannot be moved immediately. In a two-‐step transfer, the inventory items are issued from the source warehouse’s location and costs of items are recorded to the in-‐transit account specified on the Inventory Preferences screen for all two-‐step transfers. Later, when the transferred inventory arrives at the target
warehouse, the user creates an inventory receipt with a reference to the original inventory transfer document; the batch generated for the receipt will move the costs of goods from the in-‐transit account to the inventory account used for the items in the destination warehouse.
Depending on the item class, the quantities of in-‐transit goods may or may not be included in availability calculation. The rules for inventory availability calculation are specified for each item class on the General Settings tab of the Item Classes screen (IN201000).
Field Descriptions:
Field Description
Field Description
Reference Nbr. The unique reference number of the transfer document, which the system automatically assigns according to the sequence assigned to transfers on the Inventory Preferences (IN.10.10.00) screen.
Status The status of the transfer. The following options are available:
• On Hold: Indicates that the document is a draft and can be edited manually or deleted. A document with this status cannot be released.
• Balanced: Means that the document’s transactions are balanced. This document can be modified, deleted, or released.
• Released: Indicates that the document has been released. Documents with this status cannot be edited or deleted.
Hold A check box that, if selected, indicates that the transfer document has the On Hold status. Clear the check box to save the transfer with the Balanced status.
Transfer Type The type of transfer. The following options are available:
• 1-‐step: The transfer operation is performed in one step: The goods are transferred from the warehouse to the destination warehouse location.
• 2-‐step: The transfer operation is made in two steps: The goods are issued at the source location and received at the target location.
Date The date when the transfer document was created. All transactions included in this document will have this transaction date.
Post Period The financial period to which the transactions from the transfer document should be posted.
Warehouse The warehouse from which the goods are transferred.
To Warehouse The warehouse to which the goods are transferred.
External Ref. Any external reference number of the inventory transfer document.
Description A brief description of the document or the transactions entered.
Control Qty. The manually entered quantity of goods transferred; available only if the Validate Document Totals on Entry check box is selected on the Inventory Preferences screen. When you’re creating a transfer, you enter this value manually to confirm the total quantity of inventory items transferred, compared to the automatically calculated quantity of inventory items included in this document. If the Control Qty. and Total Qty. values do not match, the system generates a warning message and the document cannot be saved.
Total Qty. The total quantity of goods transferred.
Transaction Details Tab
Inventory ID The identifier of the goods to be transferred.
Subitem The subitem code for the goods to be transferred if subitems are used in your system and the Use Subitem check box is selected on the Inventory Preferences screen. To specify subitems of the received goods, click the Bin/Lot/Serial action on the table toolbar. If multiple subitems were specified, the column displays <SPLIT>.
Location The warehouse location from which the goods are transferred.
To Location The warehouse location to which the goods are transferred.
Quantity The quantity of the transferred goods (in the units indicated below).
UOM The unit of measure (UOM) used for the goods to be transferred.
Lot/Serial Nbr The lot or serial number of the transferred goods.
Expiration Date The expiration date of the transferred goods
Reason Code The reason code associated with the transferred goods.
Description A brief description of the goods transfer transaction.
Financial Details Tab
Batch Nbr. The reference number of the batch generated for the transfer. Click the number to open the Journal Transactions (GL.30.10.00) screen and view the transaction details.
Scenario
A local store “RETAIL2” is need of some items to restock their selves. Fortunately “RETAIL” warehouse is close by and able to get the store the items they need quickly. Someone from the store will pick up the items.
1. Open Transfers screen (screen ID IN304000): Distribution > Inventory > Work Area > Enter > Transfers Replace XX with the Initials of your first and last name.
Screen Section Field Value
Summary Transfer Type 1-‐Step
Summary Date {Today’s Date}
Summary Post Period {Current Period}
Summary Warehouse ID RETAIL
Summary To Warehouse ID RETAIL2
Summary Description xx: 1-‐Step Transfer
Transaction Details Inventory ID XXROUTER0001 Transaction Details Subitem 0-‐0
Transaction Details Location R02C03L01
Transaction Details To Location ID R01C01 Transaction Details Quantity 1
Transaction Details UOM BOX
Transaction Details Lot/Serial Nbr. {select the lot number assigned on the receipt you created in the previous exercise}
Transaction Details Inventory ID XXMOUSE0001 Transaction Details Subitem 0-‐0
Transaction Details Location R01C01L01
Transaction Details To Location ID R01C02 Transaction Details Quantity 10
Transaction Details UOM PC
2. Save your changes 3. Unselect Hold
4. Click on Release button
5. Click on Reports button and select Inventory Register Detailed
Scenario
A local store “RETAIL2” is need of some items to restock their selves. These items are in the main warehouse “WHOLESALE”. Shipping will take 2 days once the items have been shipped. We need to utilize the systems feature to keep track of the items in transit until received by store.
1. Open Transfers screen (screen ID IN304000): Distribution > Inventory > Work Area > Enter > Transfers
Screen Section Field Value
Summary Transfer Type 2-‐Step
Summary Date {Today’s Date}
Summary Post Period {Current Period}
Summary Warehouse ID WHOLESALE
Summary To Warehouse ID RETAIL2
Summary Description xx: 2-‐Step Transfer
Transaction Details Inventory ID XXDESKT0001
Transaction Details Subitem 0-‐0
Transaction Details Location R01C01L01
Transaction Details Quantity 10
Transaction Details UOM PC
Transaction Details Inventory ID XXLAPT0001
Transaction Details Subitem 0-‐0
Transaction Details Location R01C01L04
Transaction Details Quantity 5
Transaction Details UOM PC
System automatically assigns the Lot/Serial number. Click on Bin/Lot/Serial and can see the Lot/Serial numbers assigned. At this time, able to change the Lot/Serial if required.
2. Save your changes 3. Unselect Hold
4. Click on Release button
5. Click on Reports button and select Inventory Register Detailed Once the shipment arrives to the final warehouse.
6. Open Receipts screen (screen ID IN301000): Distribution > Inventory > Work Area > Enter > Receipts
Screen Section Field Value
Summary Date {Todays Date}
Summary Post Period {Default Period}
Summary Transfer Nbr. {select the transfer number assigned on the 2-‐step transfer you created in the previous exercise}
Summary Description xx: Transfer Receipt
Transaction Details Inventory ID XXDESKT0001 Transaction Details Subitem 0-‐0
Transaction Details Warehouse RETAIL2 Transaction Details Location R02C01 Transaction Details Quantity 10
Transaction Details UOM PC
Transaction Details Unit Cost 745.00
Transaction Details Inventory ID XXLAPT0001 Transaction Details Subitem 0-‐0
Transaction Details Warehouse RETAIL2 Transaction Details Location R02C02 Transaction Details Quantity 5
Transaction Details UOM PC
Transaction Details Unit Cost 1024.45
7. Enter / Select Transfer Nbr.
8. Save your changes 9. Unselect Hold
10. Click on Release button
Release IN Documents (IN501000)
Use this form to view and release inventory documents with the Balanced status. When the documents are released, the corresponding transactions will be posted to the General Ledger module if the Automatically Post On Release option is selected on the Inventory Preferences (screen ID IN101000) form.
1. Open Release IN Documents screen (screen ID IN501000): Distribution > Inventory > Work Area > Enter >
Release IN Documents
Close Financial Periods (IN509000)
Use this form to close active financial periods in the Inventory module, which is a required stage of closing a period in the General Ledger. (The financial period can be closed in the General Ledger module only if it is closed in the Accounts Payable, Cash Management, Accounts Receivable, and Inventory modules.) When you close a given financial period, all preceding active periods will be closed as well if they have not already been closed.
Posting transactions to closed periods is not allowed unless you have selected the Allow Posting to Closed Periods check box on the General Ledger Preferences (screen ID GL102000) form.
1. Open Close Financial Periods screen (screen ID IN509000): Distribution > Inventory > Work Area > Enter >
Close Financial Periods
Validate Inventory
Use this form to recalculate the quantities of stock items available at warehouses. The validation process entails recalculating availability data for the selected inventory items, based on all open inventory documents and open sales orders.
It is recommended that you perform the validation after you change the item availability calculation options— the system will recalculate the item availability and allocation data in accordance with the options selected most recently. The
validation process doesn’t update the cost layers.
If, during the validation process, the system recovers available quantities of specific stock items, it attempts to open orders with Back Order status created for these items. Starting from the earliest back order, the system checks the quantity on the order. If the quantity is equal to or less than the recovered quantity, the system opens the order and switches to the next back order until either all recovered quantities are applied or all back orders are checked.
1. Open Validate Inventory screen (screen ID IN505000): Distribution > Inventory > Work Area > Enter >
Validate Inventory