Skip to main content

Self-Serve Utility - Remove Invoice Correction

This utility enables the removal of any invoice corrections in branches to which the user has access. This AQ also includes:

  • run phases displaying what information will be updated or removed
  • a table backup in the event the Support department has to restore any data afterward
  • an option to remove associated payments to the invoice
  • All Self Serve Utilities

 

Requirements

The user must have access to Admin Tools.

 

AQ Parametersmceclip0.png

Parameter Description
Invoice Number The unique number of the invoice being corrected.
Remove All AR Payments

Values include:

  • Yes - Removes all AR payments associated with the invoice
  • No - Keeps all AR payments associated with the invoice
Run Phase

Values include:

  • Analysis - displays what information will be updated or removed
  • BackUp - a table backup in the event the Support department has to restore any data afterward.
    • The Commit phase requires a new backup if the last backup took place longer than one hour prior to the latest commit attempt.  
  • Commit - enacts the update or removal of information
    • An analysis is recommended before committing a change.

 

 

User Access

  1. Navigate to Start Page > Actions menu > Admin Tools > Category = System > Report > Advance Query tab
  2. Type the name of the targeted AQ in the Title column to search for the Query by name. 
    mceclip2.png

  3. Click the row of the Query in the grid.
  4. In the Advance Query Users section, select User or Group.
  5. Place a check mark in the User or Group check box to enable the query for that user or group.
  6. Click Save.
  7. A "Save Complete" confirmation pop-up displays. Click OK. The AQ is now available to the selected user or group. 
    • The application may have to be restarted for the AQ change to take effect. 

 

Phase List

  1. Navigate to Start Page > Actions menu > Admin Tools > Category = System > Report > Advance Query tab
  2. Type the name of the targeted AQ in the Title column to search for the Query by name. 
    mceclip1.png

  3. Click the row of the Query in the grid.
  4. In the Advance Query Parameter section, select Pareameter Name @Phase.
  5. Under Value List Source click Edit. It should display:
    SELECT 0 AS INTValue, 'Analysis' AS DisplayValue
    UNION
    SELECT 1 AS INTValue, 'BackUp' AS DisplayValue
    UNION
    SELECT 2 AS INTValue, 'Commit' AS DisplayValue
  6. Click Save.
    • The application may have to be restarted for the AQ change to take effect. 

 

Usage

It's recommended to do a backup by selecting Run Phase parameter = Backup.

  1. From the Main Menu, navigate to Report > Reports
  2. From the Report Category list, click Self-Serve Utilities.
    AQMain.png

  3. Select the AQ from the Report area on the right. The AQ opens in a new window.
  4. Enter the invoice number of the invoice being corrected.  
  5. In the Remove All AR Payments row, select Yes or No from the value column's drop-down menu to choose whether to remove or keep AR payments associated with the invoice. 
  6. In the Run Phase row, select Analysis, BackUp, or Commit from the value column's drop-down menu to analyze what information what will be changed, to back up the invoice data before making changes, or commit a change to the invoice, respectively. 
    • Backup phase is required before applying the Commit phase.
    • The Commit phase requires a new backup if the last backup took place longer than one hour prior to the latest commit attempt.  
    • Payments affiliated with correcting invoice are required to be backed out on commits.
      mceclip1.png

  7. Click Run Query. Changes will be made to the invoice per values selected from the Run Phase drop-down menu. 

 

Results of using the Utility

Removal of any invoice errors will be messaged in the lower-left. Any utility processing errors will also be displayed in the messaging area. 

Error Message Solution
The invoice provided is equal to its own root invoice.  Please provide the invoice number for the correcting invoice you wish to remove. Make sure you entered the correct invoice number
Example: 7122-R2 not 7122
The invoice is equal to the root invoice for another invoice correction.  Please remove that other correcting invoice before attempting to remove this correcting invoice. Make sure you entered the correct invoice number
Example: 7122-R2 not 7122
Invoice number does not exist or you do not have permission to its branch. Verify you have access to that Invoice and that it's a valid Invoice number.
 
Note: if there are multiple corrections, all corrections in a sequence need to be removed to make a new invoice correction.
 

Analysis

mceclip6.png
 
mceclip4.png
 
 

Backup

mceclip7.png
 

Commit

mceclip8.png
 
 

Articles in this section

Was this article helpful?
0 out of 0 found this helpful
Share

Comments

0 comments

Please sign in to leave a comment.