Minimum Requirements for Miscellaneous Cash Payments Import File

When testing Miscellaneous Cash Payments Imports, it is recommended to begin by first importing a file that meets the basic requirements

• Munis
• Miscellaneous Cash Payments Import

Informational

Create a basic standard layout Miscellaneous Cash Payments Import .txt file by following the below example:

H000009122007                                        1                               

DADMN   0000001000

Header line:

• Position 1 is “H” for header
• Positions 2-5 is fiscal year (0000 specifies current default fiscal year)
• Positions 6-13 Payment Date (all 8 positions must be populated)
• Position 54 is the Payment Method (refers to payment methods as defined in the Payment Methods program; leave spaces for preceding positions)

Detail line:

• Position 1 is “D” for detail
• Positions 2-7 are the charge code (be sure to enter an active charge code; leave spaces for unpopulated positions)
• Positions 8-18 are the Payment Amount. Must fill all 10 positions, utilizing leading zeros (in the example, 0000001000 = 10.00)

When formatting a Miscellaneous Cash Payments Import File in Notepad or Excel, unseen special characters can be entered to represent spaces. Payment Method is Invalid Error Miscellaneous Cash Payments Import