Skip to main content

Avatar GL 2022 Update 2

Product Requirements / Recommendations

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

Product Update Form Description

An issue is resolved where the Crystal Report launched from the 'General Ledger Payment/Adjustment Account Numbers' form may not display the Admission Program.

Included Updates

None

Required Updates

None

Details

NEW1 CHANGED0 FIXED0
New (1)
General Ledger Payment/Adjustment Account Numbers - Crystal Report
The crystal report of the 'General Ledger Payment/Adjustment Account Numbers' form displays all the components with the correct component values.

KB0069723 v0.01
Value Added: The 'General Ledger Payment/Adjustment Account Numbers' is updated to include the value of 'Admission Program' in the crystal report if it is defined as an interface component.
Topics
• NX • Print General Ledger Payment/Adjustment Interface
 
Acceptance Tests

AV-79003 Summary | Details
General Ledger Payment/Adjustment Account Numbers - Crystal Report
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 Charge Account Numbers
  • General Ledger Interface Components
  • General Ledger Payment/Adjustment Account Numbers
  • Registry Settings (PM)
  • Table Import For General Ledger Account Numbers
Scenario 1: General Ledger Payment/Adjustment Account Numbers - Crystal Report Validation
Specific Setup:
  • System updated with Avatar GL module.
  • General Ledger Interface components are defined. Note the components.
  • General Ledger Charge Account Numbers and default account numbers are defined. Note the account codes/values.
  • Dictionary Update:
  • File: G/L Interface
  • (200) - Credit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the values.
  • (201) - Debit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the values.
  • (202) - Credit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the values.
  • (203) - Debit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the values.
Steps
  1. Open the 'General Ledger Payment/Adjustment Account Numbers' form.
  2. Select component and the component value for each of the components.
  3. In the 'Credit General Ledger Pay/Adj Account Number' field select desired account from the dropdown list.
  4. In the 'Debit General Ledger Pay/Adj Account Number' field select desired account from the dropdown list.
  5. Click [File General Ledger Pay/Adj Account Numbers].
  6. Go to the 'G/L Defaults for Pay/Adj' section.
  7. Select desired account from the 'Default Credit General Ledger Pay/Adj Account Number' dropdown list.
  8. Select desired account from the 'Default Debit General Ledger Pay/Adj Account Number' dropdown list.
  9. Click [File Default General Ledger Pay/Adj Account Numbers].
  10. Go to the 'Print G/L Pay/Adj Table' section.
  11. Click [Print Crystal Report].
  12. Verify the report displays all the components correctly with the value entered/selected for the component.
  13. Open the 'Crystal report' or any other SQL data Viewer.
  14. Query 'Select * from GL.pay_adj_account_numbers'.
  15. Verify the SQL table displays the correct component descriptions and values for each of the component selected.
Scenario 2: Table Import For General Ledger Account Numbers - Payment Adjustment Account Numbers
Specific Setup:
  • System updated with Avatar GL module.
  • General Ledger Interface components are defined. Note the components.
  • General Ledger Charge Account Numbers and default account numbers are defined. Note the account codes/values.
  • Dictionary Update:
  • File: G/L Interface
  • (200) - Credit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the values.
  • (201) - Debit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the values.
  • (202) - Credit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the values.
  • (203) - Debit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the values.
  • File Explorer:
  • A file is created to add general ledger 'Payment Adjustment Account Number'.
Steps
  1. Open the 'Table Import For General Ledger Account Numbers' form.
  2. Verify the selection for 'GL Payment/ Adjustment Account Numbers' is available.
  3. Select the 'GL Payment/Adjustment Account Numbers'.
  4. Select the 'Append to Existing Table'.
  5. Select the file identified in the setup section.
  6. Click [Import GL Account Numbers].
  7. Verify the data imported correctly and displays the 'Total Number of Rows in File'.
  8. Click [Close Report].
  9. Open the 'General Ledger Payment/Adjustment Account Numbers' form.
  10. Select ' Print G/L Pay/Adj Table' section.
  11. Click [Crystal Report].
  12. Verify the new row added to the table and displays data correctly as imported though file import.
Topics
• NX • Print General Ledger Payment/Adjustment Interface

 

  • Was this article helpful?