Hi ,
I need to return a count of all the unique ( don't count the duplicate ) voucher number of a journal in vedor payment journal.
Can you help me with the code??
Hi ,
I need to return a count of all the unique ( don't count the duplicate ) voucher number of a journal in vedor payment journal.
Can you help me with the code??
Just use "group by" to group by voucher and "where" to select only records from the journal required. Here is documentation with examples docs.microsoft.com/.../select-statement-syntax
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,214 Most Valuable Professional
nmaenpaa 101,156