Skip to main content

Avatar GL 2023 Quarterly Release 2023.02 Acceptance Tests

  1. Last updated
  2. Save as PDF
Update 1 Summary | Details
Avatar GL 2023 is Installed
Scenario 1: Validate Upgrading Avatar GL 2022 to 2023 is successful when 2022.04.00 is loaded
Specific Setup:
  • Latest Monthly Release is installed.
Steps
  1. Open the "Product Updates" form.
  2. Select the appropriate [Namespace] from the Application dropdown list
  3. Click [Select Update/Customization Pack].
  4. Browse to the location for the updates and select the Update 1.
  5. Click [OK] on the "File Upload Complete" window.
  6. Click [Review Update/Customization Pack Contents].
  7. Verify Update 1 is included.
  8. Click [Install Update/Customization Pack].
  9. Click [OK] when the install completes.
  10. Click [Close Form].
Topics
• Upgrade
Update 2 Summary | Details
Payment Acknowledgement - General Ledger Payment Acknowledgement Account Numbers
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Registry Settings (PM)
  • User Definition
  • Posting/Adjustment Codes Definition
  • General Ledger Payment Acknowledgement Interface Components
  • General Ledger Payment Acknowledgement Account Numbers
  • Crystal Report Viewer
  • Compile General Ledger Payment/Adjustment Interface File
  • Table Import For General Ledger Account Numbers
  • Dictionary Update (PM)
  • General Ledger Payment/Adjustment Account Numbers
  • Admission (Outpatient)
  • Financial Eligibility
  • Client Ledger
  • Payment Acknowledgement
Scenario 1: Enable Payment Acknowledgement - Forms, Fields and Table validation
Specific Setup:
  • System is updated for General Ledger module.
  • Registry Setting:
  • The ‘Avatar PM->Billing->Remittance Processing->->->Enable Payment Acknowledgement’ registry setting is set to ‘Y’.
  • Dictionary Update:
  • Other Table Files:
  • (5521) Program - contains 3-5 dictionary codes and dictionary values. Note the dictionary codes/values.
  • (5522) Account - contains 3-5 dictionary codes, dictionary values and extended dictionary values. Note the dictionary codes/values.
  • File: G/L Interface
  • (204) - Credit G/L Payment Acknowledgement Account Number - contains 3-5 dictionary codes and dictionary values. Note the dictionary codes/values.
  • (205) - Debit G/L Payment Acknowledgement Account Number - contains 3-5 dictionary codes and dictionary values. Note the dictionary codes/values.
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 'Table Import For General Ledger Account Numbers' form.
  24. Verify the 'Load Which Table' field does not contain 'GL Payment Acknowledgement Account Numbers' selection.
  25. Discard the form.
  26. Open the 'Registry Settings' form.
  27. Select the 'Prevent Posting Payments Unless Payment has been Acknowledged' registry setting.
  28. Verify the registry setting is set to '0' and system does not allow to make any selections other than zero.
  29. Open the 'Registry Settings' form.
  30. Set the 'Enable Payment Acknowledgement' registry setting to 'Y'.
  31. Submit the form.
  32. Open the 'User Definition' form.
  33. Select the login user from the 'Select User' field.
  34. Click 'Forms and Tables' item.
  35. Click [Select Forms for User Access].
  36. Verify the 'Payment Acknowledgement' form is available under the 'Remittance Processing' item.
  37. Verify the 'General Ledger Payment Acknowledgement Interface Components' and 'General Ledger Payment Acknowledgement Account Numbers' forms are available under the 'General Ledger Interface' item.
  38. Select the 'Payment Acknowledgement', 'General Ledger Payment Acknowledgement Interface Components' and 'General Ledger Payment Acknowledgement Account Numbers' forms.
  39. Click [OK].
  40. Click [Select Tables for Product SQL Access].
  41. Verify the 'payack_account_numbers' sql table is available under 'GL' database and in the Avatar PM namespace.
  42. Select the 'payack_account_numbers' sql table.
  43. Click [OK].
  44. Click [Submit].
  45. Click [No].
  46. Verify the 'Payment Acknowledgement', 'General Ledger Payment Acknowledgement Interface Components' and 'General Ledger Payment Acknowledgement Account Numbers' forms are accessible from the menu.
  47. Open the ‘Posting/Adjustment Code Definition’.
  48. Select ‘Edit’ and select any posting code.
  49. Verify that the 'Payment Acknowledgement Type' field is displayed on the form.
  50. Close the form.
  51. Open the ‘Compile General Ledger Payment/Adjustment Interface File’ form.
  52. Verify that the ‘Include Payments Acknowledgments’ field displayed on the form with two options: 1. Payment Acknowledgement 2. Post Payment Entry
  53. Close the form.
  54. Open the 'Table Import For General Ledger Account Numbers' form.
  55. Verify the 'Load Which Table' field contains 'GL Payment Acknowledgement Account Numbers' selection.
  56. Discard the form.
  57. Open the 'Registry Settings' form.
  58. Select the 'Prevent Posting Payments Unless Payment has been Acknowledged' registry setting.
  59. Verify the system allows user to select any value from the available values.
  60. Close the form.
