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) / Receivables Year End C...
Microsoft Dynamics GP (Archived)

Receivables Year End Close (GP 2013 R2)

(0) ShareShare
ReportReport
Posted on by David Layten 1,819

My Client has a Calendar and Fiscal Year End of 12/31. When performing the Year End Close on Receivables this month, she closed the Calendar but not the Fiscal. Therefore the "Amounts Since Last Close" did not Zero out the This Year column and move the amounts to the Last Year Column.

Since this time Receivables information for 2015 has been posted. We have discussed that if she closes the Fiscal Year End now that effectively she will have 13 months in her Last Year Column (since it is almost the end of January.

This companies Sales Staff uses the Navigation Lists for Customers and the data provided in that view shows the Amounts Since Last Close. This information is very important to the sales staff. She does understand that they can get accurate Year to Date and Last Year information in other inquiry windows in GP.

My question is has anyone either started a case with Microsoft or used Microsoft Professional Services to fix the Amounts Since Last Close Buckets in GP. I want to help my customer but have not found any information to be able to assist her on this.

Also, I do not want to start a case with Microsoft Support for them to tell me there is no way to correct this.

Thanks in advance for your help.

*This post is locked for comments

  • Verified answer
    David Layten Profile Picture
    David Layten 1,819 on at
    RE: Receivables Year End Close (GP 2013 R2)

    Bill,

    Thanks for the information. My client wanted me to open a case with Microsoft. Microsoft does have a series of scripts that can update the Customers This Year, Last Year and even Life to Date. (They have them for both Payables and Receivables but I only worked with the Receivables Scripts.)

    We did not update the Life To Date numbers but the other updates did work as expected.

    One important note: The Fiscal Year End Close not only closes Customer Balances but also updates the Salesperson and Sales Territories "This Year" and "Last Year" in their cards. Microsoft's suggestion to update these figures manually.

    I did write scripts to update to update that data from their associated Summary Tables (RM00302 Salesperson and RM00305 Sales Territory)

    David

  • Bill Campbell Profile Picture
    Bill Campbell on at
    RE: Receivables Year End Close (GP 2013 R2)

    David, not to speak for Frank, but other than the table ID, he pretty much told you what you need to do.

    You can open a case with Tech - however, I have often been told they don't like to provide that kind of fix.

    Writing the SQL Script is the easy way out on this one - I think I would take that and (with  backup of course) run with that solution.

  • David Layten Profile Picture
    David Layten 1,819 on at
    RE: Receivables Year End Close (GP 2013 R2)

    Leslie,

    Thanks for your response. I was assuming that would be the case. I am planning on opening a case with Microsoft on this. Do you think I can assume that they will be able to assist me with this project?

    David

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Receivables Year End Close (GP 2013 R2)

    On this one, I would be tempted (oh heck, I would do it) to use SQL to modify the tables such that they displayed the correct answer.

    Kind regards,

    Leslie

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,321 Super User 2025 Season 1 on at
    RE: Receivables Year End Close (GP 2013 R2)

    You're right, my eyes were one line off in the table list I was looking at :)

  • David Layten Profile Picture
    David Layten 1,819 on at
    RE: Receivables Year End Close (GP 2013 R2)

    Frank,

    Thanks for the response. The tables I need updated are in the RM00103 table not the RM00104 table.

    David

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,321 Super User 2025 Season 1 on at
    RE: Receivables Year End Close (GP 2013 R2)

    David, if their Calendar and Fiscal years are the same, why are the Fiscal amounts important?  If the Fiscal Amounts are critical, I'd run a SQL script on RM00104 and make the Fiscal values = Calendar values.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,430 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans