Report Library - Stock Control

Deadstk.sty - Dead Stock Valuation Report

Produces a report of all stock that has not been sold since a user specified date. The report lists the product code, item description, current stock holding, total inventory value of that stock and last sale date.

Pricels2.sty - Price List by Stock Group

This is a price list report sorted by stock group. The report includes the stock group code and group description as a sub heading. Then the product code, description, stock price D and the quantity in stock.

Priceup.sty - Stock Group Price Updates

This is a special purpose report that performs a price update on the stock file based on stock group formulas. It is equivalent to peforming a Global Price Adjustment with the Apply All Formulas selection ticked.

This report is useful if data is being imported from an external source and you wish to update stock group price formulas afterwards. You can run the report, for example, from an icon by executing:

VB /RUN:PRICEUP /EXIT

Output is sent to "none" so no paper copy of the report need be printed.

No user prompting occurs when this report is executed. It cannot therefore be cancelled.

Serial.sty - Serial Number History Report

This report tracks the history of product items by serial number or unique property type. It lists the product code, serial number (or unique property), type of transaction (purchase order, invoice, back order, etc.) transaction number, transaction date and from/to account (supplier or customer). The report is sorted by product code and serial number.

Skaudit.sty - Stock Codes Audit Report

This report produces a list of all product codes in the system that have not been assigned stock codes or supplier codes. It also generates a CSV file that can be loaded into Microsoft Excel and other popular applications and then re-imported back into CAPITAL via the External File Import Utility found in Installation Workshop.

Stexport.sty - Product Changes Stock Records Export

This sample report creates a dBase III compatible data file containing stock information for transfer to another system. It can easily be adapted to export structured ASCII text data instead. Only products 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. Also see the report Stockexp.sty which allows you to export the same data each time that report is run.

The exported file is called newstk.dbf and is placed in the same directory 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 of the stock fields in the stock control system are exported using this report. To see which fields these are select Edit|Body Management and double-click on the Body 1 entry and view the Body Field List.

Stockexp.sty - Stock Data Export

This sample report creates a dBase III compatible data file containing stock information for transfer to another system. Only stock items that have the Reporting|Supplier Group setting ticked, will be placed in the exported file.

The exported file is placed on C:\ drive and has the file name STOCKFIL.DBF. You can change the type of file generated, its destination, and its file name, by selecting File|Export from the menu.

The fields that are exported include:

The product code
The product description
The stock group
The supplier group
The box conversion factor
The weight
The volume
The unit of measure
The box unit of measure
Ttock Price "A" (first price)

Invstlab.sty - Stock Labels From Invoices

This form prints one label for each item on an invoice for the quantity sold. Zero or negative quantities are ignored. Non-stock items are skipped over.

The label will prompt for the invoice number to print. The label prints the product description and an EAN/JAN 13 bar code based on the contents of the stock Alternative code field.

The form does not take into account the "number of labels to print" setting found in stock control, however it could be expanded to use this feature.

This form also shows how Visual Builder's HoldRecord feature can be put to practical use for printing multiple labels per record in the system.

____________________________