Avatar PM 2023 Update 115

Last updated
Save as PDF

Product Requirements and Recommendations

Avatar PM required
RADplus required

Recommended Update Level

Avatar PM 2023 Monthly Release 2023.02.02
RADplus 2023 Monthly Release 2023.02.02

Product Update Description

The 'Payment Acknowledgement' form is modified to include transactions related to Client Services in the 'Posting Summary' field. Support is added to the 'Enable Payment Acknowledgement' registry setting for the 'Print General Ledger Payment Acknowledgement Interface Detail' form which is introduced in Avatar GL 2023 update 3.

Required Updates

None

Included Updates

10, 17, 18, 21, 25, 35, 39, 44, 56, 57, 62, 63, 66, 67, 72, 73, 76, 77, 78, 79, 85, 88, 89, 93, 94, 96, 98, 101, 102, 109

Details

NEW1 CHANGED0 FIXED0

New (1)

AV-91332 Details | User Acceptance Tests

Payment Acknowledgement - Pending Posting Summary

The 'Payment Acknowledgement' form is modified to include transactions related to Client Services in the 'Posting Summary' field.

The 'Payment Acknowledgement' form is modified to expand the 'Posting Summary' display box to include the remaining/outstanding balance and details for payments related to client services.

Value Added: Support is added to the 'Enable Payment Acknowledgement' registry setting for the 'Print General Ledger Payment Acknowledgement Interface Detail' form.

Topics

• GL • NX • Payment Acknowledgement

Acceptance Tests

AV-91332 Summary | Details

Payment Acknowledgement - Pending Posting Summary

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
Financial Eligibility
General Ledger Payment Acknowledgement Account Numbers
GL_Payment_Acknowledgement_Interface_Detail.rpt
Payment Acknowledgement
Print General Ledger Payment Acknowledgement Interface Detail
Registry Settings (PM)
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

Open the 'Payment Acknowledgement General Ledger Interface Components' form.
Select components.
Submit the form.
Open the 'General Ledger Payment Acknowledgement Account Numbers' form.
Select component and the component value for each of the components.
Select credit and debit account numbers.
File Account numbers for each component and date range (optional) combination.
Go to section 'G/L Payment Acknowledgement Defaults'.
Add default account numbers.
File Default account numbers.
Submit the form.
Open ‘Payment Acknowledgment’ form.
Enter desired value in ‘Batch Number’.
Select desired ‘Posting Code’.
Enter desired value in ‘Check/EFT Number’.
Enter desired value in ‘Amount’.
Select desired ‘Guarantor’. If a ‘Self-Pay guarantor is selected, the ‘Client’ field will be enabled.
Enter desired value in ‘Name/Source’.
Enter desired value in ‘Client’, if enabled.
Enter desired value in ‘Check/EFT Date’. Note the Check/EFT number to be used in the 'Batch Cash Posting'.
Enter desired value in ‘Receipt Date’.
Enter desired value in ‘Deposit Date’.
Select desired ‘Treatment Service’. Please note: The treatment service used must have program extended dictionary setup in the setup section.
Select desired ‘Category’ from 'Account' dictionary.
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.
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.
Enter desired value in ‘Bank Ref #’.
Enter desired value in ‘Comments’.
Click [File].
Verify that the ‘Payment Acknowledgement’ message is received and states the following: Filed successfully. The Transaction Number is [Number].
Click [Discard].
Open the 'Compile General Ledger Payment/Adjustment Interface File' form.
Select dates that cover the transactions above and select 'Yes' for pre compile.
Select 'Payment Acknowledgement' in the 'Include Payment Acknowledgement' field.
Click [Process].
Validate the message that ask user to navigate to 'Print General Ledger Payment/Adjustment Interface File Detail' form to see the report.
Open the 'Print General Ledger Payment/Adjustment Interface File Detail' form.
Enter the date range of the report.
Process the report.
Verify the report displays data correctly.
Close the report.
Close the form.
Enter rows with the Account, Treatment Service and Program used as components.
The following ‘Payment Acknowledgement’ displays: Filed successfully. Do you need to continue with Post Payment Accounting Entry?
File the form.
Open the 'Compile General Ledger Payment/Adjustment Interface File' form.
Select dates that cover the transactions above and select 'Yes' for pre compile.
Select 'Payment Acknowledgement' in the 'Include Payment Acknowledgement' field.
Click [Process].
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.
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

