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

Community site session details

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

Credit & Collections - Periodic Tasks - Update Financials Not Working

(1) ShareShare
ReportReport
Posted on by 286
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)
  • CA Neeraj Kumar Profile Picture
    1,326 on at
    Credit & Collections - Periodic Tasks - Update Financials Not Working
     
    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
  • PaladinSteve Profile Picture
    286 on at
    Credit & Collections - Periodic Tasks - Update Financials Not Working
    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.
  • Verified answer
    CA Neeraj Kumar Profile Picture
    1,326 on at
    Credit & Collections - Periodic Tasks - Update Financials Not Working
     
    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
     
  • Sohaib Cheema Profile Picture
    48,117 User Group Leader on at
    Credit & Collections - Periodic Tasks - Update Financials Not Working
    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. 

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

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

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 886 User Group Leader

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 870 Super User 2025 Season 2

#3
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 697

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans