Jiwa

I am trying to import a Purchase order using import from XML ( manually using the utilities tab )
The PO lines gets populated correctly however there are a couple of issues

1. The Creditor Name does not appear
2. The Product descriptions do not appear

when I hit Save , I get the following error

"Error : The parameterised query '(@OrderNo varchar(6) , @CreditorId char(2) , @OrderType smallint , @Or expects parameter
@Header1 ' which was not supplied .
module onerror"

I have attached the simple xml file I am using.

any help is appreciated.

I've found this to be 3 separate bugs.

I have taken the liberty of testing this and logging the 3 separate bugs for you - they are 11964, 11965 and 11966

Hi Mike,

Noting the bugs have been marked as fixed I have downloaded the latest patch 134 and tested.
The reported 3 bugs are gone but have a couple of new ones. Appreciate your attention.

the new findings. As below.
A sample xml file is attached.
1. The PO reference does not show on the screen after import but shows after hitting the save ( minor
issue but could confuse the user as they will think the reference did not come through ).
Can live educate the user on this for now.
2. Major issue - The tag <cost> is used to import the ExPrice and Jiwa Rounds off this. Such as
38.5 becomes 39 and 31.4 becomes 31

indikad wrote:2. Major issue - The tag <cost> is used to import the ExPrice and Jiwa Rounds off this. Such as
38.5 becomes 39 and 31.4 becomes 31

FYI this was fixed in bug 12002, and there is a workaround. When you export a PO to XML, you'll note there is a "HomeCurrencyDecimalPlaces" tag for each PO Line. The Import of a PO from XML assumes this tag to be present - and incorrectly does not fallback to the local currency decimal places if not supplied. The bug addresses this, but for now just supply the tag and you'll have your price precision back.

tested the workaround on patch 134. Working.
Thanks Mike.