User Tools

Site Tools


shiptoquery

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

shiptoquery [2015/09/21 16:34] (current)
cparagoso created
Line 1: Line 1:
 +There could be instances wherein a customer would like to be able to generate a Customer Report with their 'Ship To Addresses'​. We currently do not have this option from our '​Design Customer/​Supplier Report'​ however, we could still extract the report by running an SQL query.
  
 +Note: The customer must be very knowledgeable about SQL databases and we must also have our programmers'​ or GLs' consent to do this.
 +
 +
 +**SELECT c.RecordNo, a.Name, c.Comment FROM Comment c INNER JOIN Account a ON AUnique=RecordNo WHERE FileNo=99 ORDER BY c.RecordNo, c.LineNo;**
 +
 +
 +
 +
 +FileNo 99 is where the Ship To Addresses are stored. After running this query, the '​Comment'​ column should show the customers'​ Ship To Addresses. ​
shiptoquery.txt ยท Last modified: 2015/09/21 16:34 by cparagoso