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
Period End Procedure - Stock Control
Viewed 1670 times since Mon, Jun 18, 2012
Statements - Batch Tracking
Viewed 1371 times since Tue, Jun 19, 2012
Assemblies - Always Build Selected Sub-Assemblies
Viewed 8692 times since Fri, Jun 8, 2012
Set Auto Expand Data Files - Batch Tracking
Viewed 1421 times since Tue, Jun 19, 2012
Edit System Status Display - Batch Tracking
Viewed 1342 times since Tue, Jun 19, 2012
Location File - Stock Control
Viewed 1394 times since Tue, Jun 19, 2012
Stock Statement - Stock Control
Viewed 2941 times since Mon, Jun 18, 2012
Location Maintenance - Stock Control
Viewed 1552 times since Mon, Jun 18, 2012
Transaction Reports - Stock Control
Viewed 1500 times since Tue, Jun 19, 2012
Entering Stock Transactions - Batch Tracking
Viewed 1493 times since Tue, Jun 19, 2012