Scenario 2: Payment Acknowledgement - Compile General Ledger Payment/Adjustment Interface File - Date specific and without date account numbers
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. Open ‘Payment Acknowledgment’ form.
  13. Enter desired value in ‘Batch Number’.
  14. Select desired ‘Posting Code’.
  15. Enter desired value in ‘Check/EFT Number’.
  16. Enter desired value in ‘Amount’.
  17. Select desired ‘Guarantor’. If a ‘Self-Pay guarantor is selected, the ‘Client’ field will be enabled.
  18. Enter desired value in ‘Name/Source’.
  19. Enter desired value in ‘Client’, if enabled.
  20. Enter desired value in ‘Check/EFT Date’. Note the Check/EFT number to be used in the 'Batch Cash Posting'.
  21. Enter desired value in ‘Receipt Date’.
  22. Enter desired value in ‘Deposit Date’.
  23. Select desired ‘Treatment Service’. Please note: The treatment service used must have program extended dictionary setup in the setup section.
  24. Select desired ‘Category’ from 'Account' dictionary.
  25. 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.
  26. 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.
  27. Enter desired value in ‘Bank Ref #’.
  28. Enter desired value in ‘Comments’.
  29. Click [File].
  30. Verify that the ‘Payment Acknowledgement’ message is received and states the following: Filed successfully. The Transaction Number is [Number]. Do you need to continue to Post Payment Accounting Entry? Note: The Transaction Number’ increments by one number with each filing.
  31. Clicking [No] returns the user to the ‘Payment Acknowledgement’ section to enter additional payments.
  32. Clicking [Yes] allows the user to post payments in 'Post Payment Accounting Entry'.
  33. Click [No].
  34. The following ‘Payment Acknowledgement’ displays: Filed successfully. Do you need to continue with Post Payment Accounting Entry?
  35. File the form.
  36. Open the 'Compile General Ledger Payment/Adjustment Interface File' form.
  37. Select dates that cover the transactions above and select 'no' for precompile.
  38. Do not select anything in the new 'Include Payment Acknowledgements' field.
  39. Click [Process].
  40. Verify it generates the payment adjustment GL strings.
  41. Return to the form.
  42. Select 'Payment Acknowledgements' in the new field.
  43. Click [Process].
  44. Verify the GL strings for the Payment Acknowledgement GL Account Numbers are generated and that contains date specific entry and an entry without a date.
  45. Close the form.
Table Import for General Ledger Account Numbers - 'GL Payment Acknowledgement Account Numbers'
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Registry Settings (PM)
  • User Definition
  • Posting/Adjustment Codes Definition
  • General Ledger Payment Acknowledgement Interface Components
  • General Ledger Payment Acknowledgement Account Numbers
  • Crystal Report Viewer
  • Compile General Ledger Payment/Adjustment Interface File
  • Table Import For General Ledger Account Numbers
  • Dictionary Update (PM)
  • General Ledger Payment/Adjustment Account Numbers
  • Admission (Outpatient)
  • Financial Eligibility
  • Client Ledger
  • Payment Acknowledgement
Internal Test Only
Topics
• NX • Payment Acknowledgement • GL
Update 3 Summary | Details
Print General Ledger Payment/Adjustment Interface File Detail
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Print General Ledger Payment Acknowledgement Interface Detail
  • Crystal Report Viewer
  • General Ledger Payment Acknowledgement Account Numbers
  • Compile General Ledger Payment/Adjustment Interface File
  • Admission (Outpatient)
  • Financial Eligibility
  • Client Ledger
  • Registry Settings (PM)
  • Payment Acknowledgement
  • GL_Payment_Acknowledgement_Interface_Detail.rpt
  • User Definition
  • Batch Cash Posting
