Claire OTS Custom excel report
Introduction
The following wiki explains how to generate an Excel OTS report that will show pictures, print specs, or sort by body
Setup
In the main JAS menu, go to:
| |
In the alternate menu, go to:
| |
Enter the appropriate selection criteria on the first screen. Once complete, click on "Proceed". | |
On the section screen, the user has the option to insert a check mark to:
Enter the appropriate template name, export file name, and password. Click on "Ok". |
Sample Output
A report will be generated, similar to the following
Related Articles
Exporting the Customer List and Label Report to Excel
Table of Contents Introduction Instructions Filling in the Export to Excel options To find the template name including file path Sample Report Introduction This wiki explains to the user how to export the customer lists and labels report to Excel. ...Claireball - Duplicates in Qlikview
Clairebell experiences a recurring issue with their Qlikview reports. Duplicates are created in the system and are seen on their reports. This happens in the individual JAS DATA companies, so you need to run the fix in each DATA company individually. ...Sent/ Unsent EDI Invoices Report
Introduction The following wiki explains how to generate a report to view EDI Invoices. Setup In EDI, go to: Invoicing Sent / Unsent EDI Invoices Report A report can be generated that displays only unsent invoices, only sent invoices, or both sent ...Creating an 870 Order Status Report
Table of Contents 1- Introduction 2- Creating the Order Status Report a. Creating an Automatic 870 b. Creating a Manual 870 3- Generating the 870 Order Status Report Introduction The following wiki explains ...Exporting P.O. Line Detail Reports to Excel
Introduction The purpose of this wiki is to give a step-by-step guide on how to export the P.O. Detail Line Report to Excel using various formats. P.O. Line Detail Report From the main menu, select: P.O. Reports P.Order Line Detail Report Under ...