950
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. Hence, I only want the Order NO where Customer Group Code = GARANTIE and to add the qty where Type = Resource
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
*This post is locked for comments
Try with If statement like
If Type = Resource Then variableQuantity += respectivetable.Quantity;
Thanks Mahesh, but if I do a SETRANGE("Customer Group Code",'GARANTIE') Then I will not get the Type:Resource because for such record the Customer Group Code is blank.
In fact, the common element between Type: Resource and Customer Group Code= GARANTIE is the ORDER NO
Hi
You may write the code:-
respectivetable.RESET;
respectivetable.SETRANGE("Customer Group Code",'GARANTIE');
respectivetable.SETRANGE(Type,respectivetable.Type::Resource);
IF respectivetable.FINDSET THEN REPEAT
variableQuantity += respectivetable.Quantity;
UNTIL respectivetable.NEXT = 0;
Otherwise if you have a key containing above fields, you may write as below (you may avoid the repeat statement):
respectivetable.RESET;
respectivetable.SETCURRENTKEY("Customer Group Code",Type);
respectivetable.SETRANGE("Customer Group Code",'GARANTIE');
respectivetable.SETRANGE(Type,respectivetable.Type::Resource);
respectivetable.CALCSUMS(Quantity);
variableQuantity := respectivetable.Quantity;
Hi
Type :: Resource - If customer Group code is blank in all the records then you will not get any records to add, the sum will be always zero, isn't it, or can you provide us details
Regards
Rajasekhar.Y
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (