1 Reply Latest reply: May 17, 2016 12:20 PM by Stefan Wühl RSS

    Apply current value to historic values

    Bart Sleegers

      Hi all,

       

      See attached file. In Microsoft NAV there is a table that logs the changing of articles in table: "Item substitution".

       

      The current value of a specific item = '55555', but as you can see this item number changed a several times.

      What I want to do is to apply the current value of the item (55555) to all historic values to use for example in de orderline history.

       

      In this way I can get the total amount of turnover of the item including all mutations with other item numbers from the past, because the item number was differtent in the past.

       

      I think I have to solve this problem with a mapping load and then off course apply this mapping in the facttable.

       

      Has anyone an idea how to make this mapping load?

       

      Thxs!

       

       

      Bart Sleegers