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
Assemblies - Omit Component from Build
Viewed 1435 times since Fri, Jun 8, 2012
Batch Tracking
Viewed 1382 times since Mon, Jun 18, 2012
Assemblies - Bulk Stock Items
Viewed 1575 times since Fri, Jun 8, 2012
Slow Moving Stock Report - Stock Control
Viewed 1663 times since Mon, Jun 18, 2012
System Profiles - Batch Tracking
Viewed 3283 times since Tue, Jun 19, 2012
Stock Assemblies - Flag as Obsolete
Viewed 9027 times since Fri, Nov 22, 2013
Controls and Audit Manager - Batch Tracking
Viewed 1221 times since Tue, Jun 19, 2012
Select Key Definition - Stock Control
Viewed 1250 times since Tue, Jun 19, 2012
Period End Procedure - Stock Control
Viewed 1539 times since Mon, Jun 18, 2012
Transaction Reports - Stock Control
Viewed 1374 times since Tue, Jun 19, 2012