Skip to main content

Avatar GL 2024 Update 2

  1. Last updated
  2. Save as PDF

Product Requirements and Recommendations

Avatar GL required
Avatar PM required
RADplus required
Avatar Cal-PM

Recommended Update Level

Avatar Cal-PM 2024 Monthly Release 2024.00.00
Avatar GL 2024 Monthly Release 2024.00.00
Avatar PM 2024 Monthly Release 2024.00.00
RADplus 2024 Monthly Release 2024.00.00

Product Update Description

The 'Include Payment Acknowledgments' field in the 'Compile General Ledger Payment/Adjustment Interface File' form is modified to be multi-select. Note: This field is added via the 'Enable Payment Acknowledgement' registry setting.

Required Updates

None

Included Updates

None

Details
NEW1 CHANGED0 FIXED0
New (1)
Compile GL Payment/Adjustment Interface File - Include Payment Acknowledgement
The 'Compile General Ledger Payment/Adjustment Interface File' form is updated to change the field type of 'Include Payment Acknowledgement' to a multi select dictionary from a single select dictionary.
The 'Include Payment Acknowledgement' field in the 'Compile General Ledger Payment/Adjustment Interface File' is updated to a multi select dictionary so the user can run the 'Payment/Adjustments', 'Payment Acknowledgement' and 'Post payment Accounting Entry’ reports at once if needed instead of running each one separately.
Value Added: The user will be able to compile all three reports at once instead of compile one at a time.
Topics
• 835 Health Care Claim Payment/Advice • NX • Payment Acknowledgement • Print General Ledger Payment/Adjustment Interface
 
Acceptance Tests
AV-90995 Summary | Details
Compile GL Payment/Adjustment Interface File - Include Payment Acknowledgement
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Admission (Outpatient)
  • Client Ledger
  • Compile General Ledger Payment/Adjustment Interface File
  • Crystal Report Viewer
  • Dictionary Update (PM)
  • Financial Eligibility
  • General Ledger Charge Account Numbers
  • General Ledger Interface Components
  • General Ledger Payment/Adjustment Account Numbers
  • Individual Cash Posting (PM)
  • Posting/Adjustment Codes Definition
  • Print General Ledger Payment/Adjustment Interface File Detail
  • Batch Cash Posting
  • General Ledger Payment Acknowledgement Account Numbers
  • General Ledger Payment Acknowledgement Interface Components
  • Payment Acknowledgement
  • Print General Ledger Payment Acknowledgement Interface Detail
  • Registry Settings (PM)
Scenario 1: Compile General Ledger Payment/Adjustment Interface File detail - Validating 'GL.compile_payadj_int_detail' SQL table - Registry setting 'Enable Payment Acknowledgement' = N
Specific Setup:
  • Registry setting 'Enable Payment Acknowledgement' is set to 'No'.
  • System updated with Avatar GL module.
  • 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.
  • 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 is 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.
  • 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. Note the posting date.
  • Close Charges:
  • Close the charges.
Steps
  1. Open the 'General Ledger Interface Components' form.
  2. Select desired number of components for 'Number of Treatment String Items To Be Included Within General Ledger Interface Components' field.
  3. Select desired components. Note the selected components.
  4. Submit the form.
  5. Open the 'General Ledger Charge Account Numbers' form.
  6. Select component value for each of the components. Note the values.
  7. Select desired account from the 'Credit General Ledger Charge Account Number' field.
  8. Select desired account from the 'Debit General Ledger Charge Account Number' field.
  9. Click [File General Ledger Charge Account Numbers].
  10. Go to 'G/L Defaults for Charges' section.
  11. Select desired account from the 'Default Credit General Ledger Charge Account Number' dropdown list.
  12. Select desired account from the 'Default Debit General Ledger Charge Account Number' dropdown list.
  13. Click [File Default General Ledger Charge Account Numbers].
  14. Close the form.
  15. Open the 'General Ledger Payment/Adjustment Account Numbers' form.
  16. Select the component value for each of the components.
  17. Select desired account from the 'Credit General Ledger Pay/Adj Account Number' field.
  18. Select desired account from the 'Debit General Ledger Pay/Adj Account Number' field.
  19. Click [File General Ledger Pay/Adj Account Numbers].
  20. Go to the 'G/L Defaults for Pay/Adj' section.
  21. Select desired account from the 'Default Credit General Ledger Pay/Adj Account Number' dropdown list.
  22. Select desired account from the 'Default Debit General Ledger Pay/Adj Account Number' dropdown list.
  23. Click [File Default General Ledger Pay/Adj Account Numbers].
  24. Close the form.
  25. Open the 'Compile General Ledger Payment/Adjustment Interface File' form.
  26. Enter the billing period and GL posting date.
  27. Select 'No' for Pre-Compile.
  28. Click [Process].
  29. Verify the GL strings for the Payments/Adjustments account numbers are generated.
  30. Return to the form.
  31. Select 'Yes' for Pre-Compile.
  32. Click [Process].
  33. Verify the report contains a message to go to the 'Print General Ledger Payment/Adjustment Interface File detail'.
  34. Open the 'Print General Ledger Payment/Adjustment Interface File detail' form.
  35. Choose the same billing period from compile and process the results.
  36. Open the 'Crystal report' or any other SQL data viewer.
  37. Query the 'Select * from GL.compile_payadj_int_detail' table for the client identified in the setup section.
  38. Verify the accounts and components displays correctly as defined.
  39. Close the 'Crystal Report'.
