Jet 7.12
Navision Sql 4
I need to filter on only the vendor ledger entry table for Vednors and invoices with a remaining balance not 0 from Vendor with largest balance to smallest . Filter appears to work but report literally hangs system
I've tried this without the Sum filter but using posting Date as a filter in the detail I get Vendors with 0 balance . Using date filter I get invoices that were posted in one month paid in the next and I need only Vendors and Invoices with outstanding balance.
While this is essentially an Aged Payables report it will eventually be run by division and branch
Date
Votes
1 comment
-
Jet Reports Historic Posts I don't immidiatly see why it wouldn't work, but you can always use the easyier (and prob faster) filter on the "Vendor" table.
The balance field is there:=NL("filter";"Vendor";"No.";"-Balance (LCY)";">0")
Is this correct or am I missing something?
Please sign in to leave a comment.