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?





      Bart Sleegers