Scenario 1: Print General Ledger Payment Acknowledgement Interface Detail - Pre Compile - Payment Acknowledgement
Specific Setup:
  • Please note: The 'Print General Ledger Payment Acknowledgement Interface Detail' form is only available if the Avatar PM registry setting 'Enable Payment Acknowledgement' is enabled and Avatar PM 2023 update 115 is installed.
  • 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 new client is created, or an existing 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. Open ‘Payment Acknowledgment’ form.
  13. Enter desired value in ‘Batch Number’.
  14. Select desired ‘Posting Code’.
  15. Enter desired value in ‘Check/EFT Number’.
  16. Enter desired value in ‘Amount’.
  17. Select desired ‘Guarantor’. If a ‘Self-Pay guarantor is selected, the ‘Client’ field will be enabled.
  18. Enter desired value in ‘Name/Source’.
  19. Enter desired value in ‘Client’, if enabled.
  20. Enter desired value in ‘Check/EFT Date’. Note the Check/EFT number to be used in the 'Batch Cash Posting'.
  21. Enter desired value in ‘Receipt Date’.
  22. Enter desired value in ‘Deposit Date’.
  23. Select desired ‘Treatment Service’. Please note: The treatment service used must have program extended dictionary setup in the setup section.
  24. Select desired ‘Category’ from 'Account' dictionary.
  25. 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.
  26. 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.
  27. Enter desired value in ‘Bank Ref #’.
  28. Enter desired value in ‘Comments’.
  29. Click [File].
  30. Verify that the ‘Payment Acknowledgement’ message is received and states the following: Filed successfully. The Transaction Number is [Number].
  31. Click [Discard].
  32. Open the 'Compile General Ledger Payment/Adjustment Interface File' form.
  33. Select dates that cover the transactions above and select 'Yes' for pre compile.
  34. Select 'Payment Acknowledgement' in the 'Include Payment Acknowledgement' field.
  35. Click [Process].
  36. Validate the message that ask user to navigate to 'Print General Ledger Payment/Adjustment Interface File Detail' form to see the report.
  37. Open the 'Print General Ledger Payment/Adjustment Interface File Detail' form.
  38. Enter the date range of the report.
  39. Process the report.
  40. Verify the report displays data correctly.
  41. Close the report.
  42. Close the form.
  43. Enter rows with the Account, Treatment Service and Program used as components.
  44. The following ‘Payment Acknowledgement’ displays: Filed successfully. Do you need to continue with Post Payment Accounting Entry?
  45. File the form.
  46. Open the 'Compile General Ledger Payment/Adjustment Interface File' form.
  47. Select dates that cover the transactions above and select 'Yes' for pre compile.
  48. Select 'Payment Acknowledgement' in the 'Include Payment Acknowledgement' field.
  49. Click [Process].
  50. Verify the GL strings for the Payment Acknowledgement GL Account Numbers are generated and that contains date specific entry and an entry without a date.
  51. Close the form.
Scenario 2: Print General Ledger Payment Acknowledgement Interface Detail - Form / Fields validation
Specific Setup:
  • Please note: The 'Print General Ledger Payment Acknowledgement Interface Detail' form is only available if the Avatar PM registry setting 'Enable Payment Acknowledgement' is enabled and Avatar PM 2023 update 115 is installed.
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', 'General Ledger Payment Acknowledgement Account Numbers' and 'Print General Ledger Payment Acknowledgement Interface Detail' forms are not available under the 'General Ledger Interface' item.
  10. Click [OK].
  11. Click [Submit].
  12. Click [No].
  13. Open the ‘Compile General Ledger Payment/Adjustment Interface File’ form.
  14. Verify that the ‘Include Payments Acknowledgments’ field not displayed on the form.
  15. Close the form.
  16. Open the 'Registry Settings' form.
  17. Select the 'Prevent Posting Payments Unless Payment has been Acknowledged' registry setting.
  18. Verify the registry setting is set to '0' and system does not allow to make any selections other than zero.
  19. Open the 'Registry Settings' form.
  20. Set the 'Enable Payment Acknowledgement' registry setting to 'Y'.
  21. Submit the form.
  22. Open the 'User Definition' form.
  23. Select the login user from the 'Select User' field.
  24. Click 'Forms and Tables' item.
  25. Click [Select Forms for User Access].
  26. Verify the 'Payment Acknowledgement' form is available under the 'Remittance Processing' item.
  27. Verify the 'General Ledger Payment Acknowledgement Interface Components', 'General Ledger Payment Acknowledgement Account Numbers' and 'Print General Ledger Payment Acknowledgement Interface Detail' forms are available under the 'General Ledger Interface' item.
  28. Select the 'Payment Acknowledgement', 'General Ledger Payment Acknowledgement Interface Components', 'General Ledger Payment Acknowledgement Account Numbers' and 'Print General Ledger Payment Acknowledgement Interface Detail' forms.
  29. Click [OK].
  30. Click [Submit].
  31. Click [No].
  32. Verify the 'General Ledger Payment Acknowledgement Interface Components', 'General Ledger Payment Acknowledgement Account Numbers' and 'Print General Ledger Payment Acknowledgement Interface Detail' forms are accessible from the menu.
Scenario 3: Print General Ledger Payment Acknowledgement Interface Detail - Pre Compile - Post Payment Entry
Specific Setup:
  • Please note: The 'Print General Ledger Payment Acknowledgement Interface Detail' form is only available if the Avatar PM registry setting 'Enable Payment Acknowledgement' is enabled and Avatar PM 2023 update 115 is installed.
  • 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 new client is created, or an existing 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. Open ‘Payment Acknowledgment’ form.
  13. Enter desired value in ‘Batch Number’.
  14. Select desired ‘Posting Code’.
  15. Enter desired value in ‘Check/EFT Number’.
  16. Enter desired value in ‘Amount’.
  17. Select desired ‘Guarantor’. If a ‘Self-Pay guarantor is selected, the ‘Client’ field will be enabled.
  18. Enter desired value in ‘Name/Source’.
  19. Enter desired value in ‘Client’, if enabled.
  20. Enter desired value in ‘Check/EFT Date’. Note the Check/EFT number to be used in the 'Batch Cash Posting'.
  21. Enter desired value in ‘Receipt Date’.
  22. Enter desired value in ‘Deposit Date’.
  23. Select desired ‘Treatment Service’. Please note: The treatment service used must have program extended dictionary setup in the setup section.
  24. Select desired ‘Category’ from 'Account' dictionary.
  25. 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.
  26. 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.
  27. Enter desired value in ‘Bank Ref #’.
  28. Enter desired value in ‘Comments’.
  29. Click [File].
  30. Verify that the ‘Payment Acknowledgement’ message is received and states the following: Filed successfully. The Transaction Number is [Number].
  31. Click [Discard].
  32. Open the 'Compile General Ledger Payment/Adjustment Interface File' form.
  33. Select dates that cover the transactions above and select 'Yes' for pre compile.
  34. Select 'Payment Acknowledgement' in the 'Include Payment Acknowledgement' field.
  35. Click [Process].
  36. Validate the message that ask user to navigate to 'Print General Ledger Payment/Adjustment Interface File Detail' form to see the report.
  37. Open the 'Print General Ledger Payment/Adjustment Interface File Detail' form.
  38. Enter the date range of the report.
  39. Process the report.
  40. Verify the report displays data correctly.
  41. Close the report.
  42. Close the form.
  43. Enter rows with the Account, Treatment Service and Program used as components.
  44. The following ‘Payment Acknowledgement’ displays: Filed successfully. Do you need to continue with Post Payment Accounting Entry?
  45. File the form.
  46. Open the 'Compile General Ledger Payment/Adjustment Interface File' form.
  47. Select dates that cover the transactions above and select 'Yes' for pre compile.
  48. Select 'Payment Acknowledgement' in the 'Include Payment Acknowledgement' field.
  49. Click [Process].
  50. Verify the GL strings for the Payment Acknowledgement GL Account Numbers are generated and that contains date specific entry and an entry without a date.
  51. Close the form.
