Quote prices not appearing in the quote window  Topic is solved

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

Quote prices not appearing in the quote window

Postby JuiceyBrucey » Tue Jan 06, 2026 4:04 pm

Hi,
7.2.1.0
SR 16
I am putting through quotes and including the InventoryID, as well as the PartNo and UnitCost, but the prices are showing up as zero in JIWA quotes.
Here is an example of the payload item I am sending through:
'Lines' =>
array (
0 =>
(object) array(
'ItemNo' => 1,
'QuoteLineID' => '4ef2836c3c5042a8a9bd',
'InventoryID' => '4fe0f3a5ed9f4813a788',
'PartNo' => 'CHOOK2',
'Description' => 'PRO-VIT-MIN COMPLETE POULTRY MIX 20 KG',
'CommentLine' => false,
'QuantityOrdered' => 1.0,
'PriceExGst' => 0.0,
'PriceIncGst' => 0.0,
'DiscountedPrice' => 0.0,
'TaxToCharge' => 0.0,
'TaxRate' => 10.0,
'UnitCost' => 15.8,
'LineLinkID' => '',
'FixSellPrice' => false,
'UserDefinedFloat1' => 0.0,
'UserDefinedFloat2' => 0.0,
'UserDefinedFloat3' => 0.0,
'LineTotal' => 18.5,
'Weight' => 20.0,
'Cubic' => 0.0,
'DiscountedPercentage' => 0.0,
'DiscountGiven' => 0.0,
'QuantityDecimalPlaces' => 2,
'QuantityOriginalOrdered' => 1.0,
'NonInventory' => false,
'CustomFieldValues' =>
array (
),
'KitLineType' => 'e_SalesQuoteNormalLine',
'KitUnits' => 0.0,
),
Everything is working fine apart from the prices showing up in JIWA.
Is everything done correctly from my end?
Does JIWA determine price by what is sent by me, or does it cross check the price based on the InventoryID and the DebtorID?
Thank you.
Cheers
JuiceyBrucey
Frequent Contributor
Frequent Contributor
 
Posts: 188
Joined: Tue Aug 18, 2020 7:19 pm
Topics Solved: 1

Re: Quote prices not appearing in the quote window  Topic is solved

Postby Mike.Sheen » Tue Jan 06, 2026 4:17 pm

Don't provide any prices and we'll work it out. The key one here is the DiscountedPrice.

You're providing 0.00 for the DiscountedPrice, and that's what we'll use. It's just as though the user keyed in ALL the values you've provided.

If you do not include the DiscountedPrice field in the DTO, then we'll follow the business rules and work out the price.

I'm assuming a lot here, because you don't mention how you are creating or updating the quote - you've not specified which route you are using, what REST verb and the payload you provided is not the Json payload, but a PHP representation - which I can understand, but courtesy would be to provide the actual representation of what is sent.
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

Re: Quote prices not appearing in the quote window

Postby JuiceyBrucey » Tue Jan 06, 2026 4:36 pm

Very sorry, sent you the reply that I get from JIWA, not the payload sent.
(This is a quote being created)
This is the items payload:
"Lines": [{
"ItemNo": 1,
"QuoteLineID": "na",
"InventoryID": "4c620d2e0c2e4ca6aaf5",
"Description": "ADVANCE ADULT ALL BREED CHICKEN CASSEROLE WET DOG FOOD 12X700 GR",
"QuantityOrdered": 1
},{
"ItemNo": 2,
"QuoteLineID": "na",
"InventoryID": "a6f8669405bb40308a13",
"Description": "ADVANCE ADULT ALL BREED CHICKEN CASSEROLE WET DOG FOOD 12X400 GR",
"QuantityOrdered": 1
},{
"ItemNo": 3,
"QuoteLineID": "na",
"InventoryID": "1283e8ef53a040c3a20e",
"Description": "ADVANCE DOG HEALTHY AGE LGE CHICKEN 15 KG",
"QuantityOrdered": 1
}]}

Originally it had prices in it, I removed all price information and sent through another quote, but price still not showing in JIWA.
JuiceyBrucey
Frequent Contributor
Frequent Contributor
 
Posts: 188
Joined: Tue Aug 18, 2020 7:19 pm
Topics Solved: 1

Re: Quote prices not appearing in the quote window

Postby JuiceyBrucey » Wed Jan 07, 2026 5:03 pm

It seems to be working now.
Someone must have fixed it.
Thank you.
Cheers
JuiceyBrucey
Frequent Contributor
Frequent Contributor
 
Posts: 188
Joined: Tue Aug 18, 2020 7:19 pm
Topics Solved: 1

Re: Quote prices not appearing in the quote window

Postby Mike.Sheen » Wed Jan 07, 2026 5:21 pm

JuiceyBrucey wrote:It seems to be working now.
Someone must have fixed it.
Thank you.
Cheers


If that is true, then you should adopt an approach of troubleshooting known as "known goods".

This means creating an environment without any customised plugins or anything else - a standard Jiwa demo database, with our standard REST API plugin and no other custom plugins.

It takes me 9 minutes to create a Windows VM, install Jiwa, create a demo database, configure and start the REST API and verify it is accepting requests.

Spend that 9 minutes and then test your operations against the "known goods" environment - if your problem still occurs, then that's actually good - because that's something we can readily verify and identify a work-around or solution - which means a fast result.

If your problem does not occur in this environment, then you can point the finger at something non-standard and start isolating what that is.

I can also guarantee your known goods environment won't suffer from mysterious fixes of unknown origin.
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 5 guests