Use the trading board

Article • 7/2/2025 • 8 min read

You can view available stock based on lot numbers per location and plan transactions with documents like sales, transfer, production, or assembly orders.

The following procedure outlines how to use the trading board.

  1. Select the Search icon ., enter Trading Board, and then choose the related link.
    The Trading Board page opens.
  2. On the action bar, select Calculate.
    The Trading Board Filter page opens.
  3. Select the following filters as required.
    FilterDescription
    Expand View by Item/LocationSelect how to calculate and arrange trading board entries on the Trading Board page. The available options are:
    • Standard
    • Item No. & Location Code
    • Location Code & Item No.
    By default, the system displays the value set up on the Trading Board Setup page.
    Location>
    Location CodeSelect a location.
    Push List
    Push List CodeSelect the push list code to view items available from the push list. For more information, see Manage the push list.
    Customer Profile>
    Profile No.Enter a profile number. The system filters and displays lot numbers related to the specified profile based on the configured inclusions and exclusions. This field is visible only when the Aptean Profiles extension is installed.
    External FilterSelect the filters based on growers and certification. For more information, see Filter the trading board based on growers and certification.
    LotSelect global lot attribute filters. The global lot attributes are set up on the Advanced Attribute Setup page.
    Date>
    Available FromSelect the availability from date. The lots which are expected in the selected date range will be displayed on the Trading Board page. Additionally, the lots that are received in inventory and do not have availability date are always shown.
    Available ToSelect the availability to date. The lots which are expected in the selected date range will be displayed on the Trading Board page. Additionally, the lots that are received in inventory and do not have availability date are always shown.
    Lot AttributeSelect the lot attribute filters.
    Trading Unit of Measure>
    Trading Unit of MeasureSelect a trading unit of measure: Base Unit of Measure, Purchase Unit of Measure, or Sales Unit of Measure. For more information, see Filter the trading board based on growers and certification.
    Filter: ItemSelect item-related filters. Additionally, you can add filters as necessary.
    Filter: Lot No. InformationSelect lot number related filters. Additionally, you can add filters as necessary.


