Kindly give an expert advice for the below said. I am interested in knowing where the mistake is taking place.
________________________________
From: Sreejith Jaganathan <sreesvantagedoubts@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Cc: "mjfw2003@..." <mjfw2003@...>
Sent: Monday, February 25, 2013 11:34 AM
Subject: [Vantage] Cost to manufacture various parts in a sales order
Â
I prepared the BAQ the statement is as below
for each OrderDtl where (OrderDtl.OrderNum = 1) no-lock , each PartMtl where (OrderDtl.PartNum = PartMtl.PartNum) no-lock , first PartOpr where (OrderDtl.PartNum = PartOpr.PartNum) no-lock , each PartCost where (PartMtl.PartNum = PartCost.PartNum) no-lock .
Selected the below fields for display
OrderDtl.OrderNum
OrderDtl.PartNum
OrderDtl.OrderQty
PartMtl.MtlPartNum
PartMtl.QtyPer
PartCost.AvgBurdenCost
PartCost.AvgLaborCost
PartCost.AvgMaterialCost
PartCost.AvgMtlBurCost
PartMtl.EstMtlBurUnitCost
For the first five fields I am getting the output correctly but for the rest of the fields I am getting the value as zero. I checked the part cost table and found that the cost of the material is there in the selected fields.
Please advice where I am making a mistake.
________________________________
From: Mark Wagner mjfw2003@...>
To: "vantage@yahoogroups.com" vantage@yahoogroups.com>
Sent: Monday, February 25, 2013 1:43 AM
Subject: Re: [Vantage] Cost to manufacture various parts in a sales order
Â
Write a baq that uses the orderdtl, partmtl, and part ops tables and then in a dashboard you could filter on  the sales order number to retrieve all the information
________________________________
From: Sreejith Jaganathan sreesvantagedoubts@...>
To: Vantage Group vantage@yahoogroups.com>
Sent: Sunday, February 24, 2013 8:09 AM
Subject: [Vantage] Cost to manufacture various parts in a sales order
Â
Dear All;
I am having a sales order which contains approximately
100 different manufactured parts with varying qty. Parts belong to different
product groups. Each part has gots its own BOM. Please advice how I could know
what would be the qty of the material, cost of the material, labour hours
required, cost of the labor etc for this particular sales order.
I want to extract the information for all the 100 parts which
are there in the sales order.
Â
Hope to receive an answer at the earliest possible.
Â
Regards
Â
Sreejith J
[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]
________________________________
From: Sreejith Jaganathan <sreesvantagedoubts@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Cc: "mjfw2003@..." <mjfw2003@...>
Sent: Monday, February 25, 2013 11:34 AM
Subject: [Vantage] Cost to manufacture various parts in a sales order
Â
I prepared the BAQ the statement is as below
for each OrderDtl where (OrderDtl.OrderNum = 1) no-lock , each PartMtl where (OrderDtl.PartNum = PartMtl.PartNum) no-lock , first PartOpr where (OrderDtl.PartNum = PartOpr.PartNum) no-lock , each PartCost where (PartMtl.PartNum = PartCost.PartNum) no-lock .
Selected the below fields for display
OrderDtl.OrderNum
OrderDtl.PartNum
OrderDtl.OrderQty
PartMtl.MtlPartNum
PartMtl.QtyPer
PartCost.AvgBurdenCost
PartCost.AvgLaborCost
PartCost.AvgMaterialCost
PartCost.AvgMtlBurCost
PartMtl.EstMtlBurUnitCost
For the first five fields I am getting the output correctly but for the rest of the fields I am getting the value as zero. I checked the part cost table and found that the cost of the material is there in the selected fields.
Please advice where I am making a mistake.
________________________________
From: Mark Wagner mjfw2003@...>
To: "vantage@yahoogroups.com" vantage@yahoogroups.com>
Sent: Monday, February 25, 2013 1:43 AM
Subject: Re: [Vantage] Cost to manufacture various parts in a sales order
Â
Write a baq that uses the orderdtl, partmtl, and part ops tables and then in a dashboard you could filter on  the sales order number to retrieve all the information
________________________________
From: Sreejith Jaganathan sreesvantagedoubts@...>
To: Vantage Group vantage@yahoogroups.com>
Sent: Sunday, February 24, 2013 8:09 AM
Subject: [Vantage] Cost to manufacture various parts in a sales order
Â
Dear All;
I am having a sales order which contains approximately
100 different manufactured parts with varying qty. Parts belong to different
product groups. Each part has gots its own BOM. Please advice how I could know
what would be the qty of the material, cost of the material, labour hours
required, cost of the labor etc for this particular sales order.
I want to extract the information for all the 100 parts which
are there in the sales order.
Â
Hope to receive an answer at the earliest possible.
Â
Regards
Â
Sreejith J
[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]