Show / Hide Table of Contents

    Example - Inventory Order Line with Tracking Lines

    The physical inventory order line should contain the following data:

    • Item No.: 80216-V
    • Location Code: BLUE
    • The fields Variant Code and Bin Code may be blank.

    There is a check mark in the field Use Tracking Lines on the physical inventory order line and the item 80216-V should be posted all time with lot nos. according to the item tracking code.

    The posting date on the physical inventory order header should be 12/31/2002.

    The expected quantity of the item 80216-V at the location BLUE on 12/31/2001 should be 120 pieces.

    The quantity on stock consists of the following lots:

    The expected Item Tracking Lines:

    Lot No. Quantity
    CH1001 80
    CH1003 30
    CH1006 10
    Total 120

    There had been recorded the following physical inventory recording lines for the item 80216-V, location code BLUE:

    Recorded Lot Nos. on the Physical Inventory Recording Lines:

    Lot No. Quantity
    CH1001 80
    CH1002 12
    CH1003 20
    Total 112

    When finishing the physical inventory order the program will calculate for the item 80216-V at the location BLUE a negative adjustment of 8 pieces and will create the following entries:

    Item Tracking lines to post:

    Lot No. Expected Quantity Recorded Quantity Quantity to post
    CH1001 80 80 0
    CH1002 0 12 + 12
    CH1003 30 20 - 10
    CH1006 10 0 - 10
    Total 120 112 - 8

    See Also

    Physical Inventory Order Lines With Item Tracking Lines
    Work with Serial and Lot Numbers

    Back to top Copyright © 2019 IndustryBuilt
    JustFood Fall 2018