Hi,
Refer to the attach pic and I want to have the sum of column 'Quantity' where Type = Resource and for Order No where Customer Group Code = GARANTIE
Please note that where type = Resource, Customer Group Code is blank.
Any idea how to do the above in C/AL CODE?
Thanks for your response
0
Comments
there are 2 scenarios:
1. You find the reason why it does not enter the CGC in case of Type=Resource, and you fix that.
(You also need to update all existing records of course)
2. You use a repeat..Until loop + a variable_Dec that loops over all records.
In this loop, you need to identify for each record if it meets the criterium: CGC = GARANTIE.
Let me know if you need more help on this
Ernst