Skip to main content

Avatar PM 2022 Update 84

Product Requirements / Recommendations

Avatar PM required
RADplus required

Recommended Update Level

Avatar GL 2022 Update 3
Avatar GL 2022 Update 4

Product Update Form Description

The 'Enable Payment Acknowledgement' registry setting is updated to support new GL interface forms introduced in Avatar GL 2022 update 3.

Included Updates

3, 9, 18, 41, 55, 59, 62, 67, 77

Required Updates

Avatar PM 2022 Update 67
Details

NEW1 CHANGED0 FIXED0
New (1)
Registry Setting - Enable Payment Acknowledgement
The 'Enable Payment Acknowledgement' registry setting is enhanced to support the 'Payment Acknowledgement', 'General Ledger Payment Acknowledgement Interface Components' and 'General Ledger Payment
Acknowledgement Account Numbers' forms.
Value Added: The 'Enable Payment Acknowledgement' registry setting is updated to support new GL interface forms.
Topics
• NX • Payment Acknowledgement
 
Acceptance Tests

AV-80264 Summary | Details
Registry Setting - Enable Payment Acknowledgement
Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:
  • Crystal Report Viewer
  • General Ledger Payment Acknowledgement Account Numbers
  • General Ledger Payment Acknowledgement Interface Components
  • Posting/Adjustment Codes Definition
  • Registry Settings (PM)
  • User Definition
  • Dictionary Update (PM)
  • Form and Table Documentation (PM)
  • Table Import For General Ledger Account Numbers
Scenario 1: Enable Payment Acknowledgement - Forms, Fields and Table validation
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 'Registry Settings' form.
  21. Set the 'Enable Payment Acknowledgement' registry setting to 'Y'.
  22. Submit the form.
  23. Open the 'User Definition' form.
  24. Select the login user from the 'Select User' field.
  25. Click 'Forms and Tables' item.
  26. Click [Select Forms for User Access].
  27. Verify the 'Payment Acknowledgement' form is available under the 'Remittance Processing' item.
  28. Verify the 'General Ledger Payment Acknowledgement Interface Components' and 'General Ledger Payment Acknowledgement Account Numbers' forms are available under the 'General Ledger Interface' item.
  29. Select the 'Payment Acknowledgement', 'General Ledger Payment Acknowledgement Interface Components' and 'General Ledger Payment Acknowledgement Account Numbers' forms.
  30. Click [OK].
  31. Click [Select Tables for Product SQL Access].
  32. Verify the 'payack_account_numbers' sql table is available under 'GL' database and in the Avatar PM namespace.
  33. Select the 'payack_account_numbers' sql table.
  34. Click [OK].
  35. Click [Submit].
  36. Click [No].
  37. Verify the 'Payment Acknowledgement', 'General Ledger Payment Acknowledgement Interface Components' and 'General Ledger Payment Acknowledgement Account Numbers' forms are accessible from the menu.
  38. Open the ‘Posting/Adjustment Code Definition’.
  39. Select ‘Edit’ and select any posting code.
  40. Verify that the 'Payment Acknowledgement Type' field is displayed on the form.
  41. Close the form.
