Page 1 of 1

Line number increment in payload SalesQuotes

PostPosted: Wed Dec 17, 2025 11:23 am
by JuiceyBrucey
Hi,
7.2.1.0
SR 16
I am doing a SalesQuote and have been told there is an error:
"The error is due to the quote when imported into JIWA has no unique Line Numbers
The QO_Lines.LineNum field were all set to 0
Where it should be 1 – 27"

This is part of the payload. Cant put the whole thing unless you need it.
'Lines' =>
array (
0 =>
(object) array(
'ItemNo' => 0,
'QuoteLineID' => '09fff224e9b54b27825d',
'InventoryID' => '48d13cf9a27640c0a09a',
'PartNo' => 'SHOWB',
'Description' => 'LAUCKE SHOWBIRD BREEDER MP 20 KG',
'CommentLine' => false,
'QuantityOrdered' => 4.0,
'PriceExGst' => 21.5,
'PriceIncGst' => 23.65,
'DiscountedPrice' => 21.5,
'TaxToCharge' => 8.6,
'TaxRate' => 10.0,
'UnitCost' => 19.1,
'LineLinkID' => '',
'FixSellPrice' => false,
'UserDefinedFloat1' => 0.0,
'UserDefinedFloat2' => 0.0,
'UserDefinedFloat3' => 0.0,
'LineTotal' => 86.0,
'Weight' => 20.0,
'Cubic' => 0.0,
'DiscountedPercentage' => 0.0,
'DiscountGiven' => 0.0,
'QuantityDecimalPlaces' => 2,
'QuantityOriginalOrdered' => 4.0,
'NonInventory' => false,
'CustomFieldValues' =>
array (
),
'KitLineType' => 'e_SalesQuoteNormalLine',
'KitUnits' => 0.0,
),

Is it 'ItemNo' => 0 that needs to be incremented with each inventory item?
thank you
Cheers

Re: Line number increment in payload SalesQuotes  Topic is solved

PostPosted: Wed Dec 17, 2025 11:26 am
by Mike.Sheen
Either provide a valid ItemNo (integer > 0) or simply do not provide one in the request at all and we will generate a sequential one for you.