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:
- Dictionary Update (PM)
- General Ledger Interface Components
- General Ledger Charge Account Numbers
- Crystal Report Viewer
- 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
- Open the 'General Ledger Payment/Adjustment Account Numbers' form.
- Select component and the component value for each of the components.
- In the 'Credit General Ledger Pay/Adj Account Number' field select desired account from the dropdown list.
- In the 'Debit General Ledger Pay/Adj Account Number' field select desired account from the dropdown list.
- Click [File General Ledger Pay/Adj Account Numbers].
- Go to the 'G/L Defaults for Pay/Adj' section.
- Select desired account from the 'Default Credit General Ledger Pay/Adj Account Number' dropdown list.
- Select desired account from the 'Default Debit General Ledger Pay/Adj Account Number' dropdown list.
- Click [File Default General Ledger Pay/Adj Account Numbers].
- Go to the 'Print G/L Pay/Adj Table' section.
- Click [Print Crystal Report].
- Verify the report displays all the components correctly with the value entered/selected for the component.
- Open the 'Crystal report' or any other SQL data Viewer.
- Query 'Select * from GL.pay_adj_account_numbers'.
- 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
- Open the 'Table Import For General Ledger Account Numbers' form.
- Verify the selection for 'GL Payment/ Adjustment Account Numbers' is available.
- Select the 'GL Payment/Adjustment Account Numbers'.
- Select the 'Append to Existing Table'.
- Select the file identified in the setup section.
- Click [Import GL Account Numbers].
- Verify the data imported correctly and displays the 'Total Number of Rows in File'.
- Click [Close Report].
- Open the 'General Ledger Payment/Adjustment Account Numbers' form.
- Select ' Print G/L Pay/Adj Table' section.
- Click [Crystal Report].
- Verify the new row added to the table and displays data correctly as imported though file import.
