Line number increment in payload SalesQuotes  Topic is solved

Discussions relating to Jiwa 7 plugin development, and the Jiwa 7 API.

Line number increment in payload SalesQuotes

Postby JuiceyBrucey » Wed Dec 17, 2025 11:23 am

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
JuiceyBrucey
Frequent Contributor
Frequent Contributor
 
Posts: 188
Joined: Tue Aug 18, 2020 7:19 pm
Topics Solved: 1

Re: Line number increment in payload SalesQuotes  Topic is solved

Postby Mike.Sheen » Wed Dec 17, 2025 11:26 am

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.
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2583
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 807


Return to Technical and or Programming

Who is online

Users browsing this forum: No registered users and 1 guest