XML Port (import)- decimal fields not working

ccbryan63

Hello. (Nav2009 R2) I have an XMLport pulling records from a text file into the general journal. The XMLport "works", that is it creates records in the journal and populates the fields, but where it fails is it doesn't insert the last three values in each line, which happen to be Amount, Debit Amount, and Credit amount. All the other fields are properly inserted into the journal, but Amount, Debit Amount, and Credit Amount are blank. These three fields look exactly like the others in the text file (except that they are decimal values), and the same as the others in the XMLport (Node Name = Amount; Node type = Element; Source Type = Field; Data Source = Gen. Journal Line::Amount).


The text file is comma delimited, with double quotes around each field. The xmlport properties that seem to be relevant are:

ID: 50100
Name: Import GL
Direction: Import
Format: Variable Text
FieldDelimiter: <">
FieldSeparator: <,>

The fields in the .txt file look like this:

......,"100.44","100.44","0.00"
......,"1023.15","1023.15","0.00"

Looking at the dataport in txt file format I see that those fields are type decimal.

Any thoughts??

Thanks,
Chandler

maniekb

Don't use semicolon, try something else.