If think you have to do something like=NL("Rows","Cust. Ledger Entry",,"Entry No.","=IF(NF(,""Closed by Amount"")>(NF(,""Original Amount""),NF(,""Entry No.""),""0"")","Closed by Entry No.",$D$4,"Posting Date",Options!$E$4,"Global Dimension 1 Code",Options!$E$5)
Date
Votes
1 comment
-
Jet Reports Historic Posts I have two jet reports against Navision 4.0 SQL that are beginning to bug me One is by reason code and shows where the entry was used to close an invoice etc - problem is it shows in some cases the closed by amount on the affected document to be greater than the original amount. No big deal the data is what the data is except
Create a second report where I'm trying to get entries where the closed by amount is > original amount and closed by entry is not a payment to verify above and see if there are others I didn't see. Problem is I I get either a value error or returns data that does not match the criteria
This is the code that does not appear to be working correctly
Filter to make sure closing entry is not a payment
=NL("Filter","Cust. Ledger Entry","Entry No.","Document Type","<>Payment","Date Filter",Options!$E$4,"Global Dimension 1 Code", Options!$E$5)
Select all items that match criteria and closed by is in the filter
=NL("Rows","Cust. Ledger Entry",,"Closed by Amount",">(NF(,""Original Amount"")","Closed by Entry No.",$D$4,"Posting Date",Options!$E$4,"Global Dimension 1 Code",Options!$E$5)
Attached are the two reports
Please sign in to leave a comment.