OVERVIEW
This report setup window provides you with the ability to choose a range of selections, sort order and report types.
You can drag and drop onto the window from the parts or supplier scratchpads to obtain a report of selected parts or suppliers only.
NOTE: This window contains fields introduced with version 5 that enable additional search (and sometimes sort controls), such as Adhoc extra where. For more help on their use and examples see the Client-Server SQL Introduction help.
File Path
Masters > Purchase Parts > Print Reports…
This file path takes you to the Purchase Parts Reports window.
Part Number
Enter part number data that restricts the records selected. If left blank, data will be extracted from the minimum and maximum extremes in the file. All selection criteria you enter will have to be met by each record processed.
Supplier Code
Enter supplier code data that restricts the records selected. If left blank, data will be extracted from the minimum and maximum extremes in the file. All selection criteria you enter will have to be met by each record processed.
Supplier part number
Enter supplier part number data that restricts the records selected. If left blank, data will be extracted from the minimum and maximum extremes in the file. All selection criteria you enter will have to be met by each record processed.
Adhoc extra where
You can enter an extra WHERE clause and entry, for example, in reports that data includes addresses, ADRCONC NOT IN (‘GB’, ‘FR’, ‘IE’) would exclude addresses from countries GB, FR and IE. Right click to view from available columns and insert from list.
Custom Search button
Click to design your own special custom search.
Use custom tick box
To turn on and off the use of the custom search design.
Sort by
Select to choose a primary sort order for the report.
Report Type
Select a report type. Any custom reports entered in the settings will appear at the bottom of the list.
Adhoc pre-sort
You can enter one or more additional sort columns that will be appended as the first sort before the main sort chosen above.
WARNING! This can disrupt sub-totalling, if present in the report. Right click to view available columns and insert from the list.
Clear ScratchPad First
Check this option to clear the scratchpad before loading the results from above.
Cancel button
Aborts the process currently in session. The keyboard equivalent is the Esc key for Windows computers and Command-.(full stop or period) for the Mac.
Print button
Will cause a report to be printed of the subject matter. Right-click to change the report destination.
| See also: | Purchase Part Selection |
Compiled in Program Version 6.00. Help date last modified on 14 November 2023
Class wpptprint (Purchase Parts Report) last modified 25 May 2022 FP: Masters > Purchase Parts > Print Reports…
