Sage 100

When importing from an ACII source file -- do you need the source file to have decimals in the dollar amounts? Someone on LinkedIn was trying to import to BR_Transaction and I found that unless I had decimals it imported as whole dollars. I don't do many ASCII source imports so I can't say if this is standard functionality (need the decimal in the source when ASCII) or a possible 4.5.0.3 bug in VI?

I'd imagine you'd need the decimals, but that's an assumption. I don't recall the last ASCII source file import (with dollar amounts) that I've done.

Me neither - I can't remember if it's a bug or whether you need to have decimals.

Wayne, do you mean is it assuming decimal places? It won' t do that the source file has to have a decimal place if you want the last 2 digits to be cents.

This probably goes without saying but you can alway import the value as a whole dollar amount into a variable and then use the variable in a calculation to impute the decimal. Based upon past experience, the imported amount from a text file is assumed to be a whole number if a decimal is not included in the value loaded. We last did this in 4.4.6. (Loading checks and deposits into BR for outstanding items.)

Thanks - I did use a calculation to get the desired result. I very rarely use straight ASCII.