Announcements
Hello. We're having trouble with a smartlist providing accurate information.
We're running a report for quarterly sales for new customers only, and we have a few questions.
1. Is there a way to search for the first "invoice" date of any customer, whether they're a brand new customer, or if they've been set up from before? So, we'd like to have a first invoice date between 1/1/20 - 3/31/20? Not just an invoice date, but the first invoice date.
2. We've run a smartlist for customers with "created date from customer master", and the created date for the customer is wrong. As an example, I've created a new customer card in January 2020, and the smartlist created date shows March 2019.
I hope this helps and looking forward to your replies.
Hi AC,
You can use a SQL query or create a smartlist to look at the FRSTINDT field from the RM00103 table, that should have the First Invoice date. I hope that works for you.
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156