Scenario 2: General Ledger Payment Acknowledgement Account Numbers - Workflow
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 dictionary codes and dictionary values.
  • (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.
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. Repeat adding account numbers with different component combinations.
  9. Repeat adding account numbers with different component combinations with date ranges.
  10. Verify the overlapping date range not allowed for the same component combinations.
  11. Close the form.
  12. Open 'General Ledger Payment Acknowledgement Account Numbers' form.
  13. Go to section 'G/L Payment Acknowledgement Defaults'.
  14. Add default account numbers.
  15. File Default account numbers.
  16. Close the form.
  17. Open the 'General Ledger Payment Acknowledgement Account Numbers' form.
  18. Click [Print Table].
  19. Verify the crystal report of payment acknowledgement account numbers is generated.
  20. Close the report.
  21. Open the 'Form and Table Documentation' form.
  22. Click [Table].
  23. Filter by Billing -> General Ledger Interface -> General Ledger Payment Acknowledgement Account Numbers.
  24. Select GL.payack_account_numbers table.
  25. Validate SQL documentation displays all the fields added to the 'General Ledger Payment Acknowledgement Account Numbers' form.
  26. Close the form.
  27. Use Crystal Reports or any other SQL data viewer.
  28. Validate the SQL Table GL.payack_account_numbers displays data as they entered in the 'General Ledger Payment Acknowledgement Account Numbers' form.
Scenario 3: Table Import For General Ledger Account Numbers - Payment Acknowledgement Account Numbers - Append To Existing Table
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 dictionary codes and dictionary values.
  • (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.
  • File Explorer:
  • First file is created to add general ledger 'Payment Acknowledgement Account Number' without any dates specified in the file.
  • Second file is created to add general ledger 'Payment Acknowledgement Account Number' with the start/end dates specified in the file.
  • Third file is created to add overlapping general ledger 'Payment Acknowledgement Account Number'.
Steps
  1. Open the 'Table Import For General Ledger Account Numbers' form.
  2. Verify the selection for 'GL Payment Acknowledgement Account Numbers' is available.
  3. Select the 'GL Payment Acknowledgement Account Numbers'.
  4. Select the 'Append to Existing Table'.
  5. Select the first file identified in the setup section.
  6. Click [Import GL Account Numbers].
  7. Verify the data generated was imported based on the criteria previously selected and correctly displays the 'Total Number of Rows in File'.
  8. Click [Close Report].
  9. Select the first file identified in the setup section again.
  10. Click [Import GL Account Numbers].
  11. Verify the system prevents the account numbers to add because of duplicate existing records.
  12. Click [Close Report].
  13. Select the second file identified in the setup section.
  14. Click [Import GL Account Numbers].
  15. Verify the data generated was imported based on the criteria previously selected and correctly displays the 'Total Number of Rows in File'.
  16. Click [Close Report].
  17. Select the third file identified in the setup section.
  18. Click [Import GL Account Numbers].
  19. Verify the data generated was imported based on the criteria previously selected and correctly displays the 'Total Number of Rows in File'.
  20. Verify the system prevents the account numbers to add because of duplicate existing records.
  21. Click [Close Report].
Scenario 4: Table Import For General Ledger Account Numbers - Payment Acknowledgement Account Numbers -Override an existing table
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 dictionary codes and dictionary values.
  • (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.
  • File Explorer:
  • First file is created to add general ledger 'Payment Acknowledgement Account Number' without any dates specified in the file. Note the values specified in the file.
  • Second file is created with the different component value for the component one. Note the values specified in the file.
Steps
  1. Open the 'Table Import For General Ledger Account Numbers' form.
  2. Verify the selection for 'GL Payment Acknowledgement Account Numbers' is available.
  3. Select the 'GL Payment Acknowledgement Account Numbers'.
  4. Select the 'Over-Ride Existing Table' from the 'Load Option' field.
  5. Select the first file identified in the setup section.
  6. Click [Import GL Account Numbers].
  7. Verify the data generated was imported based on the criteria previously selected and correctly displays the 'Total Number of Rows in File'.
  8. Click [Close Report].
  9. Select the first file identified in the setup section again.
  10. Click [Import GL Account Numbers].
  11. Verify the system overrides an existing record.
  12. Click [Close Report].
  13. Select the second file identified in the setup section.
  14. Click [Import GL Account Numbers].
  15. Verify the SQL table displays a record that is recently imported and overrides an existing record of the file.
  16. Click [Close Report].
  17. Select the third file identified in the setup section.
  18. Click [Import GL Account Numbers].
  19. Verify the data generated was imported based on the criteria previously selected and correctly displays a row that overrides an existing record of the file.
  20. Click [Close Report].
  21. Click [Close Form].
Topics
• NX • Payment Acknowledgement