format of Unit Price during import

dago

Hello when i am importing sales invoice from xml file where the unit price is e.g. : 234.564 it doesnt work.

How can i change the format during export to this number : 234,564 ??

ramiresreis

in excel?

dago

no
in navision, I am tryig to import data from xml file to NAV. to be exact: from sales invoice to purchase order

ara3n

change the element to text, on trigger Import::OnAfterAssignVariable() add code to convert period to comma and move then assign it to a decimal value.

dago

can you help me with such code, please.
I have tried command FORMAT accoording to NAV Help but didnt understand...

Thanks

ara3n

here is the code for export.

Export::OnBeforePassField()
MyText := format(MyDecimal);
MyText := CONVERTSTR(MyText,'.','~');
MyText := CONVERTSTR(MyText,',','.');
MyText := CONVERTSTR(MyText,'~',',');

Basically I'm changing dot to ~ first, then changing comma to dot, then changing ~ to comma.

dago

what should i put instead of MyDecimal ??

Savatage

Basically Mydecimal would be the number you want to fix (unit price) if that's the problem #.

Format will change the decimal to text - then you can corrrect the text version of the unit price.

PS..The evaluate function can be used to change the text back into decimal.

dago

well, my question is what this will do :

unit_price := format(*******);
unit_price := CONVERTSTR(unit_price,'.',',');

what should i put instead *****
the exact number from the sales invoice or what should be there?