Pages

Monday, February 11, 2013

Disabling Accounts using Concurrent programs

There are two useful concurrent programs you can leverage in GL to disable accounts en-mass.

 Program - Inherit Segment Value Attributes

 When this program is run it will automatically propagate the attributes of a segment value to all account code combinations which contain that segment value.This feature eases chart-of-accounts maintenance by automatically replicating changes in segment value attributes to the accounts containing each segment value. For example, if you disable a particular cost centre segment value in the Segment Values window, you can optionally require that all accounts which contain that cost centre are also automatically disabled.
You need to run this program (from the Submit Request window), there are no parameters to define. The program automatically updates the accounting flexfield structure assigned to the set of books for your responsibility.
Use the Segment Value Inheritance Execution Report to view the account code combinations which have been changed. This report is automatically generated on completion of the Segment Value Inheritance Program.
 ____________________________________________________________
Prevent Action
Individual segment value attributes override account code combination attributes.You can prevent selected accounts from being affected by segment value attribute changes by selecting the 'Preserved' check box in the GL Accounts window.
>>Setup>>Financials>>Accounts>>Combinations 

 Cross Validation Violation Report

Accounts that violate CVR can be automatically disabled too
The standard GL report "Cross Validation Violation Report" has an option to disable all combinations violating the rules.  

The following have to be added to the GL Super User (and any other Resp that plan to use them)