The system displays the Last used options and filters option in the Use default values from field by default, specifying that the system applies previously used options and filters to the Trading Board Filter page.

  1. Select OK.
    The trading board entries are displayed on the Entries FastTab of the Trading Board page.
    By default, you can view the following fields in the Simple view.

    FieldDescription
    Item No.Item number of the lot number defined when calculating the trading board.
    DescriptionSpecifies a default text to describe the item.
    Lot No.Specifies the code for the number series that will be used to assign numbers to the lot number of the available inventory.
    Location CodeSpecifies the location code for the displayed quantities.
    Global AttributesGlobal lot attributes 1 to 8 with their corresponding values.
    Availability DateSpecifies the date when the lot number is available.
    Available Quantity (Base)Specifies the quantity available which is to be used in the base unit of measure. This value is calculated as:
    Available Quantity (Base) = {Inventory (Base) + Qty. on Purchase Order (Base) + Qty. on Sales Return Order (Base) + Qty. on Production Order (Base) + Qty. on Assembly Order (Base) + Qty. on Inbound Transfer (Base)} - {Qty. on Sales Order (Base) + Qty. on Prod. Component (Base) + Qty. on Asm. Component (Base) + Qty. on Purchase Return Order (Base) + Qty. on Outbound Transfer (Base)}
    Base Unit of Measure CodeSpecifies the base unit used to measure the item, such as piece, box, or pallet. The base unit of measure also serves as the conversion basis for alternate units of measure.
    QuantityEnter the item quantities you want to assign to the linked document in the trading unit of measure on a lot level. This field value cannot exceed the value on the Available Quantity (Base) field.
    Unit PriceEnter the unit price you want to use in the trading unit of measure on a lot level. This field is editable only when the Pricing Strategy field on the General FastTab of the Trading Board Setup page is set to Manual.
    Description 2Specifies the additional item description of the available inventory.
    Min. Sales PriceSpecifies the minimum sales price of the trading board line displayed in the base unit of measure based on the historic price setup.
    Max. Sales PriceSpecifies the maximum sales price of the trading board line displayed in the base unit of measure based on the historic price setup.
    Avg. Sales PriceSpecifies the average sales price of the trading board line displayed in the base unit of measure based on the historic price setup.
    FrozenIndicates if the price is frozen. It is available only when the extension Aptean Advanced Pricing extension is installed. For more information, see Integration of Trading Board with Aptean Advanced Pricing extension.
    ErrorIndicates if an error occurred when assigning the lot number to a document.For more information, see Error handling in the trading board.
  2. On the action bar, select Advanced view to view the following additional fields:

    FieldDescription
    Available Quantity (Sales)Specifies the quantity available calculated to the sales unit of measure.
    Sales Unit of Measure CodeSpecifies the sales unit of measure code associated with the item.
    Available Quantity (Purchase)Specifies the quantity available calculated to the purchase unit of measure.
    Purchase Unit of Measure CodeSpecifies the purchase unit of measure code associated with the item
    Inventory (Base)Specifies the remaining quantity in inventory in the base unit of measure.
    Qty. on Purchase Order (Base)Specifies the quantity to be received in purchase lines in the base unit of measure for this lot on this location.
    Qty. on Sales Return (Base)Specifies the quantity to be received in sales return lines in the base unit of measure for this lot on this location.
    Qty. on Production Order (Base)Specifies the remaining quantity in Production lines in the base unit of measure for this lot on this location.
    Qty. on Assembly Order (Base)Specifies the remaining quantity in Assembly lines in the base unit of measure for this lot on this location.
    Qty. on Inbound Transfer (Base)Specifies the quantity to be received in transfer lines in the base unit of measure for this lot on this location.
    Qty. on Sales Order (Base)Specifies the quantity to be shipped in sales lines in the base unit of measure for this lot on this location.
    Qty. on Prod. Component (Base)Specifies the remaining quantity in component lines in the base unit of measure for this lot on this location.
    Qty. on Asm. Component (Base)Specifies the remaining quantity in assembly lines in the base unit of measure for this lot on this location.
    Qty. on Purchase Return Order (Base)Specifies the quantity to be shipped in purchase return lines in the base unit of measure for this lot on this location.
    Qty. on Outbound Transfer (Base)Specifies the quantity to be shipped in transfer lines in the base unit ofmeasure for this lot on this location.
    Qty. on Buffer Order (Base)Specifies how many units of an item in a lot are allocated on the tracking lines of the linked buffer order for the specified location, in the base unit of measure of the item.
    Source No.Specifies the Vendor No. for the lot number.
    Source Name.Specifies the Vendor Name for the Vendor No.
    Document No.Specifies the purchase order number.
    Pricing StrategySpecifies the pricing strategy defaulted from Trading Board Setup page. For more information, see Integration of Trading Board with Aptean Advanced Pricing extension.
    Trading Unit of Measure CodeSpecifies the trading unit of measure code in the sales unit associated with the item.
    Error TextSpecifies the error text produced when assigning lot to document line. For more information, see Error handling in the trading board.
    Combine LotsSpecifies whether this trading board line is combined by item number, location code, trading unit of measure code, unit price, and global lot attributes when assigned to an outbound document. The available options are:
    • Uncombine
    • Try to Combine
    For more information, see Set up the trading board. If you set the Pricing Strategy field to Manual or make changes to the Trading Unit of Measure Code field, the system changes the Combine Lots field value of the line to Uncombine.

  • On the Filters FastTab of the Trading Board page, you can edit the filters as required.
  • On the action bar, select Calculate > Recalculate to recalculate the trading board entries based on the filters selected.

You can add entries to the push list and open the push list directly from the trading board. For more information, see Manage the push list from the trading board.

You can link the trading board to existing sales, transfer, production, or assembly orders. For more information, see Link the trading board to existing documents.

Additionally, you can create sales, transfer, production, or assembly orders and link the trading board to the documents created. For more information, see Create and link documents from the trading board.

After linking a document to the trading board, you can enter the Quantity and Unit Price field values and assign the item quantities and unit price entered to the lines of the respective linked document. For more information, see Assign quantities to linked documents.