Costing by warehouse location
Many businesses operate with more than one warehouse location. Often times the landed cost of a given Item ends up being different when that item is received into each location / warehouse. You would like your ERP system to do costing by warehouse location so that you can have the right cost of goods sold whenever you sell that item from a specific location. Paragon handles this in an easy and efficient manner.
Step 1: My company
You need to enable costing by warehouse in Paragon. All you need to do is open my company from the settings page, hit the financials tab and check the box called valuation by warehouse.
Make sure you hit the save button before you exit.
Step 2: Receive goods by warehouse
Receive items with different costs in two different locations - as shown below. We used one product here as an example.
As you can see, the cost of this item is different on the two receipts. Notice the ship to locations are different in the receipt No.326 and No.327.
Step 3: Ship your goods from different warehouses
Now that you received the item in two different locations, you are ready to sell and ship it to the customer. For that, you need to create two shipments from the ship module. You can create a shipment off of an order, a packing list, an invoice or just manually.
As evidenced in our example, the ship from locations are different from ship #275 to #276. This means their unit costs should be different, even though the sale price is the same.
Step 4: Verify your costs
In order to verify your costs related to these transactions, you need to go to the inventory module. Search for this product and then select the history tab.
The unit values for ship #275 and #276 differ according to the location from which they have been shipped to the customer.
Now What?
Now we can calculate the cost of goods sold for this item drone t-shirt corresponding to these two shipments.
It will be 2 * $8.25 + 2 * $10 which equals to $36.5
Related Articles
Set up your company information
Introduction Before starting anything, you should store relevant information about your company, or how you want things to look. Luckily, Paragon stores all these settings in My Company, where all the changes and necessary configurations can be found ...Importing warehouse locations
If you have multiple warehouse locations that you want to add to Paragon's warehouse setup, you can import the information using the Universal Translator tool through the Location module. If you are unfamiliar with importing and transferring data ...Creating new locations
Introduction Paragon allows you to track your inventory within your warehouse by using locations. Locations can be as granular as you would like and you can have as many as you want. The following article explains how to add locations in Paragon. If ...View your inventory by location when adding an item to a transaction
It's not uncommon for organizations to own different warehouses in separate geographical locations. Companies usually want to ship their items from their closest warehouse to reduce transport and customs costs. These companies would want their ERP ...Rule - How to automatically update the warehouse attribute in a transaction
An important feature of your shipments may be to have the warehouse name as a header attribute. Rather than filling in this information every time you create a shipment, Paragon allows this attribute to be automatically updated once your shipment is ...