Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. 'Amounts Since Last Closed' View in Customer or Vendor Summary reflects incorrect close date in Microsoft Dynamics GP

'Amounts Since Last Closed' View in Customer or Vendor Summary reflects incorrect close date in Microsoft Dynamics GP

View products that this article applies to.

Symptoms

The 'Amounts Since Last Close' view for Customer or Vendor Summary Inquiry show incorrect Year-to-Date or Last Year values.
  • The Payables Management year is closed at an incorrect date.
  • The Receivables Management year is closed at an incorrect date.
  • The YTD and LYR values for Payables Management Vendors does not reflect the correct amount.
  • The YTD and LYR values for Receivables Management Customers does not reflect the correct amount.

↑ Back to the top

Cause

The Year End Close process for Receivables Management and Payables Management is not date specific to transactions. This means that transactions up to the date the close process is performed are considered Last Year (LYR) and the transactions entered after the close are considered Year to Date (YTD). The date of the transaction is not a consideration. 

For example, if you perform the close process in Receivables Management or Payables Management at the end of February, the transactions in January and February will also be moved to 'last year' for the "Amounts Since Last Close' view in the Customer or Vendor Summary window.

↑ Back to the top

Resolution

This can be resolved through a SQL scripting solution. Below are the steps for this:

**Please make a current backup of your company database, and perform these steps in a Test company first to verify it works the way you expect.



PAYABLES MANAGEMENT:

1. Download the PMCALC.zip that contains scripts for Payables Management:

https://mbs2.microsoft.com/fileexchange/?fileID=91a12810-1bbe-4d6e-afd5-64dff29cecde


2. Go to the location you saved the zip file and extract the five SQL statements in it.

 
3. In SQL Server Management Studio, execute these SQL statements (from the PMCALC.zip file) against the company database:

create_table_taPMRECALC.SQL

smPM_Summary_stored_procedure_LASTYEAR.SQL

smPM_summary_stored_procedure_THISYEAR.SQL



4. Open the ‘LAST YEAR PM Recalc.sql’ script and copy it in to a query window. Edit the dates as needed for 'Last Year' and execute it against the company database. For instance, if your last closed year was 2015 and the dates were 01/01/2015 through 12/31/2015, then edit this script to look as follows:

exec smPMSummaryNOINVYTDLYR '01/01/2015', '12/31/2015'

5. Open the ‘THIS YEAR PM Recalc.sql’ script and copy it into a query window. Edit the dates as needed for the 'current year' and execute it against the company database. For instance, if your current open year is 2016 and the dates are 01/01/2016 through 12/31/2016, then edit to this script to look as follows:

exec smPMSummaryNOINVYTD '01/01/2016', '12/31/2016'

6. Review your YTD and LYR values in your company for accuracy.



RECEIVABLES MANAGEMENT:


1. Download the RMRECALC.zip that contains scripts for Receivables Management:

https://mbs2.microsoft.com/fileexchange/?fileID=dddbed25-f461-4a7c-8d41-21a078370966


2. Go to the location you saved the zip file and extract the five SQL statements in it.


3. In SQL Server Management Studio, execute the following statements (from the RMRECALC.zip file) against the company database:

create_table_taRMRECALC.SQL

smRM_summary_stored_proc_LASTYEAR.SQL

smRM_summary_stored_Proc_THISYEAR.SQL



4. Open the ‘LAST YEAR RM Recalc.sql’ script and copy it in to a query window. Edit the dates as needed for 'Last Year' and execute it against the company database. For instance, if your last closed year was 2015 and the dates were 01/01/2015 through 12/31/2015, then edit this script to look as follows:

exec smRMSummaryLYR '01/01/2015', '12/31/2015'

5. Open the ‘THIS YEAR RM Recalc.sql’ script and copy it in to a query window.  Edit the dates as needed for the 'current year' and execute it against the company database. For instance, if your current open year is 2016 and the dates are 01/01/2016 through 12/31/2016, then edit this script to look as follows:

exec smRMSummary '01/01/2016', '12/31/2016'

6. Review your YTD and LYR values in your company for accuracy.




↑ Back to the top

Keywords: kbmbspartner, kbmbsmigrate, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 3193375
Revision : 1
Created on : 1/7/2017
Published on : 10/25/2016
Exists online : False
Views : 310