Cost of WIP Report

Yahoo Archive
1
Thanks, I will take care of it there.



Tim Dines

Information Technology

Steel Parts Manufacturing, Inc.

801 Berryman Pike

Tipton, IN 46072

Direct: 765-675-5201

Cell: 765-437-1402



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gary Parfrey
Sent: Tuesday, January 26, 2010 2:26 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Cost of WIP Report





Tim

If you are writing a report, I would calculate it there. Vantage is
buggy andlimited when adding calcs or adding totals to non total
formulae

Gary

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Dines, Tim
Sent: 26 January 2010 5:49 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Cost of WIP Report

Gary,

What is the proper Progress syntax to subtract the todate costs from the
parttran total. This is the one that should give the WIP Value.

Tim Dines

Information Technology

Steel Parts Manufacturing, Inc.

801 Berryman Pike

Tipton, IN 46072

Direct: 765-675-5201

Cell: 765-437-1402

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gary Parfrey
Sent: Tuesday, January 26, 2010 11:42 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Cost of WIP Report

Tim

Your part transaction totals are unit costs and have not been multiplied
by the transaction qty.

or use the parttran.extcost field

Gary

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of timdines@... <mailto:timdines%40ymail.com>
<mailto:timdines%40ymail.com>
<mailto:timdines%40ymail.com>
Sent: 26 January 2010 3:29 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Cost of WIP Report

Using the outline submitted by Gary Parfrey, I have created a WIP Cost
report. The BAQ and the report XML have been uploaded to a folder. There
is a problem with this report that I am hoping somebody can give me
direction on. I am trying to show cost for each operation in the
manufacturing process, but the numbers are not working out.

Tim Dines
Steel Parts Manufacturing, Inc.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
"timdines@..." <tdines@...> wrote:
>
> I am in the process of developing a Cost of WIP report and making good
progress. I am not the greatest query writer that ever lived so I hope
that somebody here can help. I have broken every job down all of the
operations that it takes to complete and I am trying to show the cost at
each step. The opseq's are 10,20,30,40 and sometimes 50. This come up
correctly along with their description and the number of parts that have
gone through each operation. The problem comes in cost. It looks like
all of the cost is going to the first operation and then I get the same
numbers for each of the operations below that. Can anyone give me a clue
as to what I have done wrong? Maybe I don't know how to group correctly.
>
> Tim Dines
> Steel Parts Manufacturing, Inc.
>

[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]





[Non-text portions of this message have been removed]
2
I am in the process of developing a Cost of WIP report and making good progress. I am not the greatest query writer that ever lived so I hope that somebody here can help. I have broken every job down all of the operations that it takes to complete and I am trying to show the cost at each step. The opseq's are 10,20,30,40 and sometimes 50. This come up correctly along with their description and the number of parts that have gone through each operation. The problem comes in cost. It looks like all of the cost is going to the first operation and then I get the same numbers for each of the operations below that. Can anyone give me a clue as to what I have done wrong? Maybe I don't know how to group correctly.

Tim Dines
Steel Parts Manufacturing, Inc.
3
Using the outline submitted by Gary Parfrey, I have created a WIP Cost report. The BAQ and the report XML have been uploaded to a folder. There is a problem with this report that I am hoping somebody can give me direction on. I am trying to show cost for each operation in the manufacturing process, but the numbers are not working out.

Tim Dines
Steel Parts Manufacturing, Inc.

--- In vantage@yahoogroups.com, "timdines@..." <tdines@...> wrote:
>
> I am in the process of developing a Cost of WIP report and making good progress. I am not the greatest query writer that ever lived so I hope that somebody here can help. I have broken every job down all of the operations that it takes to complete and I am trying to show the cost at each step. The opseq's are 10,20,30,40 and sometimes 50. This come up correctly along with their description and the number of parts that have gone through each operation. The problem comes in cost. It looks like all of the cost is going to the first operation and then I get the same numbers for each of the operations below that. Can anyone give me a clue as to what I have done wrong? Maybe I don't know how to group correctly.
>
> Tim Dines
> Steel Parts Manufacturing, Inc.
>
4
Tim



Your part transaction totals are unit costs and have not been multiplied
by the transaction qty.

or use the parttran.extcost field



Gary



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of timdines@...
Sent: 26 January 2010 3:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Cost of WIP Report







Using the outline submitted by Gary Parfrey, I have created a WIP Cost
report. The BAQ and the report XML have been uploaded to a folder. There
is a problem with this report that I am hoping somebody can give me
direction on. I am trying to show cost for each operation in the
manufacturing process, but the numbers are not working out.

