User Tools

Site Tools


Sidebar

Get the Most Out of Your ERP

The Windward Professional Services Catalog

Our catalog of services has topic-based, role-based, or technical plans that can help you maximize your software investment.




Follow Windward Software



New Feature Round-up
shiptoquery

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 (6 years ago) by cparagoso