Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Customer History - Created date from customer master in incorrect

(0) ShareShare
ReportReport
Posted on by 25

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. 

Categories:
  • Suggested answer
    Shannon Aune Profile Picture
    Shannon Aune on at
    RE: Customer History - Created date from customer master in incorrect

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans