Report tables needed for Sales Gross Margin Report - Vantage 8.0

Yahoo Archive
1
Thanks Vic, I think that is precisely what I'm looking for. You've been a great source of information for me and I truly appreciate it.

Mike Abell
Systems Analyst / Network Administrator
Flexial - BOA Group - Cookeville, Tennessee
Office: 931.432.1853 ext 302
Mobile: 615.418.3055
email: MAbell@...


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Monday, July 30, 2012 11:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report tables needed for Sales Gross Margin Report - Vantage 8.03/Progress



If you invoice daily, the InvcDtl tables have what you want.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
flexial_ma
Sent: Monday, July 30, 2012 11:47 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Report tables needed for Sales Gross Margin Report -
Vantage 8.03/Progress

Hi All,

I am wanting to design a variant of the Sales Gross Margin canned report and
would like to know if someone could tell me what tables this report is
using?? Specifically, I need to find the "costs" of a part/job at time of
shipment which is what this report can give me. For example, part xxxx on
invoice xxxx shipped xxxx qty on date xx/xx/xxxx on job # xxxxx with Labor,
Material, Burden, Subcontract costs xxxx. I need the costs at this point
which is what this report kind of does but I need more functionality. I
would love to know what tables in Vantage this report is pulling from.
Thanks!

Mike Abell

No virus found in this message.
Checked by AVG - www.avg.com<http://www.avg.com>
Version: 2012.0.2197 / Virus Database: 2437/5164 - Release Date: 07/30/12

-----
No virus found in this message.
Checked by AVG - www.avg.com<http://www.avg.com>
Version: 2012.0.2197 / Virus Database: 2437/5164 - Release Date: 07/30/12

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



[Non-text portions of this message have been removed]
2
Hi All,

I am wanting to design a variant of the Sales Gross Margin canned report and would like to know if someone could tell me what tables this report is using?? Specifically, I need to find the "costs" of a part/job at time of shipment which is what this report can give me. For example, part xxxx on invoice xxxx shipped xxxx qty on date xx/xx/xxxx on job # xxxxx with Labor, Material, Burden, Subcontract costs xxxx. I need the costs at this point which is what this report kind of does but I need more functionality. I would love to know what tables in Vantage this report is pulling from. Thanks!

Mike Abell
3
If you invoice daily, the InvcDtl tables have what you want.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
flexial_ma
Sent: Monday, July 30, 2012 11:47 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report tables needed for Sales Gross Margin Report -
Vantage 8.03/Progress





Hi All,

I am wanting to design a variant of the Sales Gross Margin canned report and
would like to know if someone could tell me what tables this report is
using?? Specifically, I need to find the "costs" of a part/job at time of
shipment which is what this report can give me. For example, part xxxx on
invoice xxxx shipped xxxx qty on date xx/xx/xxxx on job # xxxxx with Labor,
Material, Burden, Subcontract costs xxxx. I need the costs at this point
which is what this report kind of does but I need more functionality. I
would love to know what tables in Vantage this report is pulling from.
Thanks!

Mike Abell



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2197 / Virus Database: 2437/5164 - Release Date: 07/30/12




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2197 / Virus Database: 2437/5164 - Release Date: 07/30/12

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