Group Billing_Reconciliation
The Billing Reconciliation functionality adds new screens, business rules and transactions to process the reconciliation and generate the required policy or client level activities to ensure the monies are applied to the bill detail records.
The Billing Reconciliation is accomplished through two screens; Group/List Bill Search Screen and Group/List Bill Reconciliation Screen. From the Bill Reconciliation Screen, based on the reconciliation action is the ability to trigger specific actions into the Policy/ /Client/ from which the bill detail originates. The same reconciliation could be processed using data intake to process the reconciliation activities.the following.
Business Rules support the Reconciliation process:
Group/List Bill Search (screen)
Group/List Bill Reconciliation (screen)
Bill Detail Search (screen)
Bill Detail Reconciliation Search (screen)
Prototype Configuration Detail Overview MaintainBillDetailReconciliation ( Business Rule)
![]()
With this feature user has the ability to reconcile the bill such that the monies are adjusted against the bill detail.
PrerequisitesFollowing Business Rules should be configured:BillSearchScreen
BillDetailReconciliationSearchScreen
BillDetailSearchScreen
BillReconciliationScreen
User should have access to the following transactions:Reconciliation
ReconciliationReversal
New Items
'BillSearchScreen' Business Rule:
Business Rule is configured to showcase the 'Group/List Bill' search feature.
'Bill Search' screen can be accessed through a new main menu item called 'Group/List Bill'.
<Group> values like 'Bill','BillDetail','BillDetailField' & 'GroupCustomer' are supported for search criteria fields.
Following are the search criteria's configured for prototype scenario:BillDetailReferenceID
CustomerNumber
For Bill records with BillOwnerTypeCode as Group Customer, the Group Customer needs to be linked through the BillOwnerGUID as the ClientGUID of the Group Customer.
For Bill records with BillOwnerTypeCode as Class, the Group Customer needs to be linked through the BillOwnerGUID as the ClassGUID.
Search results are displayed as per the configuration and also default sorted by BillReferenceID.
Following are the fields configured as part of results section:BillReferenceID
CustomerNumber
BillGeneratedDate
Upon selection of any one of the search result then user is navigated to the 'Group/List Bill Reconciliation' Screen.
'BillDetailReconciliationSearchScreen' Business Rule:Business Rule is configured to showcase the BillDetailReconcilationSearch feature which supports editing of the reconciled bill detail records.
Following are the search criteria's configured for prototype scenario:Amount
SuspenseNumber
StatusCode
<Group> values like 'BillDetailReconciliation','BillDetail','BillDetailField' & 'GroupCustomer','Client','ClientField','Policy','PolicyField','Segment' & 'SegmentField are supported for search criteria fields.
Following are the fields configured as part of results section:BillDetailReferenceID
PolicyNumber
SuspenseNumber
Results are filtered based on the criteria entered by the user and upon selection of any one of the search result then user is navigated to the 'Group/List Bill Reconciliation' Screen.
Bill Detail Reconciliation search screen allows user to edit the bill amounts for multiple times before clicking of 'Save' / 'Cancel' button on the Group/List Bill
Reconciliation ScreenWhen user selects 'Cancel' button then the Adjust context is not considered and also user is returned back to initial load of 'Group/List Bill Reconciliation' Screen.
When user selects 'Save' then a confirmation window is appeared and upon confirming the reconciliation entries is saved and associated policy/client/group customer activity is triggered.
'BillDetailSearchScreen' Business RuleBusiness Rule is used for the LinkSuspense purpose and the 'BillDetailSearchScreen' is appeared as one of the part of 'Bill Detail Search' section.
Following are the search criteria's configured for prototype scenario:Amount
BillGroupType
PolicyNumber
<Group> values like 'BillDetail','BillDetailField' & 'GroupCustomer','Client','ClientField','Policy','PolicyField','Segment' & 'SegmentField are supported for search criteria fields.
Following are the fields configured as part of results section:Amount
PolicyNumber
Results are filtered based on the criteria entered by the user.
'BillReconciliationScreen' Business RuleThis screen allows the user to reconcile the Group/List Bill that is selected.
Header section of 'Bill Reconciliation' screen is displayed with the below information:Bill Reference ID
Group Customer Number
Class Name
Group Bill Date
The next section is 'Bill Reconciliation' section which allows a user to perform reconciliation and below are the data displayed as part of this section:Total Amount Due
Current Reconciled Amount
By using either 'Link Suspense' or 'Adjust' buttons user can reconcile the bill details.
When user selects 'Cancel' button then the Adjust/Link Suspense context is not considered and also user is returned back to initial load of 'Group/List Bill
Reconciliation' ScreenWhen user selects 'Save' then a confirmation window is appeared and upon confirming the reconciliation entries is saved and associated policy/client/group customer activity is triggered.
'Reconciliation' TransactionTransaction Type - Policy Financial
Processing Order - 1500
This transaction is called under the <ReconciliationTransactionOnEntity> element of 'BillReconciliationScreen' BR.
Following are the set of fields configured for this transaction where the data is populated from 'BillReconciliationScreen'.
BilLDetailReferenceGUID
AmounttoReconcile
'MaintainBillDetailReconciliation' Business Rule is attached to this transaction in order to allow reconciliation to be processed. After processing the transaction the bill detail record status is changed to Reconciled if the entire amount of the bill detail is reconciled.
Note: The SuspenseNumber and SuspenseType elements are deprecated from the MaintainBillDetailReconciliation rule and now the linking is performed through AsActivitySuspense to AsBillDetailReconciliation.
New Items
None
Changes to Existing Items
MaintainBillDetailReconciliation - The 4 instances (overides) of this rule are updated to remove the unused syntax.
BillDetailReconciliationSearch - References to the SuspenseNumber that is used to specify the search criteria and column result is removed.
Configuration Details
<MaintainBillDetailReconciliation>
<BillDetailReconciliation>
<ReferenceGUID>BillDetailReferenceGUIDMV</ReferenceGUID>
<AmountField>AmountToReconcileCMV</AmountField>
<EffectiveDate>ReconciliationEffectiveDateMV</EffectiveDate>
<Tests>
<Test>1=1</Test>
</Tests>
</BillDetailReconciliation>
</MaintainBillDetailReconciliation>'ReconciliationReversal' Transaction
Transaction Type - Policy Financial
Processing Order - 1000
This transaction is called under the <ReconciliationReversalTransactionOnEntity> element of 'BillReconciliationScreen' Business Rule.
Following are the set of fields configured for this transaction where the data is populated from 'BillReconciliationScreen'.OriginatingActivityGUID
'ShadowPendingActivities' Business Rule is attached to this transaction in order to shadow the reversed reconciliation record associated to the OriginatingActivityGUID.
After processing the transaction user should be able to see that Reconciliation done has been reversed and the status of the bill detail record is changed to Under reconciliation.
Note: Both the 'Reconciliation' & 'ReconciliationReversal' transactions are available under the below levels of Prototype company:Client Plan
Customer Plan
Group Prototype Product
Existing ItemsNone