Skip to main content

Avatar PM 2022 Update 108

  1. Last updated
  2. Save as PDF

Product Requirements / Recommendations

Avatar PM required
RADplus required

Recommended Update Level

Avatar GL 2022 Update 6

Product Update Form Description

The 'Enable Payment Acknowledgement' registry setting is updated to allow the inclusion of Payment Acknowledgements in the 'Compile General Ledger Payment/Adjustment Interface File'. The 'Program' extended dictionary off of 'Treatment Service' is also added to support Payment Acknowledgements in the 'Compile General Ledger Payment/Adjustment Interface File'. Note: 'Compile General Ledger Payment/Adjustment Interface File' is updated to include Payment Acknowledgements in Avatar GL 2022 update 6.

Included Updates

3, 9, 13, 18, 25, 34, 41, 48, 51, 55, 59, 61, 62, 67, 77, 84, 87, 88, 90, 91, 94, 95, 97, 99, 100, 103

Required Updates

Avatar PM 2022 Update 88
Details
NEW1 CHANGED0 FIXED0
New (1)
Registry Setting - Enable Payment Acknowledgement
When "Y" is selected the 'Payment Acknowledgment', 'General Ledger Payment Acknowledgment Interface Components' and 'General Ledger Payment Acknowledgment Account Numbers' forms will be added. Additionally, the 'Posting/Adjustment Codes Definition' form will be updated to include a new field called 'Payment Acknowledgement Type' and the 'Compile General Ledger Payment/Adjustment Interface File' will be updated to include a new field called 'Include Payment Acknowledgments'.

Selecting "N" will remove the new forms and field. Note: Selecting "N" will remove all selections from the 'Prevent Posting Payments Unless Payment has been Acknowledged' registry setting.
The 'Program' extended dictionary off of 'Treatment Service' is also added to support Payment Acknowledgements in the 'Compile General Ledger Payment/Adjustment Interface File'. Note: 'Compile General Ledger Payment/Adjustment Interface File' is updated to include Payment Acknowledgements in Avatar GL 2022 update 6.
Value Added: The registry setting 'Enable Payment Acknowledgement' is updated to allow the inclusion of Payment Acknowledgements in the 'Compile General Ledger Payment/Adjustment Interface File'.
Topics
• 835 Health Care Claim Payment/Advice • NX • Payment Acknowledgement
 
Acceptance Tests
AV-83038 Summary | Details
Registry Setting - Enable Payment Acknowledgement
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Compile General Ledger Payment/Adjustment Interface File
  • Crystal Report Viewer
  • General Ledger Payment Acknowledgement Account Numbers
  • General Ledger Payment Acknowledgement Interface Components
  • Posting/Adjustment Codes Definition
  • Registry Settings (PM)
  • User Definition
  • Admission (Outpatient)
  • Batch Cash Posting
  • Client Ledger
  • Compile General Ledger Charge Interface File
  • Dictionary Update (PM)
  • Financial Eligibility
  • General Ledger Charge Account Numbers
  • General Ledger Payment/Adjustment Account Numbers
  • Payment Acknowledgement
