i am trying to use the landed cost feature.... i have some other costs like freight cost addition to the purchase order... so i am trying to use purchase order for that product price only..and i create MM Receipt from that after completing that i create invoice vendor ...then go to the landed cost tab to include some of the costs of that purchase order or recipt.. then i press distribute cost.... then complete and post.. can this will calculate the product COGs for me when i sell the product..? if no ..how can i determine the product COGs ?
i have a problem on distributing costs for my additional landed costs to my receipts of a purchase order.. can any body tell me the correct steps please... i can not go further because of this..
Did you follow the steps is the costing work procedure here:
If so, please make a thorough explanation of the troubles you've been having.
to make my problem clear,let me take an example assume:
1. i have purchase a 2 products with the ff PO price in one Purchase order..
product_a: $1000 for quantity 100
product_b: $2000 for quantity 200
2. at this level the product cost of goods sold COGS will be
3. but i have some additional costs inaddition to purchase order cost like:
frieght : $100
bank charge: $100
4.Now, the product COGS should be updated for the two products above and of course the product Asset too.
5. The question is how can i update that, i use version 2.5.3a... but i tried the ff by myself
1st. i enter the purchase order for the two products.. and add the additional costs like freight on that purchase order in different purchase order line, there fore i had five lines entered with a total of $3300.... and i create invoice vendor and receipt and did all the necessary matching... but the product COGs is not updated rather just $10 for product_a and $20 for product_b...
2nd. i enter the PO for the two products only then generate the receipt and invoice vendor
then i create new invoice vendor for the above expences and then after i allocate the cost for the generated receipt using the distribute method of Quantity.. of caurse the landed cost allocation is created for both products acccordingly but the Product COGs is not still updated...
3rd. i create new cost elements .. and enter by manually calculating the landed costs to each products purchased. example , let's say i have purchase one product called product_x using $1000 for 10 quantity... and cost me $100 for transportation. i will enter the purchase order just only for the product purchase, $1000 and i generate,complete and post Receipt and invoice vendor ... look until this time the product COGs for product_x is $1000/100 =10... now i use the product window and product cost tab and create new cost called freight by making it burden/Material overhead.. and use the following calculaion
$100/10=10...$100 to mean transportation cost and 10 to mean quantity... then i add 10 in the current cost field to add $10 for all product_x as its COGs... now the Cogs is changed from $10 to $20 ... but i don't think this is the right way of adding additional costs ..
how can then be my problem resolved using compiere
i am waiting...
My apologies for the above link, I forgot which forum I was reading....
The best recommendation is to purchase the Compiere manual and follow closely the steps for Landed Costs. It is a pretty thorough explanation. The problem may be in using 253a, a lot of the costing was not changed until after 253c, so you may need to migrate to a newer version in order to accomplish what you describe.
Hope that helps, and best wishes.
Log in to post a comment.