Report 116 (Statement) only bigger than 0

julkifli33

hi all
do you know how to filter Report 116 Statement
i want to show only Remaining Amount > 0
thanks

mohana_cse06

Either you have to show Remaining Amount filter of Cust. Ledger Entry while running report by giving it on ReqFilterFields of Cust. Ledger Entry dataitem
or if you want it everytime simply set it on DataItemTableView property

julkifli33

mohana_cse06 wrote:

Either you have to show Remaining Amount filter of Cust. Ledger Entry while running report by giving it on ReqFilterFields of Cust. Ledger Entry dataitem
or if you want it everytime simply set it on DataItemTableView property

i can't
I already tested it....
this Remaining Amount is not the field in Cust Ledger Entry table
but this one is Global Variable (Decimal)

julkifli33

another question ....
for statement....
is it showing all the transaction?
or only for the transaction still open?
i thought it should be only the open one... is it?

mohana_cse06

julkifli33 wrote:

mohana_cse06 wrote:

Either you have to show Remaining Amount filter of Cust. Ledger Entry while running report by giving it on ReqFilterFields of Cust. Ledger Entry dataitem
or if you want it everytime simply set it on DataItemTableView property

i can't
I already tested it....
this Remaining Amount is not the field in Cust Ledger Entry table
but this one is Global Variable (Decimal)

Which version you are using?
I can see Remaining Amount field in Cust. Ledger Entry table(Field no. 13) in NAV 2009SP1