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.

Error Message: "This is an invalid Reporting Date. It will be adjusted." when you change the Period Begin date in Project Accounting in Microsoft Dynamics GP


View products that this article applies to.

Symptoms

 

You receive an error when you enter 53 for the Rep Period and you change the Period Begin date on your timesheets, equipment logs, or miscellaneous logs in Project Accounting in Microsoft Dynamics GP:
This is an invalid Reporting Date. It will be adjusted.

You are unable to enter the transaction with that date and reporting period combination.


↑ Back to the top


Cause

When you enter 53 for the No of Reporting Periods per Year and you have selected Weekly for Reporting Periods in setup, you must enter a Period Begin date that is the first day of the weekly period. If you do not, then the system will error and will revert your period and date back to the default.

↑ Back to the top


Resolution

When you use 53 for your reporting period on your transaction, the date entered for your Period Begin must be the first day of that period. It is also true that a Rep Period of 53 will never default in when you create a cost transaction. It must always be manually entered to be used and the correct beginning date chosen.

Typically weekly reporting periods only have 52 reporting periods. 53 is allowed as a way to accommodate leap years.

Here is an example of how the set up can be utilized for a 53rd weekly period.

Setup:

1. Reporting Periods: Weekly
2. No of Reporting Periods per Year: 53
3. First Date of Reporting Period 1: 1/01/2012
4. User Date: 12/25/2016

When I create my cost transaction with a User Date of 12/25/2016, 1 defaults in for the Rep Period and 12/25/16 and 12/31/16 are the dates. If I want this transaction to post to the 53rd reporting period, I must first change the Rep Period field to 53. When that occurs my dates are automatically changed but they are not correct. I must manually change the Period Begin date to be 12/25/16. When I do this, my Period End date goes to 12/31/16 and I can post my transaction.

Note If I use the VCR button to advance the period dates, my reporting period is set to 2.


↑ Back to the top


More Information

Note In the example above, if I do not enter 12/25/16 as my Period Begin date and instead enter 12/26/16 for example, I will receive the warning message 
This is an invalid Reporting Date. It will be adjusted.

At this time my reporting period and dates will go back to the entries that defaulted in when I started my cost transaction.

↑ Back to the top


Keywords: kbmbspartner, kbmbsmigrate, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2495145
Revision : 1
Created on : 1/7/2017
Published on : 6/8/2012
Exists online : False
Views : 157