LOOKUP function with a version module
I am facing a situation that seems weird to me. In a module, I want to repatriate the value of a forecast made last month. So I create a line item that uses the LOOKUP function :
previous Fcst = Fcst Qty[LOOKUP: Param Version.Previous Version], Param Version is a system module that manages versions.
It seems to work. The value is: previous Fcst = 200 (it is a dummy value, but it is to make the situation more readable)
I play with the module and I change the value of the current forecast : 100
Then I create a new line item identical to the previous one: previous Fcst #2= Fcst Qty[LOOKUP: Param Version.Previous Version]
The values are :
previous Fcst = 200
previous Fcst #2 = 100
Both values should be 200 and the creation order seems to be involved in the situation.
Finally, I create an intermediate line item : PREVIOUS VERSION = Param Version.Previous Version and update the two line items:
previous Fcst = Fcst Qty[LOOKUP: PREVIOUS VERSION] = 200
previous Fcst #2 = Fcst Qty[LOOKUP: PREVIOUS VERSION] = 200
This seems to work with an intermediate line item
Can you help me to understand this situation?