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.