Accounting Date more than one year in the future

SUGGESTED

AP invoices were entered with an accounting date of 12/31/23 instead of 12/31/22.  Posting in JC and GL are rejected.

  • 0

    Revise the invoices enter the actual date it should be. 

    When it asks where to reverse it from select the original date used.

  • 0
    SUGGESTED

    Use AP > Tasks > Change Invoices to change the accounting date to 12/31/22  and nothing else on each invoice. When prompted for which date to use to reverse the invoice, chose the "Original Date" which will create reversing entries in General Ledger as of 12/31/23. To confirm that the 12/31/23 non-posting GL entries net to zero, use the GL report > Entries by Account and choose the NEW file. Each account listed on that report should show a net total of 0.00.  At a later time, when everyone is out of the system, and you can confirm that the NEW.GLT file contains only the 12/31/23 entries, you can use Common Tasks > Tools > File Tools to change the name of the NEW.GLT file to something like "BAD_DATES_NEW.GLT" that will hide it from daily use (assuming you are not using "named" files for GLT.

    Art MInds
    Independent Senior Consultant

  • 0 in reply to Art Minds

    I had a similar issue and was able to delete the GL entries.  I just need to take care of JC now.  If I rename the file, will that work?  I tried renaming it in Windows explore (I've done it once in the past) but it didn't work because I kept getting an error mesage that the new.jct file was missing.

  • 0 in reply to Cristina1

    You must use File Tools to rename files. The file name, for example NEW.JCT, is only a pointer to a subfolder containing multiple data tables that comprise the full data set referenced as NEW.JCT.  Using Windows Explorer to rename the file leaves all the actual data stranded, and no longer connected to the pointer file.

  • Hi,

    so I have a similar case where two transactions and their reversals are sitting in the new file for JC. Their accounting date is 1-10-3202 , so it wont clear ever. 

    Do I also need to do the renaming of the new.glt file?

  • 0 in reply to Algirdas Purkenas

    Yes, that would be how to remove those transactions. Only rename when everyone is out of the system and double-check that the only entries in the New.glt file are the future date entries and that they net to zero. I also add the current date to the filename so I know when I did the renaming in case I ever need to bring it back. Ex. 101323New.GLT I've never had to bring one back!