Versions Compared

Version Old Version 27 New Version 28
Changes made by

Pat Zelei

Pat Zelei

Saved on

Key

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


Panel

Table of Contents


Refunds

...

  1. From the Transaction menu, select "Refunds".
  2. Click on 
  3. Enter in desired information from the refund.
    1. If creating a refund check, select Create Check' which then opens the Check Date, Bank Account, and Vendor Number fields for data entry. 
    2. click on  to add line items.


    3. To enter an account code:

      1. Use the drop down to select an account
      2. Begin typing the account code to narrow down the selections 
        1. Note: When typing the account code it is necessary to include the hyphens 
      3. Use the Image Modified icon to open a pop up window for the account search
        1. The account search option includes the FYTD Received and FYTD Percent Received amounts
  4. Click on Save to post the refund to the system.  Click on Cancel to cancel out of the transaction without posting.  

...

  1. Search desired transaction  on grid
  2. Click on Image Modifiedto edit the transaction
    1. Make desired changes
  3. Click on Image Modified to save desired changes, click on Cancel to not post the changes and return to the grid.


Print Refunds

Click on Image Modified to generate a copy of a posted Refund in a XML or PDF format.  Users have the ability to print a single Refund or select several refunds at one time to print in a batch. 

...

  1. Search for desired refund to be deleted.
  2. Click on the Delete icon 
  3. Confirm you want to delete Yes or No

Import Refunds

The Import Refunds option may be used to import Refunds from a spreadsheet (CSV format).  Please refer to the Refund Import Criteria for details on the CSV file format.  A template spreadsheet is also provided below.  Any rules pertaining to Refunds will also be applied when importing Refunds.  

  1. From the Transaction menu select "Refunds."
  2. Click on Image Added to import from Refund grid.
  3. Click on "Choose File," browse for the file (.CSV) and click "Open" or select the file by double-clicking on the file name.
  4. The selected filename will be visible to verify the system is ready to Load the proper file.
  5. Click on "Load" to process the chosen file and post the transactions.
  6. A message box will appear showing the number of Records Loaded and the Number of Errors. 
  7. An output file named “USASLOADERR.CSV” will be created containing the number of records loaded or records with errors. 
    1. If there are records that did not load, the file will contain only those records that did not load successfully and will provide error messages explaining why. 
    2. If there are no errors, the file will say "No errors. Records loaded: #" where # is the number of records successfully loaded.
  8. If an error occurs, open the output CSV file to read the error, make the necessary corrections, and re-import the corrected file.

Refund Import Criteria

Please use the template spreadsheet containing the fields in the proper format (listed in the table below).  If you are not using the template spreadsheet and instead using a spreadsheet of your own, the field names on the spreadsheet must exactly match the Field names listed below.  The field names are not case sensitive, but must be entered exactly.    Please note, the fields specified below as "Required field" are the only fields that must appear in the spreadsheet.  All other fields are optional.


Field   

Format

Definition

Refund #An integer with a maximum of 8 digits.Enter a refund # or if left blank, the system will auto assign.
DateAcceptable formats as used in UI can utilize '/' slashes or '-' hyphens or numbers only (no delimiter). 

MMDDYYYY
MM/DD/YYYY
MM-DD-YYYY		Enter date or if left blank, the system will default to current date.
Line NumberMust be a number.Required field must be an integer. The first item for each refund must start with the number 1 or the transaction will not be imported. If you are entering multiple items for the same receipt number, please increment the line number accordingly.
Item DescriptionItem Description with a maximum length of 3000Description of the item
AmountMust be a number. Cannot use $.Required field. If a whole number is used, a decimal is not needed to be entered.  i.e. 16 can be entered for 16.00
Full Account CodeMust be formatted with the hyphen as the delimiter as in the UI.  (i.e. 001-1740-0000-000000-101)Required field (only if an Xref Code is not included)  The type of Account used must be a revenue account.
Refunded ToMaximum length is 3000 charactersDetails of where the transaction was refunded to.
DescriptionMaximum length is 3000 charactersDescription of transaction header for refund.
Xref CodeAccepts numeric and alphanumeric characters.  Must match the existing xref code for the account (it is case sensitive).Unique code that corresponds with the Full Account Code. 
Create CheckTrue/False or T/FIndicates if a check should be created for the refund. If left blank it will default to false.
Bank Account #Must be a number.Not required. Will default to the default bank account if a bank account number is not specified.
Check DateAcceptable formats as used in UI can utilize '/' slashes or '-' hyphens or numbers only (no delimiter). 

MMDDYYYY
MM/DD/YYYY
MM-DD-YYYY		Enter date or if left blank, the system will default to current date for the created check.
Vendor # / Vendor NumberMust be a number that matches an existing vendor.Only required if create check is true.



More Information

Individual user refund processing is controlled by a variety of variables, such as User account where the Account Filter and Role are defined for each user, Rules, etc.

...