Hi,
I am trying to extract a list from the Customer Ledger Entry table which meet certain filters. One of which is the Detailed Customer Ledger Entry table summed Amount field, at a given posting date, was not nil, even if it is nil now.
I have read a few posts, and have primarily used this page as my guide, but the resulting table is returning an error.
Filters= [note, the ¦ symbol indicates an adjacent cell]
-
Company= ¦ ABC
-
Posting Date ¦ ..31/07/2021
-
Document No. ¦ *SUSPENSE*
My main key is created fine:
=NL("Rows","Cust. Ledger Entry",,"Filters=",$B$5:$C$7,"+Posting Date","*")
But it's the linking to the other Detailed table which is causing me an issue. As advised in the separate page, the Sum is calculated in a different field (I'm using $K$2). Note, unlike the linked post, this needs to Link to another table, so I've done my best to code this.
="=NL(""Sum"",""Detailed Cust. Ledg. Entry"",""Amount"",""Cust. Ledger Entry No."",NF(,""Entry No.""),""Posting Date"",$C$6)"
The key includes this new cell as a filter here:
=NL("Rows","Cust. Ledger Entry",,"Filters=",$B$5:$C$7,"+Posting Date","*","Link=","Detailed Cust. Ledg. Entry","Cust. Ledger Entry No.","=Entry No.",$K$2,"<0")
But when I run the report, I'm warned that I've got an invalid field:
'=NL(_Sum_,_Detailed Cust_ Ledg_ Entry_,_Amount_,_Cust_ Ledger Entry No__,NF(,_Entry No_),_Posting Date_,$C$6)'
Does anybody know what I'm doing wrong, and what would be the correct/best way to link these tables?