Skip to Content
0
Jun 20, 2014 at 07:11 AM

Error when adding an Invoice

157 Views

Dear all,

I get the error below whenever i add an A/R Invoice copied from a Sales Order.

[Microsoft][SQL Server Native Client 10.0][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. (CINF)

My G/l account are set per item group. I have no Transaction notifications on my database, neither do i have formatted searches.

I run a query on the CINF table of the database, and below is what i got.

Version CompnyName Flags InfoL1 InfoL2 InfoA1 InfoA2 ACTStamp ADMStamp RTTStamp CINFStamp LawsSet EnblVatGrp EnblVTGPmn VatOOS_O VatOOS_I VatStnd_O VatStnd_I VatExmpt_O VatExmpt_I VatHalf_O VatHalf_I VatZrRt_O VatZrRt_I MaxActGrps EnblDctSrc EnblRCN EnblCorINV EnblCshRep EnblIRTRep EnblTrnRep EnblVPMRep EnblACTRep EnblFTZ EnblSlfPCH EnblPCHUpd EnblRsvINV EnblRTDnld RTTDnldAdr ZPrcCode EnblExpns EnblRtrRep IsEC EnblCshDsc EnblLostCD NumActLvls EnblRealRD EnblVTGNoD EnblGLManP EnblOptVIP EnblActCrC EnblFrnAct EnblECAct EnblECRpt EnblRound EnblPrVatS EnblYrTrns EnblActTtl EnblDocWrn ActSegNum EnbSgmnAct SizeOfSeg0 SizeOfSeg1 SizeOfSeg2 SizeOfSeg3 SizeOfSeg4 SizeOfSeg5 SizeOfSeg6 SizeOfSeg7 SizeOfSeg8 SizeOfSeg9 Rprt1099 MultiAddss EnbDunning EnbQtyEDln Itw1Date Itw1Time Itw1Count EnbPayRef EnblDfrTax EnblClsPr EnblTaxEL EnableBOE EnableWHT EnblEquVat EnblFAsset EnblDoubt RateBase BOEStatClo ARDocsInWT BISBnkCnt BISRBnkCd BISRBnkAc BISRBranch EnblBPConn EnblVATDat EnblStAgRp EnblCARepo EnblMatRev EnblMBPRec CshDscGros EnblTaxInv EnblCorAct EnblRuDIP EnblCurDec EnblPayMtd EnblBaseUn EnblVATAna EnblExREnh VATGrpCal MaxChoose EnblInfla EnblLAWHT EnblRTWHT ChkQunty SriMngSys BtchMngSys SriCreatIn EnblFolio EnblDocSbT IepsPayer DaysOrdCnc EnblLATaxS PercOfAcq MinBaseDoc EnblDpmJdt EnblDownP EnblNDdctC DocNmMtd DoFilter EnblOnPDCh EnblOnWnCr EnblDefInx EnblMxComm EnblIndxOp EnblSbtCVo MinAmntOAP CredSumm PostdChk PostdCred CredVend WkoStatus DispTrByDf stampTax MinAmntAL BlockZeroQ AutoCrIns EnbRepomo RFCValidat MxDcsInPmt RelStkNoPr CashDisc EnableSMS EnblIndic EnbFedTax EnblCounty Language ChkIntgUpd ChkIntgCre BisBnkAcKy EnbZeroDec EnbDecWord ChkWrdOnly EnBnkStmnt CalcVatGrp TaxSysType ESEnabled RateTotal CompanyHis EnblAssVal CompanySta eFRTActLvs TaxGrpType InstallNo IsOldPA EnbNegDoc Algo ArcComp UpdatedTF DARDBGUID NegStoLv SPNEnabled PrsWkCntEb DashbdEb BoxEffDate LogInstanc UpdateDate UserSign2 SnapShotId CreatedBy B1SgtEb IsHConEnv B1BuzzEb IMCEEnable DKeyId ResetDData ConvDifAct BasEffDate oldFxAss EnblSPEDUF DpmAffTot AliasUpd TrailDays TestComp 900059 CONSULTANTS THRIFT SHOP NNNNNNNNNNNNNNNNNNNNNNNNNNNNNN NULL NULL NULL NULL 0 0 0 0 GB L Y X0 X1 NULL NULL NULL NULL NULL NULL NULL NULL 8 N N N N N N N N N N N Y N NULL Centr_z N NULL Y V NULL 5 Y Y NULL NULL Y Y Y NULL Y Y N NULL NULL 0 N 0 0 0 0 0 0 0 0 0 0 N NULL Y NULL NULL NULL NULL NULL N NULL NULL N Y N NULL Y P NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL N NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 NULL NULL NULL Y A R N NULL NULL N 30 NULL 0.000000 0.000000 Y Y NULL NULL N Y Y Y Y Y Y 0.000000 Y Y Y Y N Y NULL 0.000000 Y N NULL NULL 0 N Y NULL NULL NULL NULL 8 Y Y NULL N N Y Y Y C Y N WLmoDoOSCMGhoQ0p5Je2VAuNuIsxs+xwkjJ00iqy26uhiWnqPsyY+k2y+UmG7nO3byikDfh5owQFqeE4luz3EY+wnL2U/4klc8WP9Wt0fLhV/MRbHHlzF3AWWr1A1uvApg2LE/WvPXA+PLNE054RPBM7c6tR9aVxe97Iz/WxgWWnTCQtDjrh1/nNznSyWDz7VEYCEIVNR6yIvONUcxXZ+a1645XBXnDSTpfAnmTwTqldT7DQrYspoXF6/E2jiAF9gbsZhIVsgPMqPFrau7TiBVG9SZQVcGL9YpJPdUTv32AxKwcqOmEM1xwjjRQpXyRjMw4LXwtH7jixO1d82HTNl60HoEnjiUQ8AaoKyo77vlXoqi7QZwQQzTFhPJ0M8she2KMYh++m1k5nNDwsgjEy9vh979EZHETvMbVzMecAAMBZPXSVN/4YdBaXDi0zcsZonEeYJcX8FuzHUWS1r389szsaHCrnEjyg2DImITit4H9dQP9AtMxqvyz5ItzbRjMFoFIoYOHzf6kD89EDiNA7ZMa0qyNiSs/KZ/qQJvfkbvNUwseWsW5H2l1rctA+sHOSJUXmBb7aJPOQBT4YquTQvj+qtd/15NkahbDiECZMRPgjzA4nLrLRGD4P/0RFPMHOY9A1KTLIy5jyi5xwz9HSJM6nJvtwDacdli9etIgAngySHOAk5vbA9u4645iAc+GlUN5RzJ0AsjsKb676NPGiN9hqrhH47s9tyGjWHTT1m35mPwEaUesmnfxnqgK2QZpHRApFDwPTkOXDT1sihc/fyWAQAUSJ+NVN N V NULL C 0020499568 N Y 2 N N NULL I Y N N NULL 0 NULL NULL 0 N Y N N N N Y NULL N N Y ccZ4OznhLdCkLrrBZhhrLiWoR0Di2TmV0CmEQ+FlmlOfwvBRPMXpUw== NULL N

I am using SAP 9.0 PL 07

Please advice further