Warehouse Transfers (Average Cost)

Body

Overview 

Before you read this knowledge article, please familiarize yourself with the Inventory Map. 

Warehouse transfers are used in Accounting Seed to transfer inventoried Products from one Location within a Warehouse to another Location within that same Warehouse or from one Warehouse to another Warehouse. A Transfer is a specific type of Inventory Movement that is non-accounting, i.e. it only affects the Inventory Quantity Available balance and does not record any general ledger transactions. Transfers do not record any general ledger transactions as there are no financial impacts to the general ledger. The inventory account is not changing, the costs are not changing, nor is ownership changing (it is not being purchased or sold). Transfers are simply Warehouse or Location movements. 

Note: A warehouse transfer (Type=Inventory Transfer) is the only non-accounting Inventory Movement that can be used by customers using Accounting Seed’s Weighted-Average Cost Inventory feature. Inventory Movements (“IIM” and “OIM”) with type=non-accounting will not be allowed when using the Weighted-Average Cost Inventory feature.

Transfers create simultaneously a non-accounting Outbound Inventory Movement (Type = Inventory Transfer) to move inventory out of the current Inventory Quantity Available record and a non-accounting Inbound Inventory Movement (Type = Inventory Transfer) to move inventory into the target Inventory Quantity Available record. Transfer Inventory Movements cannot move zero or negative units.

  • Transfers of non-serialized Products will create one (1) Inbound and one (1) Outbound Inventory Movement record.
  • Transfers of serialized Products will create one (1) Inbound and one (1) Outbound Inventory Movement record for each specific serial number identified on the OIM.
    Important: For serialized Products, quantities that do not have a specific serial number identified will be aggregated into one (1) Inbound and one (1) Outbound inventory Movement record. (See examples below.) 

Do you want to:

Return to top

Perform a Warehouse Transfer  (User Interface)

All transfers are initiated from the Inventory Quantity Available record that you are transferring out of. 

  1. Navigate to Accounting Home and click the Create Entries tab. Then, under the Orders menu, click Inventory Quantity Available.
  2. Select the (Inventory Quantity Available) IQA record for which units will be transferred out of.

    WH_1.png

  3. Click on the drop-down arrow in the top right hand menu. From the drop-down select transfer.

    WH_2.png

    Note: The Inventory Transfer panel displays. The display shows the Available Quantity that can be transferred. As noted above, you cannot transfer zero (0) or negative amounts.

    Note: Required fields displays with a red asterisk (*).

    Note: Click the Location Name drop-down list to view the listing of all available locations (up to 2,999). Additionally, when you are on the Product page, and click Build Product, the Location drop-down list can also be clicked to view the listing of all available locations.

    ERP_Lightning_12.png
    Note: Click here to view the above image in full screen. 

    Note: As noted in the overview, if the inventory is serialized, you also have the option to enter the specific serial numbers to be transferred.

  4. Once all of the detail has been entered, click Transfer.

    The system will display a banner showing that the transfer was successful. It will also show the Inbound and Outbound Inventory movement records. In this example, since the serial numbers were provided, each serial number had its own Inbound and Outbound Inventory Movement record. 

    WH_5.png

  5. Below is a Transfer example, except the specific serial numbers to be transferred were not entered (they were left blank). This is, in‌ ‌essence, the same as transferring a non-serialized product. Once all of the detail has been entered, click Transfer.

    WH_6.png

  6. The system will display a banner showing that the transfer was successful. It will also show the Inbound and Outbound Inventory movement records. In this example, since there were no serial numbers provided, only one (1) Inbound and one (1) Outbound Inventory Movement record were created. 

    WH_7.png

  7. As noted above, each Transfer will create Inbound and Outbound Inventory Movements (IIM & OIM). Each of the movement records is available for examination. The two screen captures below show the IIM and the OIM of one of the serialized Products. Note that each record identifies the Inventory Quantity Available record affected, the Quantity, the Serial Number (if one was assigned) and the associated Inventory Movement.

    WH_8.png

    WH_9.png

  8. To see all of the IIM or OIM that have impacted an inventory account, either navigate to the List View of the Inventory Quantity Available and select the desired inventory record or simply click on the Inventory Quantity Available link on any of the above screens. Both options will open the record. Click on the Related tab to view the related lists for the record. Here all of the IIM and OIM records will be shown. 

    WH_10.png

Return to top

Inventory Transfer API

If you have our Orders & Inventory package, multiple (up to thousands) of Inventory Transfers can be made at once using the Inventory Transfer API. The fields that are included when you currently perform a single Warehouse Transfer are available as part of the API process when performing many transfers at the same time. You can also automate transfers using a flow, refer to the Transfers Invocable Flow article for detailed steps. For more information, refer to the Inventory Transfer API Documentation, in the API section of our Knowledge Base:

The following must be true to utilize this feature:

  • The ledger must be transactional (not Budget or Consolidation).
  • The ledger must be active.
  • The ledger must not be a shadow ledger.
  • The accounting variable must be active.
  • The accounting variable type must match the type on the transfer.

Note: Checks apply to both Average Cost and Standard Cost organizations.

Remove a Warehouse Transfer

To undo a transfer, both the IIM and OIM record(s) must be identified, as well as, the Inventory Quantity Available records that were affected. 

Note: BOTH the IIM and the OIM records must be individually deleted. When Inventory Movements are deleted they are now automatically emptied from the Recycle Bin as a safeguard, preventing users from undeleting them.

  1. Start with the Inbound Inventory Movement.

  2. Navigate to Inventory Quantity Available (“IQA”) and select the IQA record that you are deleting the transfer from. Click on the Related tab to view the related lists for the record. Here all of the IIM and OIM records will be shown. Select the IIM of the transfer that is to be undone.

  3. Click Delete.

    WH_11.png

    A message displays on the screen confirming that the delete was successful. You will also be returned to the IQA record. From the related list page, you will see that the IIM record is no longer listed. 

    WH_12.png

  4. The next step is to delete the Outbound Inventory Movement.

  5. Navigate to Inventory Quantity Available (“IQA”) and select the IQA record that you are deleting the transfer from. Click on the Related tab to view the related lists for the record. Select the OIM of the transfer that is being deleted.

  6. To complete and confirm the deletion, repeat steps 3 & 4 above.

Return to top

____________________

SPRING '23 RELEASE ICON.png

Spring '25 Preview 1 Release

Release Notes and Schedule

  • Location Name drop-down list can be clicked to view all available locations (up to 2, 999). This is also true for the Location drop-down list on the Product | Build Product page. 
Title
Warehouse Transfers (Average Cost)
URL Name
498178837
Orders & Inventory (Average Cost)Manage Inventory (Average Cost)
Skip Feed

Nothing here yet?

Log in to post to this feed.

End of Feed
Nothing here yet?Log in to post to this feed.