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
Merge Stock Codes Utility
Viewed 1693 times since Tue, Jun 12, 2012
Stock History Analysis
Viewed 2087 times since Fri, Jun 8, 2012
Extra (Other) Maintenance Screens - Stock Control
Viewed 1615 times since Mon, Jun 18, 2012
Selective Extra Batch Input Items
Viewed 1583 times since Wed, May 18, 2016
Stock Transfers - Stock Control
Viewed 1684 times since Mon, Jun 18, 2012
Average Cost Updating - Replace Cost if Stock Cost is Zero
Viewed 1586 times since Fri, Jun 8, 2012
Invoice and Credit Documents - Batch Tracking
Viewed 1982 times since Tue, Jun 19, 2012
Stock Assemblies - Stock Control
Viewed 1613 times since Mon, Jun 18, 2012
Recalculate Cost of Assemblies
Viewed 131 times since Tue, Oct 15, 2024
Location Maintenance - Stock Control
Viewed 1686 times since Mon, Jun 18, 2012