Re: [Emerald] Purchase Order Error

Ed Miller ( (no email) )
Wed, 21 Jul 1999 13:51:28 -0400

PayMethod GroupID SortOrder
--------------- ----------- ---------
Cash (null) (null)
Check (null) (null)
Purchase Order (null) (null)
Credit Card (null) 1
Invoice (null) 1
Master Card (null) (null)
Other (null) 1

(7 row(s) affected)
There is a space in front of Cash, Check and Purchase Order not Credit Card,
Invoice, Master Card or Other

A quick question.
Is there a script that will change the Sub Accounts of inactive Master
Accounts to inactive from active?
It does not change when inactivate the account.

> Ed Miller wrote:
> >
> > Getting SQL Server Error: 547 Update statement conflicted with COLUMN
> > FOREIGN KEY constraint 'FK_MasterAcc_PayMe_623A9EC6'. The conflict
occurred
> > in database 'Emerald', table 'Paymethods', column 'PayMethod'
> >
> > When I try to chand payment method to Purchace Order. This is happening
in
> > several versions of Emerald. 2.5.267 is the current version on this
> > machine. Same thing is happening with newer versions.
>
> If you do a:
>
> Select * From PayMethods, do you have a "Purchase Order" entry?
>
> --
>
> Dale E. Reed Jr. Emerald and RadiusNT
> __________________________________________
> IEA Software, Inc. www.iea-software.com
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart