>> Fastbase Business Software Ltd

Fastbase Accounting System - Online Manual

Running Stock Report for Parts with no List Price

Document 103213/1

Entered Thu, 22 May 2003 16:41 by Peter Campbell
Updated Thu, 22 May 2003 16:44
Previous


Any stock report can be run for "zero sell price" items only, follow the instructions below for an example:

1. Select the Stock Price List report from the Reports - Miscellaneous menu.
2. Press F1 on the "Selected Parts" prompt.
3. Select the "More Options" button.
4. Enter the following in the "SQL Statement" field: SELL_PRICE1 = 0

Only parts which have a zero sell price will be reported.
There are 5 selling prices labelled SELL_PRICE1, SELL_PRICE2 ... SELL_PRICE5.


Online documentation: enter keywords to search for: