Journal Import amounts inconsistent when using Insert a Decimal point when missing option
Description of Issue
Journal Import option 'Insert a decimal point when missing' is inconsistentÂ
Some journals import values correctly while others do not
Context
Import Journals
Cause
Custom or incorrect formatting on Import File.Â
Resolution
Review import files. Establish a standard for importing if multiple users are importing journals through the Import Journals program to help eliminate inconsistencies with imported files. All cells in import file should be formatted as either Text or General.Â
If amounts already have a decimal point in the import file, do not use the option 'Insert a decimal point when missing'.Â
Additional Information