Scenario 2: Compile General Ledger Payment/Adjustment Interface File - Validating 'Include Payment Acknowledgement' - Registry setting 'Enable Payment Acknowledgement' = Y
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.
  • General Ledger Payment Acknowledgement 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
  • (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.
  • (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.
  • Individual Cash Posting:
  • Post payments, adjustments and/ or transfers for 2-3 services. Note the posting date.
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. 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. Add the new row for post payment accounting entry.
  37. File the form.
  38. Open the 'Batch Cash Posting' form.
  39. Enter desired date to the 'Date of Receipt or Adjustment' field.
  40. Enter desired date to the 'Cash Posting Date' field.
  41. Select 'Payment' in the 'Posting Type' field.
  42. Select 'No' in the 'Payment Acknowledgment' field.
  43. Select desired guarantor.
  44. 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.
  45. Select payment acknowledgement defined for the selected guarantor.
  46. Validate the 'Amount to Post' field defaults to the remaining amount of the selected payment acknowledgment.
  47. Select desired value in the 'Individual or All Clients' field.
  48. Select desired client from the 'Client ID' field if the 'Client ID' field is marked as the required field.
  49. Select desired program from the 'Program of Service' field.
  50. Select service start date in the 'From Date' field.
  51. Select service end date in the 'To Date' field.
  52. Select desired payment acknowledgement code from the 'Posting Code' field.
  53. Validate the 'Receipt' field defaults in the transaction number of the payment acknowledgment If payment acknowledgment is selected.
  54. Enter the same Check/EFT # in the 'Check #' field that is entered in the 'Payment Acknowledgement'.
  55. Select 'Ignore' in the 'Write Off or Ignore Remaining Balance' field.
  56. Click [Process].
  57. Validate the form files successfully.
  58. Open the 'Compile General Ledger Payment/Adjustment Interface File' form.
  59. Select dates that cover the transactions above and select 'no' for pre compile.
  60. Verify the 'Include Payment Acknowledgement' field is multi select checkbox field.
  61. Verify the 'Include Payment Acknowledgement' field contains three options: 1. Payments/Adjustments 2. Payment Acknowledgement 3. Post Payment Accounting Entry
  62. Do not select anything in the 'Include Payment Acknowledgments' field.
  63. Click [Process].
  64. Verify it generates the payment adjustment GL strings.
  65. Return to the form.
  66. Select 'Payment Acknowledgement' in the 'Include Payment Acknowledgments' field.
  67. Click [Process].
  68. Verify the GL strings for the Payment Acknowledgement GL Account Numbers are generated.
  69. Return to the form.
  70. Select 'Post Payment Entry' in the 'Include Payment Acknowledgments' field.
  71. Click [Process].
  72. Verify the GL strings for the Post Payment Entry account numbers are generated.
  73. Return to the form.
  74. Select 'Payments/Adjustments' in the 'Include Payment Acknowledgments' field.
  75. Click [Process].
  76. Verify the GL strings for the Payments/Adjustments account numbers are generated.
  77. Return to the form.
  78. Select 'Payments/Adjustments', 'Payment Acknowledgement', and 'Post Payment Entry' in the 'Include Payment Acknowledgments' field.
  79. Click [Process].
  80. Verify the GL strings for the Payments/Adjustments, Payment Acknowledgement and Post Payment Entry account numbers are generated.
  81. Select 'Payments/Adjustments' and 'Payment Acknowledgement' in the 'Include Payment Acknowledgments' field.
  82. Click [Process].
  83. Verify the GL strings for the Payments/Adjustments and Payment Acknowledgement account numbers are generated.
  84. Return to the form.
  85. Select 'Payments/Adjustments' and 'Post Payment Entry' in the 'Include Payment Acknowledgments' field.
  86. Click [Process].
  87. Verify the GL strings for the Payments/Adjustments and Post Payment Entry account numbers are generated.
  88. Return to the form.
  89. Select different combinations and verify the related GL accounts are displayed.
  90. Return to the form.
  91. Close the form.
Topics
• 835 Health Care Claim Payment/Advice • NX • Payment Acknowledgement • Print General Ledger Payment/Adjustment Interface