Good Day Shreejith:
BAQ
Files: Part, PartBin and PartCost - link by Part# and Company
PartNum Part
Description Part
PartClass Part
Bin PartBin --- but you will get multiple lnes if in more then one bin
BinQty partbin--- but you will get multiple lnes if in more then one bin
CostMethod Part
UnitCost PartCost -- but there are five buckets , so either show all five, or do a
Calc = SUM ( avelab, burden, etc.)
MtlBurdenCost PartCost - is only one Bucket of cost
Amount(Calculated Field ??? Exended Cost = [PartCost:QOH] * [calc field(sum of cost buckets]
again will get multiple lines if multiple bins
I attached screen shots, but they may get deleted.
Sun is on 9.05.605 since 10/2/11 - SQL-Unidata
Live on 9.05.601B since 11/29/10
Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)
.
len.hartka@...
Leonard C. Hartka, IS Project Manager\ERP Specialist
Sun Automation Group
66 Loveton Circle
Sparks, Md. 21152
410-329-3560 ext. 120
410-329-3564 FAX
443-255-7192 Work Cell
len.hartka@...
www.Sunautomation.com <http://www.sunautomation.com/>
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Sreejith Jaganathan
Sent: Tuesday, January 31, 2012 7:07 AM
To: Vantage Group
Subject: [Vantage] Part Bin & Cost Report - Tables Required for preparing the report
Good Afternoon;
I want to prepare a report which should contain the below
fields. Please do let me know which all tables I should use in order to get the
report.
The fields required
PartNum
Description
PartClass
Bin
BinQty
CostMethod
UnitCost
MtlBurdenCost
Amount(Calculated Field)
I tried the partcost table but I found all the values to be
zero. When I see the STOCK STATUS report under the INVENTORY Ã REPORTS I could see the cost of the
various parts.
Please help me out in knowing the table
Regards
Sreejith J
[Non-text portions of this message have been removed]
This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
[Non-text portions of this message have been removed]
BAQ
Files: Part, PartBin and PartCost - link by Part# and Company
PartNum Part
Description Part
PartClass Part
Bin PartBin --- but you will get multiple lnes if in more then one bin
BinQty partbin--- but you will get multiple lnes if in more then one bin
CostMethod Part
UnitCost PartCost -- but there are five buckets , so either show all five, or do a
Calc = SUM ( avelab, burden, etc.)
MtlBurdenCost PartCost - is only one Bucket of cost
Amount(Calculated Field ??? Exended Cost = [PartCost:QOH] * [calc field(sum of cost buckets]
again will get multiple lines if multiple bins
I attached screen shots, but they may get deleted.
Sun is on 9.05.605 since 10/2/11 - SQL-Unidata
Live on 9.05.601B since 11/29/10
Sun was previously on M2K (Manage-2000) 7.0 SP 5 (Informix)
.
len.hartka@...
Leonard C. Hartka, IS Project Manager\ERP Specialist
Sun Automation Group
66 Loveton Circle
Sparks, Md. 21152
410-329-3560 ext. 120
410-329-3564 FAX
443-255-7192 Work Cell
len.hartka@...
www.Sunautomation.com <http://www.sunautomation.com/>
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Sreejith Jaganathan
Sent: Tuesday, January 31, 2012 7:07 AM
To: Vantage Group
Subject: [Vantage] Part Bin & Cost Report - Tables Required for preparing the report
Good Afternoon;
I want to prepare a report which should contain the below
fields. Please do let me know which all tables I should use in order to get the
report.
The fields required
PartNum
Description
PartClass
Bin
BinQty
CostMethod
UnitCost
MtlBurdenCost
Amount(Calculated Field)
I tried the partcost table but I found all the values to be
zero. When I see the STOCK STATUS report under the INVENTORY Ã REPORTS I could see the cost of the
various parts.
Please help me out in knowing the table
Regards
Sreejith J
[Non-text portions of this message have been removed]
This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
[Non-text portions of this message have been removed]