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:
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.
should we decided to add document no. to primary key, we'll encounter duplicate entry no. in our cust. ledger entry in the future..?
Thats why I told you to check the some transactions after adding the document no in primary key.
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(<>''))