ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> A/P aging posting error
http://www.istechforum.com/YaBB.pl?num=1219760495

Message started by ASIMedicalJR on 08/26/08 at 07:21:35

Title: A/P aging posting error
Post by ASIMedicalJR on 08/26/08 at 07:21:35

So I voided a check as of 07/31/08 that was cut in 2006.  I then reversed the voucher in the A/P-B screen.  Now I am getting an error message when I post through GL-O that states:

    Unable to post the selected batches because one or more batches contain the following problem(s):
      Clearing account entires in batch.
    You can deselect the batches that are causing this condition and then post the remaining batches, or make  
    corrections through GL-P, Edit GL Batch Entries, and try posting again.

Does anyone know why I am getting this error message?  And how do I fix it so I can post?  Because the batch is not out of balance; therefore, fixing it through GL-P like the error message suggests will not fix the problem.  

Thanks for the help!  
Jamie






Title: Re: A/P aging posting error
Post by cathyh on 08/26/08 at 07:53:38

Sounds like the GL accounts used in the 2006 accounts are no longer in your account list so it's using the clearing account in GL-O but does not want to post to it.  Check the accounts in the original entries and compare to current GL accounts.  You may need to add the accounts back in and then edit the entry  through GL-P.
Hope this helps...

Title: Re: A/P aging posting error
Post by ASIMedicalJR on 08/26/08 at 09:12:33

The GL account that GL-O will no let me post is still in our chart of accounts in EVO and is labeled as a Suspense O for Owners Equity.  So what do I need to do with it?

Thank you!

Title: Re: A/P aging posting error
Post by ASIMedicalJR on 08/26/08 at 10:23:05

Also, I ran the GL Transactions report in EVO for the day the check was cut and the day the voucher/invoice was entered into EVO.  I see when it was paid it affected cash (an account that isn't used for checks anymore but other pmts) and payables which is correct.  But the report is not pulling anything for the invoice date report for that vendor.  So how else can I see the accounts the original entry affected?

Title: Re: A/P aging posting error
Post by cathyh on 08/26/08 at 12:15:42

IF you run the GL Transactions for RS type use the post date of the invoice (or a range close to it) and the invoice # in Inv/Vchr# range you should get it.
There may be something else up with trying to reverse a check from 2006-  
but the invoice should affect a sales account / Accounts Receivable, and a COGS account /Inventory account  with the invoice reversal.

Title: Re: A/P aging posting error
Post by ASIMedicalJR on 08/27/08 at 14:22:11

Okay, so I CAN NOT find the dang entry for this transaction where it was posted when it was entered as a voucher through A/P-B in November 2006.  I have tried pulling it several ways in GL-C.  I have the invoice number, date, vendor, etc. so EVO is getting all the information it needs to find the original entry and it gives me nothing.  I am in limbo and am unable to post RP-Purchases and GJ-General Journal in the mean time.  Please help me figure this out, thank you much appreciated.

 

Title: Re: A/P aging posting error
Post by cathyh on 09/03/08 at 08:31:11



Quote:
You can deselect the batches that are causing this condition and then post the remaining batches, or make    
    corrections through GL-P, Edit GL Batch Entries, and try posting again.


Here is how I would tackle this:

I would use this delselect method to post as many transactions as possible-  for instance choose by date or type.   Then I would go to GL-C and print "Unposted" transactions to take a look at the transaction that includes a post to the suspense account.  Is it the voucher reversal (sales account, receivables, COGS expense account, or inventory asset) or the voided check (cash, receivables)?

Once I figured this out I would edit the transaction in GL-P.

One other thought-  I wonder if the problem is it is trying to use the original date in the voucher reversal but you are not allowed to post to that date because you have set the period end close date?

ISTech Support Forum » Powered by YaBB 2.1!
YaBB © 2000-2005. All Rights Reserved.