Options

Report 116 (Statement) only bigger than 0

julkifli33julkifli33 Member Posts: 1,078
hi all
do you know how to filter Report 116 Statement
i want to show only Remaining Amount > 0
thanks

Comments

  • Options
    mohana_cse06mohana_cse06 Member Posts: 5,504
    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
  • Options
    julkifli33julkifli33 Member Posts: 1,078
    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)
  • Options
    julkifli33julkifli33 Member Posts: 1,078
    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?
  • Options
    mohana_cse06mohana_cse06 Member Posts: 5,504
    julkifli33 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
Sign In or Register to comment.