Page 1 of 1

Price Ex and Price Inc

PostPosted: Fri Mar 09, 2018 12:51 pm
by enueca
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.

Re: Price Ex and Price Inc

PostPosted: Fri Mar 09, 2018 1:13 pm
by Scott.Pearce
What if you only provide one of "PriceExGst" and "PriceIncGst"?

Re: Price Ex and Price Inc

PostPosted: Sun Mar 11, 2018 1:22 pm
by Mike.Sheen
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.

Re: Price Ex and Price Inc

PostPosted: Wed Mar 14, 2018 9:04 am
by enueca
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.

Re: Price Ex and Price Inc

PostPosted: Wed Mar 14, 2018 10:02 am
by Mike.Sheen
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.

Re: Price Ex and Price Inc

PostPosted: Thu Mar 15, 2018 4:04 pm
by enueca
Tried providing only the DiscountedPrice, but PriceExGST still being overwritten by some other amount.

Re: Price Ex and Price Inc  Topic is solved

PostPosted: Thu Mar 15, 2018 4:08 pm
by Mike.Sheen
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.

Re: Price Ex and Price Inc

PostPosted: Thu Mar 15, 2018 4:11 pm
by enueca
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.

Re: Price Ex and Price Inc

PostPosted: Thu Mar 22, 2018 10:43 am
by Mike.Sheen
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