Skip to main content

Avatar GL 2022 Update 3

Product Requirements / Recommendations

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

Recommended Update Level

Avatar PM 2022 Update 84

Product Update Form Description

'General Ledger Payment Acknowledgement Interface Components' and 'General Ledger Payment Acknowledgement Account Numbers' are added. These forms are available with registry setting "Enable Payment Acknowledgement". Please note that Avatar PM 2022 Update 62, 67, and 84 must also be installed in order to make use of this functionality.

Included Updates

None

Required Updates

None

Details

NEW2 CHANGED0 FIXED0
New (2)
General Ledger - Payment Acknowledgement General Ledger Interface Components
The 'Payment Acknowledgement General Ledger Interface Components' form is added to the system through registry setting 'Enable Payment Acknowledgement'.
Value Added: This form will be used to define what components make up a GL string.
Topics
• NX • Payment Acknowledgement
 
General Ledger - General Ledger Payment Acknowledgment Account Numbers
The 'General Ledger Payment Acknowledgment Account Numbers' form is added to the system through registry setting 'Enable Payment Acknowledgement'.
General Ledger Payment Acknowledgment Account Numbers – G/L Interface for Payment Acknowledgment - This form defines the account numbers, credit and debit, tied to a specific combination.
General Ledger Payment Acknowledgment Account Numbers – G/L Defaults for Payment Acknowledgment - When the system does not find a payment acknowledgement GL account number, this is where those payments will hit. Users will be expected review and correct so payments do not remain tied to this default account.
Value Added: The general ledger configuration is updated to give the ability to billing supervisor or system administrator to define and maintain the GL account numbers payment acknowledgement and Post Accounting Entry.
Topics
• NX • Payment Acknowledgement
 
Acceptance Tests

AV-80294 Summary | Details
General Ledger - Payment Acknowledgement General Ledger Interface Components
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
AV-80295 Summary | Details
General Ledger - General Ledger Payment Acknowledgment Account Numbers
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)
  • 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: 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 3: 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

 

  • Was this article helpful?