Avatar GL 2022 Update 4

Last updated
Save as PDF

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

'Table Import for General Ledger Account Numbers' is updated to support importing GL Payment Acknowledgement Account Numbers. 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

Required Updates

Avatar GL 2022 Update 3

Details

NEW1 CHANGED0 FIXED0

New (1)

AV-80296 Details | User Acceptance Tests

Table Import For General Ledger Account Numbers - Payment Acknowledgement Account Numbers

The 'GL Payment Acknowledgement Account Numbers' option is added to the 'Load Which Table' field of the 'Table Import for General Ledger Account Numbers' form.

Value Added: The 'Table Import For General Account Numbers' form is updated to support the table import of general ledger payment acknowledgement account numbers.

Topics

• NX

Acceptance Tests

AV-80296 Summary | Details

Table Import For General Ledger Account Numbers - Payment Acknowledgement Account Numbers

Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following:

Crystal Report Viewer
Dictionary Update (PM)
General Ledger Payment Acknowledgement Account Numbers
General Ledger Payment Acknowledgement Interface Components
Registry Settings (PM)
Table Import For General Ledger Account Numbers
User Definition

Scenario 1: 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

Open the 'Table Import For General Ledger Account Numbers' form.
Verify the selection for 'GL Payment Acknowledgement Account Numbers' is available.
Select the 'GL Payment Acknowledgement Account Numbers'.
Select the 'Append to Existing Table'.
Select the first file identified in the setup section.
Click [Import GL Account Numbers].
Verify the data generated was imported based on the criteria previously selected and correctly displays the 'Total Number of Rows in File'.
Click [Close Report].
Select the first file identified in the setup section again.
Click [Import GL Account Numbers].
Verify the system prevents the account numbers to add because of duplicate existing records.
Click [Close Report].
Select the second file identified in the setup section.
Click [Import GL Account Numbers].
Verify the data generated was imported based on the criteria previously selected and correctly displays the 'Total Number of Rows in File'.
Click [Close Report].
Select the third file identified in the setup section.
Click [Import GL Account Numbers].
Verify the data generated was imported based on the criteria previously selected and correctly displays the 'Total Number of Rows in File'.
Verify the system prevents the account numbers to add because of duplicate existing records.
Click [Close Report].

Scenario 2: 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

Open the 'Table Import For General Ledger Account Numbers' form.
Verify the selection for 'GL Payment Acknowledgement Account Numbers' is available.
Select the 'GL Payment Acknowledgement Account Numbers'.
Select the 'Over-Ride Existing Table' from the 'Load Option' field.
Select the first file identified in the setup section.
Click [Import GL Account Numbers].
Verify the data generated was imported based on the criteria previously selected and correctly displays the 'Total Number of Rows in File'.
Click [Close Report].
Select the first file identified in the setup section again.
Click [Import GL Account Numbers].
Verify the system overrides an existing record.
Click [Close Report].
Select the second file identified in the setup section.
Click [Import GL Account Numbers].
Verify the SQL table displays a record that is recently imported and overrides an existing record of the file.
Click [Close Report].
Select the third file identified in the setup section.
Click [Import GL Account Numbers].
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.
Click [Close Report].
Click [Close Form].

Topics

• NX