Quantity UOM (UOM Active Only)

Available when UOM is Active or Pending. Select the UOM to display quantities in.

Initially set to the Base UOM, Sale UOM, Purchase UOM or Manufacture UOM for the Product according to the UOM Enquiry Default specified in User Preferences.

Note: Quantities will be rounded down to be displayed with the number of decimals of the selected UOM.

Quantities

In Stock

Stock currently on hand.

- Allocated

Allocated stock includes:

• Stock allocated in Sales Orders and Invoices that have not been posted from OE and / or IN.
• Stock in unposted JC Batches.
• Positive manufactures with pending usages.
• Negative manufactures (dis-assemblies) pending manufacture.

- Transfer Out

Stock quantity transferred out of the selected location.

Stock allocated in Sales Orders and Invoices that have not been posted from OE and / or IN. Also includes unposted JC Batches. (Accredo Saturn Only)

= Available

Stock available for sale, that is, In Stock less Allocated.

+ Variance

The quantity from pending adjustments due to stocktake variance, credit write offs, and other adjustments.

+ Transfer In

The quantity being transferred into the selected location. (Accredo Saturn Only)

+ On Order

The quantity ordered from suppliers.

+ Shipped

The quantity on Shipments not yet receipted.

- Back Order

The quantity on back order for Customers.

- Committed

Stock On Order or Shipped that is already committed to a Job.

+ Returned

The quantity pending inwards from credits, including negative manufactures pending usages.

+ In Production

The quantity currently in pending manufacture.

= Theoretical

The theoretical quantity in stock if all Sales Orders and outstanding Invoices were supplied and processed, all Back-orders fulfilled, all orders received from suppliers, all stock In-transit received, all quantities returned and quantities in production considered, and an update from stocktake completed.

Bin Code

The location of the product in the warehouse. (Accredo Mercury Only)

Minimum Maximum

Minimum and maximum quantities to be held in stock. If the quantity in stock falls below the minimum level a quantity is calculated and can be included on the Product, Product by Location and Stock Sales and Valuation report layouts. You can generate a Purchase Order to bring stock to the maximum level by using the Generate Order button on the PO Enter Purchase Order form. Minimum Quantity and Maximum Quantity are only relevant for diminishing items. See Re-Order Report for details of how these fields are used. 

Accredo Saturn Only: The fields on this tab are read-only; to edit these values, refer to the Locations tab. Accredo Mercury Only:The Maximum Quantity cannot be below the Minimum Quantity.

Rec. Reorder

The Recommended Reorder amount is calculated as follows:

If Theoretical stock < Minimum Qty, then Rec Reorder = Maximum Qty less Theoretical.

If UOM is used, the Rec. Reorder quantity will be rounded up to the next UOM if necessary.

Accredo Saturn Only: Maximum and minimum quantities are entered on the Locations tab.

Pending Stock Movements Grid

View details of pending stock movement for each Product.

Period

Select the date range to show stock movements for.

Motion

Select the type of pending stock movement, or select All Pending to see all.

Grid Toolbar

Expand Toolbar (Ctrl+F9)

Expand the toolbar to give access to all toolbar options. Press Esc to close the expanded toolbar.

Open (F12)

Opens the related document to be viewed.

Print (Ctrl+P)

Print the Stock Movement report, or save as an Excel worksheet, or PDF file to send.

Filter / Sort List (Ctrl+F2)

Clear Filter / Sort (Ctrl+F3)

Apply or clear a Filter & Sort. The button changes to indicate if a filter and sort is applied.

Customise (Alt+F5)

Opens Customise Fields, you can customise the fields visible in the grid.

Refresh (F5)

Reloads changes other Users may have made.

Calculate Totals / Clear Totals
(Alt+=)

Toggle on/off total calculation for the list fields where Total is selected in grid customisation.

Customise Toolbar

Customise Toolbar or right-click in the toolbar below the buttons to access the Customise Toolbar Menu.

Grid Fields

Quantity In

The Product quantity to be entered into stock.

Quantity Out

The Product quantity to be removed from stock.

Balance

The balance of stock available.

Source

The source module of the document.

Class

The type of stock movement.

Location

The Location of the stock. (Accredo Saturn Only)

Date

The pending date of the stock movement.

Party Code

The Customer, Creditor or Job code (left blank for stock transfers).

Document

The type of document the stock movement originated from.

Effective Date

Dependant on the movement Source and Class: