Hi Guys
I have a situation in WEBI, I have a field with a date and #, the date is allocated to a GRV Date (Posting Date) and the # is allocated to the document date. So when an article ordered, the order qty column corresponds to the document date, but it duplicates the product line as soon as the product is received. I would like everything to be in one line, I need to create a variable to ignore the "#"but I am not too sure how to do this.
Any Advise Please?
I have a situation in WEBI, I have a field with a date and #, the date is allocated to a GRV Date (Posting Date) and the # is allocated to the document date. So when an article ordered, the order qty column corresponds to the document date, but it duplicates the product line as soon as the product is received. I would like everything to be in one line, I need to create a variable to ignore the "#"but I am not too sure how to do this.
Any Advise Please?