Calculating WIP Costs

Yahoo Archive
1
Thanks a tough nut to crack. I've come close a couple times but never been to get it exact. Be mindfull of the closed/reopened and posted jobs. These costs will have been moved off and the calc will need to restart on the reopen date.

PartTran,JobHead,JobAsm,JobOpr,LaborDtl,Resource,RescGrp plus some others I can't remember of the top of my head.


--- In vantage@yahoogroups.com, "dswmaom" <dwalker@...> wrote:
>
> I am trying to create a BAQ that calculates WIP costs that mirror the standard Work In Process Report costs.
>
> Can anyone point me in the right direction in terms of tables, fields to use to accumulate the WIP costs?
>
> Thx,
> Dale.
>
2
I am trying to create a BAQ that calculates WIP costs that mirror the standard Work In Process Report costs.

Can anyone point me in the right direction in terms of tables, fields to use to accumulate the WIP costs?

Thx,
Dale.
3
I am working on the same, but not back to it recently. There are many
tables and calcs, Help in Vantage lists alot about the report.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of dswmaom
Sent: Tuesday, January 19, 2010 3:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Calculating WIP Costs




I am trying to create a BAQ that calculates WIP costs that mirror the
standard Work In Process Report costs.

Can anyone point me in the right direction in terms of tables, fields to
use to accumulate the WIP costs?

Thx,
Dale.






[Non-text portions of this message have been removed]
4
Thanks - I just read the help text and I don't think that I can get there by using the standard BAQ, BAQRD, Crystal tools. I suspect this will require the use of SQL views and multiple work tables and I have no exposure to that type of development yet.

I looked throught the "files" section of the Yahoo Group site and didn't find any type of WIP replacement report using BAQ/Crystal tools. Does anyone have such a report that they might share?
thx,
Dale.




--- In vantage@yahoogroups.com, "Karen Schoenung" <kschoenung@...> wrote:
>
> I am working on the same, but not back to it recently. There are many
> tables and calcs, Help in Vantage lists alot about the report.
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of dswmaom
> Sent: Tuesday, January 19, 2010 3:30 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Calculating WIP Costs
>
>
>
>
> I am trying to create a BAQ that calculates WIP costs that mirror the
> standard Work In Process Report costs.
>
> Can anyone point me in the right direction in terms of tables, fields to
> use to accumulate the WIP costs?
>
> Thx,
> Dale.
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
5
There is a different way to get the WIP costs into a BAQ. Maybe you can
try the following



Link the Jobhead to jobassembl to part tran(outerjoin on jobnum)

Filter on where jobhead.wipcleared = false and jobassembl.assyseq = 0



Add up all the actual costs in the jobassembl table this will give you
costs to date for each element. (TLA + LLA)



Summarize the parttran table.

Sum costs for the following trantypes

MFG-VAR, MFG-CUS (COS amounts),

MFG-STK, (Received to stock amounts)

You will need to add job to job transaction and maybe others like
ASM-STK depending on how you are using Vantage/Epicor



The todate costs in the jobassembl minus the outgoing summarized costs
in the parttran give you the remaining WIP value



Regards



Gary





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of dswmaom
Sent: 19 January 2010 10:44 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Calculating WIP Costs





Thanks - I just read the help text and I don't think that I can get
there by using the standard BAQ, BAQRD, Crystal tools. I suspect this
will require the use of SQL views and multiple work tables and I have no
exposure to that type of development yet.

I looked throught the "files" section of the Yahoo Group site and didn't
find any type of WIP replacement report using BAQ/Crystal tools. Does
anyone have such a report that they might share?
thx,
Dale.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Karen Schoenung" <kschoenung@...> wrote:
>
> I am working on the same, but not back to it recently. There are many
> tables and calcs, Help in Vantage lists alot about the report.
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of dswmaom
> Sent: Tuesday, January 19, 2010 3:30 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Calculating WIP Costs
>
>
>
>
> I am trying to create a BAQ that calculates WIP costs that mirror the
> standard Work In Process Report costs.
>
> Can anyone point me in the right direction in terms of tables, fields
to
> use to accumulate the WIP costs?
>
> Thx,
> Dale.
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





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