ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Problem Reports - Sporadic >> Batches out of balance due to PO received
http://www.istechforum.com/YaBB.pl?num=1208809255

Message started by JCL on 04/21/08 at 13:20:55

Title: Batches out of balance due to PO received
Post by JCL on 04/21/08 at 13:20:55

We have this problem, on a limited, but definately recurring basis.

It seems to have something to do with receiving things directly to a WO#.

The items are received, but it creates an out of balance journal entry.

Debit WIP say for $50.00 (which is correct)
Credit PO RNI for $112 (or some other totally random $ amt).

This has been happening for a year or more, sometimes twice a month, sometimes not at all. I am totally stumped!! I just go in and edit the batches and correct it, but I was wondering if anybody else is having the same problem.

Title: Re: Batches out of balance due to PO received
Post by lmk223a on 04/22/08 at 05:56:27

When this happens to us, it's indicative of a record lock occurring when receiving Purchase Orders. Not only is the GL batch out of balance, but also the a/p invoice is not able to be matched to the po receipt in AP-C.

Is anyone receiving an error message or record lock message when receiving?

Title: Re: Batches out of balance due to PO received
Post by cathyh on 04/22/08 at 08:48:16

The same thing has happened to us, particularly the person in AP invoicing a PO receipt and materials receiving a PO at the same time. We have resorted to making the AM hours for AP to do PO invoicing and PM hours materials can do PO receipts.
Before Evo introduced a more compliant GL by changing the GL-P edit GL batches, we would insert the missing transactions and adjust amounts. ( for us the random amounts could be traced to a particular PO invoice.) We haven't had to do this in a long while so I'm not sure how this program works now.
If you do a printout of GL transactions, GL-C Unposted, sometimes you can figure out which transactions are mixed up.

Title: Re: Batches out of balance due to PO received
Post by Dawn J. on 04/22/08 at 11:26:32

This happens to us often...well it USED to happen to us often. It quit happening when we threatened to tie the employee who kept making mistakes while receiving PO's to the highest beam in the warehouse if she didn't quit control-alt-deleting to get out of her mistakes!!

Title: Re: Batches out of balance due to PO received
Post by cathyh on 04/22/08 at 11:35:00

Yes there are a number of places where control/alt/del does bad things!

Title: Re: Batches out of balance due to PO received
Post by Lynn_Pantic on 04/25/08 at 12:33:20

The initial issue reported by JCL in this thread has been found and fixed. It would only happen when receiving to Work Order and only if a Make From and non-Make From were on the same PO or received perhaps on different PO's within the same session of PO-C. The component cost of the Make From components was being added to the other non-make from lines. It has been fixed and the latest update file (3/27/08) has been patched.

Title: Re: Batches out of balance due to PO received
Post by JCL on 04/28/08 at 10:14:06

Thank you!! :)

So I should re-install that update then, or if I wait till the next update, it would be in there??

Title: Re: Batches out of balance due to PO received
Post by Lynn_Pantic on 05/05/08 at 17:51:07

If you have already installed the 3/27/08 update, go to www.istechsupport.com/status.php and install the patches that have been released since you applied the udpate.