Hello, new here, i added some inventory items, and it was the time to create a new purchase invoice
to calculate the cost of my product i have (freight cost - local shipping cost - other fees such as payment fees)
here is a screnshot of the purchase invoice, why the fright cost is not divided on the total quantity, for example, the shipping cost is 1800, should be divided by 600kg so it’s 3LYD per product, but manager calcs it in another weird way
if this is the correct “accountant way” of calculating the item cost let me know please
thank you.
Manager use weight average of the item value AFAIK. So if you buy:
Product 1: $5 each, 20 pcs = $100
Product 2: $10 each, 5 pcs = $50
This means a shipping cost of $10 will be assigned as $6.67 to Product 1, $3.33 to Product 2
Yes found th le full method used in the last updates, is there a way to calculate based on the quantity, because im only purchasing in kg “weight”
I haven’t found a way to have Manager calculate the cost the way I want it to. For example, I calculate unit cost as:
- item cost + custom duty (by actual amount) + freight cost (by volume)
So I manually the cost on each PO and use contra-accounts to make it work:
create the freight invoice to pay the freight company
COGS is correct:
Accounts payable is correct:
If there is a better way to deal with cost, I welcome any suggestion.
hmmm, i see what you did there, i don’t know if is this the right way but it works, more steps in my opinion.
i will search more and let you know if there is a better way.
Thanks.
I just found out you can directly assign cost to an item by leaving the quantity field blank:
nice trick, but i have found that issuing a payment receipt to the shipping company is better, since i sh buy from a supplier, and shipping goes to other company, i just do like you. Thanks
