Language:


Stock List Comparison

This report displays current stock figures and open (unfulfilled) order quantities for all or selected Items for two specified Locations. If the second Location has insufficient stock to satisfy the Orders assigned to it, the report will also show whether the first Location has any free stock available for transfer.

For each Item, the report has six columns as follows:

Ordered 1
The open order quantity for Location 1.

Location 1
The current stock level of the Item in Location 1.

Ordered 2
The open order quantity for Location 2.

Location 2
The current stock level of the Item in Location 2.

1->2
If Location 2 does not have sufficient stock of an Item to satisfy all open Orders, this figure is the quantity available to be transferred from Location 1 in order to remedy the situation. If Location 1 also has open Orders, it is assumed that these will be satisfied first.

Loc 1/Ord 1
The quantity in free stock in Location 1 (i.e. column 2 - column 1).
The open order quantity figures for Locations 1 and 2 are calculated using the Location field on the 'Del Terms' card of each Order. The Location on flip F of the 'Items' card is not used.

Item No.
Paste Special    Item register
Range Reporting    Alpha
Enter an Item Number (or range of numbers) to produce a Stock List for specific Item(s). Use a colon (:) to separate the first and last number.

Only Stocked Items in the range will be shown (not Plain, Service or Structured Items).

Group
Paste Special    Item Group register, Sales Ledger
Range Reporting    Alpha
Enter an Item Group Code to produce a report covering all Stocked Items in a particular Item Group.

Location 1
Paste Special    Locations setting, Stock module
Specify here the Location from which surplus stock is to be transferred. This will be the From Location in any subsequent Stock Movement.

Location 2
Paste Special    Locations setting, Stock module
Specify here the Location to which stock is to be transferred in order to satisfy any open Orders. This will be the To Location in any subsequent Stock Movement.

Only with balance
Check this box if you want to exclude from the report all Items for which the column 5 figure is zero. This figure will be zero if there is sufficient stock in Location 2 to satisfy all open Orders, or if there is no stock in Location 1 that can be transferred.