Problem with sum of Flowfield

Nizar
Nizar Member Posts: 61
edited 2006-06-05 in NAV/Navision Classic Client
Hello,

When i use the fonction Calcsum to sum field which FieldClass is flowfield,
an error occured that i can't use this fonction with Flowfield
Can you help me.

Thanks.

Comments

  • sgg
    sgg Member Posts: 109
    ********************************************************
    *** C/SIDE Reference Guide ***

    CALCSUMS
    Use this function to calculate the total of a column of SumIndexFields in a C/SIDE table. Using parameters, you can tell the system exactly which fields to calculate.

    [Ok :=] Record.CALCSUMS (Field1, [Field2],...)
    Ok

    Data type: boolean

    If you omit this optional return value and if one of the fields is not a SumIndexField, a run-time error occurs. If you include a return value, the system assumes you will handle any errors.

    ***********************************************************

    Since FlowFields are NOT allowed as SumIndexFields, you May not use FlowFields in CalcSums Function.
    Sunday, Godwin G
  • DenSter
    DenSter Member Posts: 8,307
    Say you have a ledger table, and you have a Quantity SumIndexField. Then in a Master table, you have a flowfield into this ledger table that totals the quantity linked to the record in the master table.

    If you want to calculate the flowfield you use CALCFIELDS. You use CALCSUMS if you want to sum up the quantity in the ledger table itself in C/AL code.
    Daniel Rimmelzwaan
    RIS Plus, LLC

Categories