Part Actual Job Costs

NOW THAT LOOKS LIKE YOU HIT THE SWEET SPOT! Im assuming TLA is actual TLE
is estimate and Lowers are sub assemblied x,y,z (which we don't have I
just see zeros in the LL fields which would make sense)



Joshua Giese

CTO

920.437.6400 Ext. 337

Site ID: 27450-E905700B2-SQL64

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of cathyattechnologicsys
Sent: Wednesday, August 7, 2013 11:52 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Part Actual Job Costs





The JobAsmbl table is a good place also.

The fields that start with TLA (This level actual) and LLA (Lower Level
Actual) keep job costing info.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"jgiese1988" <jgiese@... <mailto:jgiese@...> > wrote:
>
> Where would you folks recommend is the best table to pull actual mfg
costs for parts from? I am trying to put together a profit margin report
from actual for determining if we keep or get rid of certain products
based on the qtu ordered and margin on them. Basically is it worth keeping
them.
>





[Non-text portions of this message have been removed]
Where would you folks recommend is the best table to pull actual mfg costs for parts from? I am trying to put together a profit margin report from actual for determining if we keep or get rid of certain products based on the qtu ordered and margin on them. Basically is it worth keeping them.
I usually start with the tablews/fields the PDR report uses.
Off the top of my head:
- JobOper table, EstProdHours and ActProdHours fields.
- JobMtl table, EstMtl and Mtl fields
- LaborDtl table, LaborHrsd and LaborRate



--- In vantage@yahoogroups.com, "jgiese1988" <jgiese@...> wrote:
>
> Where would you folks recommend is the best table to pull actual mfg costs for parts from? I am trying to put together a profit margin report from actual for determining if we keep or get rid of certain products based on the qtu ordered and margin on them. Basically is it worth keeping them.
>
The JobAsmbl table is a good place also.

The fields that start with TLA (This level actual) and LLA (Lower Level Actual) keep job costing info.

--- In vantage@yahoogroups.com, "jgiese1988" <jgiese@...> wrote:
>
> Where would you folks recommend is the best table to pull actual mfg costs for parts from? I am trying to put together a profit margin report from actual for determining if we keep or get rid of certain products based on the qtu ordered and margin on them. Basically is it worth keeping them.
>