When a stock report is selected, an output selection window is opened. For most stock reports you will be able to select the details that are shown on the report.

One of these selectable options will be to show Landed Costs. The option to show the report with Landed Costs will not be available when Weighted value is selected. To produce a Profit report based on Landed Cost, select Transactional and select to show the report with Landed Costs.

This displays a selection window that allows the report to be expanded from a basic list of Stock Codes and Names.

You can overwrite this default title with any title that you want.

Any options not shown here, are detailed under the specific report to which they relate.

Full Details - Adds information such as the date each Record was entered and last changed, the superseded Stock Code, the User who entered and last edited the Record and the Status of the Record i.e. Serialised or Sub Analysis item.

Quantity and Value Details - Adds details of all Movements In and Out for the current period and for the year to date, the three valuations and the current Physical and Free Quantities with a total for Orders In and Out.

Movements In and Out - Adds individual figures for the quantity of Stock moved In and Out for all twelve or thirteen periods of the Current, Next and Last years.

Base Prices - Adds the standard buying and selling prices that appear on the main Stock Record screen. This can be used to produce a Price List.

All Prices - Adds as many of the ten Buying and Selling Prices as have been used for each Stock Record, complete with a summary of the price methods used and quantity breaks. If this option is selected, then two further radio buttons are displayed, enabling you to select the currency information on the report:

Weight - Adds the Weights information.

User Keys - Adds any entries that have been made in the User Keys window.

Facets - This option is only available where Use Stock Facets is enabled in System Control. If selected then any facets assigned to each record are included in the report.

Notes - Adds any entries that have been made in the Notes window.

New Page for each Record - Prints the details for each Stock Record on a new page.

Provides an easy means of capturing Physical stock quantities.

It is used in the same way as the Stock list, but has fewer optional fields.

This report has an 'As at Period' option.

You can choose to run the report as at Last Year, Current Year or Next Year for any period.

The report will correct the current physical balance to include only movements, in and out, up to and including the period selected.

Provides key information for each Sub Analysis or sub-analysis heading.

It is used in the same way as the Stock list, but has fewer optional fields.

This landscape report shows details of Stock Levels and availability. It enables you to see how the free stock quantity has been calculated and provides a recommendation of any Stock that requires re-ordering.

The information contained includes Stock Code, Physical, Deliveries to update, Allocated Stock, Unallocated Orders, Stock On Order In, Projected Free Stock, Minimum Quantity and Suggested Order quantity.

The Free Stock calculation method is shown in the report header.

By default, the report will be Based On Stock, but you can have the report Based On Sub Analysis if you prefer. Click on the menu to change the selection.

The second menu contains a list of types to be reported on. This list defaults to Allocated Stock. The other options in this list are On Order (In), Recommended Order and Recommended Order including Unallocated. A selection of one of these types will report only on the Stock Levels where stock is not up to the Minimum Quantity. The last option on the menu is All Records, if this is selected the report will include all Stock Levels disregarding Minimum Quantities.

Full Details - adds details to the report.

Movements In and Out - not available if you are basing the report on Sub Analysis.

All Prices - not available if you are basing the report on Sub Analysis. If this is selected you can then select whether to show Home Values or Home and Currency.

Notes - adds any entries that have been made in the Notes window.

New Page for each Record - prints the details for each Stock Record on a new page.

Using this option, you can produce Stock Valuation reports listing your stock holding valued by a selected method.

The menu allows the selection between a Valuation Report that Excludes or Includes Sub Analysis values. Sub analysis quantities are always included in the valuation, this menu just defines whether or not they are shown in the report.

Exclude Sub Analysis Values - produces a valuation report based on the sub-analysis records but with the values totalled and reported at Stock Record level.

Include Sub Analysis Values - produces a valuation report printing the individual Sub Analysis quantities and values. This report will not include stock records that have no sub-analysis associated with them.

The FIFO Value is calculated by totalling the value of inbound transactions in reverse order until the physical stock quantity is reached. This calculation may take some time if there are a lot of stock records or stock movements.

If you are using FIFO as your valuation method and you wish to produce a valuation report that is not the sum of the FIFO valuations of the sub analysis records, then you should use the alternative Access Crystal report - FIFO Valuation by Stock Record

This is calculated by moving stock in at Actual price and out at Average price.

This is calculated as the Physical quantity * Latest Cost price.

The valuation report for Latest Value when Include Sub Analysis Values has been selected, shows the value of the stock based on the individual Sub Analysis values. An addition option is available for this report:

Use Main Cost Price - This option enables you to show the value of the Sub Analysis Stock using the Main Stock record Cost price. This tick box defaults to the state of the corresponding Use Main Cost Price option in Stock Options - Sub Analysis tab card.

(use this option for Fixed Weighted) If you are using Fixed Weighted valuation, the Fixed Weighted values held by the system will be used for the report.

If you are using Weighted valuation, the values will be calculated as (Value of inward movements / Total Quantity In) * Physical Quantity

Provides a choice of two different margin calculations for all ten Selling Prices.

It is used in the same way as the Stock list, but has fewer optional fields.

This lists all of the Movements of Serial Numbers that have been entered into the System.

All Movements - Displays a pull down Menu. The options are All Movements, Movements In, Movements Out, Items in Stock.

By default, all the Movement Type boxes are selected, but individual Movement Types can be de-selected by un-ticking the boxes.

The Home, Home and Currency, Currency or 2nd Base values can be selected. If Home and Currency is selected, both Home and currency equivalent values will be shown.

It is used in the same way as the Stock list, but has an additional optional field, Components.

Clicking Components adds an option to include Full Names, and the report will detail the Components of each Sub-Assembly and the availability of Assemblies based on the Components available.

It is used in the same way as the Stock list, but has fewer optional fields.

Lists all the special prices that are unique for each combination of Customer and Stock Record.

Selecting Scheduled Orders displays an empty list window. This facility allows forward planning of Stock availability based on batched Sales and Purchase Orders.

You should first select the number of Weeks or Months between the Subtotals that you want to examine, using the drop down menu and the entry box:

Expand Assemblies - enables you to look at the Components, if this is relevant.

The Stock menu has two options, so that you can select whether to base your report on Stock or on Sub Analysis.

Click the Display button to open a dialog where you can select the type of Orders for the list.

The Print button displays a Scheduled Orders print selection window for you to select the enhancements to the standard report that you want to add.