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

PZ if it is closed.



Thanx,

Nick



Nick Radich
Sr. Programmer/Analyst
EPC Molding, Inc.
Direct (320) 679-6683
Toll free (800) 388-2155 ext. 6683
Fax (320) 679-4516
nick_radich@xxxxxxxxxxxxxx



Larenzo Alexander <larenzo_alexander@xxxxxxxxx>
Sent by: bpcs-l-bounces+nick_radich=epcmolding.com@xxxxxxxxxxxx
06/24/2009 09:27 AM
Please respond to
BPCS ERP System <bpcs-l@xxxxxxxxxxxx>


To
BPCS ERP System <bpcs-l@xxxxxxxxxxxx>
cc

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,



? ? ?