Open the 'Registry Settings' form.
Set the 'Enable Payment Acknowledgement' registry setting to 'N'.
Submit the form.
Open the 'User Definition' form.
Select the login user from the 'Select User' field.
Click 'Forms and Tables' item.
Click [Select Forms for User Access].
Verify the 'Payment Acknowledgement' form is not available under the 'Remittance Processing' item.
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.
Click [OK].
Click [Submit].
Click [No].
Open the ‘Compile General Ledger Payment/Adjustment Interface File’ form.
Verify that the ‘Include Payments Acknowledgments’ field not displayed on the form.
Close the form.
Open the 'Registry Settings' form.
Select the 'Prevent Posting Payments Unless Payment has been Acknowledged' registry setting.
Verify the registry setting is set to '0' and system does not allow to make any selections other than zero.
Open the 'Registry Settings' form.
Set the 'Enable Payment Acknowledgement' registry setting to 'Y'.
Submit the form.
Open the 'User Definition' form.
Select the login user from the 'Select User' field.
Click 'Forms and Tables' item.
Click [Select Forms for User Access].
Verify the 'Payment Acknowledgement' form is available under the 'Remittance Processing' item.
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.
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.
Click [OK].
Click [Submit].
Click [No].
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

Open the 'Payment Acknowledgement General Ledger Interface Components' form.
Select components.
Submit the form.
Open the 'General Ledger Payment Acknowledgement Account Numbers' form.
Select component and the component value for each of the components.
Select credit and debit account numbers.
File Account numbers for each component and date range (optional) combination.
Go to section 'G/L Payment Acknowledgement Defaults'.
Add default account numbers.
File Default account numbers.
Submit the form.
Open ‘Payment Acknowledgment’ form.
Enter desired value in ‘Batch Number’.
Select desired ‘Posting Code’.
Enter desired value in ‘Check/EFT Number’.
Enter desired value in ‘Amount’.
Select desired ‘Guarantor’. If a ‘Self-Pay guarantor is selected, the ‘Client’ field will be enabled.
Enter desired value in ‘Name/Source’.
Enter desired value in ‘Client’, if enabled.
Enter desired value in ‘Check/EFT Date’. Note the Check/EFT number to be used in the 'Batch Cash Posting'.
Enter desired value in ‘Receipt Date’.
Enter desired value in ‘Deposit Date’.
Select desired ‘Treatment Service’. Please note: The treatment service used must have program extended dictionary setup in the setup section.
Select desired ‘Category’ from 'Account' dictionary.
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.
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.
Enter desired value in ‘Bank Ref #’.
Enter desired value in ‘Comments’.
Click [File].
Verify that the ‘Payment Acknowledgement’ message is received and states the following: Filed successfully. The Transaction Number is [Number].
Click [Discard].
Open the 'Compile General Ledger Payment/Adjustment Interface File' form.
Select dates that cover the transactions above and select 'Yes' for pre compile.
Select 'Payment Acknowledgement' in the 'Include Payment Acknowledgement' field.
Click [Process].
Validate the message that ask user to navigate to 'Print General Ledger Payment/Adjustment Interface File Detail' form to see the report.
Open the 'Print General Ledger Payment/Adjustment Interface File Detail' form.
Enter the date range of the report.
Process the report.
Verify the report displays data correctly.
Close the report.
Close the form.
Enter rows with the Account, Treatment Service and Program used as components.
The following ‘Payment Acknowledgement’ displays: Filed successfully. Do you need to continue with Post Payment Accounting Entry?
File the form.
Open the 'Compile General Ledger Payment/Adjustment Interface File' form.
Select dates that cover the transactions above and select 'Yes' for pre compile.
Select 'Payment Acknowledgement' in the 'Include Payment Acknowledgement' field.
Click [Process].
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.
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