Scenario 1: Enable Payment Acknowledgement - Forms, Fields and Table validation
Steps
  1. Open the 'Registry Settings' form.
  2. Set the 'Enable Payment Acknowledgement' registry setting to 'N'.
  3. Submit the form.
  4. Open the 'User Definition' form.
  5. Select the login user from the 'Select User' field.
  6. Click 'Forms and Tables' item.
  7. Click [Select Forms for User Access].
  8. Verify the 'Payment Acknowledgement' form is not available under the 'Remittance Processing' item.
  9. Verify the 'General Ledger Payment Acknowledgement Interface Components' and 'General Ledger Payment Acknowledgement Account Numbers' forms are not available under the 'General Ledger Interface' item.
  10. Click [OK].
  11. Click [Select Tables for Product SQL Access].
  12. Verify the 'payack_account_numbers' sql table is not available under 'GL' database and in the Avatar PM namespace.
  13. Click [OK].
  14. Click [Submit].
  15. Click [No].
  16. Open the ‘Posting/Adjustment Code Definition’ form.
  17. Select ‘Edit’ and select any posting code.
  18. Verify that the 'Payment Acknowledgement Type' field is not displayed on the form.
  19. Close the form.
  20. Open the ‘Compile General Ledger Payment/Adjustment Interface File’ form.
  21. Verify that the ‘Include Payments Acknowledgments’ field not displayed on the form.
  22. Close the form.
  23. Open the 'Registry Settings' form.
  24. Select the 'Prevent Posting Payments Unless Payment has been Acknowledged' registry setting.
  25. Verify the registry setting is set to '0' and system does not allow to make any selections other than zero.
  26. Open the 'Registry Settings' form.
  27. Set the 'Enable Payment Acknowledgement' registry setting to 'Y'.
  28. Submit the form.
  29. Open the 'User Definition' form.
  30. Select the login user from the 'Select User' field.
  31. Click 'Forms and Tables' item.
  32. Click [Select Forms for User Access].
  33. Verify the 'Payment Acknowledgement' form is available under the 'Remittance Processing' item.
  34. Verify the 'General Ledger Payment Acknowledgement Interface Components' and 'General Ledger Payment Acknowledgement Account Numbers' forms are available under the 'General Ledger Interface' item.
  35. Select the 'Payment Acknowledgement', 'General Ledger Payment Acknowledgement Interface Components' and 'General Ledger Payment Acknowledgement Account Numbers' forms.
  36. Click [OK].
  37. Click [Select Tables for Product SQL Access].
  38. Verify the 'payack_account_numbers' sql table is available under 'GL' database and in the Avatar PM namespace.
  39. Select the 'payack_account_numbers' sql table.
  40. Click [OK].
  41. Click [Submit].
  42. Click [No].
  43. Verify the 'Payment Acknowledgement', 'General Ledger Payment Acknowledgement Interface Components' and 'General Ledger Payment Acknowledgement Account Numbers' forms are accessible from the menu.
  44. Open the ‘Posting/Adjustment Code Definition’.
  45. Select ‘Edit’ and select any posting code.
  46. Verify that the 'Payment Acknowledgement Type' field is displayed on the form.
  47. Close the form.
  48. Open the ‘Compile General Ledger Payment/Adjustment Interface File’ form.
  49. Verify that the ‘Include Payments Acknowledgments’ field displayed on the form with two options: 1. Payment Acknowledgement 2. Post Payment Entry
  50. Close the form.
  51. Open the 'Registry Settings' form.
  52. Select the 'Prevent Posting Payments Unless Payment has been Acknowledged' registry setting.
  53. Verify the system allows user to select any value from the available values.
  54. Close the form.
Scenario 2: Payment Acknowledgement - Compile General Ledger Payment/Adjustment Interface File-Batch Cash Posting
Specific Setup:
  • System updated with Avatar GL module.
  • General Ledger Charge Account Numbers and default account numbers are defined.
  • General Ledger Payment/Adjustment components and account numbers are defined.
  • Registry Setting:
  • The 'Enable Payment Acknowledgement' registry setting is enabled.
  • The 'Prevent Posting Payments Unless Payment has been Acknowledged' registry setting is set to '1&2'.
  • Dictionary Update:
  • File: Client
  • (101) - Treatment Service - enter a code/value and then select the Program extended dictionary and enter desired value (i.e. 000111). Note dictionary code/value. Please note - The value entered here will also need to be added to the 'Program (5521)' dictionary in other tabled files for testing the GL compile.
  • File: Other Table Files:
  • (5521) Program - contains dictionary codes and dictionary values. Add the extended dictionary value from the '(101) Client' file and 'Treatment Service' dictionary.
  • (5522) Account - contains dictionary codes, dictionary values and extended dictionary values.
  • File: G/L Interface
  • (204) - Credit G/L Payment Acknowledgement Account Number - contains dictionary codes and dictionary values.
  • (205) - Debit G/L Payment Acknowledgement Account Number - contains dictionary codes and dictionary values.
  • Admission:
  • A client is identified with charges that resulted in payments, and/or adjustments being posted to the charges.
  • Guarantor/Payors:
  • An existing guarantor is identified who does not have a Financial Class that has the Extended Data Element for (1500) System Financial Class set to Self Pay. Note the guarantor's code/name.
  • Financial Eligibility:
  • Assign desired guarantor to the client.
  • Client Charge Input:
  • A service is rendered to the client.
  • Client Ledger:
  • Make sure the service is distributed to the guarantor assigned to the client.
