Check for Future Period Postings

  • Check for Future Period Postings

    Posted by Hal-Robinson on January 4, 2017 at 5:11 pm
    • Hal Robinson

      Member

      January 4, 2017 at 5:11 PM

      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

      Member

      January 4, 2017 at 5:54 PM

      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

      fOKaa4qNSqOcfehwlb4l_FISCAL PERIODS SETUP.JPG

      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;

      0lQl2RDSSUeTUHgyVnYH_SL - ACCT TRX in Future Periods.JPG

      pZcfKU7TSO5mRwAZke0s_SL Add Column.JPG

      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

      Member

      January 5, 2017 at 10:09 AM

      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

      Member

      January 5, 2017 at 10:47 AM

      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

      Member

      January 6, 2017 at 10:27 AM

      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

      Member

      January 5, 2017 at 10:11 AM

      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

      Member

      February 7, 2017 at 2:15 AM

      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

      Member

      January 5, 2017 at 2:07 AM

      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

      Member

      January 5, 2017 at 8:52 AM

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

    Hal-Robinson replied 7 years, 6 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Check for Future Period Postings’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!