Canned Sales Gross Margin report does not print

Yahoo Archive
1
Thank you for the quick response.  

We've decided to recreate the report.  I'm using the InvcDtl table, but the JobCost which there are two JC and no JC (preceding the field) the totals are very close, but off by 3 or 4 percent. 

Will I need to link to the JobAssm. table? 

Thanks in advance.   
2

When doing a print or preview of the Sales Gross Margin report in Vista 8.03.408B, the following error message is generated in the "System Monitor:" 


Type:3

Program:ar/arr80.p

Method:getRptTableIncludedFields

Table:RptTable

Field:RptTableID

Rowid:

Message:Could not find RptTable for the specified table name.



3

On 607A there was a patch they sent me to fix this.  They actually sent me the arr80.p file.  Did you just upgrade?

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, December 11, 2014 9:48 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Canned Sales Gross Margin report does not print.

 

 

When doing a print or preview of the Sales Gross Margin report in Vista 8.03.408B, the following error message is generated in the "System Monitor:" 

 

Type:3

Program:ar/arr80.p

Method:getRptTableIncludedFields

Table:RptTable

Field:RptTableID

Rowid:

Message:Could not find RptTable for the specified table name.

 

 

4
Patch 8.03.410 fixed this issue. 
 
Jonathan Lang
I.T Manager
Database Engineer



On Thursday, December 11, 2014 11:59 AM, "Miguel Santillan msantillan@... [vantage]" <vantage@yahoogroups.com> wrote:


  
<div id="ygrps-yiv-228926647yiv8704122164ygrp-text">
  
  
  <div>
 
Miguel A. Santillan
Compass Manufacturing Systems
 
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, December 11, 2014 9:48 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Canned Sales Gross Margin report does not print.
 
 
When doing a print or preview of the Sales Gross Margin report in Vista 8.03.408B, the following error message is generated in the "System Monitor:" 
 
Type:3
Program:ar/arr80.p
Method:getRptTableIncludedFields
Table:RptTable
Field:RptTableID
Rowid:
Message:Could not find RptTable for the specified table name.
 
 
</div>
 


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

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-mkp #ygrps-yiv-228926647yiv8704122164hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-mkp #ygrps-yiv-228926647yiv8704122164ads {
margin-bottom:10px;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-mkp .ygrps-yiv-228926647yiv8704122164ad {
padding:0 0;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-mkp .ygrps-yiv-228926647yiv8704122164ad p {
margin:0;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-mkp .ygrps-yiv-228926647yiv8704122164ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-sponsor #ygrps-yiv-228926647yiv8704122164ygrp-lc {
font-family:Arial;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-sponsor #ygrps-yiv-228926647yiv8704122164ygrp-lc #ygrps-yiv-228926647yiv8704122164hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-sponsor #ygrps-yiv-228926647yiv8704122164ygrp-lc .ygrps-yiv-228926647yiv8704122164ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164activity span {
font-weight:700;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164activity span span {
color:#ff7900;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164activity span .ygrps-yiv-228926647yiv8704122164underline {
text-decoration:underline;}

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

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 .ygrps-yiv-228926647yiv8704122164attach div a {
text-decoration:none;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 .ygrps-yiv-228926647yiv8704122164attach img {
border:none;padding-right:5px;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 .ygrps-yiv-228926647yiv8704122164attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 .ygrps-yiv-228926647yiv8704122164attach label a {
text-decoration:none;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 .ygrps-yiv-228926647yiv8704122164bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 .ygrps-yiv-228926647yiv8704122164bold a {
text-decoration:none;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 dd.ygrps-yiv-228926647yiv8704122164last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 dd.ygrps-yiv-228926647yiv8704122164last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 dd.ygrps-yiv-228926647yiv8704122164last p span.ygrps-yiv-228926647yiv8704122164yshortcuts {
margin-right:0;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 div.ygrps-yiv-228926647yiv8704122164attach-table div div a {
text-decoration:none;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 div.ygrps-yiv-228926647yiv8704122164attach-table {
width:400px;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 div.ygrps-yiv-228926647yiv8704122164file-title a, #ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 div.ygrps-yiv-228926647yiv8704122164file-title a:active, #ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 div.ygrps-yiv-228926647yiv8704122164file-title a:hover, #ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 div.ygrps-yiv-228926647yiv8704122164file-title a:visited {
text-decoration:none;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 div.ygrps-yiv-228926647yiv8704122164photo-title a, #ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 div.ygrps-yiv-228926647yiv8704122164photo-title a:active, #ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 div.ygrps-yiv-228926647yiv8704122164photo-title a:hover, #ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 div.ygrps-yiv-228926647yiv8704122164photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 div#ygrps-yiv-228926647yiv8704122164ygrp-mlmsg #ygrps-yiv-228926647yiv8704122164ygrp-msg p a span.ygrps-yiv-228926647yiv8704122164yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 .ygrps-yiv-228926647yiv8704122164green {
color:#628c2a;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 .ygrps-yiv-228926647yiv8704122164MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 o {
font-size:0;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164photos div {
float:left;width:72px;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

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

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164reco-category {
font-size:77%;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164reco-desc {
font-size:77%;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 .ygrps-yiv-228926647yiv8704122164replbq {
margin:4px;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-mlmsg select, #ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 input, #ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-mlmsg pre, #ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 code {
font:115% monospace;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-mlmsg #ygrps-yiv-228926647yiv8704122164logo {
padding-bottom:10px;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-msg p#ygrps-yiv-228926647yiv8704122164attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-reco #ygrps-yiv-228926647yiv8704122164reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-sponsor #ygrps-yiv-228926647yiv8704122164ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-sponsor #ygrps-yiv-228926647yiv8704122164ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-sponsor #ygrps-yiv-228926647yiv8704122164ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-text {
font-family:Georgia;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-text tt {
font-size:120%;}

#ygrps-yiv-228926647 #ygrps-yiv-228926647yiv8704122164 #ygrps-yiv-228926647yiv8704122164ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-228926647