The customer price being imported via XML sales order import is being ignored

Owned by Beth Blok (Unlicensed)
Last updated: Nov 21, 2022 by Mike SheenVersion comment
1 min read

Problem

Importing sales orders uses the debtors specific price and appears to be ignoring the price that is in the XML file. 

Solution

the tags have changed between 6.5.13 and Version 7.  The way to see what tags are used to resolve this issue is to create a sales order in Jiwa that gives you the result you want to be imported - i.e. change the Ex GST Price from the price that is defaulted into Price Ex, save and then export the XML.  Review the file in Notepad and locate the relevant tags.

Price = price Jiwa calculates for this customer for this item for this quantity - tag is PriceExGST.  In this example it would be the Debtor Specific Price
Price Ex = the price I am charging the customer - tag is DiscountedPrice (this is the tag to imported for the price to be charged to the customer)
Price Inc = the Inc GST Price being charged - tag is PriceIncGST etc 

Extract from the XML file

<PriceExGst>150.000000</PriceExGst>
<PriceIncGst>148.500000</PriceIncGst>
<DiscountedPrice>135.000000</DiscountedPrice>
<TaxToCharge>13.500000</TaxToCharge>

The tag you need to bring in the price for the customer is DiscountedPrice.