Hello all,
My GI for Purchase receipts is currently doubling the Qty and the Amount. I am unsure how to correct that issue. Attached is the GI in questions. Any feedback would be helpful.
Thankyou
Hello all,
My GI for Purchase receipts is currently doubling the Qty and the Amount. I am unsure how to correct that issue. Attached is the GI in questions. Any feedback would be helpful.
Thankyou
Hi
I tried to change to Inner join but same. But have a check with the development team and find the correct tables Joins
HI
I am not seeing the doubling on your GI. Here is what I see:
When I filter total and QTY:
Can you share a screen shot of what you are seeing?
HI
I am not seeing the doubling on your GI. Here is what I see:
When I filter total and QTY:
Can you share a screenshot of what you are seeing?
Hi
Hi
All you need to do is set the Aggregate function to Average or Min/Max. If you dont set anything then when you use the Group By in your GI it will default to Sum. So if you have 1 receipt line you will have the correct valye but if you have 2 receipt lines it will double the values, 3 will triple it etc. So therefore if you use Average it will display correct as if it has 2 lines it will double it an then divide the result by2. You could also use Max or Min as that will take the highest/lowest value,
Hi
All you need to do is set the Aggregate function to Average or Min/Max. If you dont set anything then when you use the Group By in your GI it will default to Sum. So if you have 1 receipt line you will have the correct valye but if you have 2 receipt lines it will double the values, 3 will triple it etc. So therefore if you use Average it will display correct as if it has 2 lines it will double it an then divide the result by2. You could also use Max or Min as that will take the highest/lowest value,
I have noted that this GI has become wildly slow to run. up to 30 seconds for the GI to load at times. Not sure what caused this now..
Yes this does have a performance impact any time you have a Grouping on the GI it will means it has to get the records then group them etc.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.