distribute cost..

2007-04-09
2013-05-02
  • Help me I will help others

    hello friends...
    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 ?
    thanks

     
    • Help me I will help others

      hello friends...
      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..
      iam waiting....
      thanks

       
    • Help me I will help others

      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
          product_a: $10
          product_b: $20
      3. but i have some additional costs inaddition to purchase order cost like:
          frieght :    $100
          bank charge: $100
          insurance:   $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...
      tahnks

       
      • Joel Stangeland

        Joel Stangeland - 2007-04-12

        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.

        JoelS

         

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks