Adding Packing Slip to Aged Receivables Rpt: V8.03

Yahoo Archive
1
Thanks so much. I'll give it a go.

Steven
2

Hello, everyone - 


Long-time lurker with a simple question.


My finance officer wants the packing slip number associated with an invoice added to the canned Vantage "Aged Receivables Report".


Assuming this report runs off of AR tables, I've tried to find these tables in the Data Dictionary.  I can't track down any AR tables.  Are they hidden?


Is it possible link to the packing slip number with the tables as defined in Report Data Definition for 'ARAgng'?


Frustrated with trying to modify the canned report, I thought I'd just create a new Crystal Report for her, linking Invoice Number and Packing Slip, but I can't figure out what tables to use to even do that.


Any help is greatly appreciated.


Steven

3
The AR tables are called InvcHead and InvcDtl the Invoice Detail table contains a link back to the Sales Order and Pack Number these should be able to be added to the Canned report without much trouble

Table InvcDtl.PackNum, InvcDtl.PackLin, InvcDtl.OrderNum, InvcDtl.OrderLine, InvcDtl.OrderRelNum

Hope this helps



Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Thu, Jan 28, 2016 at 11:43 AM, srussell@... [vantage] <vantage@yahoogroups.com> wrote:
 
<div>
  
  
  <p></p><p><span>Hello, everyone - </span></p><p><span><br></span></p><p><span>Long-time lurker with a simple question.</span></p><p><span><br></span></p><p><span>My finance officer wants the packing slip number associated with an invoice added to the canned Vantage &quot;Aged Receivables Report&quot;.</span></p><p><span><br></span></p><p><span>Assuming this report runs off of AR tables, I&#39;ve tried to find these tables in the Data Dictionary.  I can&#39;t track down any AR tables.  Are they hidden?</span></p><p><span><br></span></p><p><span>Is it possible link to the packing slip number with the tables as defined in Report Data Definition for &#39;ARAgng&#39;?</span></p><p><span><br></span></p><p><span>Frustrated with trying to modify the canned report, I thought I&#39;d just create a new Crystal Report for her, linking Invoice Number and Packing Slip, but I can&#39;t figure out what tables to use to even do that.</span></p><p><span><br></span></p><p><span>Any help is greatly appreciated.</span></p><p><span><br></span></p><p><span>Steven</span></p><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>