Open ‘Payment Acknowledgment’ form.
Enter desired value in ‘Batch Number’.
Select desired ‘Posting Code’.
Enter desired value in ‘Check/EFT Number’.
Enter desired value in ‘Amount’.
Select desired ‘Guarantor’. If a ‘Self-Pay guarantor is selected, the ‘Client’ field will be enabled.
Enter desired value in ‘Name/Source’.
Enter desired value in ‘Client’, if enabled.
Enter desired value in ‘Check/EFT Date’. Note the Check/EFT number to be used in the 'Batch Cash Posting'.
Enter desired value in ‘Receipt Date’.
Enter desired value in ‘Deposit Date’.
Select desired ‘Treatment Service’. Please note: The treatment service used must have program extended dictionary setup in the setup section
Select desired ‘Category’ from 'Account' dictionary.
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.
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.
Enter desired value in ‘Bank Ref #’.
Enter desired value in ‘Comments’.
Click [File].
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.
Clicking [No] returns the user to the ‘Payment Acknowledgement’ section to enter additional payments.
Clicking [Yes] allows the user to post payments in 'Post Payment Accounting Entry'.
Click [Yes].
Click [New Row] in ‘Post Payment Accounting Entry’.
Select desired ‘Treatment Service’. It will default if filed in the ‘Payment Acknowledgement’.
Select desired ‘Program’. This is from ‘Other Table Files: (5521) Program’, not a program in ‘Program Maintenance’.
Select desired ‘Account’.
Select desired ‘Amount’.
Validate that the ‘Posting Code; defaulted from the ‘Payment Acknowledgement’.
Select desired ‘Posting Date’.
Validate that the ‘Posting Summary’ is correct.
If desired, and first row partially posts the 'Amount', click [New Row] and repeat the steps.
If desired, click [Delete Row]. A ‘Confirm Delete’ message will be displayed. Select desired value.
Click [File].
The following ‘Payment Acknowledgement’ displays: Filed successfully. Do you need to continue with Post Payment Accounting Entry?
Click [Yes].
Open the 'Batch Cash Posting' form.
Enter desired date to the 'Date of Receipt or Adjustment' field.
Enter desired date to the 'Cash Posting Date' field.
Select 'Payment' in the 'Posting Type' field.
Select 'Yes' in the 'Payment Acknowledgment' field.
Select desired guarantor.
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.
Select payment acknowledgement defined for the selected guarantor.
Validate the 'Amount to Post' field defaults to the remaining amount of the selected payment acknowledgment.
Select desired value in the 'Individual or All Clients' field.
Select desired client from the 'Client ID' field if the 'Client ID' field is marked as the required field.
Select desired program from the 'Program of Service' field.
Select service start date in the 'From Date' field.
Select service end date in the 'To Date' field.
Select desired payment acknowledgement code from the 'Posting Code' field.
Validate the 'Receipt' field defaults in the transaction number of the payment acknowledgment If payment acknowledgment is selected.
Enter the same Check/EFT # in the 'Check #' field that is entered in the 'Payment Acknowledgement'.
Select 'Ignore' in the 'Write Off or Ignore Remaining Balance' field.
Click [Process].
Validate the form files successfully.
Open ‘Payment Acknowledgment’ form.
Enter the transaction number from the above payment acknowledgement.
Click [Search].
Verify all the details related to the transaction populated correctly in the 'Payment Acknowledgement' section of the form.
Verify the 'Posting summary' field is updated correctly with the transaction posted through the 'Batch Cash Posting'.
Open the 'Crystal Reports' or any other SQL Data Reporting tool.
Select the PM namespace.
Identify desired database and SQL table - SYSTEM.pay_ack_post_pay_acc_ent
Locate to the SQL Editor
Query 'select * from Select * from SYSTEM.pay_ack_post_pay_acc_ent where transaction_number=25
Validate the ID cell is equal to '13'
Validate the account_code cell is equal to '501'
Validate the account_value cell is equal to 'IncludeYRequireY'
Validate the GUARANTOR_ID cell is equal to '100'
Validate the date_of_payment cell is equal to '2022-03-01'
Validate the payment_type_code cell is equal to '100'
Validate the payment_type_value cell does not contain 'Payment - Check'
Validate the payment_amount cell does not contain '25.00'
Validate the option_desc cell is equal to 'Payment Acknowledgement'
Validate the type_of_payment cell is equal to 'PAYMENT'
Close the SQL data viewer.

Topics

• GL • NX • Payment Acknowledgement

Table Changes

Table	Column	Change
SYSTEM.pay_ack_post_pay_acc_ent		method change