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
View Current Period Dates - Stock Control
Viewed 1451 times since Mon, Jun 18, 2012
Marking a Stock Item as Batch/Serial Tracked - Batch Tracking
Viewed 2158 times since Tue, Jun 19, 2012
Matrix Enquiry - Batch Tracking
Viewed 1416 times since Tue, Jun 19, 2012
Batch Optional 2 - Batch Tracking
Viewed 1350 times since Wed, Jun 20, 2012
Record Bin Locations on Batch or Serial Items
Viewed 2115 times since Mon, May 16, 2016
Controls and Audit Manager - Batch Tracking
Viewed 1362 times since Tue, Jun 19, 2012
Period / Year End Facilities - Stock Control
Viewed 1525 times since Tue, Jun 19, 2012
Assemblies - Bulk Stock Items
Viewed 1707 times since Fri, Jun 8, 2012
Order Entry - Batch Tracking
Viewed 1705 times since Tue, Jun 19, 2012
Assemblies - Omit Component from Build
Viewed 1584 times since Fri, Jun 8, 2012