ISTech Support Forum - PO-RNI errors when re-opening old POs

dkpruett

Browser

Posts: 23

PO-RNI errors when re-opening old POs
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.

Back to top

IP Logged

Lynn_Pantic

Administrator

evolution (n) -
gradual change to a
different form

Posts: 5663

Re: PO-RNI errors when re-opening old POs
Reply #1 - 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.

Back to top

Lynn Pantic
IS Tech Support
lynn@istechsupport.com

IP Logged

dkpruett

Browser

Posts: 23

Re: PO-RNI errors when re-opening old POs
Reply #2 - 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.

Back to top

IP Logged

lmk223a

Senior Member

Accountant

Posts: 377

Re: PO-RNI errors when re-opening old POs
Reply #3 - 08/02/07 at 06:01:43

Quote from 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.

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.

Back to top

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan

IP Logged

cathyh

Active Member

I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female

Re: PO-RNI errors when re-opening old POs
Reply #4 - 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.

Back to top

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1

IP Logged

dkpruett Browser Posts: 23	Re: PO-RNI errors when re-opening old POs Reply #5 - 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.
Back to top	IP Logged

cathyh

Active Member

I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female

Re: PO-RNI errors when re-opening old POs
Reply #6 - 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?

Back to top

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1

IP Logged

cathyh Active Member I used to be indecisive; now I'm not so sure...... Posts: 1210 Gender:	Re: PO-RNI errors when re-opening old POs Reply #7 - 09/19/07 at 13:19:31 Nevermind I found them in BKAPHPOL- I just didn't scroll down far enough. I just deleted the bogus records that do not seem to show up anywhere else. I hope they continue not to show up.
Back to top	Cathy Hamilton Wing Inflatables, Inc. EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09) Windows 2008 Server/client Pervasive V10.1 IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5663	Re: PO-RNI errors when re-opening old POs Reply #8 - 09/20/07 at 15:19:01 The bogus records only existin BKAPHPOL and the next post contains the fix.
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

cathyh Active Member I used to be indecisive; now I'm not so sure...... Posts: 1210 Gender:	Re: PO-RNI errors when re-opening old POs Reply #9 - 09/20/07 at 15:31:58 Excellent!
Back to top	Cathy Hamilton Wing Inflatables, Inc. EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09) Windows 2008 Server/client Pervasive V10.1 IP Logged