It sounds like your trigger is causing you the problem.  Standard BPCS
leaves the record active and the Purchasing system will pick the correct
quote based upon the due date of the purchase order line.

There is not a system parameter in answer to your original question.  I
suggest removing the trigger.
 

-----Original Message-----
From: bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx] On Behalf
Of Daniel Wilkins
Sent: Thursday, June 30, 2005 1:04 PM
To: SSA's BPCS ERP System
Subject: RE: [BPCS-L] Vendor Quote Maintenance

Mine stays active too. But I have a trigger over the file so I know that
when the discontinue date is changed, it deletes the record and then
adds it back with the new discontinue date. 

Version  6.1.01


-----Original Message-----
From: bpcs-l-bounces+dwilkins=suz.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+dwilkins=suz.com@xxxxxxxxxxxx] On Behalf Of Dan
Sweeney
Sent: Thursday, June 30, 2005 12:17 PM
To: 'SSA's BPCS ERP System'
Subject: RE: [BPCS-L] Vendor Quote Maintenance

I just checked in Version 6.1.02 and when I change the discontinue the
record stays active.

What version of BPCS are you on?


-----Original Message-----
From: bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+dsweeney=phoenixbcinc.com@xxxxxxxxxxxx] On Behalf
Of Daniel Wilkins
Sent: Thursday, June 30, 2005 12:06 PM
To: bpcs-l@xxxxxxxxxxxx
Subject: [BPCS-L] Vendor Quote Maintenance

Currently the Vendor Quote Maintenance program deletes the current
record and adds a new one when the user changes the discontinue date,
instead of just changing the record. Is there some kind of system parm
or something that can be changed to make the program just change the
record and not delete and then add it back with the new date? I don't
have the source for this program and no way to get it. 

 

Thanks,

Daniel


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.