 |
|
|
Report Library - Customer & Supplier Transactions Cuexport.sty - Customer Changed Records Export This sample report creates a dBase III compatible data file containing customer information for transfer to another system. It can easily be adapted to export structured ASCII text data instead. Only customers that have changed since the last time the report was executed will be exported. The report is divided into two sections (bodies). The first creates the export data file and the second uses the Write() function to record that the data has been exported. The next time the report is run, only records that have since changed will be exported. The exported file is called newcu.dbf and is placed in the same folder as the company it is run from. You can change the type of file generated, its destination, and its file name, by selecting File|Export from the menu. Most customer fields are exported using this report excluding those specifically related to transaction numbers, dates or amounts. To see which fields these are select Edit|Body Management and double-click on the Body 1 entry and view the Body Field List. If you want to also export user defined fields you will need to modify the report to include them. Invsort.sty - Invoices printed in special sorted sequences This transaction will print invoices in special sorted sequences: by account code, customer name, postcode and state. It can also be adapted for other kinds of specialised sort sequences. Special.sty - Price List with Customer Special Pricing Support This report generates a price list sorted by product code. It includes the product code, product description, a sample list price (stock control price B) and a sell price that takes into account any special customer price rules. The report makes use of the SpecialPrice() function to retrieve account specific pricing. Special2.Sty - Customer Price List by Product Group This report prints a price list for a specific customer and product group. The report includes the product code (part number), product description, stock control price C and the customer specific special price. The report also includes extended product description lines when applicable. Unpaidsp.sty - Unpaid Invoice By Salespersons Report This report lists unpaid invoices grouped and totaled by individual salesperson. Unpweek.sty - Unpaid Transactions By Week This reports showns unpaid customer transactions by week, then unpaid supplier transactions by week. Runlist.sty - Invoice Run List This sample reports demonstrates how to create and sort an export file and then base a report around the newly created file. Using this technique, the main invoice file does not have to be custom sorted. This means that Runlist.sty will always run at about the same speed regardless of the size of the invoice database. The report begins by scanning between two date ranges all invoice transactions that do not have a blank 3rd invoice reference field. (Ourref3) The matching record data is copied into a new database called 'RUNLIST'. At the same time, RUNLIST is sorted by the 3rd invoice reference field. The first body of the report creates RUNLIST. As this body is doing the preparatory ground work, it is marked as invisible so that it does not appear on any printed reports. The second body of the report then reads and presents the contents of RUNLIST.
____________________________ Related Topics |
Keep in mind that CAPITAL Visual Builder
does not create new database files in print preview mode. If you
want to test the creation of the report you will need to at least
print it to a disk file.