RE: Pre-payment 03.020.00 getting 6002 error auto numbering in effect
Hello JECI,
I see a bug for 6002 "Auto numbering in effect, entry in field will be overridden" when using possible values to pull up a reference number in the Quick Voucher and Prepayment screen.
Is this what is happening when you attempt to select the PP?
. A summary of the solution is detailed below.
• Symptom - Msg 6002 when F3 on refnbr in Quick Voucher/Prepayment screen
• Cause - Bug 25107.
System message 6002 when hitting F3 in the reference Nbr field in the Quick Voucher and Prepayment Entry screen if the company ID is greater than 4 characters.
• Resolution –(run the application db in Sql server query analyzer)
Alter Procedure APDoc_QCPP_RefNbr @parm1 varchar(1), @parm2 varchar (10), @parm3 varchar(10) as
Select * From APDoc
Where DocClass = @parm1 and CpnyID = @parm2 and (APDoc.DocType = 'VO' OR APDoc.DocType = 'PP')
and APDoc.RefNbr LIKE @parm3 and Status <> 'V'
Order by RefNbr
Thank you!
Jana MacDonald