Hello,
How is it possible to make a join in the data manager considering a valid period. I have two tables, the value entry and a price list with a valid price for a period with starting and ending date. Now I tried to join the price for every item no to the value entry, but how can I set a join/condition for the valid period of each price?
Thanks
Date
Votes
1 comment
-
Peggy A. Farmer Did you every get an answer to your question above? We have a similar situation are struggling to join price table based on valid period to the customer invoice transaction invoice date.
Any input would be appreciated.
Please sign in to leave a comment.