Home » Categories » Solutions by Business Process » Stock Control and Batch Tracking

Transaction Optional - Stock Control

Datafile Software

Transaction Optional - Stock Control

SL/PL-ACCOUNT X (10) Holds the sales/purchase account code for which this transaction was generated.

NOMINAL CODE X (16) Holds the nominal code. Typically this is the sales (or purchase depending on type) nominal code recorded on the stock record unless amended via the Order Processing/Invoicing system.

USER-1 Any Stock Transaction Header item (see System Profiles)

USER-2 Any Stock Transaction Detail item (see System Profiles)

TAX-CODE X (1) Holds the VAT code for the generated transaction. Usually the default code recorded on the Stock file unless amended via the Order Processing/Invoice systems or overridden with EC/Exempt codes based on the customer/supplier.

TAX-AMOUNT K, L Holds the tax amount applicable for the transaction.

PACK-QUANTITY N Holds the pack quantity of the stock item (copied from stock record at time of transaction generation).

DISCOUNT-RATE K, L Holds the (line) discount rate applied to this transaction when generated within the order processing / invoicing systems.

DISCOUNT-AMNT K, L Holds the (line) discount value given for this transaction within the order processing / invoicing systems.

TFR-STOCK CODE X (16) A Stock Transfer generates two type ‘7’ transactions per transfer.This item contains the ‘other’ side (either from/to depending on negative/positive state of the qty value) of the transfer for enquiry. For assembly transaction then the component type ‘9’ transactions have the assembly stock code recorded here.

PRICE-PER-FACTOR N Holds the price per (or cost per on goods in) at which the stock item was issued (received).

CURRENCY-CODE X (3) If generated via the Order Processing/Invoicing systems and the Foreign Currency accessory is in use then this is the currency than the stock transaction was generated in.

CURRENCY-RATE M This is the exchange rate the transaction was generated at.

CURRENCY-COST/PRICE K, L, M This is the currency value the transaction was generated at.

PERIOD-NUMBER N This is the period number the transaction was generated in.

WEEK-NUMBER N This is the week number (if appropriate) the transaction was generated in.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Multiple Locations
Viewed 2203 times since Mon, Jun 18, 2012
Standard Costing
Viewed 2306 times since Mon, Jun 18, 2012
Stock File FULL Screen Design (Premier) - Stock Control
Viewed 2457 times since Tue, Jun 19, 2012
Period End Procedure - Stock Control
Viewed 2323 times since Mon, Jun 18, 2012
Memo Facility Configuration - Stock Control
Viewed 1989 times since Tue, Jun 19, 2012
Currency Considerations
Viewed 2069 times since Mon, Jun 18, 2012
Database Audit - Batch Tracking
Viewed 2019 times since Tue, Jun 19, 2012
Transaction Analysis Summary - Stock Control
Viewed 1964 times since Mon, Jun 18, 2012
Separate Lookups for Second / Extra Maintenance Screens
Viewed 2011 times since Tue, Jun 12, 2012
Warehouse Tablet - User-Defined Database Landing Page / Edit
Viewed 722 times since Thu, Jan 9, 2025