Tim Dines
Steel Parts Manufacturing, Inc.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"timdines@..." <tdines@...> wrote:
>
> I am in the process of developing a Cost of WIP report and making good
progress. I am not the greatest query writer that ever lived so I hope
that somebody here can help. I have broken every job down all of the
operations that it takes to complete and I am trying to show the cost at
each step. The opseq's are 10,20,30,40 and sometimes 50. This come up
correctly along with their description and the number of parts that have
gone through each operation. The problem comes in cost. It looks like
all of the cost is going to the first operation and then I get the same
numbers for each of the operations below that. Can anyone give me a clue
as to what I have done wrong? Maybe I don't know how to group correctly.
>
> Tim Dines
> Steel Parts Manufacturing, Inc.
>





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

What is the proper Progress syntax to subtract the todate costs from the
parttran total. This is the one that should give the WIP Value.



Tim Dines

Information Technology

Steel Parts Manufacturing, Inc.

801 Berryman Pike

Tipton, IN 46072

Direct: 765-675-5201

Cell: 765-437-1402



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gary Parfrey
Sent: Tuesday, January 26, 2010 11:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Cost of WIP Report





Tim

Your part transaction totals are unit costs and have not been multiplied
by the transaction qty.

or use the parttran.extcost field

Gary

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of timdines@... <mailto:timdines%40ymail.com>
Sent: 26 January 2010 3:29 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Cost of WIP Report

Using the outline submitted by Gary Parfrey, I have created a WIP Cost
report. The BAQ and the report XML have been uploaded to a folder. There
is a problem with this report that I am hoping somebody can give me
direction on. I am trying to show cost for each operation in the
manufacturing process, but the numbers are not working out.

Tim Dines
Steel Parts Manufacturing, Inc.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
"timdines@..." <tdines@...> wrote:
>
> I am in the process of developing a Cost of WIP report and making good
progress. I am not the greatest query writer that ever lived so I hope
that somebody here can help. I have broken every job down all of the
operations that it takes to complete and I am trying to show the cost at
each step. The opseq's are 10,20,30,40 and sometimes 50. This come up
correctly along with their description and the number of parts that have
gone through each operation. The problem comes in cost. It looks like
all of the cost is going to the first operation and then I get the same
numbers for each of the operations below that. Can anyone give me a clue
as to what I have done wrong? Maybe I don't know how to group correctly.
>
> Tim Dines
> Steel Parts Manufacturing, Inc.
>

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





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



If you are writing a report, I would calculate it there. Vantage is
buggy andlimited when adding calcs or adding totals to non total
formulae



Gary



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dines, Tim
Sent: 26 January 2010 5:49 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Cost of WIP Report





Gary,

What is the proper Progress syntax to subtract the todate costs from the
parttran total. This is the one that should give the WIP Value.

Tim Dines

Information Technology

Steel Parts Manufacturing, Inc.

801 Berryman Pike

Tipton, IN 46072

Direct: 765-675-5201

Cell: 765-437-1402

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gary Parfrey
Sent: Tuesday, January 26, 2010 11:42 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Cost of WIP Report

Tim

Your part transaction totals are unit costs and have not been multiplied
by the transaction qty.

or use the parttran.extcost field

Gary

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of timdines@... <mailto:timdines%40ymail.com>
<mailto:timdines%40ymail.com>
Sent: 26 January 2010 3:29 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Cost of WIP Report

Using the outline submitted by Gary Parfrey, I have created a WIP Cost
report. The BAQ and the report XML have been uploaded to a folder. There
is a problem with this report that I am hoping somebody can give me
direction on. I am trying to show cost for each operation in the
manufacturing process, but the numbers are not working out.

Tim Dines
Steel Parts Manufacturing, Inc.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
"timdines@..." <tdines@...> wrote:
>
> I am in the process of developing a Cost of WIP report and making good
progress. I am not the greatest query writer that ever lived so I hope
that somebody here can help. I have broken every job down all of the
operations that it takes to complete and I am trying to show the cost at
each step. The opseq's are 10,20,30,40 and sometimes 50. This come up
correctly along with their description and the number of parts that have
gone through each operation. The problem comes in cost. It looks like
all of the cost is going to the first operation and then I get the same
numbers for each of the operations below that. Can anyone give me a clue
as to what I have done wrong? Maybe I don't know how to group correctly.
>
> Tim Dines
> Steel Parts Manufacturing, Inc.
>

[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]