FindBillDetail Activity Function Return Policy Count
The FindBillDetail activity function has been expanded to return counts of the items in the bill detail array. The GenerateBill transaction on the Customer Plan within the Prototype company has been updated to return these new, additional values. New math arrays are defined for the Policy, Client and Segment BillDetail records returned from the function in addition to the existing aggregated array of all Bill Detail records. The new feature allows the users to verify expected bill detail counts vs actual records found.
Prerequisites
In order for the activity function to return any values, there must be records on AsBillDetail in a pending status that match the input criteria (Date range and BillGroupGUID)
New Items
Transaction - GenerateBill (Customer Plan, Prototype company)
<MathVariables>
<MathVariable VARIABLENAME="BillDetailArrayMV" TYPE="STRINGARRAY" OPERATION="FILLBY-LIST" DATATYPE="TEXT"></MathVariable>
<MathVariable VARIABLENAME="BillDetailPolicyGUIDArrayMV" TYPE="STRINGARRAY" OPERATION="FILLBY-LIST" DATATYPE="TEXT"></MathVariable>
<MathVariable VARIABLENAME="BillDetailClientGUIDArrayMV" TYPE="STRINGARRAY" OPERATION="FILLBY-LIST" DATATYPE="TEXT"></MathVariable>
<MathVariable VARIABLENAME="BillDetailSegmentGUIDArrayMV" TYPE="STRINGARRAY" OPERATION="FILLBY-LIST" DATATYPE="TEXT"></MathVariable>
<MathVariable VARIABLENAME="BillOwnerTypeMV" TYPE="EXPRESSION" DATATYPE="TEXT">Activity:BillGroupType</MathVariable>
<MathIF IF="BillOwnerTypeMV = 'CLASS'">
<MathVariable VARIABLENAME="BillOwnerGUIDMV" TYPE="EXPRESSION" DATATYPE="TEXT">Activity:Class</MathVariable>
</MathIF>
<MathIF IF="BillOwnerTypeMV = 'GROUPCUST'">
<MathVariable VARIABLENAME="BillOwnerGUIDMV" TYPE="SQL" DATATYPE="TEXT">SELECT ClientGUID FROM AsGroupCustomer WHERE GroupCustomerGUID='[Activity:GroupCustomer]'</MathVariable>
</MathIF>
<MathStatement TYPE="ACTIVITYFUNCTION" FUNCTIONNAME="FindBillDetail">
<Parameters>
<Parameter NAME="StartDate" TYPE="INPUT">Activity:BillingStartDate</Parameter>
<Parameter NAME="EndDate" TYPE="INPUT">Activity:BillingEndDate</Parameter>
<Parameter NAME="BillGroupGUID" TYPE="INPUT">BillOwnerGUIDMV</Parameter>
<Parameter NAME="BillMinimumAmountThreshhold" TYPE="INPUT">Activity:ThreshholdMinimumAmount</Parameter>
<Parameter NAME="BillMaximumAmountThreshhold" TYPE="INPUT">Activity:ThreshholdMaximumAmount</Parameter>
<Parameter NAME="BillDetailArray" TYPE="OUTPUT">BillDetailArrayMV</Parameter>
<Parameter NAME="BillDetailPolicyGUIDArray" TYPE="OUTPUT">BillDetailPolicyGUIDArrayMV</Parameter>
<Parameter NAME="BillDetailClientGUIDArray" TYPE="OUTPUT">BillDetailClientGUIDArrayMV</Parameter>
<Parameter NAME="BillDetailSegmentGUIDArray" TYPE="OUTPUT">BillDetailSegmentGUIDArrayMV</Parameter>
</Parameters>
</MathStatement>
<MathVariable VARIABLENAME="BillDetailCount" TYPE="AGGREGATEFUNCTION" DATATYPE="INTEGER" METHOD="COUNT">BillDetailArrayMV</MathVariable>
<MathVariable VARIABLENAME="BillDetailPolicyCount" TYPE="AGGREGATEFUNCTION" DATATYPE="INTEGER" METHOD="COUNT">BillDetailPolicyGUIDArrayMV</MathVariable>
<MathVariable VARIABLENAME="BillDetailClientCount" TYPE="AGGREGATEFUNCTION" DATATYPE="INTEGER" METHOD="COUNT">BillDetailClientGUIDArrayMV</MathVariable>
<MathVariable VARIABLENAME="BillDetailSegmentCount" TYPE="AGGREGATEFUNCTION" DATATYPE="INTEGER" METHOD="COUNT">BillDetailSegmentGUIDArrayMV</MathVariable>
<MathVariable VARIABLENAME="ReferenceIDMV" TYPE="IDENTIFIER" DATATYPE="TEXT">
<Parts>
<Part TYPE="SEQUENCE" FORMAT="0000000000">ReferenceIDMV</Part>
</Parts>
</MathVariable>
</MathVariables>
Changes to Existing Items
The Math section is appended to the existing GenerateBill transaction.
Configuration Details
GenerateBill transaction
New Math elements- New MathVariables
- BillDetailPolicyGUIDArrayMV: this variable is initialized and will hold the output array of the FindBillDetail function listing the Policy level bill detail records.
- BillDetailClientGUIDArrayMV: this variable is initialized and will hold the output array of the FindBillDetail function listing the Client level bill detail records.
- BillDetailSegmentGUIDArrayMV: this variable is initialized and will hold the output array of the FindBillDetail function listing the Segment level bill detail records.
- BillDetailCount: this variable returns the aggregate function count of the records in the BillDetailArrayMV output array of the FindBillDetail function.
- BillDetailPolicyCount: this variable returns the aggregate function count of the records in the BillDetailPolicyGUIDArrayMV output array of the FindBillDetail function.
- BillDetailClientCount: this variable returns the aggregate function count of the records in the BillDetailClientGUIDArrayMV output array of the FindBillDetail function.
- BillDetailSegmentCount: this variable returns the aggregate function count of the records in the BillDetailSegmentGUIDArrayMV output array of the FindBillDetail function.
New Function Parameters
- BillDetailPolicyGUIDArray: this parameter is the output array of the FindBillDetail function listing the Policy level bill detail records.
- BillDetailClientGUIDArray: this parameter is the output array of the FindBillDetail function listing the Client level bill detail records.
- BillDetailSegmentGUIDArray: this parameter is the output array of the FindBillDetail function listing the Segment level bill detail records.