Payment Acknowledgement - Compile General Ledger Payment/Adjustment Interface File
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
- Compile General Ledger Payment/Adjustment Interface File
- Crystal Report Viewer
- General Ledger Payment Acknowledgement Account Numbers
- General Ledger Payment Acknowledgement Interface Components
- Posting/Adjustment Codes Definition
- Registry Settings (PM)
- User Definition
- Admission (Outpatient)
- Batch Cash Posting
- Client Ledger
- Compile General Ledger Charge Interface File
- Dictionary Update (PM)
- Financial Eligibility
- General Ledger Charge Account Numbers
- General Ledger Payment/Adjustment Account Numbers
- Payment Acknowledgement
Scenario 1: Enable Payment Acknowledgement - Forms, Fields and Table validation
Steps
- 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' and 'General Ledger Payment Acknowledgement Account Numbers' forms are not available under the 'General Ledger Interface' item.
- Click [OK].
- Click [Select Tables for Product SQL Access].
- Verify the 'payack_account_numbers' sql table is not available under 'GL' database and in the Avatar PM namespace.
- Click [OK].
- Click [Submit].
- Click [No].
- Open the ‘Posting/Adjustment Code Definition’ form.
- Select ‘Edit’ and select any posting code.
- Verify that the 'Payment Acknowledgement Type' field is not displayed on the form.
- Close the form.
- 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' and 'General Ledger Payment Acknowledgement Account Numbers' forms are available under the 'General Ledger Interface' item.
- Select the 'Payment Acknowledgement', 'General Ledger Payment Acknowledgement Interface Components' and 'General Ledger Payment Acknowledgement Account Numbers' forms.
- Click [OK].
- Click [Select Tables for Product SQL Access].
- Verify the 'payack_account_numbers' sql table is available under 'GL' database and in the Avatar PM namespace.
- Select the 'payack_account_numbers' sql table.
- Click [OK].
- Click [Submit].
- Click [No].
- Verify the 'Payment Acknowledgement', 'General Ledger Payment Acknowledgement Interface Components' and 'General Ledger Payment Acknowledgement Account Numbers' forms are accessible from the menu.
- Open the ‘Posting/Adjustment Code Definition’.
- Select ‘Edit’ and select any posting code.
- Verify that the 'Payment Acknowledgement Type' field is displayed on the form.
- Close the form.
- Open the ‘Compile General Ledger Payment/Adjustment Interface File’ form.
- Verify that the ‘Include Payments Acknowledgments’ field displayed on the form with two options: 1. Payment Acknowledgement 2. Post Payment Entry
- Close the form.
- Open the 'Registry Settings' form.
- Select the 'Prevent Posting Payments Unless Payment has been Acknowledged' registry setting.
- Verify the system allows user to select any value from the available values.
- Close the form.
Scenario 2: Payment Acknowledgement - Compile General Ledger Payment/Adjustment Interface File-Batch Cash Posting
Specific Setup:
- System updated with Avatar GL module.
- General Ledger Charge Account Numbers and default account numbers are defined.
- General Ledger Payment/Adjustment components and account numbers are defined.
- Registry Setting:
- The 'Enable Payment Acknowledgement' registry setting is enabled.
- The 'Prevent Posting Payments Unless Payment has been Acknowledged' registry setting is set to '1&2'.
- Dictionary Update:
- File: Client
- (101) - Treatment Service - enter a code/value and then select the Program extended dictionary and enter desired value (i.e. 000111). Note dictionary code/value. Please note - The value entered here will also need to be added to the 'Program (5521)' dictionary in other tabled files for testing the GL compile.
- File: Other Table Files:
- (5521) Program - contains dictionary codes and dictionary values. Add the extended dictionary value from the '(101) Client' file and 'Treatment Service' dictionary.
- (5522) Account - contains dictionary codes, dictionary values and extended dictionary values.
- File: G/L Interface
- (204) - Credit G/L Payment Acknowledgement Account Number - contains dictionary codes and dictionary values.
- (205) - Debit G/L Payment Acknowledgement Account Number - contains dictionary codes and dictionary values.
- Admission:
- A client is identified with charges that resulted in payments, and/or adjustments being posted to the charges.
- Guarantor/Payors:
- An existing guarantor is identified who does not have a Financial Class that has the Extended Data Element for (1500) System Financial Class set to Self Pay. Note the guarantor's code/name.
- Financial Eligibility:
- Assign desired guarantor to the client.
- Client Charge Input:
- A service is rendered to the client.
- Client Ledger:
- Make sure the service is distributed to the guarantor assigned to the client.
Steps
- 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.
- Use Crystal Reports or any other SQL data viewer.
- Validate the SQL Table GL.payack_account_numbers displays data as they entered in the 'General Ledger Payment Acknowledgement Account Numbers' 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 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].
- Add the new row for post payment accounting entry.
- File the form.
- 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 'No' 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 the 'Compile General Ledger Payment/Adjustment Interface File' form.
- Select dates that cover the transactions above and select 'no' for pre compile.
- Do not select anything in the new 'Include Payment Acknowledgements' field.
- Click [Process].
- Verify it generates the payment adjustment GL strings.
- Return to the form.
- Select 'Payment Acknowledgements' in the new field.
- Click [Process].
- Verify the GL strings for the Payment Acknowledgement GL Account Numbers are generated.
- Return to the form.
- Select 'Post Payment Entry' in the new field.
- Click [Process].
- Verify the GL strings for the Post Payment Entry account numbers are generated.
- Open the 'Crystal Reports' or any other SQL Data Reporting tool.
- Select the PM namespace.
- Identify desired database and SQL table - GL.comp_pay_ack_int_detail
- Locate to the SQL Editor
- Query 'Select * from GL.comp_pay_ack_int_detail WHERE PATID=[Desired ClientId].
- Validate the FACILITY cell is equal to '98'
- Validate the 1st PATID cell is equal to the client id identified in the setup section.
- Validate the EPISODE_NUMBER column displays correct value.
- Validate the GUARANTOR_ID column displays correct value.
- Validate the 'amount 'cell displays the correct amount from the payment acknowledgement form.
- Validate the gl_credit_number cell displays the correct account number set up.
- Validate the gl_debit_number cell displays the correct account number set up.
- Validate the 'interface_component_1_cd' displays the correct value from the setup.
|
Topics
• 835 Health Care Claim Payment/Advice
• NX
• Payment Acknowledgement
|
Payment Acknowledgement - General Ledger components, accounts and compile
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
- Compile General Ledger Payment/Adjustment Interface File
- Crystal Report Viewer
- General Ledger Payment Acknowledgement Account Numbers
- General Ledger Payment Acknowledgement Interface Components
- Posting/Adjustment Codes Definition
- Registry Settings (PM)
- User Definition
- Admission (Outpatient)
- Batch Cash Posting
- Client Ledger
- Compile General Ledger Charge Interface File
- Dictionary Update (PM)
- Financial Eligibility
- General Ledger Charge Account Numbers
- General Ledger Payment/Adjustment Account Numbers
- Payment Acknowledgement
Scenario 1: Enable Payment Acknowledgement - Forms, Fields and Table validation
Steps
- 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' and 'General Ledger Payment Acknowledgement Account Numbers' forms are not available under the 'General Ledger Interface' item.
- Click [OK].
- Click [Select Tables for Product SQL Access].
- Verify the 'payack_account_numbers' sql table is not available under 'GL' database and in the Avatar PM namespace.
- Click [OK].
- Click [Submit].
- Click [No].
- Open the ‘Posting/Adjustment Code Definition’ form.
- Select ‘Edit’ and select any posting code.
- Verify that the 'Payment Acknowledgement Type' field is not displayed on the form.
- Close the form.
- 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' and 'General Ledger Payment Acknowledgement Account Numbers' forms are available under the 'General Ledger Interface' item.
- Select the 'Payment Acknowledgement', 'General Ledger Payment Acknowledgement Interface Components' and 'General Ledger Payment Acknowledgement Account Numbers' forms.
- Click [OK].
- Click [Select Tables for Product SQL Access].
- Verify the 'payack_account_numbers' sql table is available under 'GL' database and in the Avatar PM namespace.
- Select the 'payack_account_numbers' sql table.
- Click [OK].
- Click [Submit].
- Click [No].
- Verify the 'Payment Acknowledgement', 'General Ledger Payment Acknowledgement Interface Components' and 'General Ledger Payment Acknowledgement Account Numbers' forms are accessible from the menu.
- Open the ‘Posting/Adjustment Code Definition’.
- Select ‘Edit’ and select any posting code.
- Verify that the 'Payment Acknowledgement Type' field is displayed on the form.
- Close the form.
- Open the ‘Compile General Ledger Payment/Adjustment Interface File’ form.
- Verify that the ‘Include Payments Acknowledgments’ field displayed on the form with two options: 1. Payment Acknowledgement 2. Post Payment Entry
- Close the form.
- Open the 'Registry Settings' form.
- Select the 'Prevent Posting Payments Unless Payment has been Acknowledged' registry setting.
- Verify the system allows user to select any value from the available values.
- Close the form.
Scenario 2: Payment Acknowledgement - Compile General Ledger Payment/Adjustment Interface File-Batch Cash Posting
Specific Setup:
- System updated with Avatar GL module.
- General Ledger Charge Account Numbers and default account numbers are defined.
- General Ledger Payment/Adjustment components and account numbers are defined.
- Registry Setting:
- The 'Enable Payment Acknowledgement' registry setting is enabled.
- The 'Prevent Posting Payments Unless Payment has been Acknowledged' registry setting is set to '1&2'.
- Dictionary Update:
- File: Client
- (101) - Treatment Service - enter a code/value and then select the Program extended dictionary and enter desired value (i.e. 000111). Note dictionary code/value. Please note - The value entered here will also need to be added to the 'Program (5521)' dictionary in other tabled files for testing the GL compile.
- File: Other Table Files:
- (5521) Program - contains dictionary codes and dictionary values. Add the extended dictionary value from the '(101) Client' file and 'Treatment Service' dictionary.
- (5522) Account - contains dictionary codes, dictionary values and extended dictionary values.
- File: G/L Interface
- (204) - Credit G/L Payment Acknowledgement Account Number - contains dictionary codes and dictionary values.
- (205) - Debit G/L Payment Acknowledgement Account Number - contains dictionary codes and dictionary values.
- Admission:
- A client is identified with charges that resulted in payments, and/or adjustments being posted to the charges.
- Guarantor/Payors:
- An existing guarantor is identified who does not have a Financial Class that has the Extended Data Element for (1500) System Financial Class set to Self Pay. Note the guarantor's code/name.
- Financial Eligibility:
- Assign desired guarantor to the client.
- Client Charge Input:
- A service is rendered to the client.
- Client Ledger:
- Make sure the service is distributed to the guarantor assigned to the client.
Steps
- 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.
- Use Crystal Reports or any other SQL data viewer.
- Validate the SQL Table GL.payack_account_numbers displays data as they entered in the 'General Ledger Payment Acknowledgement Account Numbers' 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 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].
- Add the new row for post payment accounting entry.
- File the form.
- 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 'No' 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 the 'Compile General Ledger Payment/Adjustment Interface File' form.
- Select dates that cover the transactions above and select 'no' for pre compile.
- Do not select anything in the new 'Include Payment Acknowledgements' field.
- Click [Process].
- Verify it generates the payment adjustment GL strings.
- Return to the form.
- Select 'Payment Acknowledgements' in the new field.
- Click [Process].
- Verify the GL strings for the Payment Acknowledgement GL Account Numbers are generated.
- Return to the form.
- Select 'Post Payment Entry' in the new field.
- Click [Process].
- Verify the GL strings for the Post Payment Entry account numbers are generated.
- Open the 'Crystal Reports' or any other SQL Data Reporting tool.
- Select the PM namespace.
- Identify desired database and SQL table - GL.comp_pay_ack_int_detail
- Locate to the SQL Editor
- Query 'Select * from GL.comp_pay_ack_int_detail WHERE PATID=[Desired ClientId].
- Validate the FACILITY cell is equal to '98'
- Validate the 1st PATID cell is equal to the client id identified in the setup section.
- Validate the EPISODE_NUMBER column displays correct value.
- Validate the GUARANTOR_ID column displays correct value.
- Validate the 'amount 'cell displays the correct amount from the payment acknowledgement form.
- Validate the gl_credit_number cell displays the correct account number set up.
- Validate the gl_debit_number cell displays the correct account number set up.
- Validate the 'interface_component_1_cd' displays the correct value from the setup.
|
Topics
• 835 Health Care Claim Payment/Advice
• NX
• Payment Acknowledgement
|