Describes where the actual costs, hours and quantities for a job are stored
Solution ID = KB-697
Goal : Describes where the actual costs, hours and quantities for a job are stored
Version = Syteline6.XX.XX
Module : SLMFG
Fact 1 : SFC, Schema
Fact 2 : Job Costs.
Database : Progress
Cause
The WIP amount fields in the jobroute table (wip-amt, wip-matl-amt, etc.) should not be used for determining the actual cost posted to an operation. They are increased by the actual amount of transactions posted but they are then reduced when pieces are moved into inventory.The two "a-" overhead fields in jobmatl hold the amount overhead (if any) that was in the materials issue cost from inventory.The two overhead fields that end with "-t" hold the overhead applied to that material when it was issued and will only have a value if the material has material overhead rates. For example, if an item was being carried in inventory with material, labor and fixed overhead cost of 50, 40 and 30 and is issued to a job and has a 20% fixed material overhead, the "a-cost" field will hold $120, the breakout "a-" fields will hold 50, 40 and 30 and the "fixovhd-t" will hold 24 (1200 * .2).
Fix
The best place from which to gather the actual costs posted against a job depends on the level of detail you want and the item's item master cost type. Hours posted against operations and quantities issued of materials are only stored one place (listed below).
If the item has a cost type of actual, the total actual cost posted to the job is stored in a series of "WIP total" fields in the job table. The total cost is stored in one field and five others store the breakdown of the total into material, labor, fixed overhead, variable overhead and outside costs. Each of the breakout buckets holds the amount of that type of cost that has been posted directly to the job as well as the amount of that type of cost that was included in any materials issued to the job. For example, WIP Labor holds the labor posted to job and the labor portion of the cost of the materials issued.
From "job":
wip-total - Holds total actual cost posted to the job.
wip-matl-total - Total material cost.
wip-lbr-total - Total labor cost.
wip-fovhd-total - Total labor and machine fixed overhead.
wip-vovhd-total - Total labor and machine variable overhead.
wip-out-total - Total outside cost.
If
the item has a cost type of standard, the WIP total buckets do not hold
the actual cost for the job (see solution 145 for an explanation of how
those buckets are used for standard costing). So, if the item is
standard costed or if you'd like more detailed (i.e. by material and
operation) costs than are found in the WIP Total buckets, you would
have to use the fields in the jobmatl and jobroute tables that
accumulate the actual cost posted against each material and operation.
Also, if you want the toal hours posted or quantities of material
issued, they are steroed in jobroute and jobmatl respectively. The
fields are the following:
From "jobroute":
setup-cost-t - Setup cost posted to the operation
run-cost-t-lbr - Labor cost posted
fixovhd-t-lbr - Fixed labor overhead cost posted
fixovhd-t-mch - Fixed machine overhead cost posted
varovhd-t-lbr - Variable labor overhead cost posted
varovhd-t-mch - Variable machine overhead cost posted
setup-hrs-t - Actual setup hours posted against the operation
run-hrs-t-lbr - Actual labor hours posted
run-hrs-t-mch - Actual machine hours posted
a-cost - Total actual cost of the material. The breakdown is stored in the following five fields.
a-matl-cost
a-lbr-cost
a-fovhd-cost
a-vovhd-cost
a-out-cost
fixovhd-t - Total actual fixed material overehad applied to this material when issued.
varovhd-t - Total actual variable applied.
qty-issued - Total quantity issued of the material to the job
