ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Problem Reports - Repeatable >> PO-RNI errors when re-opening old POs
http://www.istechforum.com/YaBB.pl?num=1185293343

Message started by dkpruett on 07/24/07 at 09:09:03

Title: PO-RNI errors when re-opening old POs
Post by dkpruett on 07/24/07 at 09:09:03

PO-I-F reports incorrectly for POs once closed but reopened and a receipt taken; we "used" to do this for RMA returns to the supplier against the original PO, but once a negative receipt occurs on that PO, the PO-RNI reports shows ALL original PO lines as RNI (i.e. I received a PO with 3 lines, each with values of $1000 per line, and then input the invoices and pay and close the PO; I then reopen the PO and do a negative receipt for $100); the PO-RNI report will show a total of $1000+$1000+$1000+(-$100)=$2900 open waiting to invoice.

If I simply had an option to not allow my users to "reopen" POs I'd be happy.

Title: Re: PO-RNI errors when re-opening old POs
Post by Lynn_Pantic on 07/24/07 at 09:52:46

Actually, there is an option in SD-C, Receiver Defaults where you can turn off the ability to reopen POs. You need to have everybody out of the system before you go into SD-C before you can see the Receiver Defaults button.

And I will have programming look into the problem. Reopening the PO should not put invoiced lines back into RNI.

Title: Re: PO-RNI errors when re-opening old POs
Post by dkpruett on 07/24/07 at 10:29:26

I thought I remembered seeing that option once before; and you're right... before I sent this email I checked the options once more and it wasn't there, but of course I had users on the system.
I went into another company file where no users were logged on, and sure enough there is a "Receiver Defaults" button at the bottom that shows up.
I'll turn that off later once all users are out, though I'd still consider the PO-RNI report as having a bug... Thanks for the quick response.

Title: Re: PO-RNI errors when re-opening old POs
Post by lmk223a on 08/02/07 at 06:01:43

Lynn_Pantic wrote:

This bug has existed for quite some time.

In the past, if we had to return an item to a vendor on a fully received po, purchasing would reopen the po to show the return and add a line item for its replacement. This action causes all previous lines to reappear on RNI. The two options to rid the report of these bogus items, is to have our systems person edit them in Maintain DataBase, or have accounting close the po after the return and its replacement line items have been received.

We have changed our behaviour to create a new po to return items to a vendor on a fully received po to avoid this problem.

Title: Re: PO-RNI errors when re-opening old POs
Post by cathyh on 09/19/07 at 09:25:41

This just happened to us. An old PO was reopened to receive an item that was on the PO but never received. The printed PO showed all lines at 0 except for the line to be received. The one line was received, but the RNI report shows all items received with original quantities, and the GL RNI account shows this also. However, there are no inventory transactions except for the line item actually received.

How can I fix this?

I don't really want to remove the ability to reopen since we have had PO's closed sometimes before invoicing and they need to be re-opened for that.

Title: Re: PO-RNI errors when re-opening old POs
Post by dkpruett on 09/19/07 at 09:46:00

To add more grief to this problem, I have turned off the option to reopen POs in SD-C but my users can STILL reopen POs. It's like that option doesn't do anything.

Title: Re: PO-RNI errors when re-opening old POs
Post by cathyh on 09/19/07 at 10:16:26

Well I guess it is good that I don't care to restrict the reopen PO ability!

I was wrong about there being GL consequences- only an amount for the correctly received line showed up in the GL so that at least is a relief.

I have looked for the erroneous PO receipt data in MD but can't find any reference to the incorrectly received line items. What file needs to be edited?

Title: Re: PO-RNI errors when re-opening old POs
Post by cathyh on 09/19/07 at 13:19:31

Nevermind I found them in BKAPHPOL- I just didn't scroll down far enough. :P
I just deleted the bogus records that do not seem to show up anywhere else. I hope they continue not to show up.

Title: Re: PO-RNI errors when re-opening old POs
Post by Lynn_Pantic on 09/20/07 at 15:19:01

The bogus records only existin BKAPHPOL and the next post contains the fix.

Title: Re: PO-RNI errors when re-opening old POs
Post by cathyh on 09/20/07 at 15:31:58

Excellent! :D