Stock Optional 2 - Stock Control


Datafile Software

Stock Optional 2 - Stock Control

NON-STOCK ITEM ? Flag to identify items for which you do not want to track quantities.

MEMO-REFERENCE Y (6) Holds the reference number of any memo attached to the stock item.The filename of the memo being STnnnnn.XXX (replacing nnnnnn with the number held here and XXX with the company id)

LAST-ORDER PRICE K, L, M The price used on the last purchase order for this item and offered by default as the cost on the next purchase order. This item is not normally invoked in a foreign currency configured system unless stock items are exclusively purchased in one currency.

STOCK-GROUP N, T, & Categorises stock items into groups and is used as an option within the Discount Matrix facilities.

ALT-EC-VAT CODE X (1) Default VAT code used on stock issues for ‘EC’ customers within Order Processing and Invoicer.

COST-PER-QTY N Similar to Price Per above but for the cost price.

PACK MULT N, K Used where selling prices and quantity are quoted in different units.E.g. Prices for paint could be quoted per litre whereas stock is held as 1 5-litre tin. This option should not be used on a stock item for which price per is in use.

CURRENCY-COST K, L, M Used within Purchase Order Processing when an order is placed for a supplier and the currency of the supplier matches that of the currency code on this stock item.

CURRENCY-CODE X (3) The Currency Code in which the currency cost is quoted.

PER-B/F-QTY K, L, M Set as part of the Recalculation of Costs for Stock Valuation procedure this is the physical quantity that ‘would’ have been available at the start of the period.

PER-B/F-COST K, L, M This is the cost price as at the start of the period.

PER-END-QTY K, L, M This is the physical quantity as of the last run of the Recalculation procedure.

PER-END-COST K, L, M This is the cost price as at last run.

DELETE AT YEAR END ? Flag to identify whether stock item should be removed as part of the year end processes.


Custom Fields

Article ID: 522
Created On: Tue, Jun 19, 2012 at 11:57 AM
Last Updated On: Thu, Jun 22, 2023 at 10:50 PM

Online URL: https://kb.datafile.co.uk/article/stock-optional-2-stock-control-522.html