Price Ex and Price Inc  Topic is solved

Discussions relating to the REST API of Jiwa 7.

Price Ex and Price Inc

Postby enueca » Fri Mar 09, 2018 12:51 pm

according to the Rest API examples of use when creating a Sales Order:
Note(3): When sales order lines are added, omitting the price will cause Jiwa to determine the price per normal pricing scheme logic.


Provided 3 line items with PriceExGst and PriceIncGst, but prices of 1 of the line items are being overwritten, while the 2 are displaying the values provided in the SalesOrder API.

JSON:
"Lines": [
{
"ItemNo": "1",
"QuantityOrdered": "10",
"PriceExGst": "46.62",
"PriceIncGst": "51.28",

"TaxRate": {
"Description": "GST",
"Rate": "10.00"
},

It's showing Price Ex. as 46.90 and Price Inc. as 51.89, please see attachments.
Attachments
lineitem.JPG
lineitem.JPG (11.69 KiB) Viewed 1569 times
enueca
Occasional Contributor
Occasional Contributor
 
Posts: 13
Joined: Fri Mar 09, 2018 11:55 am

Re: Price Ex and Price Inc

Postby Scott.Pearce » Fri Mar 09, 2018 1:13 pm

What if you only provide one of "PriceExGst" and "PriceIncGst"?
Scott Pearce
Senior Analyst/Programmer
Jiwa Financials
User avatar
Scott.Pearce
Senpai
Senpai
 
Posts: 743
Joined: Tue Feb 12, 2008 11:27 am
Location: New South Wales, Australia
Topics Solved: 221

Re: Price Ex and Price Inc

Postby Mike.Sheen » Sun Mar 11, 2018 1:22 pm

I think what Scott means is what if you provided either PriceExGst or PriceIncGst.

But ultimately the best practice would be to provide only the DiscountedPrice - which is the ExGST price you are selling it at, after any discount. PriceExGST does not include discounts, and I suspect perhaps your debtor is configured with a discount amount, which may explain the difference in what you're supplying to the API and what is being used.

I'd try supplying just the DiscountedPrice and see how you fare with that.
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: 2445
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 757

Re: Price Ex and Price Inc

Postby enueca » Wed Mar 14, 2018 9:04 am

I tried providing the PriceExGst only, and seems that it's still being changed when it gets to Jiwa. According to the supplier, it's correct that they overwrite the prices.
enueca
Occasional Contributor
Occasional Contributor
 
Posts: 13
Joined: Fri Mar 09, 2018 11:55 am

Re: Price Ex and Price Inc

Postby Mike.Sheen » Wed Mar 14, 2018 10:02 am

enueca wrote:I tried providing the PriceExGst only, and seems that it's still being changed when it gets to Jiwa. According to the supplier, it's correct that they overwrite the prices.


Please try only providing the DiscountedPrice.
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: 2445
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 757

Re: Price Ex and Price Inc

Postby enueca » Thu Mar 15, 2018 4:04 pm

Tried providing only the DiscountedPrice, but PriceExGST still being overwritten by some other amount.
enueca
Occasional Contributor
Occasional Contributor
 
Posts: 13
Joined: Fri Mar 09, 2018 11:55 am

Re: Price Ex and Price Inc  Topic is solved

Postby Mike.Sheen » Thu Mar 15, 2018 4:08 pm

enueca wrote:Tried providing only the DiscountedPrice, but PriceExGST still being overwritten by some other amount.


I don't think PriceExGST means what you think it does.

Jiwa knows what it thinks the PriceExGST should be - but what you sell to someone at is the DiscountedPrice - that's what is important to supply for a sales order.
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: 2445
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 757

Re: Price Ex and Price Inc

Postby enueca » Thu Mar 15, 2018 4:11 pm

I don't think PriceExGST means what you think it does.

Jiwa knows what it thinks the PriceExGST should be - but what you sell to someone at is the DiscountedPrice - that's what is important to supply for a sales order.


I am posting the sales order to Jiwa as a buyer. So I think it makes sense that the supplier corrects the PriceExGST based on how much they really sell it. Thanks for the help.
enueca
Occasional Contributor
Occasional Contributor
 
Posts: 13
Joined: Fri Mar 09, 2018 11:55 am

Re: Price Ex and Price Inc

Postby Mike.Sheen » Thu Mar 22, 2018 10:43 am

Hi enueca,

I think you may still have an issue when setting the Discounted price - see this forum post regarding a current known issue and a work-around.

Mike
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: 2445
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 757


Return to REST API

Who is online

Users browsing this forum: No registered users and 3 guests