Description of Issue

Miscellaneous Cash Import Error on Output-Process

Additional information concerning a status error of 100 [100]

Error executing selectAdjustmentId

Context

Munis
Accounts Receivable
Miscellaneous Cash Import

Cause

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.

Resolution

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.

Additional 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.

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.
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.
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:

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.
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.

Browser not supported