Scenario 4: Payment Acknowledgement - Post Payment Entry - Batch Cash Posting
Specific Setup:
  • Please note: The 'Print General Ledger Payment Acknowledgement Interface Detail' form is only available if the Avatar PM registry setting 'Enable Payment Acknowledgement' is enabled and Avatar PM 2023 update 115 is installed.
  • 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 new client is created, or an existing 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 ‘Payment Acknowledgment’ form.
  2. Enter desired value in ‘Batch Number’.
  3. Select desired ‘Posting Code’.
  4. Enter desired value in ‘Check/EFT Number’.
  5. Enter desired value in ‘Amount’.
  6. Select desired ‘Guarantor’. If a ‘Self-Pay guarantor is selected, the ‘Client’ field will be enabled.
  7. Enter desired value in ‘Name/Source’.
  8. Enter desired value in ‘Client’, if enabled.
  9. Enter desired value in ‘Check/EFT Date’. Note the Check/EFT number to be used in the 'Batch Cash Posting'.
  10. Enter desired value in ‘Receipt Date’.
  11. Enter desired value in ‘Deposit Date’.
  12. Select desired ‘Treatment Service’. Please note: The treatment service used must have program extended dictionary setup in the setup section
  13. Select desired ‘Category’ from 'Account' dictionary.
  14. 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.
  15. 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.
  16. Enter desired value in ‘Bank Ref #’.
  17. Enter desired value in ‘Comments’.
  18. Click [File].
  19. 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.
  20. Clicking [No] returns the user to the ‘Payment Acknowledgement’ section to enter additional payments.
  21. Clicking [Yes] allows the user to post payments in 'Post Payment Accounting Entry'.
  22. Click [Yes].
  23. Click [New Row] in ‘Post Payment Accounting Entry’.
  24. Select desired ‘Treatment Service’. It will default if filed in the ‘Payment Acknowledgement’.
  25. Select desired ‘Program’. This is from ‘Other Table Files: (5521) Program’, not a program in ‘Program Maintenance’.
  26. Select desired ‘Account’.
  27. Select desired ‘Amount’.
  28. Validate that the ‘Posting Code; defaulted from the ‘Payment Acknowledgement’.
  29. Select desired ‘Posting Date’.
  30. Validate that the ‘Posting Summary’ is correct.
  31. If desired, and first row partially posts the 'Amount', click [New Row] and repeat the steps.
  32. If desired, click [Delete Row]. A ‘Confirm Delete’ message will be displayed. Select desired value.
  33. Click [File].
  34. The following ‘Payment Acknowledgement’ displays: Filed successfully. Do you need to continue with Post Payment Accounting Entry?
  35. Click [Yes].
  36. Open the 'Batch Cash Posting' form.
  37. Enter desired date to the 'Date of Receipt or Adjustment' field.
  38. Enter desired date to the 'Cash Posting Date' field.
  39. Select 'Payment' in the 'Posting Type' field.
  40. Select 'Yes' in the 'Payment Acknowledgment' field.
  41. Select desired guarantor.
  42. 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.
  43. Select payment acknowledgement defined for the selected guarantor.
  44. Validate the 'Amount to Post' field defaults to the remaining amount of the selected payment acknowledgment.
  45. Select desired value in the 'Individual or All Clients' field.
  46. Select desired client from the 'Client ID' field if the 'Client ID' field is marked as the required field.
  47. Select desired program from the 'Program of Service' field.
  48. Select service start date in the 'From Date' field.
  49. Select service end date in the 'To Date' field.
  50. Select desired payment acknowledgement code from the 'Posting Code' field.
  51. Validate the 'Receipt' field defaults in the transaction number of the payment acknowledgment If payment acknowledgment is selected.
  52. Enter the same Check/EFT # in the 'Check #' field that is entered in the 'Payment Acknowledgement'.
  53. Select 'Ignore' in the 'Write Off or Ignore Remaining Balance' field.
  54. Click [Process].
  55. Validate the form files successfully.
  56. Open ‘Payment Acknowledgment’ form.
  57. Enter the transaction number from the above payment acknowledgement.
  58. Click [Search].
  59. Verify all the details related to the transaction populated correctly in the 'Payment Acknowledgement' section of the form.
  60. Verify the 'Posting summary' field is updated correctly with the transaction posted through the 'Batch Cash Posting'.
  61. Open the 'Crystal Reports' or any other SQL Data Reporting tool.
  62. Select the PM namespace.
  63. Identify desired database and SQL table - SYSTEM.pay_ack_post_pay_acc_ent
  64. Locate to the SQL Editor
  65. Query 'select * from Select * from SYSTEM.pay_ack_post_pay_acc_ent where transaction_number=25
  66. Validate the ID cell is equal to '13'
  67. Validate the account_code cell is equal to '501'
  68. Validate the account_value cell is equal to 'IncludeYRequireY'
  69. Validate the GUARANTOR_ID cell is equal to '100'
  70. Validate the date_of_payment cell is equal to '2022-03-01'
  71. Validate the payment_type_code cell is equal to '100'
  72. Validate the payment_type_value cell does not contain 'Payment - Check'
  73. Validate the payment_amount cell does not contain '25.00'
  74. Validate the option_desc cell is equal to 'Payment Acknowledgement'
  75. Validate the type_of_payment cell is equal to 'PAYMENT'
  76. Close the SQL data viewer.
