Journal Import - Unable to import journal - DateTime data found with invalid format at cell

Description of Issue

When importing a journal through the Import Journals program, the following error occurs:

Munis (Glimptje)
Unable to import journal(s)
Message="Unable to load import file
Message="Flat file loader failed.
Message="Unable to process import file.
Message="DateTime data found with invalid format at cell

Context
  • Import Journals

  • Excel

  • Cell Format

Cause

Excel cell formatting incompatible

Resolution

Excel cell formatting must be updated to be compatible with import by using text or other that will not enter time data

Additional Information

Text is the suggested cell format for excel imports into EERP

Â