0

Return Multiple lines of comments

Hello,

I am trying to build an accounts receivable aging and all is ok except that only one comment per sales invoice is currently being returned.

Here are the codes I have been using:

Links:

=NL("Link","Customer",,"No.","=Customer No.") =NL("Link","Detailed Cust. Ledg. Entry",,"Cust. Ledger Entry No.","=Entry No.","Filters=",$C$12:$D$12) =NL("Link","Sales Comment Line",,"No.","=Document No.") Fields:

Entry No. Customer No. LinkField([Customer],[Name]) LinkField([Customer],[Credit Limit (LCY)]) LinkField([Customer],[Phone No.]) LinkField([Customer],[Contact]) LinkField([Customer],[Customer Posting Group]) LinkField([Customer],[Statistics Group]) LinkField([Customer],[Payment Terms Code]) Due Date Document Type Document No. External Document No. Description Posting Date Currency Code LinkSum([Detailed Cust. Ledg. Entry],[Amount (LCY)]) LinkSum([Detailed Cust. Ledg. Entry],[Amount (LCY)],[Initial Entry Due Date],[..42502]) LinkSum([Detailed Cust. Ledg. Entry],[Amount (LCY)],[Initial Entry Due Date],[05/13/2016..]) LinkSum([Detailed Cust. Ledg. Entry],[Amount (LCY)],[Initial Entry Due Date],[42473..42502]) LinkSum([Detailed Cust. Ledg. Entry],[Amount (LCY)],[Initial Entry Due Date],[42443..42472]) LinkSum([Detailed Cust. Ledg. Entry],[Amount (LCY)],[Initial Entry Due Date],[42413..42442]) LinkSum([Detailed Cust. Ledg. Entry],[Amount (LCY)],[Initial Entry Due Date],[42383..42412]) LinkSum([Detailed Cust. Ledg. Entry],[Amount (LCY)],[Initial Entry Due Date],[..42382]) LinkField([Sales Comment Line],[Comment]
Table: =NL("Table","Cust. Ledger Entry",$E$31:$AC$31,"Headers=",$E$30:$AC$30,"TableName=","CustLedgerEntry","Filters=",$C$9:$D$10,"InclusiveLink=",$E$29,"InclusiveLink=Cust. Ledger Entry",$F$29,"IncludeDuplicates=","True","InclusiveLink=Cust. Ledger Entry",$AC$29)
IncludeDuplicates=","True" is supposed to return unique values however for the sales comment it only returns the first one and not however many lines of comments the sales invoice has.

Any guidance will be greatly appreciated.

Thanks,

Yameen.

0 comments

Please sign in to leave a comment.