web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Credit & Collections - Periodic Tasks - Update Financials Not Working

(2) ShareShare
ReportReport
Posted on by 290
Good day,
 
I am attempting to run the Periodic Task in the Credit & Collections module to Update Financials, and I am getting a warning that "The entered date must follow the period code." The dates were prepopulated with a Start Date of the fiscal year start and an End Date of the fiscal year end. Dates are in U.S. m/d/yyyy format. It won't let me move forward with these dates, or any others I've tried.
 
 
I've tried other date combinations, like 8/1/25..8/31/25, 9/1/25..9/18/25 (today), 1/1/25..9/18/25 (calendar YTD) and 8/19/25..9/18/25 (full month). They all give the same error.
 
I've tried to search for a solution, but the only suggestion was to set up Period Codes in the Sales & Marketing Parameters. That may be where the start and end dates defaulted from, as this is what I have set up there: 
 
 
But I don't understand what Sales & Marketing parameters have to do with Financials in Credit & Collections, or how the period codes would need to be set up to get this to work. As far as I can tell, the Period Codes in Sales & Marketing tie to project management and billing. There doesn't seem to be anything in Microsoft's documentation to indicate this is necessary setup for Credit & Collections. Any guidance on what I need to do to resolve this error so I can move forward?
Categories:
I have the same question (0)
  • Sohaib Cheema Profile Picture
    49,664 Super User 2026 Season 1 on at
    It appears that Either your period Id definition (From and To Date) has been changed, since you set this up Or someone has changed these dates on Sales and marketing Parameters form, after period was selected on this form.
    I recommend for manually correcting the from and to date fields, on the Sales and Marketing Parameters (making sure these dates match with the period defined)
     
    Once done, run the Update financials. 
  • Verified answer
    CA Neeraj Kumar Profile Picture
    5,135 Super User 2026 Season 1 on at
     
    If the business requirement is to run update financials with any given from date and to date, you can define a period code with frequency of day, and generate periods..
     
    Then you will have period for all dates and you can select as per the need in "Update Financials" batch job.
     
     
    Then you will have all the date available while running the job:
     
    Regards,
    Neeraj Kumar
     
  • PaladinSteve Profile Picture
    290 on at
    Thank you, Neeraj. I was able to get the process to run successfully in my UAT environment. 
     
    For those like me who wondered what the process does, as far as I can tell, it updates the Customer's General>Statistics>Financials tab with invoice activity by the date period specified. I don't know why it wouldn't work for any period other than "Daily", but with Daily as the Period Code set in the Sales & Marketing Parameters, it returned a total by day of the customer's sales.
     
    You get 3 columns: From Date, To Date and Amount. Using Daily, the From Date and To Date will be the same for each line - a single day.
     
    It doesn't seem to include any payment activity, so it's not useful for In/Out analysis. 

    In all honesty, running it using Daily seems kind of useless. I could see it being more useful to run by Week, Month or Quarter to view summed sales activity by period easily. But Daily is the only Period Code I was able to get to work.
  • CA Neeraj Kumar Profile Picture
    5,135 Super User 2026 Season 1 on at
     
    Yes it makes sense to see such balances for a bigger period other than daily. After looking at data, i believe it starts making sense that why Period code is kept by Microsoft as parameter.
     
    Thank you so much for sharing the knowledge after able to run the process.
     
    Regards,
    Neeraj Kumar

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 699

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 582 Super User 2026 Season 1

#3
Subra Profile Picture

Subra 493

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans