Skip to main content

Avatar GL 2024 Monthly Release 2024.02.00 Acceptance Tests

  1. Last updated
  2. Save as PDF
Update 4 Summary | Details
General Ledger Payment Acknowledgement Interface Details Report - Data Verification
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • General Ledger Payment Acknowledgement Interface Components
  • General Ledger Payment Acknowledgement Account Numbers
  • Crystal Report Viewer
  • General Ledger Interface Components
  • General Ledger Payment/Adjustment Account Numbers
  • General Ledger Charge Account Numbers
  • Client Ledger
  • Individual Cash Posting (PM)
  • Payment Acknowledgement
  • Batch Cash Posting
  • Compile General Ledger Payment/Adjustment Interface File
  • Print General Ledger Payment/Adjustment Interface File Detail
  • Print General Ledger Payment Acknowledgement Interface Detail
Scenario 1: General Ledger Payment Acknowledgement Account Numbers - Workflow
Specific Setup:
  • System is updated for General Ledger module.
  • Registry Settings:
  • The ‘Avatar PM->Billing->Remittance Processing->->->Enable Payment Acknowledgement’ registry setting is set to ‘Y’.
  • Dictionary Update:
  • File: Other Table Files:
  • (5521) Program - contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • (5522) Account - contains at least one dictionary code / dictionary value and extended dictionary values. Note the dictionary codes/values and extended dictionary code/value.
  • File: G/L Interface
  • (204) - Credit G/L Payment Acknowledgement Account Number - Contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • (205) - Debit G/L Payment Acknowledgement Account Number - Contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • (200) - Credit G/L Charge Account Number - Contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • (201) - Debit G/L Charge Account Number - Contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • (202) - Credit G/L Payment Adjustment Account Number - Contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • (203) - Debit G/L Payment Adjustment Account Number - Contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • 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.
  • General Ledger Charge Account Numbers and default account numbers are defined.
  • General Ledger Interface Components and General Ledger Payment/Adjustment account numbers are defined.
  • General Ledger Payment/Acknowledgement components and account numbers are defined.
Steps
  1. Open the 'General Ledger Payment Acknowledgement Account Numbers' form.
  2. Verify the "Payment/Adjustment And Transfer Codes" is included as a component.
  3. Select components and the component values for each of the components.
  4. Select credit and debit account numbers.
  5. Set up accounts that incorporate the program entered in the 'Program' extended dictionary of the 'Treatment Service'. (Please note: Repeat adding account numbers with different component combinations with different date ranges if needed/required. The overlapping date range does not allow for the same component combinations).
  6. Click [File Account Numbers].
  7. Go to 'G/L Payment Acknowledgement Defaults' section.
  8. Add default credit and debit account numbers.
  9. File [Default Account Numbers].
  10. Go back to 'General Ledger Payment Acknowledgement Account Numbers' section.
  11. Click [Print Table].
  12. Verify the crystal report of payment acknowledgement account numbers is launched successfully and it includes:
  13. Account
  14. Treatment Service
  15. Program
  16. Start Date Range
  17. End Date Range
  18. Credit Account Code
  19. Debit Account Code.
  20. Default Credit Code
  21. Default Debit Code
  22. Payment/Adjustment And Transfer Codes
  23. Close the report.
  24. Access the 'Crystal Reports' or any other SQL data viewer.
  25. Validate the SQL Table GL.payack_account_numbers displays data as they entered in the 'General Ledger Payment Acknowledgement Account Numbers' form.
  26. Close the 'Crystal Report'.
Scenario 2: Payment Acknowledgement - Print General Ledger Payment Acknowledgement Interface Details
Specific Setup:
  • System is updated for General Ledger module.
  • Registry Settings:
  • The ‘Avatar PM->Billing->Remittance Processing->->->Enable Payment Acknowledgement’ registry setting is set to ‘Y’.
  • Dictionary Update:
  • File: Other Table Files:
  • (5521) Program - contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • (5522) Account - contains at least one dictionary code / dictionary value and extended dictionary values. Note the dictionary codes/values and extended dictionary code/value.
  • File: G/L Interface
  • (204) - Credit G/L Payment Acknowledgement Account Number - Contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • (205) - Debit G/L Payment Acknowledgement Account Number - Contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • (200) - Credit G/L Charge Account Number - Contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • (201) - Debit G/L Charge Account Number - Contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • (202) - Credit G/L Payment Adjustment Account Number - Contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • (203) - Debit G/L Payment Adjustment Account Number - Contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • 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.
  • General Ledger Charge Account Numbers and default account numbers are defined.
  • General Ledger Interface Components and General Ledger Payment/Adjustment account numbers are defined.
  • General Ledger Payment/Acknowledgement components and account numbers are defined.
  • Admission:
  • The 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 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 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 an 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. Click [File].
  32. The following ‘Payment Acknowledgement’ displays: Filed successfully. Do you need to continue with Post Payment Accounting Entry?
  33. Click [Yes].
  34. Add the new row for post payment accounting entry.
  35. File the form.
  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 desired value in the 'Write Off or Ignore Remaining Balance' field.
  54. Click [Process].
  55. Validate the form files successfully.
  56. Open the 'Compile General Ledger Payment/Adjustment Interface File' form.
  57. Select dates that cover the transactions above and select 'no' for pre compile.
  58. Verify the 'Include Payment Acknowledgement' field contains three options: 1. Payments/Adjustments 2. Payment Acknowledgement 3. Post Payment Accounting Entry
  59. Select 'Payments/Adjustments', 'Payment Acknowledgement', and 'Post Payment Entry' in the 'Include Payment Acknowledgments' field.
  60. Click [Process].
  61. Verify the GL strings for the Payments/Adjustments, Payment Acknowledgement and Post Payment Entry account numbers are generated.
  62. Return to the form.
  63. Close the form.
  64. Open the 'Print General Ledger Payment/Adjustment Interface Details' form.
  65. Verify the payment/adjustments transactions for the client are included in the report.
  66. Open the 'Print General Ledger Payment Acknowledgement Interface Details' form.
  67. Verify the default payment acknowledgement account numbers are included in the report.
  68. Verify the account numbers that were created using the "Payment/Adjustment And Transfer Codes" component are included.
  69. Verify no duplicate rows and no rows with type of payment/adjustment in the payment acknowledgement report.
  70. Close the report.
  71. Close form.
General Ledger Payment Acknowledgement Account Numbers - Posting Codes
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • General Ledger Payment Acknowledgement Interface Components
  • General Ledger Payment Acknowledgement Account Numbers
  • Crystal Report Viewer
  • General Ledger Interface Components
  • General Ledger Payment/Adjustment Account Numbers
  • General Ledger Charge Account Numbers
  • Client Ledger
  • Individual Cash Posting (PM)
  • Payment Acknowledgement
  • Batch Cash Posting
  • Compile General Ledger Payment/Adjustment Interface File
  • Print General Ledger Payment/Adjustment Interface File Detail
  • Print General Ledger Payment Acknowledgement Interface Detail
Scenario 1: General Ledger Payment Acknowledgement Account Numbers - Workflow
Specific Setup:
  • System is updated for General Ledger module.
  • Registry Settings:
  • The ‘Avatar PM->Billing->Remittance Processing->->->Enable Payment Acknowledgement’ registry setting is set to ‘Y’.
  • Dictionary Update:
  • File: Other Table Files:
  • (5521) Program - contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • (5522) Account - contains at least one dictionary code / dictionary value and extended dictionary values. Note the dictionary codes/values and extended dictionary code/value.
  • File: G/L Interface
  • (204) - Credit G/L Payment Acknowledgement Account Number - Contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • (205) - Debit G/L Payment Acknowledgement Account Number - Contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • (200) - Credit G/L Charge Account Number - Contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • (201) - Debit G/L Charge Account Number - Contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • (202) - Credit G/L Payment Adjustment Account Number - Contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • (203) - Debit G/L Payment Adjustment Account Number - Contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • 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.
  • General Ledger Charge Account Numbers and default account numbers are defined.
  • General Ledger Interface Components and General Ledger Payment/Adjustment account numbers are defined.
  • General Ledger Payment/Acknowledgement components and account numbers are defined.
Steps
  1. Open the 'General Ledger Payment Acknowledgement Account Numbers' form.
  2. Verify the "Payment/Adjustment And Transfer Codes" is included as a component.
  3. Select components and the component values for each of the components.
  4. Select credit and debit account numbers.
  5. Set up accounts that incorporate the program entered in the 'Program' extended dictionary of the 'Treatment Service'. (Please note: Repeat adding account numbers with different component combinations with different date ranges if needed/required. The overlapping date range does not allow for the same component combinations).
  6. Click [File Account Numbers].
  7. Go to 'G/L Payment Acknowledgement Defaults' section.
  8. Add default credit and debit account numbers.
  9. File [Default Account Numbers].
  10. Go back to 'General Ledger Payment Acknowledgement Account Numbers' section.
  11. Click [Print Table].
  12. Verify the crystal report of payment acknowledgement account numbers is launched successfully and it includes:
  13. Account
  14. Treatment Service
  15. Program
  16. Start Date Range
  17. End Date Range
  18. Credit Account Code
  19. Debit Account Code.
  20. Default Credit Code
  21. Default Debit Code
  22. Payment/Adjustment And Transfer Codes
  23. Close the report.
  24. Access the 'Crystal Reports' or any other SQL data viewer.
  25. Validate the SQL Table GL.payack_account_numbers displays data as they entered in the 'General Ledger Payment Acknowledgement Account Numbers' form.
  26. Close the 'Crystal Report'.
Scenario 2: Payment Acknowledgement - Print General Ledger Payment Acknowledgement Interface Details
Specific Setup:
  • System is updated for General Ledger module.
  • Registry Settings:
  • The ‘Avatar PM->Billing->Remittance Processing->->->Enable Payment Acknowledgement’ registry setting is set to ‘Y’.
  • Dictionary Update:
  • File: Other Table Files:
  • (5521) Program - contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • (5522) Account - contains at least one dictionary code / dictionary value and extended dictionary values. Note the dictionary codes/values and extended dictionary code/value.
  • File: G/L Interface
  • (204) - Credit G/L Payment Acknowledgement Account Number - Contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • (205) - Debit G/L Payment Acknowledgement Account Number - Contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • (200) - Credit G/L Charge Account Number - Contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • (201) - Debit G/L Charge Account Number - Contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • (202) - Credit G/L Payment Adjustment Account Number - Contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • (203) - Debit G/L Payment Adjustment Account Number - Contains at least one dictionary code / dictionary value. Note the dictionary code(s)/value(s).
  • 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.
  • General Ledger Charge Account Numbers and default account numbers are defined.
  • General Ledger Interface Components and General Ledger Payment/Adjustment account numbers are defined.
  • General Ledger Payment/Acknowledgement components and account numbers are defined.
  • Admission:
  • The 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 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 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 an 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. Click [File].
  32. The following ‘Payment Acknowledgement’ displays: Filed successfully. Do you need to continue with Post Payment Accounting Entry?
  33. Click [Yes].
  34. Add the new row for post payment accounting entry.
  35. File the form.
  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 desired value in the 'Write Off or Ignore Remaining Balance' field.
  54. Click [Process].
  55. Validate the form files successfully.
  56. Open the 'Compile General Ledger Payment/Adjustment Interface File' form.
  57. Select dates that cover the transactions above and select 'no' for pre compile.
  58. Verify the 'Include Payment Acknowledgement' field contains three options: 1. Payments/Adjustments 2. Payment Acknowledgement 3. Post Payment Accounting Entry
  59. Select 'Payments/Adjustments', 'Payment Acknowledgement', and 'Post Payment Entry' in the 'Include Payment Acknowledgments' field.
  60. Click [Process].
  61. Verify the GL strings for the Payments/Adjustments, Payment Acknowledgement and Post Payment Entry account numbers are generated.
  62. Return to the form.
  63. Close the form.
  64. Open the 'Print General Ledger Payment/Adjustment Interface Details' form.
  65. Verify the payment/adjustments transactions for the client are included in the report.
  66. Open the 'Print General Ledger Payment Acknowledgement Interface Details' form.
  67. Verify the default payment acknowledgement account numbers are included in the report.
  68. Verify the account numbers that were created using the "Payment/Adjustment And Transfer Codes" component are included.
  69. Verify no duplicate rows and no rows with type of payment/adjustment in the payment acknowledgement report.
  70. Close the report.
  71. Close form.
Topics
• Payment Acknowledgement • Print General Ledger Payment/Adjustment Interface
 

Avatar_GL_2024_Monthly_Release_2024.02.00_Details.csv