Versions Compared

Old Version 1

changes.mady.by.user Knowledge Assistant

Saved on

compared with

New Version Current

changes.mady.by.user Knowledge Assistant

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.




Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleDescription of Issue

Miscellaneous Cash Import Error on Output-Process

Additional information concerning a status error of 100 [100]

Error executing selectAdjustmentId

...

Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleCause

In this scenario, users may receive this error when attempting to Output-Process an import to create a Payment Batch. This can be due to the formatting in Date Fields in the import file and in this scenario the import file might not have leading zeros in the dates. 


Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleResolution

To resolve this issue, please add a leading zero to any date columns. This may require column formatting changes in the Excel file if this is a .xlsx file. This can also be done if the file is converted or already a .csv (Comma Separated Value) file and opened in Notepad or Notepad++ where adding a leading zero(s) to the dates should stick, import and Output-Process accordingly.


Panel
borderColor#03396c
titleColorWhite
titleBGColor#03396c
titleAdditional Information

The below information can assist with the Resolution above:

Dates

There are three ways to ensure Munis properly parses your date in a CSV file.

  1.  Include slashes in your date in the format mm/dd/yyyy (3/5/2021). Munis will recognize this format as a valid date even without the leading zero.
  2.  When entering your date into a cell, start by typing an apostrophe (') before typing the full date in the format mmddyyyy. The apostrophe forces Excel to treat the contents of the cell as plain text rather than a number, as in 03052021.
  3. Specify formatting for the cell (right-click and choose Format Cells…) using a Custom format of “mmddyyyy”.

ZIP Codes

ZIP Codes are a bit more complex because there are two options: 5-digit and ZIP+4.

By default, data entered as a ZIP+4 will already be treated as text and Excel will not drop the leading zero. You can also prefix a ZIP+4 with the apostrophe (described above for Dates) and without affecting the output (i.e. it will not drop the leading zero).
Users can prevent the leading zero from dropping from a 5-digit ZIP code using the following two methods:

  1.  When entering your date into a cell, start by typing an apostrophe (') before typing the ZIP code in the format 00000. The apostrophe forces Excel to treat the contents of the cell as plain text rather than a number, as in 04096.
  2. Specify formatting for the cell (right-click and choose Format Cells…) using a Custom format of “00000” (that’s five zeroes) - The one method that works for both 5-digit and ZIP+4 is the apostrophe. There is no method we are aware of to Format Cells to work with both 5-digit and ZIP+4.

...