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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / RM Year End Procedure ...
Microsoft Dynamics GP (Archived)

RM Year End Procedure after posting invoices/pyaments in the New Year

(0) ShareShare
ReportReport
Posted on by FRANCIS 295

I have a client who had not run the Year end process  for RM for the Year 2009. In fact they also did not ran the Year End process for all other modules. However they have posted numerous transactions in the Year 2010. Now that I took over their support and would like to bring things under control. I want to run RM Year End process, but when I ran it over a test database all up to date sales amount, Cost, Payments considered as last Year sales.

 

Any thoughts/inputs are apreciated.

 

Francis

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi Francis--

    There really is not a good solution.  If they are on V9 or later, then you can rely on the Fiscal and Calendar Year summaries instead of the amounts since last closed numbers.  The specific fields impacted are described in the receivables year end article in the KnowledgeBase on CustomerSource/PartnerSource (let me know if you need guidance in locating the document...but if you search receivables year end it should come up).

    RM year end is not date sensitive and will close all posted activity to the prior year for the purposes of those summary fields.  It does not impact transaction detail, though. 

     Take care,

    Christina

  • Sagi88 Profile Picture
    Sagi88 2,250 on at

    Hi Francis.

    If this is important data for the account it is possible to rebuild these amounts using the period activity files.

    For example in Sales - the cumulative file is the RM00103 and the period history file is RM00104.

    If you are comfortable with sql scripts you can reset the values of the RM00103 file with those of the RM00104

    Hope this helps

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    Francis,

    In both RM and PM, you can manually update Year-to-Date, Last Year, and Life-to-Date summary information for customers and vendors in the Summary cards.  Assuming you have the correct year-end values, you could use these windows to update or update them via SQL script directly in the tables. 

  • FRANCIS Profile Picture
    FRANCIS 295 on at

     thanks

    Can anyone share those scripts for AR, PM, IV

     regards

     Francis

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans