Sales Analysis Report for 8.03

Yahoo Archive
1
Below is the command text for the Microsoft query. It should be good enough for you to see which tables, fields to use. I don't feel comfortable sharing actual sales data with group.

SELECT InvcHead_0.InvoiceDate, InvcHead_0.InvoiceNum, InvcDtl_0.ProdCode, InvcDtl_0.OurShipQty, InvcDtl_0.PartNum, Customer_0.CustID, Customer_0.Name, Customer_0.GroupCode, Customer_0.TerritoryID, Customer_0.State, InvcDtl_0.ExtPrice, InvcDtl_0.TotalMiscChrg, InvcHead_0.FiscalYear, InvcHead_0.InvoiceAmt, InvcDtl_0.SalesChart, InvcDtl_0.COSMtlChart, InvcDtl_0.JournalNum, InvcDtl_0.LbrUnitCost, InvcDtl_0.MtlUnitCost, InvcDtl_0.SubUnitCost, InvcHead_0.FOB, InvcHead_0.TermsCode, InvcDtl_0.DiscountPercent, InvcDtl_0.Discount, InvcHead_0.FiscalPeriod, Customer_0.Country, InvcDtl_0.OrderNum, InvcDtl_0.OrderLine
FROM MFGSYS.PUB.Customer Customer_0, MFGSYS.PUB.InvcDtl InvcDtl_0, MFGSYS.PUB.InvcHead InvcHead_0
WHERE Customer_0.Company = InvcHead_0.Company AND Customer_0.CustNum = InvcHead_0.CustNum AND InvcDtl_0.Company = Customer_0.Company AND InvcDtl_0.Company = InvcHead_0.Company AND InvcDtl_0.InvoiceNum = InvcHead_0.InvoiceNum AND InvcDtl_0.CustNum = InvcHead_0.CustNum AND ((InvcHead_0.FiscalYear=2014) AND (InvcHead_0.InvoiceDate>{d '2011-12-31'}) AND (Customer_0.Company='ppi'))
ORDER BY InvcHead_0.InvoiceNum


Thanks,

[cid:image001.png@01CF6544.B70519A0]
Ben Burford
Accounting Manager
Poly Portables, LLC
Toll Free: (800) 241-7951 Ext. 308
Local: 706-864-3776
Cell: 706-973-0180



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

Does anyone have a Sales Analysis Report for 8.03 done in Crystal that they would like to share?  We would like to make some changes to it, but it is one of those reports that can't be modified because it's not based on Crystal Reports.


Steven G.

3
I have a query built in Excel that pulls the data from vantage via ODBC. I find that it updates much quicker than running reports out of crystal/vantage. Also have one for stock status. The stock status report in Vantage is by far the worst in terms of speed to return.



Thanks,

[cid:image001.png@01CF63C2.872E2FB0]
Ben Burford
Accounting Manager
Poly Portables, LLC
Toll Free: (800) 241-7951 Ext. 308
Local: 706-864-3776
Cell: 706-973-0180



[Non-text portions of this message have been removed]
4
Would you mind sharing it or posting it to this group?

Steven G.
On Tuesday, April 29, 2014 3:49 PM, Ben Burford <bburford@...> wrote:
  
<div id="ygrps-yiv-1263130115yiv4983875547ygrp-text">
  
  
  <div>I have a query built in Excel that pulls the data from vantage via ODBC. I find that it updates much quicker than running reports out of crystal/vantage. Also have one for stock status. The stock status report in Vantage is by far the worst in terms of speed to return.<br clear="none">

Thanks,

[cid:image001.png@01CF63C2.872E2FB0]
Ben Burford
Accounting Manager
Poly Portables, LLC
Toll Free: (800) 241-7951 Ext. 308
Local: 706-864-3776
Cell: 706-973-0180

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

</div>
 


