B1 Sap error -5002: 10000100 - Document total value must be zero or greater than zero

[mihamuro]

Hi, we are currently using Api with SAP Business One 10 to upload Returns to SAP.

We are using next querry but receiving Sap error -5002: 10000100 - Document total value must be zero or greater than zero:

<BOM>
<BO>
<AdmInfo>
<Object>16</Object>
</AdmInfo>
<ORDN>
<row>
<NumAtCard>FWIZ0000001</NumAtCard>
<DocDate>20240814</DocDate>
<DocDueDate>20240814</DocDueDate>
<CardCode>510000000</CardCode>
<CardName>Victory Supermarkets Ltd1</CardName>
<DocTotal>NULL</DocTotal>
<Address>Big St 29, Marseille, France</Address>
</row>
</ORDN>
<RPD1>
<row>
<LineNum>1</LineNum>
<ItemCode>4a1848dd-52f5-11ea-b82b-00505697fa93</ItemCode>
<Quantity>5</Quantity>
<Price>3</Price>
<unitMsr>pcs</unitMsr>
<AcctCode>70000000</AcctCode>
</row>
</RPD1>
</BO>
</BOM>

Any help will be highly welcomed.

[Felipe_Lima · Accepted solution]

Hi @mihamuro ,

I'm not a technical expert, but your XML looks weird to me, in the row level bit specifically. From my understanding, ORDN should have RDN1 as its line-level child, not RPD1 as you shared here. Hence, DocTotal is 0 as there are no lines feeding it.

I hope it helps.

BR,
Felipe

[mihamuro · Accepted solution]

Felipe, actualy it helped! Thank you for the help and сommunity сontribution.