ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> GL-O not balancing
http://www.istechforum.com/YaBB.pl?num=1070470068

Message started by stl3370 on 12/03/03 at 08:47:48

Title: GL-O not balancing
Post by stl3370 on 12/03/03 at 08:47:48

Using Evo with 11/4 update.

This has never been a problem before, but I've had it happen three times now in the past two weeks where GL-O doesn't balance. It is always caused by the same situation--receiving a PO. I always get the credit to RNI, but nothing else to the transaction. Even more problematic is that the inventory items are not being received in. The QOH is not updated and there is no transaction showing. But the PO shows closed and I can go into AP-C to apply the invoice. I tried reversing everything and re-doing it, but I still get the same problem. Any ideas as to what may be going on?

Thanks,
Sean
Leybold Optics

Title: Re: GL-O not balancing
Post by Lynn_Pantic on 12/03/03 at 09:45:55

No errors during the receiving process? Any common thread among the three occurrences such as Lot control or the same item number or something? I have not had any other reports of this problem.

Title: Re: GL-O not balancing
Post by stl3370 on 12/03/03 at 10:06:26

Nothing that I can see. The vendors and items are different. We don't use lot or serial control, F&O's, or make-from's. They were just typical PO's for stock parts from vendors we do quite a bit of transactions with. Other receipts for the vendor on the same day were processed with no problems. The clerk that enters the transactions had no problems and didn't realize there was a problem until I asked her about it. I tried fixing it in both regular DBA and Evo and even on different PC's to no avail. Also tried the fix binary zeroes routine, but that didn't work either.

Title: Re: GL-O not balancing
Post by stl3370 on 12/04/03 at 05:43:20

I think I figured out what is causing this, but I am still not sure why. The 2 PO's that I had problems with yesterday do not have anything in the PO type field. I tried going through PO-A to make it a P (we never do service PO's), but can't get to that field. It appears to me that the correct field in maintain database is bkap_po_confirm(2). Can anyone confirm that this correct?

Thanks,
Sean

Title: Re: GL-O not balancing
Post by Lynn_Pantic on 12/04/03 at 06:53:51

Yes, that is the correct field but I am not sure how you were ever able to create a PO without it. You could run UT-K-B on the BKAPPO file and change all values of that field to P to make sure there aren't any more.

Title: Re: GL-O not balancing
Post by aricon on 12/04/03 at 18:22:12

Lynn,

You may or may not recall that one of my clients (UMC) had EXACTLY this same bug a while back and Allen made a change in the PO-A run file that fixed it. Might want to check with him.

Title: Re: GL-O not balancing
Post by stl3370 on 12/12/03 at 10:07:40

Had this problem again today. I made sure that all PO's were coded as "P" in maintain database when I had the problem last week; however, this occured on a PO that was not in the system at that time. The PO date was listed as 00/00/00 also. Appears that something is happening when the buyers are first entering the PO's.

Sean
Leybold Optics

Title: Re: GL-O not balancing
Post by jeanb on 12/29/03 at 08:41:53

Check to see if the PO has a type "P" on it when you go back into it. We have this happen every now and then and have never figured out why. Also see the same problem someone else had in this forum under DBA Items. I cannot find a common link with the po's this happens to, but the amount received is also not in the total qty on hand either and I end up with an unbalanced g/l transaction also.

Title: Re: GL-O not balancing
Post by Lynn_Pantic on 12/29/03 at 09:47:33

Are the PO's all being entered manually in PO-A or are they converted from RFQ, generated by MRP or copied from existing PO? Need to determine under what circumstances the PO is being saved without the P/S designation and date. This should be pulled in as soon as the vendor code is entered in PO-A.

Title: Re: GL-O not balancing
Post by jeanb on 12/31/03 at 13:11:14

We have been having this exact same problem. As far as I can tell, there is no common link. Our po's are entered manually. It has happened quite a bit lately, and started happening in September of 2003.