Child pages
  • Including transport costs when transfering inventory between locations

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML Wrap
classcol span_3_of_5

ANSWER ID:11012

AccountEdge Pro and Network Edition only

When using multiple inventory locations, it's not uncommon to transfer stock from one location to another. When doing this, you can also incorporate the transport costs into the value of the inventory.

This is done by recording a bill to take stock items from one location and add them to another.

This process assumes you've already set up your stock locations. For more info on this, see the AccountEdge help (Australia | New Zealand).

 

UI Expand
title1. Create a supplier card

If you use a transport company create a supplier card for them. Otherwise create a generic 'Shipping and Handling' supplier card to track these costs.

  1. Go to the Card File command centre and click Card List.
  2. Click New.
  3. Select Supplier as the card type.
  4. Enter the card details. Here's our example:
    ImageImage RemovedImage Added
  5. Click OK.
UI Expand
title2. Transfer the stock

You can now record a purchase to take the stock from one location and add it to another and incorporate the transport costs.

In our example we have 6 items on hand in the Warehouse location.

ImageImage RemovedImage Added

We want to transfer 3 of these items to the Perth location to meet a customer's demand. We do this by recording a new Item Bill transaction under the supplier card we created earlier.

To record the transaction

  1. Go to the Purchases command centre and click Enter Purchases.
  2. Select the supplier card created earlier.
  3. Click Layout and ensure Item is selected.
  4. On the first line:
    1. Enter -3 in the Bill column.
    2. Select the item to be transferred.
    3. Leave the Price and Amount fields as they appear.
    4. For the Location, select the location the stock is being transferred from.
    5. For the Tax/GST code, select N-T.
  5. On the second Line:
    1. Enter 3 in the Bill column.
    2. Select the same item.
    3. Leave the Price and Amount fields as they appear.
    4. For the Location, select the location the stock is being transferred to.
    5. For the Tax/GST code, select N-T.
  6. On the third line (to account for the transport costs):
    1. Enter zero (0) in the Bill column (or leave it blank).
    2. Select the same item.
    3. For the Location, select the location the stock is being transferred from.
    4. Enter the Price (the transport cost).
    5. Use the applicable Tax/GST code for your circumstances. Here's our example.
      ImageImage RemovedImage Added
  7. Click Record.

The item will now be split between the two locations and the item's values will be increased by the purchase.

ImageImage RemovedImage Added

HTML Wrap
width15%
classcol span_1_of_5
 
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namegreen
titleRelated topics
HTML Wrap
classsidebarlinks

Inventory locations (Australia)

Inventory locations (New Zealand)