Microsoft Dynamics GP Year-End Update 2021: Receivables Management

Hello Dynamics Fanatics,

In this article, I would like to provide tips that will ensure that your Receivables Management Year End Close process goes smoothly.

Does the 2021 Year-End Update include any changes for the Receivables Management Year-End Closing process?

No, there are no changes included the 2021 Year-End Update that will affect the Receivables Management year-end close process. Here is a link to blog BLOG!!!! that contains the Year End Update fixes included in the update

When should the Year End Close for Receivables Management be done?

1. If you are using a Calendar year, the year-end process should be done at the end of your calendar year, prior to posting any transactions in the next calendar year.
2. For those using a Fiscal year, the year-end process should be done at the end of your fiscal year, prior to posting any transactions fin the next fiscal year.

What does the year end close process do and/or affect?

1. The Calendar year end close clears the Calendar Year-to-Date Finance Charges and moves them to the Last Year Calendar field in the Customer Finance Charge Summary window found under (Cards >> Sales >> Summary >> Finance Charges).
2. The Fiscal Year end close transfers all amounts other than the Calendar Year-to-Date Finance Charges to the Last Year column in the Customer Summary window (Cards >> Sales >> Summary).

What steps should I take to close the year?

Post all transactions for the current year and then proceed through the rest of the steps outlined in Year-end closing procedures for Receivables Management - Dynamics GP | Microsoft Docs

Key points to remember:

1. Make a restorable backup when it is recommended as you work through Year-end closing procedures for Receivables Management - Dynamics GP | Microsoft Docs.
2. Receivables Management is not completely date sensitive. This means that if you do not close the year after you enter all the current year transactions and before you enter transactions for the new year, some areas in GP will contain incorrect information.
3. Since there are some date sensitive features, it is recommended you close the year on time.
4. You will notice that we have two articles around closing Receivables Management Year-end closing procedures for Receivables Management - Dynamics GP | Microsoft Docs and Payables Management Year-end closing for Payables Management - Dynamics GP | Microsoft Docs - both instructions say to 'Close the tax year by going to Microsoft Dynamics GP >> Routines >> Company >> Tax Year-End Close. You will only have to do that once, typically after both RM and PM are closed. The reason this step appears in both articles is due to the fact that not everyone used both the RM and PM modules. 

Amounts Since Last Close are incorrect after the Year End Close:

Although Receivables Management is date sensitive, the following items are updated based on the ‘actual’ date the year is closed Receivables Management. These are known as Amounts Since Last Close views:

• The SmartList objects
• The Receivables Management summary reports
• The Amounts Since Last Close view in the Customer Summary window

The items that are flagged with an asterisk are affected by the calendar year-end close. All the other items are affected by the fiscal year-end close.

• Average Days to Pay - Year
• Finance Charges CYTD*
• Finance Charges LYR Calendar*
• High Balance LYR
• High Balance YTD
• Number of ADTP Documents - LYR
• Number of ADTP Documents - Year
• Number of NSF Checks YTD
• Total # FC LYR*
• Total # FC YTD*
• Total # Invoices LYR
• Total # Invoices YTD
• Total Amount of NSF Check YTD
• Total Bad Debt LYR
• Total Bad Debt YTD
• Total Cash Received LYR
• Total Cash Received YTD
• Total Discounts Available YTD
• Total Discounts Taken LYR
• Total Discounts Taken YTD
• Total Finance Charges LYR*
• Total Finance Charges YTD*
• Total Returns LYR
• Total Returns YTD
• Total Sales LYR
• Total Sales YTD
• Total Waived FC LYR*
• Total Waived FC YTD*
• Total Writeoffs LYR
• Total Writeoffs YTD
• Unpaid Finance Charges YTD*
• Write Offs LYR
• Write Offs YTD

*If the Year to Date or Last Year amounts are incorrect in the Amount Since Last Close View: you can use the link below to download the Receivable's Management Recalc Scripts as well as additional information on the Amounts Since Last Close.

https://community.dynamics.com/gp/b/dynamicsgp/posts/amounts-since-last-close-views-incorrect-in-payables-or-receivable-s-after-closing-the-year

Assistance for the Receivables Management Year End Close:

• Microsoft Dynamics GP Blog
• Microsoft Dynamics Community
• Microsoft Dynamics Support

If you are creating a case with the Technical Support Team, please refer to the routing below to ensure you are routed to the correct Professional for assistance with the Receivables Management Year End Close:

--Support Topic Selection: Financial - Receivables Management
---Sub-topic Selection: Year End Procedures

Year-End Resources:

• Refer to Year-end closing procedures for Receivables Management - Dynamics GP | Microsoft Docs
• For Information about performing the year-end closing procedures in Receivables Management in Microsoft Dynamics GP after December 31, click on KB 851140.

Year-End Close Resources:

Be sure to refer to the GP 2021 Year-End Blog Schedule to review current and upcoming blog posts and other helpful resource links related to Year-End Closing for Dynamics GP.

I hope this is helpful and that you have a successful Year-End!!  If you have any feedback or suggestions, please let us know. 

Have a wonderful Year-End!!!

Brandon Jarrett | Support Engineer | Microsoft Dynamics GP