As per 8.03.407, here is the help:
________________________________
The Sales Gross Margin report prints Cost of Sales (COS) at time of
Shipment or the Job Adjusted Cost at the time of job, and Sales Revenue
information for the invoices created during the selected date range.
Only the amounts from Shipment invoices are calculated and displayed on
this report. For more information on how Shipment invoices are created,
read the AR Invoice Entry topic.
The Invoice Detail costs are pulled from the part transaction table
(parttran) records created at the time of Shipment. These costs for
parts shipped from stock are taken from the partcost table at the time
of shipment. The costs for parts shipped from jobs in the parttran table
are calculated as unit costs from the total labor, burden, material,
subcontract, and material burden costs posted against each job. The
costs for the shipment parttran record is calculated in a manner similar
to how the cost of sales is determined in the WIP report.
Because the cost fields in the InvcDtl table (InvcDtl.SubUnitCost,
InvcDtl.MtlUnitCost, InvcDtl.MtlBurUnitCost, InvcDtl.LbrUnitCost, and
InvcDtl.BurUnitCost) are from the parttran record at the time of
shipping, the Sales Gross Margin report should reconcile to the
appropriate GL accounts after the Capture COS and WIP activity is run.
In cases where a job has partial shipments and costs may be late and
quantities reported are not accurate at the time of the partial
shipments, the JC cost fields may present the information desired when
looking at the report from a Jobcost view and not a Fiscal Period GL
view. For more information, see Use Adjusted Cost.
Use Adjusted Cost
Check this box to populate the cost fields of Labor, Burden, Material,
Subcontract, Material Burden, Total Cost from the Job Closing Unit Cost
fields (for Labor, Burden, so forth) instead of the corresponding
standard invoice cost fields.
The fields that hold these costs are as follows: InvcDtl.JCSubUnitCost,
InvcDtl.JCMtlUnitCost, InvcDtl.JCMtlBurUnitCost, InvcDtl.JCLbrUnitCost,
and InvcDtl.JCBurUnitCost.
The Job Closing Unit Cost fields are updated on the invoice detail
record when a job is closed, and they are a recalculation of the costs
for all of the parts shipped from the job. As a result, this checkbox is
valuable when you want the cost to more accurately present the costs of
the parts on the invoice if the job had many partial shipments during
the life of the job or had late costs applied after invoices were
created.
This will provide costs that are easier to reconcile to the jobs, but
may not reconcile to the GL, because some of the costs picked up by the
GL would be variance costs or costs captured for partial shipments in
different fiscal periods.
However, if this box is checked, the standard invoice cost fields are
still used for invoiced items for jobs that are still open. The standard
fields are also still used for parts that were shipped from inventory.
The lines on the report that use the Job Adjusted cost fields are marked
with an asterisk slash */ just before the applicable cost fields.
________________________________
So if you use the USE ADJUSTED COST switch, you are getting your costs
from the Job Close fields for those invoices where you are shipping from
the job. If you don't use the switch, then you are getting the costs at
the time of shipping.
Charlie Smith
Smith Business Services / 2W Technologies LLC
www.vistaconsultant.com <http://www.vistaconsultant.com/> /
www.2WTech.com
[Non-text portions of this message have been removed]
________________________________
The Sales Gross Margin report prints Cost of Sales (COS) at time of
Shipment or the Job Adjusted Cost at the time of job, and Sales Revenue
information for the invoices created during the selected date range.
Only the amounts from Shipment invoices are calculated and displayed on
this report. For more information on how Shipment invoices are created,
read the AR Invoice Entry topic.
The Invoice Detail costs are pulled from the part transaction table
(parttran) records created at the time of Shipment. These costs for
parts shipped from stock are taken from the partcost table at the time
of shipment. The costs for parts shipped from jobs in the parttran table
are calculated as unit costs from the total labor, burden, material,
subcontract, and material burden costs posted against each job. The
costs for the shipment parttran record is calculated in a manner similar
to how the cost of sales is determined in the WIP report.
Because the cost fields in the InvcDtl table (InvcDtl.SubUnitCost,
InvcDtl.MtlUnitCost, InvcDtl.MtlBurUnitCost, InvcDtl.LbrUnitCost, and
InvcDtl.BurUnitCost) are from the parttran record at the time of
shipping, the Sales Gross Margin report should reconcile to the
appropriate GL accounts after the Capture COS and WIP activity is run.
In cases where a job has partial shipments and costs may be late and
quantities reported are not accurate at the time of the partial
shipments, the JC cost fields may present the information desired when
looking at the report from a Jobcost view and not a Fiscal Period GL
view. For more information, see Use Adjusted Cost.
Use Adjusted Cost
Check this box to populate the cost fields of Labor, Burden, Material,
Subcontract, Material Burden, Total Cost from the Job Closing Unit Cost
fields (for Labor, Burden, so forth) instead of the corresponding
standard invoice cost fields.
The fields that hold these costs are as follows: InvcDtl.JCSubUnitCost,
InvcDtl.JCMtlUnitCost, InvcDtl.JCMtlBurUnitCost, InvcDtl.JCLbrUnitCost,
and InvcDtl.JCBurUnitCost.
The Job Closing Unit Cost fields are updated on the invoice detail
record when a job is closed, and they are a recalculation of the costs
for all of the parts shipped from the job. As a result, this checkbox is
valuable when you want the cost to more accurately present the costs of
the parts on the invoice if the job had many partial shipments during
the life of the job or had late costs applied after invoices were
created.
This will provide costs that are easier to reconcile to the jobs, but
may not reconcile to the GL, because some of the costs picked up by the
GL would be variance costs or costs captured for partial shipments in
different fiscal periods.
However, if this box is checked, the standard invoice cost fields are
still used for invoiced items for jobs that are still open. The standard
fields are also still used for parts that were shipped from inventory.
The lines on the report that use the Job Adjusted cost fields are marked
with an asterisk slash */ just before the applicable cost fields.
________________________________
So if you use the USE ADJUSTED COST switch, you are getting your costs
from the Job Close fields for those invoices where you are shipping from
the job. If you don't use the switch, then you are getting the costs at
the time of shipping.
Charlie Smith
Smith Business Services / 2W Technologies LLC
www.vistaconsultant.com <http://www.vistaconsultant.com/> /
www.2WTech.com
[Non-text portions of this message have been removed]