Adjustments import interface

The adjustments interface allows the bulk import of adjustments, which can all be loaded into Utilmate and applied to a customer account. This interface is useful for scenarios where you wish to apply an adjustment to a large group of customers.

The "Interfaces\Adjustments Import" folder is polled at 12pm each day.

1. If the file is successfully processed it is placed in "Interfaces\Adjustments Import\Archive".
2. If it is not able to be processed it is placed in the "Interfaces\Adjustments Import\Error" folder with an error file explaining why.

This interface can also be manually run at any time from the Scheduled Tasks screen.

File Format

Must be a CSV file with the following columns (Bold = Mandatory):

account_number - the account number must be a valid account number in Utilmate. If an account number cannot be found, the file will error with an error message explaining the account number that cannot be found.

adj_reason_code -the adj type must be a valid and active adjustment code in Utilmate. If an adjustment type cannot be found, the file will error with an error message explaining the adjustment type that cannot be found. The list of adjustment codes can be seen on the Adjustments maintenance screen.

adj_date - the adj date must be a valid date in DD/MM/YYYY format.

post_adj - if Post is set to "Y" the adjustment will automatically be approved and posted to the customer's account. If Post is set to "N" the adjustment will appear in the Charge and Adjustment Approval Screen for a user to approve.

adj_amount - the amount must be a positive value without the $ or any "," thousand separator. The adjustment type controls if it is a debit or credit adjustment. 

notes - optional notes to add in the notes field on the Accounts Receivable > Transaction List screen.

See below sample adjustment import file.