Stock > Inquiries > Movements > FIFO cost movement 

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 afterfield (AFTSTO), the formula would be:

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

    Prerequisites

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    Header

    Fields

    The following fields are present on this tab :

    Selection

    Enter or select a stock site for the inquiry.

    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.

    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 (+)

    Close

     

    Tab Movements/Products

    Presentation

    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.

    Close

     

    Fields

    The following fields are present on this tab :

    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.

     

    • 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)

     

    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)

     

    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)

     

     

    • 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.

     

    • 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.

    Close

     

    Action icon

    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.

     

    Close

     

    Specific actions

    The following fields are included on the window opened through this button :

    Selection

    • Active memo (field MEMO)

    This field displays the Memo code if one is being used for the current criteria.

    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

    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 (+)

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

    Close

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

    Error messages

    The only error messages are the generic ones.

    Tables used

    SEEREFERTTO Refer to documentation Implementation