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

      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,