Required Filter Field not working

hi all,

for report 211: Customer - Payment Receipt, required filter field look up not working?! supposingly when user running the report, it will prompt to filter by customer no./ posting date/ document no.

but when i click on the document no., list box for me to select from (FORM Customer Ledger Entries) not appeared !

the standard version are not working too..

i check my customer ledger entry table, there's a LookupFormID - FORM Customer Ledger Entries is being set,

i am able to open up FORM Customer Ledger Entries in object designer..




  • Go to Cust Ledger Entry  Table Design

    On Document No -->Properties --> Table Relation 

    "Cust. Ledger Entry"."Document No." WHERE (Document No.=FILTER(<>''))

    You need to define document no as part of key.

  • In reply to Amol:

    hi amol,

    thanks for replying, and from the system i need to set document no. as a PRIMARY key?

  • In reply to nikeman77:

    You need to add that .

    But check the sales transactions after adding document no in primary key i,.e. Posting of Sale  Invoice.

  • In reply to Amol:

    hi amol,

    should we decided to add document no. to primary key, we'll encounter duplicate entry no. in our cust. ledger entry in the future..?


  • In reply to nikeman77:

    Thats why I told you to check the some transactions after adding  the document no in primary key.

  • In reply to Amol:


    I am facing the same scene but not with forms..Its in a report based on Item ledger entry.

    now when i click on one of my required filter field " Batch No." its throwing error " the following field must be included in the tables primary key".

    In ILE "Entry No. " is the primary Key.

    According to this if i make Batch no. as primary key then it will work but  " I DO NOT WANT TO MAKE IT PRIMARY KEY. table relation can be only possible on primary key. what other options are ? plz suggest..Thanks..

    Table relation i m making in ILE

    "Item Ledger Entry"."Batch No." WHERE (Batch No.=FILTER(<>''))