Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Margaret Knight]

I have a report with “weekly dates” in the column. The report failed with an error message “Date 7-3-17 is not valid for the selected company.” Basically this report wouldn’t accept any date after the 6 period. 

I have checked GP fiscal periods and all is set up for 2017.

Other item strange is the base period drop down only goes to “8” (not 12) for 2017.

Any thoughts as to what the problem may be?

——————————
Margaret Knight-Dominguez
Director of Finance
Construction Labor Contractors LLC
Richfield OH
——————————

[Margaret Knight]

Note we are on MR version 2.12.14001.45 

Wondering if there is a “fix” or something available for this error?

——————————
Margaret Knight-Dominguez
Director of Finance
Construction Labor Contractors LLC
Richfield OH
——————————
——————————————-

[Frank Heslin]

Hi Margaret,

Are you using the DataMart or Legacy connector?  If your using the DataMart then you probably need to rebuild it.  My guess is that you setup some of those periods ‘after’ you originally built your DataMart.

——————————
Frank Heslin
Financial Systems Administrator
ExamWorks, Inc.
Atlanta GA

Member, GPUG Advisory Committee
Chairman, Georgia Regional GPUG Chapter
Summit 2016 Track Leader

GP2015 R2
MR CU14

Follow me on Twitter: @Automate_It

GPUGGA – http://www.gpug.com/Atlanta

*** Help Us, Help You…provide enough info so that we don’t have to ask for more:) ***
*** If you solve your issue please share the solution to assist others! ***
——————————
——————————————-

[Margaret Knight]

Yes, we are using Data Mart. We rebuilt it last night and all is working well!

Thank you,
Peggy

——————————
Margaret Knight-Dominguez
Director of Finance
Construction Labor Contractors LLC
Richfield OH
——————————
——————————————-

[Stuart Gallion]

To clarify, does this mean the DM will have to be rebuilt when a new year is added to GP?
For example:
When our Datamart was built, the years through 2017 existed in GP. When I do the 2016 GL year end close I will build CY 2018. Will the DM have to be rebuilt for it to pull 2018 postings? We commonly have expense deferral transactions that amortize over a year that will post in the next couple of months.

——————————
Stuart Gallion
Project Accountant/GP System Administrator GP2010SP1/FRx6.7
Stanford Hotels Corporation
San Francisco CA
——————————
——————————————-

[Beat Bucher]

Hi Margaret,
Before rebuilding your Datamart (if you use it), check what is your selected ‘default’ GP company in MR 2012 ..
Go under : Menu > Companies > look at which company has the check-mark on the left side.

MR pulls the fiscal periods from the ‘default’ company.. thus when you have multiple companies setup, this can play some fool games in your reports, especially if your companies are not all set with the same Fiscal Calendar Setup in GP..

——————————
Beat Bucher
Business Analyst, Dynamics GP MVP
Ultra-Electronics Forensic Technology Inc.
Montreal QC/Canada
+1-514-489-4267
@GP_Beat http://dyngpbeat.wordpress.com/
Montreal QC GPUG Chapter Leader
GP2013R2 / MR2012 CU14
——————————
——————————————-