Topics Map > Accounting > Accounts Receivable

UAFR - Fix an Accounts Receivable Feeder File that has Errors

This job aid will help you Fix an Accounts Receivable (AR) Feeder File that has Errors.

NOTE: You will need to remove the "Copy of" and "-ERROR" segments and add periods back into the file name since they were removed because the file had an error(s).

Example: Copy of fi_ar_feeder1 mhosp 20151210090002 xls-ERROR should be fi_ar_feeder1.mhosp.20151210090002.xls

NOTE: You have to delete the entire column and not just the content in the individual cell or the file won't process correctly.

To do this, place your mouse at the top of the column above the first row (you will see a black down arrow), then right-click and select Delete from the menu.

  1. Open your email with the Subject: "Processing Results."
  2. Save the email's attached [error] file to your desktop or a folder.
  3. Open the attachment.
  4. Scroll to the right of the file and look for the error message(s) ERRORMSG
  5. Make the corrections that are designated by the error message
  6. Delete the columns titled "FILEINENUMBER" and "ERRORMSG."
  7. Save the file with a new name and then upload the file by following the steps under the Upload Accounts Receivable (AR) Feeder File job aid.

KeywordsAR   Doc ID135169
OwnerLearning Systems SupportGroupUI Training and Development Resources
Created2024-01-31 15:59:55Updated2024-01-31 16:01:03
SitesUniversity of Illinois Training and Development Resources
Feedback  0   0