Report/BAQ to seperate Mfg Variance by Material, Subcontract, La

So, you use the PartTrans file's data and analyze in MS Access? Can you share your Access DB with me?

Thanks,
Keith


--- In vantage@yahoogroups.com, "Geary, Stephanie" <sgeary@...> wrote:
>
> We are only on 6.1 but we do break these out with access from the part
> transaction file.
As you do work on a job, variances to Standard (we are standard costed) are calculated and tracked. As soon as you close the Job (move to stock or ship from job), these variance elements all get lumped together into one variance account. We have the need to see these elements broken out... has anyone been able to do this? Does anyone have an idea as to an approach we could use?

Any ideas or thoughts are welcome!!!!!!

Thanks,
Keith
We are only on 6.1 but we do break these out with access from the part
transaction file.





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of keithfwalter@...
Sent: Wednesday, July 29, 2009 9:03 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report/BAQ to seperate Mfg Variance by Material,
Subcontract, Labor, & Overhead





As you do work on a job, variances to Standard (we are standard costed)
are calculated and tracked. As soon as you close the Job (move to stock
or ship from job), these variance elements all get lumped together into
one variance account. We have the need to see these elements broken
out... has anyone been able to do this? Does anyone have an idea as to
an approach we could use?

Any ideas or thoughts are welcome!!!!!!

Thanks,
Keith



[Non-text portions of this message have been removed]