0

Sum of Amount LCY in Detail Cust ledger Entries with filter

Is it possible to do a sum of the (amount lcy) in the "detailed cust. ledg. entry", with the filtering from another table which is the "cust ledger entry"? I have tried to use the link function however i could not get the correct sum in the Jetreport. Below are my code.

Any assistance would be appreciated.

=NL("Sum","Detailed Cust. Ledg. Entry","Amount ($)",,,,,,,"link=","Cust. Ledger Entry","Entry No.","=Cust. Ledger Entry No.","Currency Code",$J725,"Posting Date",".."&$I$8,"Customer Posting Group",$K$724,"Datasource=","abc","company=",$G$6)

Thanks

0 comments

Please sign in to leave a comment.