0

NL Sum to be filtered based on the value from other table

=-NL("Sum","Detailed GST Ledger Entry","GST Base Amount","Posting Date",$E$3,"GST %",G25,,,"GST Component Code","IGST","Location Reg. No.",$F$4,"Transaction Type","Sales","Document Type","Invoice","Link=","Customer","No.","=Source No.","GST Customer Type",F25)

I have GST Customer Type in Detailed GST ledger Entries also but some are wrong, which can't be amended, hence I want to use the same field from customer card which has the correct GST Customer Type.

The above formula is not working,  is it possible to apply the filter based on value from other table for NL sum function ?

Please help 

 

4 comments

Please sign in to leave a comment.