At the reconciliation level, you can create a data filter that stores out-ofbalance keys for use in a subsequent qualifier report. In a multi-level job, it is important to make sure that the keys passed to the qualifier include only the keys you want on the report by setting return codes. This ensures that reports from subsequent levels are correct.
Problem
In ACR/Detail, you want to create a data filter and print a qualifier level report whether or not keys exist at the qualifier level.
Solution
Code the extraction definitions to extract a dummy key with dummy internal items that will meet the criteria to be put into the data filter, even if no other keys meet that criteria.
Complete the steps below to print a qualifier report even if no valid key is extracted.
1 ) Set up a base job and set the filter for a qualifier to ON, so that only the items that you note as out-of-balance are passed to a qualifier.
See the “Setting Up Multi-Level Reconciliation” section in the ACR/Detail User Guide.
2 ) On the base level job, create a dummy key and move a literal of DUMMY to the key.
Move literal “DUMMY” to Key1
Move +1 to Internal Item 001
3 ) Add a rule that sets the dummy key value out of balance. Specify a return code that will pass the filter.
If Internal Item 001 = +1
Set return code to 222
4 ) Add your regular business rules to determine if your key values are accurate. Specify a return code to pass any desired key to the qualifier reporting at that level.
5 ) Set up a qualifier job. This job has the same job/step name as the base job but has a value other than spaces in the qualifier field.
6 ) For the qualifier job, go into the reconciliation level and specify that the job uses the data filter from the base job, which you set up in step 1, with the return code range appropriate for the rules that you set up in steps 3 and 4.
At this point, you have the keys, if any, that you want to include in the qualifier report as well as the dummy key.
7 ) On the qualifier job, set up an active rule that sets the dummy key out of balance.
If Internal Item 001 = +1
Set return code to 222
8 ) Set the qualifier report to print only the keys that are in balance. This step eliminates the dummy key from printing on the qualifier report. Be sure to set the report to always print with headings, so that the report will print even if there are no keys.
In the instructions above, step 2 creates a key that will always pass a value to the qualifier, which ensures that the qualifier job will run. Because the qualifier job always runs, a qualifier report is always printed. These instructions avoid printing the dummy key by setting the dummy key out of balance and setting the report to print only keys that are in balance.
If you have other balancing rules and want to print only the out-of-balance keys, reverse the logic : mark the dummy key as in balance and choose to print only out-of-balance keys on the report.
Comments
0 comments
Please sign in to leave a comment.