[Hal Robinson]

Looking to have a monthly control to identify if any GL entries are posted in a future period.  Any ideas?

——————————
Hal Robinson
VP of Finance
US Assure
Jacksonville FL
——————————

[Frank Heslin]

Hi Hal,

The easiest way to PREVENT entries being posted into a future period is to keep the period closed.

You can get to it by following this path (as long as you have access to it):

Microsoft Dynamics GP > Setup > Company > Fiscal Periods

A quick way to find any entries that have already been posted to a future period is from a SmartList.

SmartList > Financial > Account Transactions > * (the * is the default), then just use this criteria:

(To get ‘Originating Posted Date’ just click on the magnifying glass, and where it says ‘Selected Columns’, click that & select ‘All Columns’, then scroll down to to select it;

Hope this helps!

——————————
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! ***
————————————————————————-

[Thomas Hill]

It is ironic to see this thread first thing this morning.  Using GP2010, we have found that AP entries were posted (erroneously) with future dates, 2116 vs 2016.  The periods are not opened in advance.  It was discovered when trying to post credits against these items, credits had correct dates, that a zero check could not (would not) be written.  

Just thought I would share.

——————————
Thomas Hill
Accounts Payable – Expense Processing
M&A Technology, Inc.
Carrollton TX
————————————————————————-

[Frank Heslin]

Thomas, was that all or part of your issue with the stuck AP batch?  Have you been able to post it yet?

——————————
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! ***
————————————————————————-

[Thomas Hill]

Frank, it is a small factor in just some of the problems.  I am beginning to think that our GP2010 files may have data corruption, a byte here and there type of thing.  Our Administrator is going to run some maintenance routines over the weekend.  Hopefully it will clear some of it up.

But as to my posting here, GP2010 allowed a batch with dates in 2116 to be posted, even though only Dec2016 was the only AP period open.

——————————
Thomas Hill
Accounts Payable – Expense Processing
M&A Technology, Inc.
Carrollton TX
————————————————————————-

[Mark Spain]

You could also use the PSTL tool and install DocDateVerfiy as this will prevent AP or those type transactions from future date.   It looks at the fiscal period setup to see if a valid period is defined and open

——————————
Mark Spain
Senior Dynamics GP Consultant
ACE Microtechnology
Huntsville AL
————————————————————————-

[Leslie Vail]

Mark,
This is absolutely the right way to go. The subledger will accept any date you use. It won’t post to the GL, but it will post to the subledger. This option should be selected at every installation of GP, in my opinion.
Leslie

——————————
Leslie Vail
Accounting Systems Consulting, Inc.
Dallas TX
——————————
——————————————-

[Martha Machado]

Are you trying to prevent it or just identify the ones that were posted? If it’s the latter, the smartlist works or there’s an Excel report for financial transactions that you could just add a date parameter to. Saves you from having to keep running the smartlist and you can also use it to monitor what month end entries are posted on time, which are late, and so on. The Excel report for journal entries would be called something like “AccountTransactions Current Financials Journal.”

——————————
Martha Machado
CPA / Consultant
CPA Projects
Pompano Beach FL
————————————————————————-

[Hal Robinson]

Hi Martha,

We can have future postings with the expense deferral entries, so the goal is to review any future entries for ones not expected.  The Excel Report is a great idea.  Thank you

——————————
Hal Robinson
VP of Finance
US Assure
Jacksonville FL
————————————————————————-