Created Failed 480000098 - Row in service document must contain description, G/L account, or total

[narayanis]

Hi,

Facing an error while importing customer service invoices in SAP Business One Version 10.

Header template fields are as follows: - 

Series

DocNum

DocType

GSTTransactionType

DocDate

DocDueDate

TaxDate

CardCode

CardName

NumAtCard

BPLId

DocCurrency

DocRate

DocTotal

Comments

Series

DocNum

DocType

GSTTranTyp

DocDate

DocDueDate

TaxDate

CardCode

CardName

NumAtCard

BPL_IDAssignedToInvoice

DocCur

DocRate

DocTotal

Comments

Detail template fields are as follows: -

ParentKey	LineNum	AccountCode	ItemDescription	Price	TaxType	TaxLiable	WTLiable	TaxCode	LocationCode
DocNum	LineNum	AcctCode	Dscription	Price	TaxType	TaxStatus	WtLiable	TaxCode	LocCode

Target data tab of DTW does not show any values for document_lines section.

[felipeprevente · Accepted solution]

Hi,

I would try to use the template in the DTW folder, keeping the correct column order and see if it makes any difference. 

Series as the first column in the Header (OINV) template seems not ideal, as DocNum is your primary reference and they normally go first in a template. Also, I never pass the Series when it is blank unless you are really posting to a specific one.

Hope it makes sense.

Felipe