Use this inquiry to search records in the Stock journal (STOJOU) and Stock FIFO cost (STOCOST) tables to identify discrepancies. You can look at a specific receipt date for a product to see what is in each table.

The results pull all the receipts and the stock quantities on that receipt date and the movements for that product. The results also show the progression of each cost tier on a specific date grouped by cost tier.

You can customize the results grid to highlight any field in a different color. Click Criteria from the Action panel and enter a formula to color code results. For example, if a field is currently highlighted, you can remove the formula or enter a new formula to change the existing color code on the field.

For example, to display a red background for negative values in the Stock after field (AFTSTO), the formula would be:

[M:SML2]AFTSTO(nolign-1)<0

Prerequisites

See also Refer to documentation Implementation

Screen management

Header

Selection

Site (field FCY)

Enter or select a stock site for the inquiry.
Currency (field CUR)

This field displays the currency based on the site and cannot be modified.
Receipt date (field REFDAT)

Enter a receipt date. This date is mandatory and only cost tiers received on this day are displayed.
Product (field ITMREF)

Enter or select a product with lot management selected in the product record. There must a product-site record for that product and site combination.
Sort order (field SRTCOD)

Select the sort order for the inquiry results. You can sort ascending or descending by allocation date or by date created:

  • Allocation date (-)
  • Allocation date (+)
  • Date created (-)
  • Date created (+)

Tab Movements/Products

The grid on this tab displays the search results based on records in the STOJOU and STOCOST tables and cannot be modified. All transactions for the cost tier on the selected receipt date display. Columns with no value do not display.

Grid

Allocation (field IPTDAT)

This field displays information based on data in the Stock journal (STOJOU) and Stock FIFO cost (STOCOST) tables and cannot be modified.

If this date is different from the creation date, it is highlighted in yellow.
FIFO date (field CSTDAT)

This field displays the FIFO date and cannot be modified.
FIFO time (field CSTTIM)

This field displays the FIFO time and cannot be modified.
STK quantity (field QTYSTU)

This field displays information based on data in the Stock journal (STOJOU) and Stock FIFO cost (STOCOST) tables and cannot be modified.
STK (field STU)
Active quantity (field ACTQTY)
Order amount (field AMTORD)
Movement value (field AMTVAL)
Order variance (field VARORD)
Status (field STA)
Movement variance (field VARVAL)
Stock before (field BEFSTO)

This field calculates the quantity based on values before the current record.
Stock after (field AFTSTO)

This field calculates the quantity based on values after the current record.
Amount base before (field BEFAMT)

This field calculates the amount based on values before the current record.
Amount base after (field AFTAMT)

This field calculates the amount based on values after the current record.
Order price (field PRIORD)

This field displays information based on data in the Stock journal (STOJOU) and Stock FIFO cost (STOCOST) tables and cannot be modified.
Valued price (field PRIVAL)
Cost source (field PRINAT)
Variance not absorbed (field AMTDEV)
Warehouse (field WRH)

This field displays information based on data in the Stock journal (STOJOU) and Stock FIFO cost (STOCOST) tables and cannot be modified.

If not relevant, this field is hidden.
Location (field LOC)
Identifier 1 (field PALNUM)
Identifier 2 (field CTRNUM)
Movement type (field TRSTYP)

This field displays information based on data in the Stock journal (STOJOU) and Stock FIFO cost (STOCOST) tables and cannot be modified.
Movement description (field MVTDES)
Project (field PJT)

This field displays information based on data in the Stock journal (STOJOU) and Stock FIFO cost (STOCOST) tables and cannot be modified.

If not relevant, this field is hidden.
Entry type (field VCRTYP)

This field displays information based on data in the Stock journal (STOJOU) and Stock FIFO cost (STOCOST) tables and cannot be modified.
Entry (field VCRNUM)
Line no. (field VCRLIN)
Source document type (field VCRTYPORI)
Original document (field VCRNUMORI)
Source document line (field VCRLINORI)
Potency (field POT)
Stock movement group (field TRSFAM)
Accounting date (field ACCDAT)
Accounting document (field NUMVCR)

This field displays information based on data in the Stock journal (STOJOU) and Stock FIFO cost (STOCOST) tables and cannot be modified.

You can access the accounting document from the Action icon menu at the beginning of the line.
Posted (field PITVALFLG)

This field displays information based on data in the Stock journal (STOJOU) and Stock FIFO cost (STOCOST) tables and cannot be modified.
Entry type (field GTE)
Owner (field OWNER)
Intercompany (field BETCPY)

This field displays whether or not this is an intercompany movement.

This field displays information based on data in the Stock journal (STOJOU) table and cannot be modified.
Creation user (field CREUSR)

This field displays the user who created the stock movement.
Date created (field CREDAT)

This field displays the date the stock movement was created.

This field displays information based on data in the Stock journal (STOJOU) table and cannot be modified.
Time (field CRETIM)

This field displays the time the movement was created.

This field displays information based on data in the Stock journal (STOJOU) table and cannot be modified.
Cost adjustment

Select this option to view various price adjustment details for the movement transaction on the line.

This option is only available if at least one price adjustment exists for the movement transaction.
Accounting document

Select this option to view the accounting document for the movement transaction on the line if it is linked to a journal entry.
Traceability

Select this option to access the stock Traceability inquiry function.
Order price detail

Select this option to view the order price detail for the movement transaction on the line.
Valuation price detail

Select this option to view the valuation price detail for the movement transaction on the line.
Miscellaneous receipts

Select this option to view the Miscellaneous receipts for the movement transaction on the line.
Original document

Select this option to access the original document, which could be a purchase order, sales order, etc.

Specific actions

Select this action to enter additional criteria for the query and customize how results display in the Product/Movements grid.

Selection

Active memo (field MEMO)

This field displays the Memo code if one is being used for the current criteria.
Formula (field SELFOR)

Enter a stock selection formula to narrow your query results.

Movements

Internal (field MISFLG)

Select this check box to include internal stock movements in the query results.

Grid Styles

Formula (field FORASY)

Enter a formula to customize the styles for the Movements/Products grid that displays the query results. You can access the Formula wizard from the Actions icon menu in this field.

For example:

To display a red background for negative values in the Stock after field (AFTSTO), the formula would be:

[M:SML2]AFTSTO(nolign-1)<0

To display an orange background when the Allocation date (IPTDAT) is different from the Creation date, the formula would be:

[M:SML2]IPTDAT(nolign-1)<>[M:SML2]CREDAT(nolign-1)

To display a yellow background for the Average cost after field (AFTPRI) when the variation between two movements exceeds 10 %, the formula would be:

nolign<[M:SML2]NBLIG & [M:SML2]AFTPRI(nolign)<>0 & abs(1-[M:SML2]AFTPRI(nolign-1)/[M:SML2]AFTPRI(nolign))>0.1
Style (field CODSTL)

This field displays the name for the style. You can enter a name when you create a custom formula.
Field code (field CODZON)

This field displays the field code affected by the formula on the line.

Movement status

Update status (field UPDFLG)

Select Updated to include movements that have been updated. This is the default selection.

Select Suspended to include movements waiting to be updated such as those that arise from a material issue in a shortage.

Movements adj.

Movements adj. (field REGFLG)

Select this check box to include movement adjustments in the query. That is, the query displays as many lines as there are moved serial numbers.

Display

Sort order (field SRTCOD)

Select the sort order for the inquiry results. You can sort ascending or descending by allocation date or by date created:

  • Allocation date (-)
  • Allocation date (+)
  • Date created (-)
  • Date created (+)
Screen code (field ECRAN)

If you want to use a custom inquiry screen, enter that code here.