Report development on C/al Code

MOSAHEBMOSAHEB Member Posts: 6
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
SLE.png 22.1K

Comments

  • evandeveerdonkevandeveerdonk Member Posts: 49
    Hi Mosaheb,

    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
    http://www.vssolutions NAV-Outlook synchronisation re-invented.
Sign In or Register to comment.