Self-Serve Utility - Remove Invoice Correction

Updated September 20, 2023 19:09

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.

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.

Navigate to Start Page > Actions menu > Admin Tools > Category = System > Report > Advance Query tab
Type the name of the targeted AQ in the Title column to search for the Query by name.
Click the row of the Query in the grid.
In the Advance Query Users section, select User or Group.
Place a check mark in the User or Group check box to enable the query for that user or group.
Click Save.
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.

Navigate to Start Page > Actions menu > Admin Tools > Category = System > Report > Advance Query tab
Type the name of the targeted AQ in the Title column to search for the Query by name.
Click the row of the Query in the grid.
In the Advance Query Parameter section, select Pareameter Name @Phase.
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
Click Save.
- The application may have to be restarted for the AQ change to take effect.

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

From the Main Menu, navigate to Report > Reports
From the Report Category list, click Self-Serve Utilities.
Select the AQ from the Report area on the right. The AQ opens in a new window.
Enter the invoice number of the invoice being corrected.
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.
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.
Click Run Query. Changes will be made to the invoice per values selected from the Run Phase drop-down menu.

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.