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
Stock Transactions
Viewed 1617 times since Mon, Jun 18, 2012
Enter Purchase Orders - Stock Control
Viewed 1508 times since Mon, Jun 18, 2012
Batch Tracking
Viewed 1679 times since Mon, Jun 18, 2012
Document Design Manager - Setting and Applying Font Defaults - Stock Control
Viewed 1695 times since Tue, Jun 19, 2012
Transferring from Existing Stock Control
Viewed 1663 times since Mon, Jun 18, 2012
Maintain Assemblies
Viewed 1712 times since Mon, Jun 18, 2012
Database Audit - Stock Control
Viewed 1574 times since Tue, Jun 19, 2012
Out of Stock Report - Stock Control
Viewed 1579 times since Mon, Jun 18, 2012
Enquire Where Stock Used - Stock Control
Viewed 1616 times since Mon, Jun 18, 2012
Update Last Sale / Purchase Dates with Assembly Build
Viewed 148 times since Wed, Oct 16, 2024