Costing

Get Involved. Join the Conversation.

Comments

  • Armando Castro

    Hi Sritama,

    Your explanation is clear about how Oracle Fusion makes the calculation and disregard units assigned. Same calculation was performed in Feb 2018 (when we implemented Oracle Fusion) but then in some release the formula was changed only in standard cost roll up calculation not in WO input cost. I remeber that becasue I had a big problem in my inventory valuation @ std cst and the reason was that the units assigned in std operation were multiplied by the usage time. The problem was that my usage time considered the 13 operators (as shown in my example) and in increased the inventory value. Then I had to change my usage time in all my standard operations to be alingned with Oracle calculation. Now there is a new change in this release 19 C in order to leave the calculation as it was in Feb 2018 when we implemented Oracle.

    Now no matter I indicate X number of units assigned (13 employees in my exapmple) I am not get my real labor cost considering the 13 employees because oracle only takes 1. 

    Question: What should I do to get the time of the 13 employees in order to get my std cost more accurate??

    Attached you will see an excel fshowing the following:

    Calculation (oracle calculation and the assumption of how the calculation should be)

    WO7295

    StdOperation

    Std Cost

    All related to the same item # 918195

    Thanks

     

     

  • Srinivasa Raghavan

    By design, any item that has costing enabled = No should not get interfaced to costing. Can you please log a service request so that we can help you with this?

    Srini

  • Dev Thota

    I created a PO with two lines one with costing flag Yes and another with costing flag "No" with 1 $ each, I performed WO,PO,costing activities, while reviewing the WO cost it is 2$ that means it included the cost disabled item as well. My requirement is to get the cost as 1$ that is only for cost enabled flag, can you please review the attached screen shot and let me know if any thing is wrong?

  • Srinivasa Raghavan

    Hi,

    Work center information is not available for variances, and that is the reason why this event class is not mapped to the work center source.

    Would you be able to differentiate by the product being produced or is it the same product being produced for both commercial and samples? If you can differentiate, then you can try using the source "Work Order Primary Output Item Identifier".

    Also, in 19D, we have added the work order DFFs as SLA sources for use with work order related event classes.

    Thanks,

    Srini

  • Krishna Ghantasala

    The system would in fact associate the cost profiles automatically if the option is 'Auto'. As I understand, looks like it's not happening for you. Can we have a quick OWC to go through your exact steps ?

  • Krishna Ghantasala

    Couple of questions please:

    How are you defining the Transport Cost Element, is it defined as Overheads or as Material cost element type?

    One option would be to explore setting up the cost element of Transport as Overhead. In such case, on Receipt in Org B. System would do the following:

    1. For Material book as Transfer Price variance for $1

    2 For Transport cost of A, book as Transfer Price variance of $5

    3. For Transport cost of B, book an Overhead absorption of $2

    The Inventory in Org B is booked $10, $2

    The Transfer Price variance Material: $1

    Transfer Price Variance Transport Org A: $5 (this you can map to a different/dummy account to eliminate)

     

  • Krishna Ghantasala

    Instead of Cost Org, you should try to use the Ship from and Ship to Organization ID, or the Profit Center BU of the destination inventory org.

     

  • Srinivasa Raghavan

    If you set the costing enabled flag to N, then the receipt to work order transaction will not be interfaced to costing and hence will not be included in the work order cost. If you are looking to fix the cost for just work order, you can try adjusting the cost using the receipt cost adjustment functionality.

    Thanks,

    Srini

  • Deepak Padhy

    Hi Huyen - For details to be shown in the inventory valuation report, the transaction should be costed and then only those will appear in the Valuation report.

    To cost the transaction-
    1) Run transfer transactions from Inventory to Costing.
    2) Create cost accounting distribution with cut off date greater than the transaction date.
    3) then after running you should check in Review cost accounting distribution, whether you are seeing the distributions or not.

     

    If you are able to see the distribution for your new cost org, then run the inventory valuation report for the cost org, the output should show data.

     

    Thanks
    Deepak.

     

  • Suman Guha

    Moved from Purchasing for Costing team to review as this is a receipt accounting report.

  • Ashok

    Dev

    You should triage this through an SR to see if this is a bug and if one exists already. In any event, this is a Purchasing report and best guided by the Purchasing team. I am moving it to the appropriate Forums Lab.

    Thanks

    Ashok

  • Sam Napoli

    Thanks Sritama,

    Appreciate the help.

    Sam

  • Sritama Sarkar

    Hi Sam,

      This change has already made its way in 19B, there is no change in behavior in 19C.

    The expected results in the above example - $3 {rate/hr} * (2/2) {hr/unit} * 2 {units} = $6

  • Sam Napoli

    Hi Sritama,

    That's ok. Sorry, I'm still confused on how it will it work in 19C and onwards?

    $3 {rate/hr} * 2 {hrs} * 2 {units} = $12.

    or

     $3 {rate/hr} * (2/2) {hr/unit} * 2 {units} = $6.

  • Sritama Sarkar

    This should not be an issue in 19C. Also, please go through my reply to another post on this thread where I explain the intended behavior with an example. Please verify that this is different from your current observation of the system.