Re: Vendor Maintenance Message - Cannot Delete Vendor -vendor has open purchase orders.

If you see that the record id is "PO" then have someone go into PUR500 and close the entire PO that should free up the vendor for deletion

Dan Sweeney - Sr Technical Consultant
PHOENIX Business Consulting, Inc.
Cell: 860.490.6712
www.phoenixbcinc.com
 


-----Original Message-----
From: bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx [mailto:bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx] On Behalf Of Larenzo Alexander
Sent: Wednesday, June 24, 2009 10:19 AM
To: BPCS ERP System
Subject: Re: [BPCS-L] Vendor Maintenance Message - Cannot Delete Vendor -vendor has open purchase orders.

No, we don't use the Accounts Payable and the message number is UMI9900 but when I use STRSQL and select records from HPH & HPO with Where selection criteria only equal to Vendor code all of the records that related to the vendor I'm trying to shows a PO status of 3, Qty Received is same as Qty Ordered. Record Id is PO. (Is it ok to be PO or should it be PZ)?

Thanks




________________________________
From: "washburnccinc@xxxxxxx" <washburnccinc@xxxxxxx>
To: bpcs-l@xxxxxxxxxxxx
Sent: Wednesday, June 24, 2009 9:57:36 AM
Subject: Re: [BPCS-L] Vendor Maintenance Message - Cannot Delete Vendor - vendor has open purchase orders.

Is the message using message number? UMI9900? or maybe?UMI9920??or maybe ?? ???
UMG0003

If it is UMI9900 it uses HPOL03 logical file to check for P/Os.

Might there be some Purchase Requistions still out there??
What about drop ship requests still pending?
Are you using Accounts Payable?


Kevin Washburn
www.washburnccinc.com



-----Original Message-----
From: Larenzo Alexander <larenzo_alexander@xxxxxxxxx>
To: BPCS ERP System <bpcs-l@xxxxxxxxxxxx>
Sent: Wed, Jun 24, 2009 8:24 am
Subject: Re: [BPCS-L] Vendor Maintenance Message - Cannot Delete Vendor - vendor has open purchase orders.



Oh yea, I forgot to mention, that my company doesnt have the source code for
this particular program.




________________________________
From: Larenzo Alexander <larenzo_alexander@xxxxxxxxx>
To: BPCS Forum Post <bpcs-l@xxxxxxxxxxxx>
Sent: Wednesday, June 24, 2009 9:11:47 AM
Subject: [BPCS-L] Vendor Maintenance Message - Cannot Delete Vendor - vendor has
open purchase orders.

When we try to delete vendor codes out of the Vendor Maintenance we get the
following message:

Cannot Delete Vendor - vendor has open purchase orders.

I used SQL to check the HPH or HPO for any open PO's and all there wasn't any
open.

Does any have any idea of what I need to check to be able to allow a user to
delete vendor codes without receiving that message.

Thanks,



? ? ?