Stock Control: Reports

Reports:

Menu Options
The following menu options are covered in this section:

|- Reports
      |- Stock Valuation
      |- Price List
      |- Vital Few
      |- Report Generator
      |- Monthly Figures
      |- Batch Number

Most of the reports will ask the basic information, e.g.

Record to start at       1
Record to finish at      399
Product code             0         (0 to ignore)
Supplier code            0         (0 to ignore)
Manufacturer code        0         (0 to ignore)
Flag mask                ?????????

1. A Range of items (Numerically)
2. Items from a specific supplier
3. Items from a specific manufacturer
4. Items in a specific product class
5. Specified by you via the Flags

Additional questions will be covered in the appropriate section below.

Stock: Valuation

This option will printout the value of the stock at any given time. It will group the items by product code and will give a summary broken down by Supplier, Manufacturer and product code.

You can run this as an un-attended option.

Stock: Price List

This option, as the name implies, will print out price lists. The following features are available:

• Multiple copies
• Alphabetically sorted by either description or code.
• Print VAT inclusive or exclusive lists
• Limit the range of items printed, by number, product code, supplier code, manufacturer or a combination of these.
• Print up to 3 discount/surcharge prices for each item.

Sort by                  D         (<C>ode or <D>esc.)
Number of copies         1
VAT                      E         (<I>nc. or <E>x)
Disc/Surc bands          N

Stock: Vital Few

This report works on the theory that only 20% of your stock accounts for 80% of your stock sales. This allows you to keep a close eye on these items, thus saving you time in checking items which do not account for a high percentage of sales. The breakpoint (the point at which to stop itemising the items) can be changed at will.

Optionally, you can base the figures on stock 'holding'. This will produce a list, based on the current value of stock held, instead of year to date sales.

Options that can be changed are:

Breakpoint               80        (<Y>.T.D. or
Base figures on          Y         <H>oldings)

Stock: Monthly Figures

This will print either the basic figures or display a graph of the sales (or purchases) of a specific group of items.

Stock: Batch Numbers

This will list all items with a batch number and include the expiry date. You have to option to restrict the report to items that are due to expire in the the next XX days.

If the number of days is set to zero then all items with a batch number will be printed.