Use this function to view all the stock lines of a given product on a site.

For further information on the creation of stock lines in Sage X3, see the Stock lines documentation.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

Header

Enter the main selection criteria.

You can choose to display only part of the defined stock using the following filters:

  • Internal stock
  • BP stock
  • Stock awaiting putaway
  • Loaned stock
  • Subcontract stock

To access additional selection criteria, click Criteria from the Actions panel.

Selections

Site (field FCY)

Renseignez obligatoirement le site. Il est initialisé par défaut avec le site associé à votre profil fonction.
Warehouse (field WRH)
Product (field ITMREF)

Enter the reference of the product for which the stock needs to be inquired.

After entering the lot code, the product reference can be populated automatically if only one single product is linked to the specified lot code.
Lot (field LOTSEL)

Reference of the lot number to be processed.

Entering the lot is optional. When there is only one product for the specified lot number, you can directly enter the lot number to automatically populate the associated product code.
If there is not any specified lot, the inquiry impacts all the lots of the product/site selection. For products managed with optional lots, select the Blank lot check box to filter stock lines with an empty lot number.
Blank lot (field LOTBLK)

Select this check box to select stock lines with an empty lot number.

Major version (field ECCVALMAJ)
License plate number (field LPNNUM)

This field is subject to theLPN - License plate no. management activity code.
Enter a license plate number if you want to limit the inquiry to the products associated with a given license plate number.
Starting serial number (field SERNUMSTR)

This is the product serial number.

Ending serial number (field SERNUMEND)

Block number 2

Stock internal (field LOCCAT001)

Select this check box to take internal locations into account.
BP stock (field LOCCAT005)
Stock pending put-away (field LOCCAT002)

Select this check box to take into account locations awaiting put-away.
Loan stock (field LOCCAT003)

Select this check box to take customer locations into account.
Subcon. stock (field LOCCAT004)

Select this check box to take subcontract locations into account.

Block number 3

Sort order (field SRTCOD)

Select the classification criteria for the display of the returned lines.
Total (field CUMFLG)

Select 'Yes' to display the total available stock at the bottom of the page.

Tab Detailed Stock

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 line / lot / sub-lot / major version/ serial number / location / licence plate number / 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.

One stock line is displayed in red and italics to indicate the line is desynchronized, i.e. the quantity on this line is different from the number of recorded serial numbers. This can occur when the serial numbers of products are set to Global receipt & issue. In this case, as long as no Resynchronization processing has been run on this line, no stock count can be performed in Global processing: the stock count list is not created. Only a non-global processing can be run: the list is created but the desynchronized stock lines are ignored.

Grid

Site (field STOFCY)
Lot (field LOT)
Sublot (field SLO)
Major version (field ECCVALMAJ)
Serial number (field SERNUM)
Warehouse (field WRH)
Location (field LOC)
License plate number (field LPNNUM)
Loc. cat. (field LOCCAT)
Count in progress (field CUNLOKFLG)
Unit (field PCU)
Quantity (field QTYPCU)
PAC-STK conv. (field PCUSTUCOE)
STK (field STU)
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)
Chronological stock (field STOCOU)
Stock transactions

Click this action to access the inquiry of stock movements for the selected product.
Detailed Allocated

Click this action to access the inquiry of detailed allocations for the selected product.
In-transit Stock

Click this action 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

Click this action to access to the transferred stock inquiry, that is to say the stock for the selected product that is about to leave the selected site.
Stock by Lot
Traceability
Serial Numbers

This action is useful for products which serial numbers are managed in Global receipt/issue.
In this case, one line can indeed correspond to multiple serial numbers. Click this action to display the list of serial numbers of the stock line.

SEEINFO This information is updated in real-time. The serial numbers that were associated with this stock line but that have been issued are not displayed in this window.

Specific Actions

Criteria

Click this action to access the additional selection criteria with respect to the criteria entered on the inquiry header.

Ranking: select the order in which the stock lines are presented:

  • By lot number
  • By location code
  • In the alphabetic order of statuses
  • By unit.

Serial number aggregation: this check box is useful for products which serial numbers are managed in Receipt/issue. In this case, each serial number makes up a stock line. If you select this check box, the inquiry presents aggregated stock lines for the serial numbers in order to reduce the volume of lines displayed.

Screen code: as a rule, inquiries can be set up. You can call customized inquiry screens using the screen code. You can use this customization to choose which piece of information you want to display on the screen and in what order it should be positioned in the grid.
For further information, see the documentation on Inquiry screens.

You can save one or many sets of criteria by recording Memo codes that can be called later on by clicking Call memo or deleted by clicking Delete memo.

Stock by Unit

Click this action to access the stock by unit inquiry: this inquiry presents by stock status or all statuses together, the stock report in stock units and packing units.

Stock by Status

Click this action to access the stock by status inquiry. 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