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 Valuation by Batch / Serial
Viewed 3663 times since Fri, Jun 8, 2012
Location Maintenance - Stock Control
Viewed 1665 times since Mon, Jun 18, 2012
Period End - Stock Control
Viewed 2136 times since Mon, Jun 18, 2012
Assemblies and Parts Explosion
Viewed 1528 times since Mon, Jun 18, 2012
Application Screen Layouts - Stock Control
Viewed 1564 times since Tue, Jun 19, 2012
Order Acknowledgement - Batch Tracking
Viewed 1572 times since Tue, Jun 19, 2012
Document Design Manager - Parameters - Stock Control
Viewed 1698 times since Tue, Jun 19, 2012
Replicate a Stock Record - Stock Control
Viewed 1506 times since Mon, Jun 18, 2012
Audit Pointers: Batch to Stock & Audit Pointers: Batch to Transactions - Batch Tracking
Viewed 1610 times since Tue, Jun 19, 2012
Stock Issues - Batch Tracking
Viewed 1465 times since Tue, Jun 19, 2012