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

I would expect PZ if it's closed.

-----Original Message-----
From: bpcs-l-bounces+wallyc=bergquistcompany.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+wallyc=bergquistcompany.com@xxxxxxxxxxxx]On
Behalf Of Larenzo Alexander
Sent: Wednesday, June 24, 2009 9: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,



? ? ?