6 Replies Latest reply: Mar 13, 2015 8:25 AM by Marcel Artz RSS

    CHALLENGE! How to keep track of stock per lot without lot :-)

    Marcel Artz

      Dear all,

       

      I have a very cool challenge which is easy to work out in Excel but (for me) really difficult in QV. Please find attached Excel file for Input & requested Output (= Stock). The Stock column is the expected outcome per day based on the records from the Input.

       

      The challenge is to keep track of a LotNr once there are multiple LotNrs on an item location. Based on First/Last In First Out (FIFO/LIFO) the Stock is tracked.

       

      Description may be a bit vague but once you see the Excel it will make sense (or please ask me and I will explain in further detail).

       

      Hope one of you can help me on the way...

       

      Best regards,

      Marcel