Report Builder - Cost of Goods Reporting question

Yahoo Archive
1
My guess is and I'm not sure what you calculated field names are but:

From version 3 to version 5, costs were broken out in inventory and not just
put in material. Did you consider TLR Labor and Burden and LLR Labor &
Burden?

Patrick


IIF(TypeCode = "M",(LLRMaterialCost + LLRSubcontractCost +
TLRMaterialCost + TLRSubcontractCost)*OurShipQty,0), InvcDt.COGS
formula PurchPart + BOMCOGS, InvcDtl.PartPercent formula
(COGS/ExtPrice)*100 )

-----Original Message-----
From: amfabllc [mailto:amfab@...]
Sent: Friday, August 09, 2002 11:51 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Builder - Cost of Goods Reporting question


I really appreciate all your input on the Old workstations! As for
the Report Builder month end COGS report, it was written in v 3, we
are now in v 5.00.329, which may have nothing to do with the
problem. For some reason, the BOM numbers seem to change depending
on when it is run, or possibly which computer it is run on.
The 'Capture COS and Wip Activity' is being run before this report is
run. I realize there are some new tables available with v 5.0 which
I have not experimented with yet. I'll give an overview of the
report to see if there is something one of you recognizes that may be
the problem. Here goes...
Report Builder: Monthend Cost of Goods Sold by Product Group Detail
Table joins: InvcDtl > PartRev - Left - Company, Part Number
InvcDtl > Part - Left - Company, Part Number
InvcDtl > Customer- Left - Company, CustNum
InvcDtl > ProdGrup- Left - Company, ProdCode
Groupings in order: (all InvcDtl.) ProdCode, PartNum, CustNum,
InvoiceNum, InvoiceLine
Sort in order: (all InvcDtl.) ProdCode, PartNum, CustNum, ShipDate
Bandlines: Title (Titles)
Page Header Row (Column Headers)
1GH-ProdCode (ProdGrup.ProdCode, ProdGrup.Description)
2GH-PartNum (InvcDtl.PartNum)
3GH-CustNum (Customer.Name)
5GH-InvoiceLine (InvcDtl.InvoiceNum, InvcDtl.InvoiceLine,
Part.TypeCode, InvcDtl.OurShipQty, InvcDtl.ExtPrice,
Part.StdMaterialCost, InvcDtl.PurchPart formula IIF
(TypeCode= "P",StdMaterialCost*OurShipQty,0), PartRev.BOMmtl formula
LLRMaterialCost + TLRMaterialCost, PartRev.BOMsc formula
LLRSubcontractCost + TLRSubcontractCost, InvcDtl.BOMCOGS formula IIF
(TypeCode = "M",(LLRMaterialCost + LLRSubcontractCost +
TLRMaterialCost + TLRSubcontractCost)*OurShipQty,0), InvcDt.COGS
formula PurchPart + BOMCOGS, InvcDtl.PartPercent formula
(COGS/ExtPrice)*100 )
1GF-ProdCode (InvcDtl.GroupCOGS aggregate Total(COGS
(),ProdCode,Every,FinalPass) , InvcDtl.GroupPercent formula
(GroupCOGS/GroupExtST)*100
Summary (InvcDtl.ReportCOGS aggregate Total(COGS(),No-
reset,Every,FinalPass) , InvcDtl.ReportPercent formula
(ReportCOGS/ReportExtTTL)*100

Any suggestions are greatly appreciated, online or offline.
Thanks!! Ann Harrell
amfab@...




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
2
I really appreciate all your input on the Old workstations! As for
the Report Builder month end COGS report, it was written in v 3, we
are now in v 5.00.329, which may have nothing to do with the
problem. For some reason, the BOM numbers seem to change depending
on when it is run, or possibly which computer it is run on.
The 'Capture COS and Wip Activity' is being run before this report is
run. I realize there are some new tables available with v 5.0 which
I have not experimented with yet. I'll give an overview of the
report to see if there is something one of you recognizes that may be
the problem. Here goes...
Report Builder: Monthend Cost of Goods Sold by Product Group Detail
Table joins: InvcDtl > PartRev - Left - Company, Part Number
InvcDtl > Part - Left - Company, Part Number
InvcDtl > Customer- Left - Company, CustNum
InvcDtl > ProdGrup- Left - Company, ProdCode
Groupings in order: (all InvcDtl.) ProdCode, PartNum, CustNum,
InvoiceNum, InvoiceLine
Sort in order: (all InvcDtl.) ProdCode, PartNum, CustNum, ShipDate
Bandlines: Title (Titles)
Page Header Row (Column Headers)
1GH-ProdCode (ProdGrup.ProdCode, ProdGrup.Description)
2GH-PartNum (InvcDtl.PartNum)
3GH-CustNum (Customer.Name)
5GH-InvoiceLine (InvcDtl.InvoiceNum, InvcDtl.InvoiceLine,
Part.TypeCode, InvcDtl.OurShipQty, InvcDtl.ExtPrice,
Part.StdMaterialCost, InvcDtl.PurchPart formula IIF
(TypeCode= "P",StdMaterialCost*OurShipQty,0), PartRev.BOMmtl formula
LLRMaterialCost + TLRMaterialCost, PartRev.BOMsc formula
LLRSubcontractCost + TLRSubcontractCost, InvcDtl.BOMCOGS formula IIF
(TypeCode = "M",(LLRMaterialCost + LLRSubcontractCost +
TLRMaterialCost + TLRSubcontractCost)*OurShipQty,0), InvcDt.COGS
formula PurchPart + BOMCOGS, InvcDtl.PartPercent formula
(COGS/ExtPrice)*100 )
1GF-ProdCode (InvcDtl.GroupCOGS aggregate Total(COGS
(),ProdCode,Every,FinalPass) , InvcDtl.GroupPercent formula
(GroupCOGS/GroupExtST)*100
Summary (InvcDtl.ReportCOGS aggregate Total(COGS(),No-
reset,Every,FinalPass) , InvcDtl.ReportPercent formula
(ReportCOGS/ReportExtTTL)*100

Any suggestions are greatly appreciated, online or offline.
Thanks!! Ann Harrell
amfab@...