ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> GL Out of Balance
http://www.istechforum.com/YaBB.pl?num=1196860836

Message started by Dennis on 12/05/07 at 06:20:36

Title: GL Out of Balance
Post by Dennis on 12/05/07 at 06:20:36

We have recently began using DBA/Evo GL (approx. 9 months) for our main company. About once every week, we get an out of balance transaction posted to the batch file and we can't process the batch until we delete the duplicate transaction. It is never more than one transaction and the transaction is always one generated from receiving purchase orders.

I have been running another company using DBA/Evo and in the last 31/2 years, never had this happen, but with our primary company, it happens about once every week or two. Has anyone experienced this and if so, what's causing.

Thanks,

Dennis :-?

Title: Re: GL Out of Balance
Post by Lynn_Pantic on 12/05/07 at 07:37:47

There was a recent fix to GL posting related to PO Received to a Work Order and Inventory Costing set to Standard Cost. If that is the issue, I can send you a patch and the fix will be in the update being posted this week. If that doesn't describe your circmstances, then we need more details. Since it isn't happening with every receipt, we need to know what the ones that do have the problem have in common.

Title: Re: GL Out of Balance
Post by Dennis on 12/05/07 at 08:10:56

I reviewed the last 4 out of balance txns: 1) 2 purchase items bought to expense, 2) 1 purchase item bought to inventory, and 3) 1 outside process on a service po to a work order. We are using average costing.

Title: Re: GL Out of Balance
Post by Lynn_Pantic on 12/05/07 at 08:21:21

No error messages during receiving? And what exactly was the out of balance? Duplicate entry for which side of the posting?

Title: Re: GL Out of Balance
Post by Dennis on 12/05/07 at 08:50:38

No error messages at time of entry (as best as we can ascertain). The duplicate is always to the debit side against inventory or expense, never a credit to GL account "Received/Not Invoiced". I can't tell if it is a first entry of a given day, midddle of day, etc. At one point in time, this would happen every week, then around Agust 2007, it pretty much stopped. Now in November 2007, it is again happening about once a week. As I said earlier, in another company I am running, I have never had this happen.

Title: Re: GL Out of Balance
Post by cathyh on 12/05/07 at 08:57:35

We've seen this when PO's are being received while AP invoices from PO receipts are being generated. We now do these at different times of the day.

Title: Re: GL Out of Balance
Post by Dennis on 12/05/07 at 09:06:11

Cathy,

You might be on to something. When this was happening alot, we started doing our invoicing after end of 1st shift and things seemed to quiet down. We now have someone new in the accounting department and they may be doing invoicing during the day. I will follow up on this.

thanks,

Dennis

Title: Re: GL Out of Balance
Post by lmk223a on 12/06/07 at 08:07:34

My 2 cents worth - we experience an error in GL batch posting for received items when the creator of the purchase order inadvertently places a comma in the GL dept field of the PO header screen.

Title: Re: GL Out of Balance
Post by Dennis on 12/06/07 at 08:12:07

In reference to a coma placed in department field, this was happening before using Evo and there was no access to GL account or department. However, keep those ideas coming. ;)