Avatar
Isidro
Participante
Isidro

El campo «Saldo» de la tabla Cliente realiza el siguiente cálculo:

 

Sum(«Detailed Cust. Ledg. Entry».Amount
WHERE (Customer No.=FIELD(No.),
Initial Entry Global Dim. 1=FIELD(Global Dimension 1 Filter),
Initial Entry Global Dim. 2=FIELD(Global Dimension 2 Filter),
Currency Code=FIELD(Currency Filter),
Excluded from calculation=CONST(No)))

 

Saludos.

#14189