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 is 's not uncommon for businesses needing to transfer to transfer stock from one location one location to another to meet customer demands or replace sold stock from a warehouse.

This support outlines a method whereby a customer can incorporate the transports costs as part of the Inventory Values.

For more information on using multiple locations, see our support note Tracking inventory at multiple locations.

How do l deal with moving items to multiple Locations, treating transport costs as part of the inventory value?

Task 1 - Supplier Card

. 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 the transport Company otherwise

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
at the bottom of the window
  1. .
  2. Select Supplier as the card type
and enter the Card
  1. .
  2. Enter the card details.
See
  1. Here's our example
below.
  1. :
    ImageImage Modified

 

Task 2 - Entering the transaction

ImageImage Removed

As we can see in the example above, currently all items on hand are held to the Warehouse location. In this example, we want to transfer three of these to
  1. 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 Added

We want to transfer 3 of these items to the Perth location to meet a customer's demand.

 Record

 We do this by recording a new Item Bill transaction under the

Shipping and Handling/Transport

supplier card we created earlier.

To record the transaction

  1. Go to the Purchases command centre and click Enter
the value
  1. 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.
Upon entering
    1. Select the item
number, leave the price and amount
    1. to be transferred.
    2. Leave the Price and Amount fields as they appear.
Make sure you select 'Warehouse' as the Location. Use the Tax code 
    1. For the Location, select the location the stock is being transferred from.
    2. For the Tax/GST code, select N-T.

Note: The Location column will only display if there is more than one location set up. Go to the Lists menu and choose Locations to view and create locations.

  1. On the second Line
, enter the value as
  1. :
    1. Enter 3 in the Bill column.
Enter
    1. Select the same item
number, leaving the price and amount
    1. .
    2. Leave the Price and Amount fields as they
are. Change the Location field to Perth. Use the Tax Code
    1. appear.
    2. For the Location, select the location the stock is being transferred to.
    3. For the Tax/GST code, select N-T.
For the transport costs, on the third line enter
  1. 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
item number and key in the Price. Use the GST tax code. Record the Bill
    1. location the stock is being transferred from.
    2. Enter the Price (the transport cost).
    3. Use the applicable Tax/GST code for your circumstances. Here's our example.
      ImageImage Modified
  1. Click Record.

The item will now be split between the

Warehouse and Perth Locations and

two locations and the item's values will be increased by the purchase.

ImageImage Modified

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)