<div style="color:#fff;height:0;"></div></div>
#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547 -- #ygrps-yiv-1263130115yiv4983875547ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-mkp #ygrps-yiv-1263130115yiv4983875547hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-mkp #ygrps-yiv-1263130115yiv4983875547ads {
margin-bottom:10px;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-mkp .ygrps-yiv-1263130115yiv4983875547ad {
padding:0 0;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-mkp .ygrps-yiv-1263130115yiv4983875547ad p {
margin:0;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-mkp .ygrps-yiv-1263130115yiv4983875547ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-sponsor #ygrps-yiv-1263130115yiv4983875547ygrp-lc {
font-family:Arial;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-sponsor #ygrps-yiv-1263130115yiv4983875547ygrp-lc #ygrps-yiv-1263130115yiv4983875547hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-sponsor #ygrps-yiv-1263130115yiv4983875547ygrp-lc .ygrps-yiv-1263130115yiv4983875547ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547activity span {
font-weight:700;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547activity span span {
color:#ff7900;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547activity span .ygrps-yiv-1263130115yiv4983875547underline {
text-decoration:underline;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 .ygrps-yiv-1263130115yiv4983875547attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 .ygrps-yiv-1263130115yiv4983875547attach div a {
text-decoration:none;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 .ygrps-yiv-1263130115yiv4983875547attach img {
border:none;padding-right:5px;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 .ygrps-yiv-1263130115yiv4983875547attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 .ygrps-yiv-1263130115yiv4983875547attach label a {
text-decoration:none;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 .ygrps-yiv-1263130115yiv4983875547bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 .ygrps-yiv-1263130115yiv4983875547bold a {
text-decoration:none;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 dd.ygrps-yiv-1263130115yiv4983875547last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 dd.ygrps-yiv-1263130115yiv4983875547last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 dd.ygrps-yiv-1263130115yiv4983875547last p span.ygrps-yiv-1263130115yiv4983875547yshortcuts {
margin-right:0;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 div.ygrps-yiv-1263130115yiv4983875547attach-table div div a {
text-decoration:none;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 div.ygrps-yiv-1263130115yiv4983875547attach-table {
width:400px;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 div.ygrps-yiv-1263130115yiv4983875547file-title a, #ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 div.ygrps-yiv-1263130115yiv4983875547file-title a:active, #ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 div.ygrps-yiv-1263130115yiv4983875547file-title a:hover, #ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 div.ygrps-yiv-1263130115yiv4983875547file-title a:visited {
text-decoration:none;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 div.ygrps-yiv-1263130115yiv4983875547photo-title a, #ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 div.ygrps-yiv-1263130115yiv4983875547photo-title a:active, #ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 div.ygrps-yiv-1263130115yiv4983875547photo-title a:hover, #ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 div.ygrps-yiv-1263130115yiv4983875547photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 div#ygrps-yiv-1263130115yiv4983875547ygrp-mlmsg #ygrps-yiv-1263130115yiv4983875547ygrp-msg p a span.ygrps-yiv-1263130115yiv4983875547yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 .ygrps-yiv-1263130115yiv4983875547green {
color:#628c2a;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 .ygrps-yiv-1263130115yiv4983875547MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 o {
font-size:0;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547photos div {
float:left;width:72px;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547reco-category {
font-size:77%;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547reco-desc {
font-size:77%;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 .ygrps-yiv-1263130115yiv4983875547replbq {
margin:4px;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-mlmsg select, #ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 input, #ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-mlmsg pre, #ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 code {
font:115% monospace;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-mlmsg #ygrps-yiv-1263130115yiv4983875547logo {
padding-bottom:10px;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-msg p#ygrps-yiv-1263130115yiv4983875547attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-reco #ygrps-yiv-1263130115yiv4983875547reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-sponsor #ygrps-yiv-1263130115yiv4983875547ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-sponsor #ygrps-yiv-1263130115yiv4983875547ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-sponsor #ygrps-yiv-1263130115yiv4983875547ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-text {
font-family:Georgia;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-text tt {
font-size:120%;}

#ygrps-yiv-1263130115 #ygrps-yiv-1263130115yiv4983875547 #ygrps-yiv-1263130115yiv4983875547ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-1263130115