Report 116 (Statement) only bigger than 0

julkifli33 · 2011-05-27

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

mohana_cse06 · 2011-05-27

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 · 2011-05-29

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 · 2011-05-29

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 · 2011-05-30

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

Report 116 (Statement) only bigger than 0

Comments

Categories