Child pages
  • Including transport costs when transfering inventory between locations

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Current »

 

 

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).

 

1. 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:
    Image
  5. Click OK.
2. 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.

Image

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.
      Image
  7. Click Record.

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

Image