Vantage 8.03 Custom WIP Report - trying to figure out correct pa

Yahoo Archive
1
Mike,



See email below - I don't know if this is what you are looking but, I
downloaded this BAQ - see email below.



I didn't need all the columns for estimates etc, so I modified the BAQ for
our company.



I like this BAQ because with the WIP Report that comes with the system is a
Progress report and you can export to Excel.



I used this BAQ because every once in a while, WIP does not get relieved
correctly and it helps me balance to the GL.



Regards



____________________________________________________________________________
__________________




Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the vantage
group.

File : /BAQs/actvestimatedcost.baq
Uploaded by : just_check <justrichpower@...
<mailto:justrichpower%40yahoo.com> >
Description : Jobs Costs 9.05.700c (Criteria: Closed & Completion Date >=
3/1/2013)

You can access this file at the URL:
http://groups.yahoo.com/group/vantage/files/BAQs/actvestimatedcost.baq

To learn more about file sharing for your group, please visit:
http://help.yahoo.com/l/us/yahoo/groups/original/members/web/index.html
Regards,

just_check <justrichpower@... <mailto:justrichpower%40yahoo.com> >







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mike Abell
Sent: Tuesday, September 03, 2013 7:33 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 8.03 Custom WIP Report - trying to figure out
correct part transactions to process MFG and COS cost....





I should have said MFG cost/transactions are actually INV Cost/Transactions
so my WIP calc = Total Job Cost - INV Cost - COS cost.

MFG should say INV. Sorry..Any help would be greatly appreciated.

Mike..

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Mike Abell
Sent: Tuesday, September 03, 2013 9:30 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Vantage 8.03 Custom WIP Report - trying to figure out
correct part transactions to process MFG and COS cost....

I'm building my own custom WIP report by figuring out MFG and COS cost by
adding up specific types of part transactions and making my WIP cost = Total
Job cost - MFG Cost - COS cost. I'm scratching my head on what to use for
"filtering" MFG transactions and "COS" transactions. So far this is what
I've used:

MFG transactions- ASM-STK,MFG-STK,MFG-VAR
COS transactions - MFG-CUS
Total Job Cost -
{JobAsmbl.TLALaborCost}+{JobAsmbl.TLABurdenCost}+{JobAsmbl.TLAMaterialCost}+
{JobAsmbl.TLASubcontractCost}

I'm REAL close to the WIP totals on the Vantage WIP (mine's a little higher)
report but I'm a little off and I'm thinking it's probably due to I'm
missing some transactions that are being totaled in the WIP calculation and
should be MFG or COS. Can anyone give me some pointers on other transactions
I might need to add for the MFG cost or COS cost? Thanks!

Mike Abell
Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office: 931.432.1853 ext 302
Mobile: 615.418.3055
email: MAbell@... <mailto:MAbell%40flexial.com>
<mailto:MAbell%40flexial.com>

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

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





[Non-text portions of this message have been removed]
2
I'm building my own custom WIP report by figuring out MFG and COS cost by adding up specific types of part transactions and making my WIP cost = Total Job cost - MFG Cost - COS cost. I'm scratching my head on what to use for "filtering" MFG transactions and "COS" transactions. So far this is what I've used:

MFG transactions- ASM-STK,MFG-STK,MFG-VAR
COS transactions - MFG-CUS
Total Job Cost - {JobAsmbl.TLALaborCost}+{JobAsmbl.TLABurdenCost}+{JobAsmbl.TLAMaterialCost}+{JobAsmbl.TLASubcontractCost}

I'm REAL close to the WIP totals on the Vantage WIP (mine's a little higher) report but I'm a little off and I'm thinking it's probably due to I'm missing some transactions that are being totaled in the WIP calculation and should be MFG or COS. Can anyone give me some pointers on other transactions I might need to add for the MFG cost or COS cost? Thanks!

Mike Abell
Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office: 931.432.1853 ext 302
Mobile: 615.418.3055
email: MAbell@...




[Non-text portions of this message have been removed]
3
I should have said MFG cost/transactions are actually INV Cost/Transactions
so my WIP calc = Total Job Cost - INV Cost - COS cost.

MFG should say INV. Sorry..Any help would be greatly appreciated.



Mike..



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mike Abell
Sent: Tuesday, September 03, 2013 9:30 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 8.03 Custom WIP Report - trying to figure out
correct part transactions to process MFG and COS cost....





I'm building my own custom WIP report by figuring out MFG and COS cost by
adding up specific types of part transactions and making my WIP cost = Total
Job cost - MFG Cost - COS cost. I'm scratching my head on what to use for
"filtering" MFG transactions and "COS" transactions. So far this is what
I've used:

MFG transactions- ASM-STK,MFG-STK,MFG-VAR
COS transactions - MFG-CUS
Total Job Cost -
{JobAsmbl.TLALaborCost}+{JobAsmbl.TLABurdenCost}+{JobAsmbl.TLAMaterialCost}+
{JobAsmbl.TLASubcontractCost}

I'm REAL close to the WIP totals on the Vantage WIP (mine's a little higher)
report but I'm a little off and I'm thinking it's probably due to I'm
missing some transactions that are being totaled in the WIP calculation and
should be MFG or COS. Can anyone give me some pointers on other transactions
I might need to add for the MFG cost or COS cost? Thanks!

Mike Abell
Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office: 931.432.1853 ext 302
Mobile: 615.418.3055
email: MAbell@... <mailto:MAbell%40flexial.com>

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





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