Stock >  Inquiries >  Stock >  Detailed stock  

Display all Hide all

The purpose of this function is to display all the stock lines of a product at a site (see the documentation Stock Lines that explains the structure of the stock lines in Sage X3).

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

Header

Presentation

The header information is used to specify the main selection criteria for the inquiry used.

Site: it is mandatory to enter a site.

Product: the Product code is mandatory. It can be entered or loaded automatically after lot code entry. However, the Product code entry remains mandatory if there are multiple products for the entered lot code.

Lot: it is possible to request an inquiry by lot (a contextual help on lot selection is available on this field). If no lot is specified, the inquiry displays the stock status for all the lots for the product / site selection. When only one product exists for the lot number specified, it is possible to enter the lot number so as to automatically load the associated Product code.

It is possible to only display part of the stock as well as the ability to define Internal stock / Stock waiting put-away / Loaned stock / sub-contract stock filters. 

 

Close

 

Fields

The following fields are present on this tab :

Selections

Enter or select a storage site at which the selected product is active.

The Selection icon (magnifying glass) only suggests products that are referenced in the products-sites table.

 

Enter the reference of the product for which the stock needs to be inquired.
  • Lot (field LOTSEL)

Reference of the lot number to be processed.
  • Major version (field ECCVALMAJ)

 
  • Starting serial number (field SERNUMSTR)

This is the product serial number.

  • Ending serial number (field SERNUMEND)

 

Block number 2

  • Stock internal (field LOCCAT001)

Takes into account the internal locations.
  • BP stock (field LOCCAT005)

 
  • Stock pending put-away (field LOCCAT002)

Takes into account the locations pending put-away.
  • Loan stock (field LOCCAT003)

Takes into account the customer locations.
  • Subcon. stock (field LOCCAT004)

Takes into account the sub-contracting locations.

Block number 3

  • Sort order (field SRTCOD)

Sorting criteria for the list or the inquiry.
  • Total (field CUMFLG)

This checkbox must be ticked to display to cumulated total at the bottom of the page.

Close

 

Tab Detailed Stock

Presentation

The columns present in this table depend on the setup of the chosen screen code.

By default the table reproduces for the chosen product, all the stock lines found for the product by specifying:

The stock quantity by lot / sub-lot / major version/ serial number / location / warehouse / status.

*The line status

*The sum of allocated quantities

*The entry number that created the line

A final summary line presents the total physical stock for the chosen selection.

 

Close

 

Fields

The following fields are present on this tab :

Grid

 
  • Lot (field LOT)

 
  • Sublot (field SLO)

 
  • Major version (field ECCVALMAJ)

 
  • Serial number (field SERNUM)

 

 
  • Location (field LOC)

 
  • Loc. cat. (field LOCCAT)

 
  • Count in progress (field CUNLOKFLG)

 

 
  • Quantity (field QTYPCU)

 
  • PAC-STK conv. (field PCUSTUCOE)

 

 
  • STK quantity (field QTYSTU)

 
  • Stock status (field STA)

 
  • Active quantity (field QTYSTUACT)

 
  • Potency (field POT)

 
  • IU potency (field ACT)

 
  • Total allocated (field CUMALLQTY)

 
  • Last receipt (field LASRCPDAT)

 
  • Last issue date (field LASISSDAT)

 
  • Identifier 1 (field PALNUM)

 
  • Identifier 2 (field CTRNUM)

 
  • Custom field 1 (field STOFLD1)

 
  • Custom field 2 (field STOFLD2)

 
  • Supplier lot (field BPSLOT)

 
  • Analysis request (field QLYCTLDEM)

 
  • Owner (field OWNER)

 
  • Expiration (field SHLDAT)

 
  • UBD (field DLUDAT)

 
  • Recontrol (field NEWLTIDAT)

 

Close

 

Action icon

Stock Transactions

 This button is used to access the stock movements inquiry for the selected product.

Detailed Allocated

This button is used to access the detailed stock allocations inquiry for the selected product.

In-transit Stock

This button is used to access to the stock in transit inquiry, that is to say the stock for the selected product that is going to the site selected.

Transferred Stock

 This button is used to access to the stock transferred inquiry, that is to say the stock for the selected product that is about to leave the selected site.

Stock by Lot
Traceability

 

Close

 

Specific Buttons

This button is used to access the additional selection criteria with respect to the criteria entered in the inquiry header.

Classification: it is possible to choose the order in which the stock lines are presented according to several criteria 

*By lot number

*By location code

*In the alphabetic order of statuses

*By unit.

Serial number aggregation: each serial number corresponds to a stock line. When this box is checked, the inquiry displays the aggregated stock lines linked to the serial numbers in order to reduce the amount of inquired lines.

Screen code: the inquiries can be set up in a general manner (for more detail, see the Inquiry screens documentation). It is possible to call upon customized inquiry screens via the screen code. This customization is used notably, to choose what information should be shown on the screen and in what order it should be positioned in the grid.

It is possible to save one or several sets of criteria by recording [Memo] codes that can be called later on [Call memo] button or deleted [Delete memo] button.

This inquiry presents by stock status or all statuses taken together, the stock report in stock units and packing units.

This inquiry presents the stock report broken down by stock status and sub-status. 

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation