Error when adding an Invoice

[former_member454461]

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 

[kothandaraman_nagarajan · Accepted solution]

Hi,

Please check if any,

1. FMS

2. Transaction notification

3. Approval procedure.

Thanks & Regards,

Nagarajan

[former_member454461]

Dear Silambu,

my query was

Select * from CINF

[kothandaraman_nagarajan]

Hi,

As per above query, sure it will return more than one value. Modify your query if needed,

SELECT Version FROM Cinf

Please refer SAP note:

1988426 - The Formatted Search triggers on a field with no
updates

Thanks & Regards,

Nagarajan

[silambarasan_rajendran]

Hi Anne,

Nagarajan sir is correct.

Please check Transaction notification that associated with other objects. i.e 30  - Journal Entry.

Regards,

silambu

[former_member454461]

Hi Silambu and Nagarajan,

thanks a lot for the help.

There was a part of a TN that had not been commented out.

issue resolved

[silambarasan_rajendran]

Hi,

Check your query with passing parameter.Your sub Query returns more than one value for assigning single value.

can you post your query?

Thanks & Regards,

Silambu