Hi,
Since we upgraded GP to 18.7, all users are experiencing freezing issues whenever they try to scroll through the Purchasing Receipt Numbers Lookup window. Sometimes it takes about 10 mins to free up. There are more than 15K records in POP10300 and I see from the trace that the below query runs continuously until it reaches the last RCT number. Is that a normal behavior? I dont know if it is just a coincidence that we have more number of Receiving transactions unposted or is it something else. Any insight is appreciated. Thank you!
SELECT TOP 25 POPRCTNM,POPTYPE,VNDDOCNM,receiptdate,GLPOSTDT,ACTLSHIP,BCHSOURC,BACHNUMB,VENDORID,VENDNAME,SUBTOTAL,TRDISAMT,TRDPCTPR,FRTAMNT,MISCAMNT,TAXAMNT,TEN99AMNT,PYMTRMID,DSCPCTAM,DSCDLRAM,DISAVAMT,DISCDATE,DUEDATE,REFRENCE,RCPTNOTE_1,RCPTNOTE_2,RCPTNOTE_3,RCPTNOTE_4,RCPTNOTE_5,RCPTNOTE_6,RCPTNOTE_7,RCPTNOTE_8,POPHDR1,POPHDR2,POPLNERR,POSTEDDT,PTDUSRID,USER2ENT,CREATDDT,MODIFDT,TRXSORCE,VCHRNMBR,Tax_Date,CURNCYID,CURRNIDX,RATETPID,EXGTBLID,XCHGRATE,EXCHDATE,TIME1,RATECALC,DENXRATE,MCTRXSTT,ORSUBTOT,ORTDISAM,ORFRTAMT,ORMISCAMT,ORTAXAMT,OR1099AM,ORDDLRAT,ORDAVAMT,WITHHAMT,SIMPLIFD,BNKRCAMT,ECTRX,TXRGNNUM,TAXSCHID,TXENGCLD,BSIVCTTL,Purchase_Freight_Taxable,Purchase_Misc_Taxable,FRTSCHID,MSCSCHID,FRTTXAMT,ORFRTTAX,MSCTXAMT,ORMSCTAX,BCKTXAMT,OBTAXAMT,BackoutFreightTaxAmt,OrigBackoutFreightTaxAmt,BackoutMiscTaxAmt,OrigBackoutMiscTaxAmt,TaxInvReqd,TaxInvRecvd,APLYWITH,PPSTAXRT,SHIPMTHD,DocPrinted,Total_Landed_Cost_Amount,BackoutTradeDiscTax,OrigBackoutTradeDiscTax,CBVAT,VADCDTRO,TEN99TYPE,TEN99BOXNUMBER,REPLACEGOODS,INVOICEEXPECTED,PrepaymentAmount,OriginatingPrepaymentAmt,POP_HDR_Errors_4,DISTKNAM,ORDISTKN,DISAVTKN,ORDATKN,InvoiceReceiptDate,Workflow_Status,DEX_ROW_ID FROM PRO.dbo.POP10300 WITH ( NOLOCK, READUNCOMMITTED) WHERE (POPRCTNM < 'RCT0574187 ') ORDER BY POPRCTNM DESC
1,881
Share
Report
All responses (
Answers (