Steps
  1. Open the 'Payment Acknowledgement General Ledger Interface Components' form.
  2. Select components.
  3. Submit the form.
  4. Open the 'General Ledger Payment Acknowledgement Account Numbers' form.
  5. Select component and the component value for each of the components.
  6. Select credit and debit account numbers.
  7. File Account numbers for each component and date range (optional) combination.
  8. Go to section 'G/L Payment Acknowledgement Defaults'.
  9. Add default account numbers.
  10. File Default account numbers.
  11. Submit the form.
  12. Use Crystal Reports or any other SQL data viewer.
  13. Validate the SQL Table GL.payack_account_numbers displays data as they entered in the 'General Ledger Payment Acknowledgement Account Numbers' form.
  14. Open ‘Payment Acknowledgment’ form.
  15. Enter desired value in ‘Batch Number’.
  16. Select desired ‘Posting Code’.
  17. Enter desired value in ‘Check/EFT Number’.
  18. Enter desired value in ‘Amount’.
  19. Select desired ‘Guarantor’. If a ‘Self-Pay guarantor is selected, the ‘Client’ field will be enabled.
  20. Enter desired value in ‘Name/Source’.
  21. Enter desired value in ‘Client’, if enabled.
  22. Enter desired value in ‘Check/EFT Date’. Note the Check/EFT number to be used in the 'Batch Cash Posting'.
  23. Enter desired value in ‘Receipt Date’.
  24. Enter desired value in ‘Deposit Date’.
  25. Select desired ‘Treatment Service’. Please note: The treatment service used must have program extended dictionary setup in the setup section.
  26. Select desired ‘Category’ from 'Account' dictionary.
  27. If the selected item, extended data dictionary value of 'Other Table Files: (5522) Account' - 'Include in Category Dictionary: Yes' the dictionary item will be available for selection. No = not available for selection.
  28. If the selected item, extended data dictionary value of 'Other Table Files: (5522) Account' - 'Require Name/Source in Payment Acknowledgement', has a value of 'Y' the 'Name/Source' field will become required. No = not required.
  29. Enter desired value in ‘Bank Ref #’.
  30. Enter desired value in ‘Comments’.
  31. Click [File].
  32. Verify that the ‘Payment Acknowledgement’ message is received and states the following: Filed successfully. The Transaction Number is 6. Do you need to continue to Post Payment Accounting Entry? Note: The Transaction Number’ increments by one number with each filing.
  33. Clicking [No] returns the user to the ‘Payment Acknowledgement’ section to enter additional payments.
  34. Clicking [Yes] allows the user to post payments in 'Post Payment Accounting Entry'.
  35. Click [Yes].
  36. Click [New Row] in ‘Post Payment Accounting Entry’.
  37. Select desired ‘Treatment Service’. It will default if filed in the ‘Payment Acknowledgement’.
  38. Select desired ‘Program’. This is from ‘Other Table Files: (5521) Program’, not a program in ‘Program Maintenance’.
  39. Select desired ‘Account’.
  40. Select desired ‘Amount’.
  41. Validate that the ‘Posting Code; defaulted from the ‘Payment Acknowledgement’.
  42. Select desired ‘Posting Date’.
  43. Validate that the ‘Posting Summary’ is correct.
  44. If desired, and first row partially posts the 'Amount', click [New Row] and repeat the steps.
  45. If desired, click [Delete Row]. A ‘Confirm Delete’ message will be displayed. Select desired value.
  46. Click [File].
  47. The following ‘Payment Acknowledgement’ displays: Filed successfully. Do you need to continue with Post Payment Accounting Entry?
  48. Click [Yes].
  49. Add the new row for post payment accounting entry.
  50. File the form.
  51. Open the 'Batch Cash Posting' form.
  52. Enter desired date to the 'Date of Receipt or Adjustment' field.
  53. Enter desired date to the 'Cash Posting Date' field.
  54. Select 'Payment' in the 'Posting Type' field.
  55. Select 'No' in the 'Payment Acknowledgment' field.
  56. Select desired guarantor.
  57. Validate the 'Selected Payment Acknowledgment' field exist and lists all payment acknowledgments that have a balance greater than $0. If a guarantor is selected in the prior field, filter by that guarantor.
  58. Select payment acknowledgement defined for the selected guarantor.
  59. Validate the 'Amount to Post' field defaults to the remaining amount of the selected payment acknowledgment.
  60. Select desired value in the 'Individual or All Clients' field.
  61. Select desired client from the 'Client ID' field if the 'Client ID' field is marked as the required field.
  62. Select desired program from the 'Program of Service' field.
  63. Select service start date in the 'From Date' field.
  64. Select service end date in the 'To Date' field.
  65. Select desired payment acknowledgement code from the 'Posting Code' field.
  66. Validate the 'Receipt' field defaults in the transaction number of the payment acknowledgment If payment acknowledgment is selected.
  67. Enter the same Check/EFT # in the 'Check #' field that is entered in the 'Payment Acknowledgement'.
  68. Select 'Ignore' in the 'Write Off or Ignore Remaining Balance' field.
  69. Click [Process].
  70. Validate the form files successfully.
  71. Open the 'Compile General Ledger Payment/Adjustment Interface File' form.
  72. Select dates that cover the transactions above and select 'no' for pre compile.
  73. Do not select anything in the new 'Include Payment Acknowledgements' field.
  74. Click [Process].
  75. Verify it generates the payment adjustment GL strings.
  76. Return to the form.
  77. Select 'Payment Acknowledgements' in the new field.
  78. Click [Process].
  79. Verify the GL strings for the Payment Acknowledgement GL Account Numbers are generated.
  80. Return to the form.
  81. Select 'Post Payment Entry' in the new field.
  82. Click [Process].
  83. Verify the GL strings for the Post Payment Entry account numbers are generated.
  84. Open the 'Crystal Reports' or any other SQL Data Reporting tool.
  85. Select the PM namespace.
  86. Identify desired database and SQL table - GL.comp_pay_ack_int_detail
  87. Locate to the SQL Editor
  88. Query 'Select * from GL.comp_pay_ack_int_detail WHERE PATID=[Desired ClientId].
  89. Validate the FACILITY cell is equal to '98'
  90. Validate the 1st PATID cell is equal to the client id identified in the setup section.
  91. Validate the EPISODE_NUMBER column displays correct value.
  92. Validate the GUARANTOR_ID column displays correct value.
  93. Validate the 'amount 'cell displays the correct amount from the payment acknowledgement form.
  94. Validate the gl_credit_number cell displays the correct account number set up.
  95. Validate the gl_debit_number cell displays the correct account number set up.
  96. Validate the 'interface_component_1_cd' displays the correct value from the setup.
Topics
• 835 Health Care Claim Payment/Advice • NX • Payment Acknowledgement
Table Changes
Table Column Change
SYSTEM.payackpostpayaccent none new postingdate index