Job finish unit cost - Overview of calculation
Solution ID = KB-237
Goal : Job finish unit cost - Overview of calculation (Actual costing) and Cost calculation when moving pieces from a job into inventory.
Version = All Version
Module : SLMFG
Fact 1 : Cost used for moving an item into inventory from a job
Fact 2 : SFC
Database : Progress, SQL
Fix
The cost
used for moving an item into inventory from a job, the job finish cost, varies
depending on the item's cost type.
Standard
costing
Items are
always moved into inventory at their item master standard unit cost at the time
of the move regardless of what cost has been posted against the job or how the
job has been processed.
Actual
Costing
For an
actual-costed item, the algorithm used for calculating the cost at which it is
moved to inventory from a job depends on the following:
1) Whether
or not the job is being closed via the job transaction.
2) Whether the SFC parameter "Cost Based on Complete" (CBC) is set to
Oper or Job.
3) Which operations are complete at the time of the move.
The basic
algorithm for calculating the unit cost is the following. This calculation is
the same for all actual costed items regardless of whether its cost method is
Average, LIFO, FIFO or Specific. See solution 183 for detailed
description of each scenario:
1) The
transaction moves pieces and closes the job.
If the job
is being closed using the job transaction's "Close Job" flag, the
system uses the total actual cost for the job minus the cost at which prior
moves (if any) had been done. The calculation is:
(Job WIP
Total - Job WIP Complete) / qty being moved
2) The job
is not closed via the transaction and CBC is Job
If the job
is not being closed and the "Cost Based on Complete" flag is set to
Job, the system uses the planned unit cost for the job. The job planned cost is
the sum of the planned unit costs for each operation in the job's routing.
3) The job
is not closed via the transaction and CBC is Oper