Topics
• GL • NX • Payment Acknowledgement
Update 4 Summary | Details
Geneva integration process - Integration file records for the accounting period
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Dictionary Update (PM)
  • General Ledger Interface Components
  • General Ledger Charge Account Numbers
  • General Ledger Payment/Adjustment Account Numbers
  • User Definition
  • Admission (Outpatient)
  • Financial Eligibility
  • Posting/Adjustment Codes Definition
  • Client Ledger
  • Individual Cash Posting (PM)
  • Geneva Integration
  • Crystal Report Viewer
  • Registry Settings (PM)
  • Create csv file
  • GL Facility Defaults
Scenario 1: Geneve Integration - Validating integration file records in the crystal report and csv file generated
Specific Setup:
  • System updated with Avatar GL(General Ledger) and Geneva Integration module.
  • Registry Setting:
  • The 'Avatar GL->Geneva Integration->->->->Enable' registry setting is set to 'Y'.
  • GL Facility Defaults:
  • Enter the dictionary path in the 'Output Path On Server For Geneva GL Compile File' to store the csv file.
  • Dictionary Update:
  • File: G/L Interface
  • (200) - Credit G/L Charge Account Numbers - Contains dictionary codes and dictionary values. Note the values.
  • (201) - Debit G/L Charge Account Numbers - Contains dictionary codes and dictionary values. Note the values.
  • (202) - Credit G/L Payment Adjustment Account Numbers - Contains dictionary codes and dictionary values. Note the values.
  • (203) - Debit G/L Payment Adjustment Account Numbers - Contains dictionary codes and dictionary values. Note the values.
  • Geneva / General Ledger Interface components are defined. Note the components.
  • Geneva / General Ledger Charge Account Numbers and default account numbers are defined. Note the account codes/values.
  • Geneva / General Ledger Payment/Adjustment Account Numbers and default account numbers are defined. Note the account codes/values.
  • Admission:
  • An outpatient client is admitted, or an existing outpatient client is identified. Please note the client must be admitted in the outpatient program which set up in the 'General Ledger Payment Adjustment Account Numbers' form. Note the admission date/program.
  • Guarantor/Payors:
  • An existing guarantor is identified. Note the guarantor's code/name.
  • Financial Eligibility:
  • Assign the guarantor to the client.
  • Recurring Client Charge Input:
  • 5-6 services are rendered to the client in a desired month. Note the last service date and last date of that month.
  • Additional 5-6 services are rendered to the client in a following month. Note the last service date and last date of that month.
  • Client Ledger:
  • Make sure services are distributed to the guarantor assigned to the client.
  • Individual Cash Posting:
  • Post payments, adjustments and/ or transfers for 2-3 services of each month. Note the posting date.
  • Close Charges:
  • Close the charges.
Steps
  1. Open 'Geneva Integration' form.
  2. Enter through date as last day of the month based on the services rendered to the client.
  3. Verify the 'Through Accounting Period' is auto-populated based on the through date entered.
  4. Select desired value from the 'Charges To Include' field.
  5. Click [Review Transaction].
  6. Verify the crystal report launched and it includes the transactions of the client for the accounting period.
  7. Click [Run the Geneva Integration].
  8. Verify the csv file has been generated to the specified dictionary set up in the 'Setup' section.
  9. Review the text file.
  10. Verify the file contains the transactions of the client for the accounting period.
  11. Open 'Geneva Integration' form again.
  12. Enter through date as last day of the second month based on the services rendered to the client.
  13. Verify the 'Through Accounting Period' is auto-populated based on the through date entered.
  14. Select desired value from the 'Charges To Include' field.
  15. Click [Review Transaction].
  16. Verify the crystal report launched and it includes the transactions of the client for the current accounting period only and does not include transactions from the previous accounting period.
  17. Click [Run the Geneva Integration].
  18. Verify the csv file has been generated to the specified dictionary set up in the 'Setup' section and it contains the transactions of the client for the current accounting period only and does not include transactions from the previous accounting period.
  19. Review the text file.
  20. Verify the file contains the transactions of the client for the accounting period of csv files generated between 7/31/23 and 8/31/23 have duplicate entries (same service date, amount, time).
Topics
• NX • Print General Ledger Payment/Adjustment Interface
 

Avatar_GL_2023_Quarterly_Release_2023.02_Details.csv