I would like to compare the Customer No. field in the customer table to the Customer No. field in the Customer Ledger Entry table.
The values are unique in the Customer table, but not unique in the Customer ledger entry table.
I would like to know which customer no.'s are in the Customer ledger entry table, but NOT in the customer table.
Date
Votes
4 comments
-
Jet Reports Historic Posts Give this a try:
=nl("Rows","Cust. Ledger Entry","Customer No.","Link=","Customer","No.","<>Customer No.")
I ran a quick test on Customer not in Sales Header and it seemed Ok. -
Jet Reports Historic Posts That did not work. The values it displayed were in both tables.
-
Jet Reports Historic Posts First off:
What is the purpose of this list?
Are you looking for deleted customers?
This shouldn't be possible, the "customer no" field on the cust le would be empty…
What NAV are you running? Is there any force-fed data in your system?
If it should be possible: the easiest way is to list all unique customers of the ledger table:
=NL("Rows";"Cust. ledger entry";"Customer No.")
with right next to it, refering to the number:
=NL(;"Customer";"No.";"No.";C2)
That way the empty cells will be the ones your looking for (conditional hide can help here).
If you find any, can you let us know how they got in there?
As for markl's suggestion, I can't get it to work… I've never tried a link with an inverse condition… is it possible?
Regards,
Jan -
Jet Reports Historic Posts I think you might try
=NL("Rows",NP("Difference",NL("Filter","Cust. Ledger Entry","Customer No."),NL("Filter","Customer","No."))
Please sign in to leave a comment.