Archive

Posts Tagged ‘Current Unit Cost’

Some notes on Job Planned Cost

February 19th, 2015 No comments

1) The “Job BOM Cost Roll Up” utility and the “Update Planned Cost” button in Job form, Cost Detail tab are pretty much doing the same thing, they will update the material cost in job material.

ScreenHunter_04 Feb. 19 09.33

 

 

 

 

 

 

ScreenHunter_05 Feb. 19 09.38

 

2) Syteline system didn’t maintain a field for total job planned cost, you have to run job costing reports like “Job Cost Various Report” to see the total planned cost.

3) Job BOM Cost Roll Up use the item Unit Cost, and Current BOM Cost Roll Up use item Current Unit Cost.  So even you just copy the Job BOM from Current BOM, the current cost of job item may be differ than the job planned cost.

4) Cost roll up utilities rely on Unit Cost and Current Unit Cost maintained in Item Cost.  For a new item, say it is a purchase item, Syteline system would not assign Unit Cost and Current Unit Cost, until you conduct the first inventory transaction for the item (the transaction can be a PO receive, a Job complete receive or Misc receipt).   So your job material plan cost would not include these new materials.  Even you create a PO for the new item, system would not save the PO cost back into item cost, until you actually receive that PO.   However, for a new item, with or without a PO, you can use Item Cost form, Cost Maint tab to assign initial Unit Cost and Current Unit Cost.

Inline image 2

You will see that the Unit Cost fields are open for edit for this new item.  Once you conduct a receiving transaction and has qty on hand, the Unit Cost fields are No Longer editable.  It will be maintained by the system.
Note 1: these initial unit costs and current unit costs will have no effect on your inventory as you have qty-on-hand of 0.  These purely just for your job plan cost.
So for a new purchase item, it is suggested that you a) setup vendor contract price, b) setup initial unit cost and current unit cost in item cost maintenance, c) do cost roll up.
5) There is checkbox in PO line form, called “Update Job Material Unit Cost”, this only works for cross-referenced job material.  It will update the job material cost, when the PO cost change.

Database table fields in Syteline Item Cost Form

October 15th, 2011 No comments

There are just so many cost related fields in item table.  I here try to map them out one by one with fields in Item Cost Form

image

Purchased Current Unit Cost:

cur_mat_cost

cur_duty_cost

cur_freight_cost

cur_brokerage

cur_insurance_cost

cur_loc_frt_cost

Manufacturing Current Unit Cost:

cur_matl_cost

cur_lbr_cost

cur_fovhd_cost

cur_vovhd_cost

cur_out_cost

Unit Cost

matl_cost

unit_mat_cost

unit_duty_cost

unit_freight_cost

unit_brokerage_cost

lbr_cost

fovhd_cost

vovhd_cost

out_cost

Unit_Cost

image

Unit Cost

Current Unit Cost:  cur_u_cost

Unit Cost: unit_cost

Assembly

asm_setup

asm_run

asm_matl

asm_tool

asm_fixture

asm_other

asm_fixed

asm_var

asm_outside

Accumulated

comp_setup

comp_run

comp_matl

comp_tool

comp_fixture

comp_other

comp_fixed

comp_var

comp_outside

image

Standard is from frzcost table.