Avatar GL 2024 Quarterly Release 2024.02 Acceptance Tests

Last updated
Save as PDF

Update 1 Summary \| Details 2024 Update installation Scenario 1: Validate Upgrading Avatar GL 2023 to 2024 is successful when 2023.02.00 is loaded Steps Open the "Product Updates" form. Select the appropriate [Namespace] from the Application dropdown list Click [Select Update/Customization Pack]. Browse to the location for the updates and select the Update 1. Click [OK] on the "File Upload Complete" window. Click [Review Update/Customization Pack Contents]. Verify Update 1 is included. Click [Install Update/Customization Pack]. Click [OK] when the install completes. Click [Close Form].	Topics • Upgrade • NX
Update 2 Summary \| Details Compile GL Payment/Adjustment Interface File - Include Payment Acknowledgement Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following: Dictionary Update (PM) General Ledger Payment/Adjustment Account Numbers Admission (Outpatient) Financial Eligibility Client Ledger Posting/Adjustment Codes Definition Individual Cash Posting (PM) Compile General Ledger Payment/Adjustment Interface File Print General Ledger Payment/Adjustment Interface File Detail Registry Settings (PM) General Ledger Payment Acknowledgement Interface Components General Ledger Payment Acknowledgement Account Numbers Payment Acknowledgement Batch Cash Posting Print General Ledger Payment Acknowledgement Interface Detail Scenario 1: Compile General Ledger Payment/Adjustment Interface File detail - Validating 'GL.compile_payadj_int_detail' SQL table - Registry setting 'Enable Payment Acknowledgement' = N Specific Setup: Registry setting 'Enable Payment Acknowledgement' is set to 'No'. System updated with Avatar GL module. Dictionary Update: File: G/L Interface (200) - Credit G/L Charge Account Numbers - Contains dictionary codes and dictionary values. Note the values. (201) - Debit G/L Charge Account Numbers - Contains dictionary codes and dictionary values. Note the values. (202) - Credit G/L Payment Adjustment Account Numbers - Contains dictionary codes and dictionary values. Note the values. (203) - Debit G/L Payment Adjustment Account Numbers - Contains dictionary codes and dictionary values. Note the values. Admission: An outpatient client is admitted, or an existing outpatient client is identified. Please note the client must be admitted in the outpatient program which is set up in the 'General Ledger Payment Adjustment Account Numbers' form. Note the admission date/program. Guarantor/Payors: An existing guarantor is identified. Note the guarantor's code/name. Financial Eligibility: Assign the guarantor to the client. Recurring Client Charge Input: 5-6 services are rendered to the client. Client Ledger: Make sure services are distributed to the guarantor assigned to the client. Individual Cash Posting: Post payments, adjustments and/ or transfers for 2-3 services. Note the posting date. Close Charges: Close the charges. Steps Open the 'General Ledger Interface Components' form. Select desired number of components for 'Number of Treatment String Items To Be Included Within General Ledger Interface Components' field. Select desired components. Note the selected components. Submit the form. Open the 'General Ledger Charge Account Numbers' form. Select component value for each of the components. Note the values. Select desired account from the 'Credit General Ledger Charge Account Number' field. Select desired account from the 'Debit General Ledger Charge Account Number' field. Click [File General Ledger Charge Account Numbers]. Go to 'G/L Defaults for Charges' section. Select desired account from the 'Default Credit General Ledger Charge Account Number' dropdown list. Select desired account from the 'Default Debit General Ledger Charge Account Number' dropdown list. Click [File Default General Ledger Charge Account Numbers]. Close the form. Open the 'General Ledger Payment/Adjustment Account Numbers' form. Select the component value for each of the components. Select desired account from the 'Credit General Ledger Pay/Adj Account Number' field. Select desired account from the 'Debit General Ledger Pay/Adj Account Number' field. 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]. Close the form. Open the 'Compile General Ledger Payment/Adjustment Interface File' form. Enter the billing period and GL posting date. Select 'No' for Pre-Compile. Click [Process]. Verify the GL strings for the Payments/Adjustments account numbers are generated. Return to the form. Select 'Yes' for Pre-Compile. Click [Process]. Verify the report contains a message to go to the 'Print General Ledger Payment/Adjustment Interface File detail'. Open the 'Print General Ledger Payment/Adjustment Interface File detail' form. Choose the same billing period from compile and process the results. Open the 'Crystal report' or any other SQL data viewer. Query the 'Select * from GL.compile_payadj_int_detail' table for the client identified in the setup section. Verify the accounts and components displays correctly as defined. Close the 'Crystal Report'. Scenario 2: Compile General Ledger Payment/Adjustment Interface File - Validating 'Include Payment Acknowledgement' - Registry setting 'Enable Payment Acknowledgement' = Y Specific Setup: System updated with Avatar GL module. General Ledger Charge Account Numbers and default account numbers are defined. General Ledger Payment/Adjustment components and account numbers are defined. General Ledger Payment Acknowledgement components and account numbers are defined. Registry Setting: The 'Enable Payment Acknowledgement' registry setting is enabled. The 'Prevent Posting Payments Unless Payment has been Acknowledged' registry setting is set to '1&2'. Dictionary Update: File: Client (101) - Treatment Service - enter a code/value and then select the Program extended dictionary and enter desired value (i.e. 000111). Note dictionary code/value. Please note - The value entered here will also need to be added to the 'Program (5521)' dictionary in other tabled files for testing the GL compile. File: Other Table Files: (5521) Program - contains dictionary codes and dictionary values. Add the extended dictionary value from the '(101) Client' file and 'Treatment Service' dictionary. (5522) Account - contains dictionary codes, dictionary values and extended dictionary values. File: G/L Interface (200) - Credit G/L Charge Account Numbers - Contains dictionary codes and dictionary values. Note the values. (201) - Debit G/L Charge Account Numbers - Contains dictionary codes and dictionary values. Note the values. (202) - Credit G/L Payment Adjustment Account Numbers - Contains dictionary codes and dictionary values. Note the values. (203) - Debit G/L Payment Adjustment Account Numbers - Contains dictionary codes and dictionary values. Note the values. (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. Admission: A client is identified with charges that resulted in payments, and/or adjustments being posted to the charges. Guarantor/Payors: An existing guarantor is identified who does not have a Financial Class that has the Extended Data Element for (1500) System Financial Class set to Self Pay. Note the guarantor's code/name. Financial Eligibility: Assign desired guarantor to the client. Client Charge Input: A service is rendered to the client. Client Ledger: Make sure the service is distributed to the guarantor assigned to the client. Individual Cash Posting: Post payments, adjustments and/ or transfers for 2-3 services. Note the posting date. Steps Open the ‘Payment Acknowledgment’ form. Enter desired value in ‘Batch Number’. Select desired ‘Posting Code’. Enter desired value in ‘Check/EFT Number’. Enter desired value in ‘Amount’. Select desired ‘Guarantor’. If a ‘Self-Pay guarantor is selected, the ‘Client’ field will be enabled. Enter desired value in ‘Name/Source’. Enter desired value in ‘Client’, if enabled. Enter desired value in ‘Check/EFT Date’. Note the Check/EFT number to be used in the 'Batch Cash Posting'. Enter desired value in ‘Receipt Date’. Enter desired value in ‘Deposit Date’. Select desired ‘Treatment Service’. Please note: The treatment service used must have an extended dictionary setup in the setup section. Select desired ‘Category’ from 'Account' dictionary. If the selected item, extended data dictionary value of 'Other Table Files: (5522) Account' - 'Include in Category Dictionary: Yes' the dictionary item will be available for selection. No = not available for selection. If the selected item, extended data dictionary value of 'Other Table Files: (5522) Account' - 'Require Name/Source in Payment Acknowledgement', has a value of 'Y' the 'Name/Source' field will become required. No = not required. Enter desired value in ‘Bank Ref #’. Enter desired value in ‘Comments’. Click [File]. Verify that the ‘Payment Acknowledgement’ message is received and states the following: Filed successfully. The Transaction Number is 6. Do you need to continue to Post Payment Accounting Entry? Note: The Transaction Number’ increments by one number with each filing. Clicking [No] returns the user to the ‘Payment Acknowledgement’ section to enter additional payments. Clicking [Yes] allows the user to post payments in 'Post Payment Accounting Entry'. Click [Yes]. Click [New Row] in ‘Post Payment Accounting Entry’. Select desired ‘Treatment Service’. It will default if filed in the ‘Payment Acknowledgement’. Select desired ‘Program’. This is from ‘Other Table Files: (5521) Program’, not a program in ‘Program Maintenance’. Select desired ‘Account’. Select desired ‘Amount’. Validate that the ‘Posting Code; defaulted from the ‘Payment Acknowledgement’. Select desired ‘Posting Date’. Validate that the ‘Posting Summary’ is correct. If desired, and first row partially posts the 'Amount', click [New Row] and repeat the steps. If desired, click [Delete Row]. A ‘Confirm Delete’ message will be displayed. Select desired value. Click [File]. The following ‘Payment Acknowledgement’ displays: Filed successfully. Do you need to continue with Post Payment Accounting Entry? Click [Yes]. Add the new row for post payment accounting entry. File the form. Open the 'Batch Cash Posting' form. Enter desired date to the 'Date of Receipt or Adjustment' field. Enter desired date to the 'Cash Posting Date' field. Select 'Payment' in the 'Posting Type' field. Select 'No' in the 'Payment Acknowledgment' field. Select desired guarantor. Validate the 'Selected Payment Acknowledgment' field exist and lists all payment acknowledgments that have a balance greater than $0. If a guarantor is selected in the prior field, filter by that guarantor. Select payment acknowledgement defined for the selected guarantor. Validate the 'Amount to Post' field defaults to the remaining amount of the selected payment acknowledgment. Select desired value in the 'Individual or All Clients' field. Select desired client from the 'Client ID' field if the 'Client ID' field is marked as the required field. Select desired program from the 'Program of Service' field. Select service start date in the 'From Date' field. Select service end date in the 'To Date' field. Select desired payment acknowledgement code from the 'Posting Code' field. Validate the 'Receipt' field defaults in the transaction number of the payment acknowledgment If payment acknowledgment is selected. Enter the same Check/EFT # in the 'Check #' field that is entered in the 'Payment Acknowledgement'. Select 'Ignore' in the 'Write Off or Ignore Remaining Balance' field. Click [Process]. Validate the form files successfully. Open the 'Compile General Ledger Payment/Adjustment Interface File' form. Select dates that cover the transactions above and select 'no' for pre compile. Verify the 'Include Payment Acknowledgement' field is multi select checkbox field. Verify the 'Include Payment Acknowledgement' field contains three options: 1. Payments/Adjustments 2. Payment Acknowledgement 3. Post Payment Accounting Entry Do not select anything in the 'Include Payment Acknowledgments' field. Click [Process]. Verify it generates the payment adjustment GL strings. Return to the form. Select 'Payment Acknowledgement' in the 'Include Payment Acknowledgments' field. Click [Process]. Verify the GL strings for the Payment Acknowledgement GL Account Numbers are generated. Return to the form. Select 'Post Payment Entry' in the 'Include Payment Acknowledgments' field. Click [Process]. Verify the GL strings for the Post Payment Entry account numbers are generated. Return to the form. Select 'Payments/Adjustments' in the 'Include Payment Acknowledgments' field. Click [Process]. Verify the GL strings for the Payments/Adjustments account numbers are generated. Return to the form. Select 'Payments/Adjustments', 'Payment Acknowledgement', and 'Post Payment Entry' in the 'Include Payment Acknowledgments' field. Click [Process]. Verify the GL strings for the Payments/Adjustments, Payment Acknowledgement and Post Payment Entry account numbers are generated. Select 'Payments/Adjustments' and 'Payment Acknowledgement' in the 'Include Payment Acknowledgments' field. Click [Process]. Verify the GL strings for the Payments/Adjustments and Payment Acknowledgement account numbers are generated. Return to the form. Select 'Payments/Adjustments' and 'Post Payment Entry' in the 'Include Payment Acknowledgments' field. Click [Process]. Verify the GL strings for the Payments/Adjustments and Post Payment Entry account numbers are generated. Return to the form. Select different combinations and verify the related GL accounts are displayed. Return to the form. Close the form.	Topics • Print General Ledger Payment/Adjustment Interface • 835 Health Care Claim Payment/Advice • NX • Payment Acknowledgement
Update 3 Summary \| Details Registry Setting - Enabled Dynamics GP Integration Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following: Registry Settings (PM) User Definition GL Facility Defaults General Ledger Payment/Adjustment Account Numbers Print General Ledger Payment/Adjustment Interface File Detail Print General Ledger Charge Interface File Detail Dictionary Update (PM) Compile General Ledger Payment/Adjustment Interface File COMPILE GENERAL LEDGER CHARGE INTERFACE FILE Table Import For General Ledger Account Numbers Scenario 1: GL Integration - Dynamics GP - Registry Setting - Enable Dynamics GP Integration Steps Open the 'Registry Settings' form. Set the 'Limit Registry Settings' to the 'Enable Dynamics GP Integration'. Click [View Registry Settings]. Validate the 'Registry Setting' field contains 'Avatar GL->General Ledger Interface->->->->Enable Dynamics GP Integration'. Validate the 'Registry Setting Details' field contains '[FACILITY SPECIFIC] ------------------------------------------------------------------------------- Enter "Y" to enable Dynamics GP integration. This will add the fields 'Dynamics GP Input Path On Server' and 'Dynamics GP Output Path On Server' to the 'GL Facility Defaults' form. The output path will be used to send compiled files to Dynamics GP. The input path will be used to get Dynamics GP accounts for comparison with Avatar GL accounts through various forms. Enter "N" to disable Dynamics GP integration.'. Validate the 'Registry Setting Value' field is defaulted to 'N'. Click [Submit]. Click [OK]. Click [Yes]. Set the ‘Limit Registry Settings’ to the ‘Dynamics GP’. Click [View Registry Settings]. Set the ‘Registry Setting Value’ input box to ‘1’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’. Click [OK]. Set the ‘Registry Setting Value’ input box to ‘M’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘Yes’. Validate the message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘No’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘‘. Click [Submit]. Click [OK]. Click [Yes]. Set the ‘Limit Registry Settings’ to the ‘Dynamics GP’. Click [View Registry Settings]. Set the 'Registry Setting Value' input box to 'Y'. Click [Submit]. Click [OK]. Click [No]. Open the 'User Definition' form. Select desired user from the ‘Select User’ field. Click the ‘Forms and Tables’ item. Click [Select Forms for User Access]. Click ‘Avatar PM’ item. Verify that the 'General Ledger Interface' item exist. Verify that all the items are checked. Click [OK]. Click [Submit]. Click [No]. Open the ‘GL Facility Defaults’ form. Verify the ‘Output Path On Server For CSV File’ field exists. Verify the ‘Dynamics GP Input Path On Server’ field exists. Verify the ‘Dynamics GP Output Path On Server’ field exists. Click the light bulb icon of the ‘Dynamics GP Input Path On Server’ field and validate the help text contains ‘This path is used for Dynamics GP to add a file of accounts that can be pulled on demand by Avatar to compare with GL accounts.' Click the ‘Return To Form’ link. Click the light bulb icon of the ‘Dynamics GP Output Path On Server’ field and validate the help text contains ‘This path is used to output a CSV file of the Avatar GL compile for Dynamics GP to use.’. Click the ‘Return To Form’ link. Click [Discard]. Click [Yes]. Open the ‘General Ledger Charge Account Numbers’ form. Click the ‘Print G/L Charge Table’ item. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the ‘General Ledger Payment/Adjustment Account Numbers’ form. Click the ‘Print G/L Pay/Adj Table’ item. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the 'Registry Settings' form. Set the 'Limit Registry Settings' to the 'Enable Dynamics GP Integration'. Click [View Registry Settings]. Set the 'Registry Setting Value' input box to 'N'. Click [Submit]. Click [OK]. Click [No]. Open the ‘GL Facility Defaults’ form. Verify the ‘Dynamics GP Input Path On Server’ field does not exist. Verify the ‘Dynamics GP Output Path On Server’ field does not exist. Click [Discard]. Click [Yes]. Open the ‘General Ledger Charge Account Numbers’ form. Click the ‘Print G/L Charge Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘General Ledger Payment/Adjustment Account Numbers’ form. Click the ‘Print G/L Pay/Adj Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the 'Registry Settings' form. Set the 'Limit Registry Settings' to the 'Enable Dynamics GP Integration'. Click [View Registry Settings]. Set the 'Registry Setting Value' input box to ''. Click [Submit]. Click [OK]. Click [No]. Open the ‘GL Facility Defaults’ form. Verify the ‘Dynamics GP Input Path On Server’ field does not exist. Verify the ‘Dynamics GP Output Path On Server’ field does not exist. Click [Discard]. Click [Yes]. Open the ‘General Ledger Charge Account Numbers’ form. Click the ‘Print G/L Charge Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘General Ledger Payment/Adjustment Account Numbers’ form. Click the ‘Print G/L Pay/Adj Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Scenario 2: GL Integration - Dynamic GP - Compile General Ledger Payment/Adjustment Interface File and Print General Ledger Payment/Adjustment Interface Detail File* Specific Setup: System updated with Avatar GL module. Registry Settings: The 'Enable Dynamics GP Integration' is set to 'Y'. Dictionary Update: File: G/L Interface (202) - Credit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (203) - Debit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. General Ledger Interface components: General ledger interface components are defined. Note the components. General Ledger Payment/Adjustment Account Numbers: General ledger credit/debit payment/adjustment account numbers, default payment/adjustment account numbers and general ledger interface components are defined. Note the account codes/values. File Explorer: Local folders are created to place the input/output CSV files. Note the paths of the folder. GL Facility Defaults: The following fields are populated with the valid paths of the input/output files for Dynamics GP. Note all the paths for later use. Output Path On Server For CSV File Dynamics GP Input Path On Server Dynamics GP Output Path On Server' GP Account File: A CSV file is created in the format account number, account description and account type that contains general ledger payment/adjustment accounts in the system but not all. Please note - the account type is exactly the values of 'Charge' or 'Pmt/Adj'. Note the account numbers included in the file. The CSV file created is placed in the path defined as the 'Dynamics GP Input Path On Server' in the 'GL Facility Defaults'. Steps Open the 'Compile General Ledger Payment/Adjustment Interface File' form. Set the 'Bill Period' field to a desired bill period. (i.e. The format of the bill period is MM/YYYY). Set the 'General Ledger Posting Date' to desired date. Set the field 'Pre-Compile' to 'No'. Click [Process]. Verify the 'Compile General Ledger Payment/Adjustment Interface File' report launches successfully. Verify the report displays the GL strings for the Payment/Adjustment account numbers with the specific information. Note the details displays on the report. Close the report. Close the form. Locate to the local folders are created to place output CSV file. Verify the CSV file matching the details shown on the 'Compile General Ledger Payment/Adjustment Interface File' report screen is generated and placed in both the paths setup for 'Output Path On Server For CSV File' and 'Dynamics GP Output Path On Server' in the 'GL Facility Defaults'. Open the 'Compile General Ledger Payment/Adjustment Interface File' form. Set the 'Bill Period' field to a desired bill period. (i.e. The format of the bill period is MM/YYYY). Set the 'General Ledger Posting Date' to desired date. Set the field 'Pre-Compile' to 'Yes'. Click [Process]. Verify the 'Compile General Ledger Payment/Adjustment Interface File' report launches successfully. Verify a 'Pre-Compile' report displays 'Pre-Compile. Please see 'Print General Ledger Payment/Adjustment Interface File Detail'. Close the report. Close the form. Open the 'Print General Ledger Payment/Adjustment Interface File Detail' form. Enter the 'Bill Period' previously specified. Click [Dynamics GP Comparison]. Verify a report launches successfully and displays only the account numbers in the compile that are missing from the GP file. Close the report. Click [Process]. Verify the report displays all applicable Payment/Adjustments within the billing period based on the data set up in the 'General Ledger Interface components' and 'General Ledger Payment/Adjustment Account Numbers'. Close the report. Close the form. Open the 'Crystal report' or any other SQL data viewer. Query the 'Select * from GL.compilepayadjintdetail' table for the client identified in the setup section. Verify the accounts and components displays correctly as defined. Close the 'Crystal Report'. Scenario 3: GL Integration - Dynamic GP - Compile General Ledger Charge Interface File and Print General Ledger Charge Interface Detail File Specific Setup: System updated with Avatar GL module. Registry Settings: The 'Enable Dynamics GP Integration' is set to 'Y'. Dictionary Update: File: G/L Interface (200) - Credit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (201) - Debit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. General Ledger Interface components: General ledger interface components are defined. Note the components. General Ledger Charge Account Numbers: General ledger credit/debit charge account numbers, default charge account numbers and general ledger interface components are defined. Note the account codes/values. File Explorer: Local folders are created to place input/output CSV file. Note the paths of the folder. GL Facility Defaults: The following fields are populated with the valid paths of the input/output files for Dynamics GP. Note all the paths for later use. Output Path On Server For CSV File Dynamics GP Input Path On Server Dynamics GP Output Path On Server' GP Account File: A CSV file is created in the format account number, account description and account type that contains general ledger charge accounts in the system but not all. Please note - the account type is exactly the values of 'Charge' or 'Pmt/Adj'. Note the account numbers included in the file. The CSV file created is placed in the path defined as the 'Dynamics GP Input Path On Server' in the 'GL Facility Defaults'. Steps Open the 'Compile General Ledger Charge Interface File' form. Set the 'Bill Period' field to a desired bill period. (i.e. The format of the bill period is MM/YYYY). Set the 'General Ledger Posting Date' to desired date. Set the field 'Pre-Compile' to 'No'. Click [Process]. Verify the 'Compile General Ledger Charge Interface File' report launches successfully. Verify the report displays the GL strings for the charge account numbers with the specific information. Note the details displays on the report Close the report. Close the form. Locate to the local folders are created to place output CSV file. Verify the CSV file matching the details shown on the 'Compile General Ledger Charge Interface File' report screen is generated and placed in both the paths setup for 'Output Path On Server For CSV File' and 'Dynamics GP Output Path On Server' in the 'GL Facility Defaults'. Open the 'Compile General Ledger Charge Interface File' form. Set the 'Bill Period' field to a desired bill period. (i.e. The format of the bill period is MM/YYYY). Set the 'General Ledger Posting Date' to desired date. Set the field 'Pre-Compile' to 'Yes'. Click [Process]. Verify the 'Compile General Ledger Charge Interface File' report launches successfully. Verify a 'Pre-Compile' report displays 'Pre-Compile. Please see 'Print General Ledger Charge Interface File Detail'. Close the report. Close the form. Open the 'Print General Ledger Charge Interface File Detail' form. Enter the 'Bill Period' previously specified. Click [Dynamics GP Comparison]. Verify a report launches successfully and displays only the account numbers in the compile that are missing from the GP file. Close the report. Click [Process]. Verify the report displays all applicable charges within the billing period based on the data set up in the 'General Ledger Interface components' and 'General Ledger Charge Account Numbers'. Close the report. Close the form. Open the 'Crystal report' or any other SQL data viewer. Query the 'Select * from GL.compilechargeintdetail' table. Verify an existence of the 'counter' field. Verify the SQL view contains correct value in the 'counter' column. Verify the SQL view displays accounts and components as defined in the setup. Close the report. Scenario 4: GL Integration - Dynamics GP - Table Import For General Ledger Account Numbers Specific Setup: System updated with Avatar GL module. Registry Settings: The 'Enable Dynamics GP Integration' is set to 'Y'. Dictionary Update: File: G/L Interface (200) - Credit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (201) - Debit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (202) - Credit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (203) - Debit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. General Ledger Interface components: General ledger interface components are defined. Note the components. General Ledger Charge Account Numbers: General ledger credit/debit charge account numbers, default charge account numbers and general ledger interface components are defined. Note the account codes/values. GL Facility Defaults: The 'Output Path On Server For CSV File', 'Dynamics GP Input Path On Server' and 'Dynamics GP Output Path On Server' are populated with the valid paths for the input/output files for Dynamics GP. Note all the paths for later use. GP Account File: A CSV file is created in the format account number, account description and account type that contains general ledger charge accounts in the system but not all. Please note - the account type is exactly the values of 'Charge' or 'Pmt/Adj'. Note the account numbers included in the file. The CSV file created is placed in the path defined as the 'Dynamics GP Input Path On Server' in the 'GL Facility Defaults'. The text file to import charge or payment/adjustment account numbers are created and placed in a local dictionary. Note the location of the file. Steps Open the 'Table Import For General Ledger Account Numbers' form. Select the 'GL Charge Account Numbers' in the 'Load Which Table' field. Select the 'Append to Existing Table' in the 'Load Option' field. Select desired charge account file for import. Click [Import GL Account Numbers]. Verify the crystal report launched and a previously selected and correctly displays the 'Total Number of Rows in File' imported successfully. Click [Close Report]. Verify another 'Table Import For General Ledger Account Numbers' report launched that contains the account numbers which are missing in GP. (Please note: System will launch the report to display the account numbers under the missing in GP if the general ledger payment/adjustment account numbers are in GL dictionary but not in the CSV file.). Close the report. Select the 'GL Payment/Adjustment Account Numbers' in the 'Load Which Table' field. Select the 'Append to Existing Table' in the 'Load Option' field. Select desired payment/adjustment account file for import. Click [Import GL Account Numbers]. Verify the crystal report launched and correctly displays the 'Total Number of Rows in File' imported successfully. Click [Close Report]. Verify another 'Table Import For General Ledger Account Numbers' report launched that contains the account numbers which are missing in GP. (Please note: System will launch the report to display the account numbers under the missing in GP if the general ledger payment/adjustment account numbers are in GL dictionary but not in the CSV file.). Close the report. Open the 'Table Import For General Ledger Account Numbers' form. Select the 'GL Charge Account Numbers' in the 'Load Which Table' field. Select the 'Over-Ride Existing Table' in the 'Load Option' field. Select desired charge account file for import. Click [Import GL Account Numbers]. Verify the crystal report launched and a previously selected and correctly displays the 'Total Number of Rows in File' imported successfully. Click [Close Report]. Verify another 'Table Import For General Ledger Account Numbers' report launched that contains the account numbers which are missing in GP. (Please note: System will launch the report to display the account numbers under the missing in GP if the general ledger payment/adjustment account numbers are in GL dictionary but not in the CSV file.). Close the report. Select the 'GL Payment/Adjustment Account Numbers' in the 'Load Which Table' field. Select the 'Over-Ride Existing Table' in the 'Load Option' field. Select desired payment/adjustment account file for import. Click [Import GL Account Numbers]. Verify the crystal report launched and correctly displays the 'Total Number of Rows in File' imported successfully. Click [Close Report]. Verify another 'Table Import For General Ledger Account Numbers' report launched that contains the account numbers which are missing in GP. (Please note: System will launch the report to display the account numbers under the missing in GP if the general ledger payment/adjustment account numbers are in GL dictionary but not in the CSV file.). Close the report. Scenario 5: GL Integration - Dynamics GP - Validating 'Dynamics GP Comparison' in the ‘General Ledger Charge Account Numbers’ form Specific Setup: System updated with Avatar GL module. Registry Settings: The 'Enable Dynamics GP Integration' is set to 'Y'. Dictionary Update: File: G/L Interface (200) - Credit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (201) - Debit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. General Ledger Interface components: General ledger interface components are defined. Note the components. General Ledger Charge Account Numbers: General ledger credit/debit charge account numbers, default charge account numbers and general ledger interface components are defined. Note the account codes/values. GL Facility Defaults: The 'Output Path On Server For CSV File', 'Dynamics GP Input Path On Server' and 'Dynamics GP Output Path On Server' are populated with the valid paths for the input/output files for Dynamics GP. Note all the paths for later use. GP Account File: A CSV file is created in the format account number, account description and account type that contains GL charge account numbers exist in the system but not all. The account type is exactly the values of 'Charge' or 'Pmt/Adj'. The CSV file created is placed in the location defined as the 'Dynamics GP Input Path On Server' in the 'GL Facility Defaults' form. Note the account numbers included in the file. Please note: If the charge account number is in the GL dictionaries (Credit G/L Charge Account Number or Debit G/L Charge Account Number) but not in the input file then it is in the missing in GP section. If the account number is in the input file but not in GL dictionaries (Credit G/L Charge Account Number or Debit G/L Charge Account Number) then it is in the missing GL section. Steps Open the 'General Ledger Charge Account Numbers' form. Click the 'Print G/L Charge Table' item. Click the [Dynamics GP Comparison]. Validate the 'Missing in GP' section of the report displays the charge account numbers which are in the GL dictionaries, but they are not in the CSV file. Validate the 'Missing in GL' section of the report displays the charge account numbers which are not in the GL dictionaries, but they are included in the CSV file. Validate that the report does not display the charge account numbers which are in the GL dictionary and the CSV file contains them. Close the report. Click the 'G/L Interface for Charges' item. Select component and the component value for each of the components. In the 'Credit General Ledger Charge Account Number' field select desired account from the dropdown list. In the 'Debit General Ledger Charge Account Number' field select desired account from the dropdown list. Click [File General Ledger Pay/Adj Account Numbers]. Click the 'G/L Defaults for Charges' item. Select desired account from the 'Default Credit General Ledger Charge Account Number' dropdown list. Select desired account from the 'Default Debit General Ledger Charge Account Number' dropdown list. Click [File Default General Ledger Pay/Adj Account Numbers]. Go to the 'Print G/L Charge Table' section. Click [Print Crystal Report]. Verify the report displays all the components correctly with the value entered/selected for the component. Close the report. Close the form. Scenario 6: GL Integration - Dynamics GP - Validating 'Dynamics GP Comparison' in the ‘General Ledger Payment/Adjustment Account Numbers’ form Specific Setup: System updated with Avatar GL module. Registry Settings: The 'Enable Dynamics GP Integration' is set to 'Y'. Dictionary Update: File: G/L Interface (202) - Credit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (203) - Debit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. General Ledger Interface components: General ledger interface components are defined. Note the components. General Ledger Payment/Adjustment Account Numbers: General Ledger Payment/Adjustment Account Numbers and default Payment/Adjustment account numbers are defined. Note the account codes/values. GL Facility Defaults: The 'Output Path On Server For CSV File', 'Dynamics GP Input Path On Server' and 'Dynamics GP Output Path On Server' are populated with the valid paths for the input/output files for Dynamics GP will be placed. Note all the paths for later use. GP Account File: A CSV file is created in the format account number, account description and account type that contains accounts in the system but not all. Please note - the account type is exactly the values of 'Charge' or 'Pmt/Adj'. Note the account numbers included in the file. The CSV file created is placed in the path defined as the 'Dynamics GP Input Path On Server' in the 'GL Facility Defaults'. Steps Open the 'General Ledger Payment/Adjustment Account Numbers' form. Click the 'Print G/L Pay/Adj Table' item. Click the [Dynamics GP Comparison]. Validate the 'Missing in GP' section of the report displays the payment/adjustment account numbers which are in GL dictionaries, but in the CSV file. Validate the 'Missing in GL' section of the report displays the payment/adjustment account numbers which are not in the GL dictionaries, but in the CSV file. Validate that the report does not display the payment/adjustment account numbers which are in the GL dictionary and the CSV file contains them. Close the report. Click the 'G/L Interface for Pay/Adj' item. 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. Close the report. Close the form. Enable Dynamics GP Integration - GL Facility Defaults Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following: Registry Settings (PM) User Definition GL Facility Defaults General Ledger Payment/Adjustment Account Numbers Print General Ledger Payment/Adjustment Interface File Detail Print General Ledger Charge Interface File Detail Dictionary Update (PM) Compile General Ledger Payment/Adjustment Interface File COMPILE GENERAL LEDGER CHARGE INTERFACE FILE Scenario 1: GL Integration - Dynamics GP - Registry Setting - Enable Dynamics GP Integration Steps Open the 'Registry Settings' form. Set the 'Limit Registry Settings' to the 'Enable Dynamics GP Integration'. Click [View Registry Settings]. Validate the 'Registry Setting' field contains 'Avatar GL->General Ledger Interface->->->->Enable Dynamics GP Integration'. Validate the 'Registry Setting Details' field contains '[FACILITY SPECIFIC] ------------------------------------------------------------------------------- Enter "Y" to enable Dynamics GP integration. This will add the fields 'Dynamics GP Input Path On Server' and 'Dynamics GP Output Path On Server' to the 'GL Facility Defaults' form. The output path will be used to send compiled files to Dynamics GP. The input path will be used to get Dynamics GP accounts for comparison with Avatar GL accounts through various forms. Enter "N" to disable Dynamics GP integration.'. Validate the 'Registry Setting Value' field is defaulted to 'N'. Click [Submit]. Click [OK]. Click [Yes]. Set the ‘Limit Registry Settings’ to the ‘Dynamics GP’. Click [View Registry Settings]. Set the ‘Registry Setting Value’ input box to ‘1’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’. Click [OK]. Set the ‘Registry Setting Value’ input box to ‘M’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘Yes’. Validate the message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘No’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘‘. Click [Submit]. Click [OK]. Click [Yes]. Set the ‘Limit Registry Settings’ to the ‘Dynamics GP’. Click [View Registry Settings]. Set the 'Registry Setting Value' input box to 'Y'. Click [Submit]. Click [OK]. Click [No]. Open the 'User Definition' form. Select desired user from the ‘Select User’ field. Click the ‘Forms and Tables’ item. Click [Select Forms for User Access]. Click ‘Avatar PM’ item. Verify that the 'General Ledger Interface' item exist. Verify that all the items are checked. Click [OK]. Click [Submit]. Click [No]. Open the ‘GL Facility Defaults’ form. Verify the ‘Output Path On Server For CSV File’ field exists. Verify the ‘Dynamics GP Input Path On Server’ field exists. Verify the ‘Dynamics GP Output Path On Server’ field exists. Click the light bulb icon of the ‘Dynamics GP Input Path On Server’ field and validate the help text contains ‘This path is used for Dynamics GP to add a file of accounts that can be pulled on demand by Avatar to compare with GL accounts.' Click the ‘Return To Form’ link. Click the light bulb icon of the ‘Dynamics GP Output Path On Server’ field and validate the help text contains ‘This path is used to output a CSV file of the Avatar GL compile for Dynamics GP to use.’. Click the ‘Return To Form’ link. Click [Discard]. Click [Yes]. Open the ‘General Ledger Charge Account Numbers’ form. Click the ‘Print G/L Charge Table’ item. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the ‘General Ledger Payment/Adjustment Account Numbers’ form. Click the ‘Print G/L Pay/Adj Table’ item. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the 'Registry Settings' form. Set the 'Limit Registry Settings' to the 'Enable Dynamics GP Integration'. Click [View Registry Settings]. Set the 'Registry Setting Value' input box to 'N'. Click [Submit]. Click [OK]. Click [No]. Open the ‘GL Facility Defaults’ form. Verify the ‘Dynamics GP Input Path On Server’ field does not exist. Verify the ‘Dynamics GP Output Path On Server’ field does not exist. Click [Discard]. Click [Yes]. Open the ‘General Ledger Charge Account Numbers’ form. Click the ‘Print G/L Charge Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘General Ledger Payment/Adjustment Account Numbers’ form. Click the ‘Print G/L Pay/Adj Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the 'Registry Settings' form. Set the 'Limit Registry Settings' to the 'Enable Dynamics GP Integration'. Click [View Registry Settings]. Set the 'Registry Setting Value' input box to ''. Click [Submit]. Click [OK]. Click [No]. Open the ‘GL Facility Defaults’ form. Verify the ‘Dynamics GP Input Path On Server’ field does not exist. Verify the ‘Dynamics GP Output Path On Server’ field does not exist. Click [Discard]. Click [Yes]. Open the ‘General Ledger Charge Account Numbers’ form. Click the ‘Print G/L Charge Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘General Ledger Payment/Adjustment Account Numbers’ form. Click the ‘Print G/L Pay/Adj Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Scenario 2: GL Integration - Dynamic GP - Compile General Ledger Payment/Adjustment Interface File and Print General Ledger Payment/Adjustment Interface Detail File* Specific Setup: System updated with Avatar GL module. Registry Settings: The 'Enable Dynamics GP Integration' is set to 'Y'. Dictionary Update: File: G/L Interface (202) - Credit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (203) - Debit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. General Ledger Interface components: General ledger interface components are defined. Note the components. General Ledger Payment/Adjustment Account Numbers: General ledger credit/debit payment/adjustment account numbers, default payment/adjustment account numbers and general ledger interface components are defined. Note the account codes/values. File Explorer: Local folders are created to place the input/output CSV files. Note the paths of the folder. GL Facility Defaults: The following fields are populated with the valid paths of the input/output files for Dynamics GP. Note all the paths for later use. Output Path On Server For CSV File Dynamics GP Input Path On Server Dynamics GP Output Path On Server' GP Account File: A CSV file is created in the format account number, account description and account type that contains general ledger payment/adjustment accounts in the system but not all. Please note - the account type is exactly the values of 'Charge' or 'Pmt/Adj'. Note the account numbers included in the file. The CSV file created is placed in the path defined as the 'Dynamics GP Input Path On Server' in the 'GL Facility Defaults'. Steps Open the 'Compile General Ledger Payment/Adjustment Interface File' form. Set the 'Bill Period' field to a desired bill period. (i.e. The format of the bill period is MM/YYYY). Set the 'General Ledger Posting Date' to desired date. Set the field 'Pre-Compile' to 'No'. Click [Process]. Verify the 'Compile General Ledger Payment/Adjustment Interface File' report launches successfully. Verify the report displays the GL strings for the Payment/Adjustment account numbers with the specific information. Note the details displays on the report. Close the report. Close the form. Locate to the local folders are created to place output CSV file. Verify the CSV file matching the details shown on the 'Compile General Ledger Payment/Adjustment Interface File' report screen is generated and placed in both the paths setup for 'Output Path On Server For CSV File' and 'Dynamics GP Output Path On Server' in the 'GL Facility Defaults'. Open the 'Compile General Ledger Payment/Adjustment Interface File' form. Set the 'Bill Period' field to a desired bill period. (i.e. The format of the bill period is MM/YYYY). Set the 'General Ledger Posting Date' to desired date. Set the field 'Pre-Compile' to 'Yes'. Click [Process]. Verify the 'Compile General Ledger Payment/Adjustment Interface File' report launches successfully. Verify a 'Pre-Compile' report displays 'Pre-Compile. Please see 'Print General Ledger Payment/Adjustment Interface File Detail'. Close the report. Close the form. Open the 'Print General Ledger Payment/Adjustment Interface File Detail' form. Enter the 'Bill Period' previously specified. Click [Dynamics GP Comparison]. Verify a report launches successfully and displays only the account numbers in the compile that are missing from the GP file. Close the report. Click [Process]. Verify the report displays all applicable Payment/Adjustments within the billing period based on the data set up in the 'General Ledger Interface components' and 'General Ledger Payment/Adjustment Account Numbers'. Close the report. Close the form. Open the 'Crystal report' or any other SQL data viewer. Query the 'Select * from GL.compilepayadjintdetail' table for the client identified in the setup section. Verify the accounts and components displays correctly as defined. Close the 'Crystal Report'. Scenario 3: GL Integration - Dynamic GP - Compile General Ledger Charge Interface File and Print General Ledger Charge Interface Detail File Specific Setup: System updated with Avatar GL module. Registry Settings: The 'Enable Dynamics GP Integration' is set to 'Y'. Dictionary Update: File: G/L Interface (200) - Credit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (201) - Debit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. General Ledger Interface components: General ledger interface components are defined. Note the components. General Ledger Charge Account Numbers: General ledger credit/debit charge account numbers, default charge account numbers and general ledger interface components are defined. Note the account codes/values. File Explorer: Local folders are created to place input/output CSV file. Note the paths of the folder. GL Facility Defaults: The following fields are populated with the valid paths of the input/output files for Dynamics GP. Note all the paths for later use. Output Path On Server For CSV File Dynamics GP Input Path On Server Dynamics GP Output Path On Server' GP Account File: A CSV file is created in the format account number, account description and account type that contains general ledger charge accounts in the system but not all. Please note - the account type is exactly the values of 'Charge' or 'Pmt/Adj'. Note the account numbers included in the file. The CSV file created is placed in the path defined as the 'Dynamics GP Input Path On Server' in the 'GL Facility Defaults'. Steps Open the 'Compile General Ledger Charge Interface File' form. Set the 'Bill Period' field to a desired bill period. (i.e. The format of the bill period is MM/YYYY). Set the 'General Ledger Posting Date' to desired date. Set the field 'Pre-Compile' to 'No'. Click [Process]. Verify the 'Compile General Ledger Charge Interface File' report launches successfully. Verify the report displays the GL strings for the charge account numbers with the specific information. Note the details displays on the report Close the report. Close the form. Locate to the local folders are created to place output CSV file. Verify the CSV file matching the details shown on the 'Compile General Ledger Charge Interface File' report screen is generated and placed in both the paths setup for 'Output Path On Server For CSV File' and 'Dynamics GP Output Path On Server' in the 'GL Facility Defaults'. Open the 'Compile General Ledger Charge Interface File' form. Set the 'Bill Period' field to a desired bill period. (i.e. The format of the bill period is MM/YYYY). Set the 'General Ledger Posting Date' to desired date. Set the field 'Pre-Compile' to 'Yes'. Click [Process]. Verify the 'Compile General Ledger Charge Interface File' report launches successfully. Verify a 'Pre-Compile' report displays 'Pre-Compile. Please see 'Print General Ledger Charge Interface File Detail'. Close the report. Close the form. Open the 'Print General Ledger Charge Interface File Detail' form. Enter the 'Bill Period' previously specified. Click [Dynamics GP Comparison]. Verify a report launches successfully and displays only the account numbers in the compile that are missing from the GP file. Close the report. Click [Process]. Verify the report displays all applicable charges within the billing period based on the data set up in the 'General Ledger Interface components' and 'General Ledger Charge Account Numbers'. Close the report. Close the form. Open the 'Crystal report' or any other SQL data viewer. Query the 'Select * from GL.compilechargeintdetail' table. Verify an existence of the 'counter' field. Verify the SQL view contains correct value in the 'counter' column. Verify the SQL view displays accounts and components as defined in the setup. Close the report. Scenario 4: GL Integration - Dynamics GP - Validating 'Dynamics GP Comparison' in the ‘General Ledger Charge Account Numbers’ form Specific Setup: System updated with Avatar GL module. Registry Settings: The 'Enable Dynamics GP Integration' is set to 'Y'. Dictionary Update: File: G/L Interface (200) - Credit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (201) - Debit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. General Ledger Interface components: General ledger interface components are defined. Note the components. General Ledger Charge Account Numbers: General ledger credit/debit charge account numbers, default charge account numbers and general ledger interface components are defined. Note the account codes/values. GL Facility Defaults: The 'Output Path On Server For CSV File', 'Dynamics GP Input Path On Server' and 'Dynamics GP Output Path On Server' are populated with the valid paths for the input/output files for Dynamics GP. Note all the paths for later use. GP Account File: A CSV file is created in the format account number, account description and account type that contains GL charge account numbers exist in the system but not all. The account type is exactly the values of 'Charge' or 'Pmt/Adj'. The CSV file created is placed in the location defined as the 'Dynamics GP Input Path On Server' in the 'GL Facility Defaults' form. Note the account numbers included in the file. Please note: If the charge account number is in the GL dictionaries (Credit G/L Charge Account Number or Debit G/L Charge Account Number) but not in the input file then it is in the missing in GP section. If the account number is in the input file but not in GL dictionaries (Credit G/L Charge Account Number or Debit G/L Charge Account Number) then it is in the missing GL section. Steps Open the 'General Ledger Charge Account Numbers' form. Click the 'Print G/L Charge Table' item. Click the [Dynamics GP Comparison]. Validate the 'Missing in GP' section of the report displays the charge account numbers which are in the GL dictionaries, but they are not in the CSV file. Validate the 'Missing in GL' section of the report displays the charge account numbers which are not in the GL dictionaries, but they are included in the CSV file. Validate that the report does not display the charge account numbers which are in the GL dictionary and the CSV file contains them. Close the report. Click the 'G/L Interface for Charges' item. Select component and the component value for each of the components. In the 'Credit General Ledger Charge Account Number' field select desired account from the dropdown list. In the 'Debit General Ledger Charge Account Number' field select desired account from the dropdown list. Click [File General Ledger Pay/Adj Account Numbers]. Click the 'G/L Defaults for Charges' item. Select desired account from the 'Default Credit General Ledger Charge Account Number' dropdown list. Select desired account from the 'Default Debit General Ledger Charge Account Number' dropdown list. Click [File Default General Ledger Pay/Adj Account Numbers]. Go to the 'Print G/L Charge Table' section. Click [Print Crystal Report]. Verify the report displays all the components correctly with the value entered/selected for the component. Close the report. Close the form. Scenario 5: GL Integration - Dynamics GP - Validating 'Dynamics GP Comparison' in the ‘General Ledger Payment/Adjustment Account Numbers’ form Specific Setup: System updated with Avatar GL module. Registry Settings: The 'Enable Dynamics GP Integration' is set to 'Y'. Dictionary Update: File: G/L Interface (202) - Credit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (203) - Debit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. General Ledger Interface components: General ledger interface components are defined. Note the components. General Ledger Payment/Adjustment Account Numbers: General Ledger Payment/Adjustment Account Numbers and default Payment/Adjustment account numbers are defined. Note the account codes/values. GL Facility Defaults: The 'Output Path On Server For CSV File', 'Dynamics GP Input Path On Server' and 'Dynamics GP Output Path On Server' are populated with the valid paths for the input/output files for Dynamics GP will be placed. Note all the paths for later use. GP Account File: A CSV file is created in the format account number, account description and account type that contains accounts in the system but not all. Please note - the account type is exactly the values of 'Charge' or 'Pmt/Adj'. Note the account numbers included in the file. The CSV file created is placed in the path defined as the 'Dynamics GP Input Path On Server' in the 'GL Facility Defaults'. Steps Open the 'General Ledger Payment/Adjustment Account Numbers' form. Click the 'Print G/L Pay/Adj Table' item. Click the [Dynamics GP Comparison]. Validate the 'Missing in GP' section of the report displays the payment/adjustment account numbers which are in GL dictionaries, but in the CSV file. Validate the 'Missing in GL' section of the report displays the payment/adjustment account numbers which are not in the GL dictionaries, but in the CSV file. Validate that the report does not display the payment/adjustment account numbers which are in the GL dictionary and the CSV file contains them. Close the report. Click the 'G/L Interface for Pay/Adj' item. 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. Close the report. Close the form. Dynamic GP is integrated with the myAvatar GL module. Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following: Registry Settings (PM) User Definition Dictionary Update (PM) GL Facility Defaults General Ledger Payment/Adjustment Account Numbers Compile General Ledger Payment/Adjustment Interface File Print General Ledger Payment/Adjustment Interface File Detail Scenario 1: GL Integration - Dynamic GP - Compile General Ledger Payment/Adjustment Interface File and Print General Ledger Payment/Adjustment Interface Detail File Specific Setup: System updated with Avatar GL module. Registry Settings: The 'Enable Dynamics GP Integration' is set to 'Y'. Dictionary Update: File: G/L Interface (202) - Credit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (203) - Debit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. General Ledger Interface components: General ledger interface components are defined. Note the components. General Ledger Payment/Adjustment Account Numbers: General ledger credit/debit payment/adjustment account numbers, default payment/adjustment account numbers and general ledger interface components are defined. Note the account codes/values. File Explorer: Local folders are created to place the input/output CSV files. Note the paths of the folder. GL Facility Defaults: The following fields are populated with the valid paths of the input/output files for Dynamics GP. Note all the paths for later use. Output Path On Server For CSV File Dynamics GP Input Path On Server Dynamics GP Output Path On Server' GP Account File: A CSV file is created in the format account number, account description and account type that contains general ledger payment/adjustment accounts in the system but not all. Please note - the account type is exactly the values of 'Charge' or 'Pmt/Adj'. Note the account numbers included in the file. The CSV file created is placed in the path defined as the 'Dynamics GP Input Path On Server' in the 'GL Facility Defaults'. Steps Open the 'Compile General Ledger Payment/Adjustment Interface File' form. Set the 'Bill Period' field to a desired bill period. (i.e. The format of the bill period is MM/YYYY). Set the 'General Ledger Posting Date' to desired date. Set the field 'Pre-Compile' to 'No'. Click [Process]. Verify the 'Compile General Ledger Payment/Adjustment Interface File' report launches successfully. Verify the report displays the GL strings for the Payment/Adjustment account numbers with the specific information. Note the details displays on the report. Close the report. Close the form. Locate to the local folders are created to place output CSV file. Verify the CSV file matching the details shown on the 'Compile General Ledger Payment/Adjustment Interface File' report screen is generated and placed in both the paths setup for 'Output Path On Server For CSV File' and 'Dynamics GP Output Path On Server' in the 'GL Facility Defaults'. Open the 'Compile General Ledger Payment/Adjustment Interface File' form. Set the 'Bill Period' field to a desired bill period. (i.e. The format of the bill period is MM/YYYY). Set the 'General Ledger Posting Date' to desired date. Set the field 'Pre-Compile' to 'Yes'. Click [Process]. Verify the 'Compile General Ledger Payment/Adjustment Interface File' report launches successfully. Verify a 'Pre-Compile' report displays 'Pre-Compile. Please see 'Print General Ledger Payment/Adjustment Interface File Detail'. Close the report. Close the form. Open the 'Print General Ledger Payment/Adjustment Interface File Detail' form. Enter the 'Bill Period' previously specified. Click [Dynamics GP Comparison]. Verify a report launches successfully and displays only the account numbers in the compile that are missing from the GP file. Close the report. Click [Process]. Verify the report displays all applicable Payment/Adjustments within the billing period based on the data set up in the 'General Ledger Interface components' and 'General Ledger Payment/Adjustment Account Numbers'. Close the report. Close the form. Open the 'Crystal report' or any other SQL data viewer. Query the 'Select * from GL.compilepayadjintdetail' table for the client identified in the setup section. Verify the accounts and components displays correctly as defined. Close the 'Crystal Report'. Scenario 2: GL Integration - Dynamics GP - Validating 'Dynamics GP Comparison' in the ‘General Ledger Charge Account Numbers’ form Specific Setup: System updated with Avatar GL module. Registry Settings: The 'Enable Dynamics GP Integration' is set to 'Y'. Dictionary Update: File: G/L Interface (200) - Credit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (201) - Debit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. General Ledger Interface components: General ledger interface components are defined. Note the components. General Ledger Charge Account Numbers: General ledger credit/debit charge account numbers, default charge account numbers and general ledger interface components are defined. Note the account codes/values. GL Facility Defaults: The 'Output Path On Server For CSV File', 'Dynamics GP Input Path On Server' and 'Dynamics GP Output Path On Server' are populated with the valid paths for the input/output files for Dynamics GP. Note all the paths for later use. GP Account File: A CSV file is created in the format account number, account description and account type that contains GL charge account numbers exist in the system but not all. The account type is exactly the values of 'Charge' or 'Pmt/Adj'. The CSV file created is placed in the location defined as the 'Dynamics GP Input Path On Server' in the 'GL Facility Defaults' form. Note the account numbers included in the file. Please note: If the charge account number is in the GL dictionaries (Credit G/L Charge Account Number or Debit G/L Charge Account Number) but not in the input file then it is in the missing in GP section. If the account number is in the input file but not in GL dictionaries (Credit G/L Charge Account Number or Debit G/L Charge Account Number) then it is in the missing GL section. Steps Open the 'General Ledger Charge Account Numbers' form. Click the 'Print G/L Charge Table' item. Click the [Dynamics GP Comparison]. Validate the 'Missing in GP' section of the report displays the charge account numbers which are in the GL dictionaries, but they are not in the CSV file. Validate the 'Missing in GL' section of the report displays the charge account numbers which are not in the GL dictionaries, but they are included in the CSV file. Validate that the report does not display the charge account numbers which are in the GL dictionary and the CSV file contains them. Close the report. Click the 'G/L Interface for Charges' item. Select component and the component value for each of the components. In the 'Credit General Ledger Charge Account Number' field select desired account from the dropdown list. In the 'Debit General Ledger Charge Account Number' field select desired account from the dropdown list. Click [File General Ledger Pay/Adj Account Numbers]. Click the 'G/L Defaults for Charges' item. Select desired account from the 'Default Credit General Ledger Charge Account Number' dropdown list. Select desired account from the 'Default Debit General Ledger Charge Account Number' dropdown list. Click [File Default General Ledger Pay/Adj Account Numbers]. Go to the 'Print G/L Charge Table' section. Click [Print Crystal Report]. Verify the report displays all the components correctly with the value entered/selected for the component. Close the report. Close the form. Scenario 3: GL Integration - Dynamics GP - Validating 'Dynamics GP Comparison' in the ‘General Ledger Payment/Adjustment Account Numbers’ form Specific Setup: System updated with Avatar GL module. Registry Settings: The 'Enable Dynamics GP Integration' is set to 'Y'. Dictionary Update: File: G/L Interface (202) - Credit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (203) - Debit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. General Ledger Interface components: General ledger interface components are defined. Note the components. General Ledger Payment/Adjustment Account Numbers: General Ledger Payment/Adjustment Account Numbers and default Payment/Adjustment account numbers are defined. Note the account codes/values. GL Facility Defaults: The 'Output Path On Server For CSV File', 'Dynamics GP Input Path On Server' and 'Dynamics GP Output Path On Server' are populated with the valid paths for the input/output files for Dynamics GP will be placed. Note all the paths for later use. GP Account File: A CSV file is created in the format account number, account description and account type that contains accounts in the system but not all. Please note - the account type is exactly the values of 'Charge' or 'Pmt/Adj'. Note the account numbers included in the file. The CSV file created is placed in the path defined as the 'Dynamics GP Input Path On Server' in the 'GL Facility Defaults'. Steps Open the 'General Ledger Payment/Adjustment Account Numbers' form. Click the 'Print G/L Pay/Adj Table' item. Click the [Dynamics GP Comparison]. Validate the 'Missing in GP' section of the report displays the payment/adjustment account numbers which are in GL dictionaries, but in the CSV file. Validate the 'Missing in GL' section of the report displays the payment/adjustment account numbers which are not in the GL dictionaries, but in the CSV file. Validate that the report does not display the payment/adjustment account numbers which are in the GL dictionary and the CSV file contains them. Close the report. Click the 'G/L Interface for Pay/Adj' item. 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. Close the report. Close the form. Dynamics GP - Table Import For General Ledger Account Numbers Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following: Table Import For General Ledger Account Numbers Registry Settings (PM) User Definition Dictionary Update (PM) GL Facility Defaults Scenario 1: GL Integration - Dynamics GP - Table Import For General Ledger Account Numbers Specific Setup: System updated with Avatar GL module. Registry Settings: The 'Enable Dynamics GP Integration' is set to 'Y'. Dictionary Update: File: G/L Interface (200) - Credit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (201) - Debit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (202) - Credit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (203) - Debit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. General Ledger Interface components: General ledger interface components are defined. Note the components. General Ledger Charge Account Numbers: General ledger credit/debit charge account numbers, default charge account numbers and general ledger interface components are defined. Note the account codes/values. GL Facility Defaults: The 'Output Path On Server For CSV File', 'Dynamics GP Input Path On Server' and 'Dynamics GP Output Path On Server' are populated with the valid paths for the input/output files for Dynamics GP. Note all the paths for later use. GP Account File: A CSV file is created in the format account number, account description and account type that contains general ledger charge accounts in the system but not all. Please note - the account type is exactly the values of 'Charge' or 'Pmt/Adj'. Note the account numbers included in the file. The CSV file created is placed in the path defined as the 'Dynamics GP Input Path On Server' in the 'GL Facility Defaults'. The text file to import charge or payment/adjustment account numbers are created and placed in a local dictionary. Note the location of the file. Steps Open the 'Table Import For General Ledger Account Numbers' form. Select the 'GL Charge Account Numbers' in the 'Load Which Table' field. Select the 'Append to Existing Table' in the 'Load Option' field. Select desired charge account file for import. Click [Import GL Account Numbers]. Verify the crystal report launched and a previously selected and correctly displays the 'Total Number of Rows in File' imported successfully. Click [Close Report]. Verify another 'Table Import For General Ledger Account Numbers' report launched that contains the account numbers which are missing in GP. (Please note: System will launch the report to display the account numbers under the missing in GP if the general ledger payment/adjustment account numbers are in GL dictionary but not in the CSV file.). Close the report. Select the 'GL Payment/Adjustment Account Numbers' in the 'Load Which Table' field. Select the 'Append to Existing Table' in the 'Load Option' field. Select desired payment/adjustment account file for import. Click [Import GL Account Numbers]. Verify the crystal report launched and correctly displays the 'Total Number of Rows in File' imported successfully. Click [Close Report]. Verify another 'Table Import For General Ledger Account Numbers' report launched that contains the account numbers which are missing in GP. (Please note: System will launch the report to display the account numbers under the missing in GP if the general ledger payment/adjustment account numbers are in GL dictionary but not in the CSV file.). Close the report. Open the 'Table Import For General Ledger Account Numbers' form. Select the 'GL Charge Account Numbers' in the 'Load Which Table' field. Select the 'Over-Ride Existing Table' in the 'Load Option' field. Select desired charge account file for import. Click [Import GL Account Numbers]. Verify the crystal report launched and a previously selected and correctly displays the 'Total Number of Rows in File' imported successfully. Click [Close Report]. Verify another 'Table Import For General Ledger Account Numbers' report launched that contains the account numbers which are missing in GP. (Please note: System will launch the report to display the account numbers under the missing in GP if the general ledger payment/adjustment account numbers are in GL dictionary but not in the CSV file.). Close the report. Select the 'GL Payment/Adjustment Account Numbers' in the 'Load Which Table' field. Select the 'Over-Ride Existing Table' in the 'Load Option' field. Select desired payment/adjustment account file for import. Click [Import GL Account Numbers]. Verify the crystal report launched and correctly displays the 'Total Number of Rows in File' imported successfully. Click [Close Report]. Verify another 'Table Import For General Ledger Account Numbers' report launched that contains the account numbers which are missing in GP. (Please note: System will launch the report to display the account numbers under the missing in GP if the general ledger payment/adjustment account numbers are in GL dictionary but not in the CSV file.). Close the report. Enable Dynamics GP Integration - Dynamics GP Comparison Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following: Registry Settings (PM) User Definition GL Facility Defaults General Ledger Payment/Adjustment Account Numbers Print General Ledger Payment/Adjustment Interface File Detail Print General Ledger Charge Interface File Detail Dictionary Update (PM) Compile General Ledger Payment/Adjustment Interface File COMPILE GENERAL LEDGER CHARGE INTERFACE FILE Table Import For General Ledger Account Numbers Scenario 1: GL Integration - Dynamics GP - Registry Setting - Enable Dynamics GP Integration Steps Open the 'Registry Settings' form. Set the 'Limit Registry Settings' to the 'Enable Dynamics GP Integration'. Click [View Registry Settings]. Validate the 'Registry Setting' field contains 'Avatar GL->General Ledger Interface->->->->Enable Dynamics GP Integration'. Validate the 'Registry Setting Details' field contains '[FACILITY SPECIFIC] ------------------------------------------------------------------------------- Enter "Y" to enable Dynamics GP integration. This will add the fields 'Dynamics GP Input Path On Server' and 'Dynamics GP Output Path On Server' to the 'GL Facility Defaults' form. The output path will be used to send compiled files to Dynamics GP. The input path will be used to get Dynamics GP accounts for comparison with Avatar GL accounts through various forms. Enter "N" to disable Dynamics GP integration.'. Validate the 'Registry Setting Value' field is defaulted to 'N'. Click [Submit]. Click [OK]. Click [Yes]. Set the ‘Limit Registry Settings’ to the ‘Dynamics GP’. Click [View Registry Settings]. Set the ‘Registry Setting Value’ input box to ‘1’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’. Click [OK]. Set the ‘Registry Setting Value’ input box to ‘M’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘Yes’. Validate the message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘No’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘‘. Click [Submit]. Click [OK]. Click [Yes]. Set the ‘Limit Registry Settings’ to the ‘Dynamics GP’. Click [View Registry Settings]. Set the 'Registry Setting Value' input box to 'Y'. Click [Submit]. Click [OK]. Click [No]. Open the 'User Definition' form. Select desired user from the ‘Select User’ field. Click the ‘Forms and Tables’ item. Click [Select Forms for User Access]. Click ‘Avatar PM’ item. Verify that the 'General Ledger Interface' item exist. Verify that all the items are checked. Click [OK]. Click [Submit]. Click [No]. Open the ‘GL Facility Defaults’ form. Verify the ‘Output Path On Server For CSV File’ field exists. Verify the ‘Dynamics GP Input Path On Server’ field exists. Verify the ‘Dynamics GP Output Path On Server’ field exists. Click the light bulb icon of the ‘Dynamics GP Input Path On Server’ field and validate the help text contains ‘This path is used for Dynamics GP to add a file of accounts that can be pulled on demand by Avatar to compare with GL accounts.' Click the ‘Return To Form’ link. Click the light bulb icon of the ‘Dynamics GP Output Path On Server’ field and validate the help text contains ‘This path is used to output a CSV file of the Avatar GL compile for Dynamics GP to use.’. Click the ‘Return To Form’ link. Click [Discard]. Click [Yes]. Open the ‘General Ledger Charge Account Numbers’ form. Click the ‘Print G/L Charge Table’ item. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the ‘General Ledger Payment/Adjustment Account Numbers’ form. Click the ‘Print G/L Pay/Adj Table’ item. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the 'Registry Settings' form. Set the 'Limit Registry Settings' to the 'Enable Dynamics GP Integration'. Click [View Registry Settings]. Set the 'Registry Setting Value' input box to 'N'. Click [Submit]. Click [OK]. Click [No]. Open the ‘GL Facility Defaults’ form. Verify the ‘Dynamics GP Input Path On Server’ field does not exist. Verify the ‘Dynamics GP Output Path On Server’ field does not exist. Click [Discard]. Click [Yes]. Open the ‘General Ledger Charge Account Numbers’ form. Click the ‘Print G/L Charge Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘General Ledger Payment/Adjustment Account Numbers’ form. Click the ‘Print G/L Pay/Adj Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the 'Registry Settings' form. Set the 'Limit Registry Settings' to the 'Enable Dynamics GP Integration'. Click [View Registry Settings]. Set the 'Registry Setting Value' input box to ''. Click [Submit]. Click [OK]. Click [No]. Open the ‘GL Facility Defaults’ form. Verify the ‘Dynamics GP Input Path On Server’ field does not exist. Verify the ‘Dynamics GP Output Path On Server’ field does not exist. Click [Discard]. Click [Yes]. Open the ‘General Ledger Charge Account Numbers’ form. Click the ‘Print G/L Charge Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘General Ledger Payment/Adjustment Account Numbers’ form. Click the ‘Print G/L Pay/Adj Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Scenario 2: GL Integration - Dynamic GP - Compile General Ledger Payment/Adjustment Interface File and Print General Ledger Payment/Adjustment Interface Detail File* Specific Setup: System updated with Avatar GL module. Registry Settings: The 'Enable Dynamics GP Integration' is set to 'Y'. Dictionary Update: File: G/L Interface (202) - Credit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (203) - Debit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. General Ledger Interface components: General ledger interface components are defined. Note the components. General Ledger Payment/Adjustment Account Numbers: General ledger credit/debit payment/adjustment account numbers, default payment/adjustment account numbers and general ledger interface components are defined. Note the account codes/values. File Explorer: Local folders are created to place the input/output CSV files. Note the paths of the folder. GL Facility Defaults: The following fields are populated with the valid paths of the input/output files for Dynamics GP. Note all the paths for later use. Output Path On Server For CSV File Dynamics GP Input Path On Server Dynamics GP Output Path On Server' GP Account File: A CSV file is created in the format account number, account description and account type that contains general ledger payment/adjustment accounts in the system but not all. Please note - the account type is exactly the values of 'Charge' or 'Pmt/Adj'. Note the account numbers included in the file. The CSV file created is placed in the path defined as the 'Dynamics GP Input Path On Server' in the 'GL Facility Defaults'. Steps Open the 'Compile General Ledger Payment/Adjustment Interface File' form. Set the 'Bill Period' field to a desired bill period. (i.e. The format of the bill period is MM/YYYY). Set the 'General Ledger Posting Date' to desired date. Set the field 'Pre-Compile' to 'No'. Click [Process]. Verify the 'Compile General Ledger Payment/Adjustment Interface File' report launches successfully. Verify the report displays the GL strings for the Payment/Adjustment account numbers with the specific information. Note the details displays on the report. Close the report. Close the form. Locate to the local folders are created to place output CSV file. Verify the CSV file matching the details shown on the 'Compile General Ledger Payment/Adjustment Interface File' report screen is generated and placed in both the paths setup for 'Output Path On Server For CSV File' and 'Dynamics GP Output Path On Server' in the 'GL Facility Defaults'. Open the 'Compile General Ledger Payment/Adjustment Interface File' form. Set the 'Bill Period' field to a desired bill period. (i.e. The format of the bill period is MM/YYYY). Set the 'General Ledger Posting Date' to desired date. Set the field 'Pre-Compile' to 'Yes'. Click [Process]. Verify the 'Compile General Ledger Payment/Adjustment Interface File' report launches successfully. Verify a 'Pre-Compile' report displays 'Pre-Compile. Please see 'Print General Ledger Payment/Adjustment Interface File Detail'. Close the report. Close the form. Open the 'Print General Ledger Payment/Adjustment Interface File Detail' form. Enter the 'Bill Period' previously specified. Click [Dynamics GP Comparison]. Verify a report launches successfully and displays only the account numbers in the compile that are missing from the GP file. Close the report. Click [Process]. Verify the report displays all applicable Payment/Adjustments within the billing period based on the data set up in the 'General Ledger Interface components' and 'General Ledger Payment/Adjustment Account Numbers'. Close the report. Close the form. Open the 'Crystal report' or any other SQL data viewer. Query the 'Select * from GL.compilepayadjintdetail' table for the client identified in the setup section. Verify the accounts and components displays correctly as defined. Close the 'Crystal Report'. Scenario 3: GL Integration - Dynamic GP - Compile General Ledger Charge Interface File and Print General Ledger Charge Interface Detail File Specific Setup: System updated with Avatar GL module. Registry Settings: The 'Enable Dynamics GP Integration' is set to 'Y'. Dictionary Update: File: G/L Interface (200) - Credit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (201) - Debit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. General Ledger Interface components: General ledger interface components are defined. Note the components. General Ledger Charge Account Numbers: General ledger credit/debit charge account numbers, default charge account numbers and general ledger interface components are defined. Note the account codes/values. File Explorer: Local folders are created to place input/output CSV file. Note the paths of the folder. GL Facility Defaults: The following fields are populated with the valid paths of the input/output files for Dynamics GP. Note all the paths for later use. Output Path On Server For CSV File Dynamics GP Input Path On Server Dynamics GP Output Path On Server' GP Account File: A CSV file is created in the format account number, account description and account type that contains general ledger charge accounts in the system but not all. Please note - the account type is exactly the values of 'Charge' or 'Pmt/Adj'. Note the account numbers included in the file. The CSV file created is placed in the path defined as the 'Dynamics GP Input Path On Server' in the 'GL Facility Defaults'. Steps Open the 'Compile General Ledger Charge Interface File' form. Set the 'Bill Period' field to a desired bill period. (i.e. The format of the bill period is MM/YYYY). Set the 'General Ledger Posting Date' to desired date. Set the field 'Pre-Compile' to 'No'. Click [Process]. Verify the 'Compile General Ledger Charge Interface File' report launches successfully. Verify the report displays the GL strings for the charge account numbers with the specific information. Note the details displays on the report Close the report. Close the form. Locate to the local folders are created to place output CSV file. Verify the CSV file matching the details shown on the 'Compile General Ledger Charge Interface File' report screen is generated and placed in both the paths setup for 'Output Path On Server For CSV File' and 'Dynamics GP Output Path On Server' in the 'GL Facility Defaults'. Open the 'Compile General Ledger Charge Interface File' form. Set the 'Bill Period' field to a desired bill period. (i.e. The format of the bill period is MM/YYYY). Set the 'General Ledger Posting Date' to desired date. Set the field 'Pre-Compile' to 'Yes'. Click [Process]. Verify the 'Compile General Ledger Charge Interface File' report launches successfully. Verify a 'Pre-Compile' report displays 'Pre-Compile. Please see 'Print General Ledger Charge Interface File Detail'. Close the report. Close the form. Open the 'Print General Ledger Charge Interface File Detail' form. Enter the 'Bill Period' previously specified. Click [Dynamics GP Comparison]. Verify a report launches successfully and displays only the account numbers in the compile that are missing from the GP file. Close the report. Click [Process]. Verify the report displays all applicable charges within the billing period based on the data set up in the 'General Ledger Interface components' and 'General Ledger Charge Account Numbers'. Close the report. Close the form. Open the 'Crystal report' or any other SQL data viewer. Query the 'Select * from GL.compilechargeintdetail' table. Verify an existence of the 'counter' field. Verify the SQL view contains correct value in the 'counter' column. Verify the SQL view displays accounts and components as defined in the setup. Close the report. Scenario 4: GL Integration - Dynamics GP - Table Import For General Ledger Account Numbers Specific Setup: System updated with Avatar GL module. Registry Settings: The 'Enable Dynamics GP Integration' is set to 'Y'. Dictionary Update: File: G/L Interface (200) - Credit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (201) - Debit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (202) - Credit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (203) - Debit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. General Ledger Interface components: General ledger interface components are defined. Note the components. General Ledger Charge Account Numbers: General ledger credit/debit charge account numbers, default charge account numbers and general ledger interface components are defined. Note the account codes/values. GL Facility Defaults: The 'Output Path On Server For CSV File', 'Dynamics GP Input Path On Server' and 'Dynamics GP Output Path On Server' are populated with the valid paths for the input/output files for Dynamics GP. Note all the paths for later use. GP Account File: A CSV file is created in the format account number, account description and account type that contains general ledger charge accounts in the system but not all. Please note - the account type is exactly the values of 'Charge' or 'Pmt/Adj'. Note the account numbers included in the file. The CSV file created is placed in the path defined as the 'Dynamics GP Input Path On Server' in the 'GL Facility Defaults'. The text file to import charge or payment/adjustment account numbers are created and placed in a local dictionary. Note the location of the file. Steps Open the 'Table Import For General Ledger Account Numbers' form. Select the 'GL Charge Account Numbers' in the 'Load Which Table' field. Select the 'Append to Existing Table' in the 'Load Option' field. Select desired charge account file for import. Click [Import GL Account Numbers]. Verify the crystal report launched and a previously selected and correctly displays the 'Total Number of Rows in File' imported successfully. Click [Close Report]. Verify another 'Table Import For General Ledger Account Numbers' report launched that contains the account numbers which are missing in GP. (Please note: System will launch the report to display the account numbers under the missing in GP if the general ledger payment/adjustment account numbers are in GL dictionary but not in the CSV file.). Close the report. Select the 'GL Payment/Adjustment Account Numbers' in the 'Load Which Table' field. Select the 'Append to Existing Table' in the 'Load Option' field. Select desired payment/adjustment account file for import. Click [Import GL Account Numbers]. Verify the crystal report launched and correctly displays the 'Total Number of Rows in File' imported successfully. Click [Close Report]. Verify another 'Table Import For General Ledger Account Numbers' report launched that contains the account numbers which are missing in GP. (Please note: System will launch the report to display the account numbers under the missing in GP if the general ledger payment/adjustment account numbers are in GL dictionary but not in the CSV file.). Close the report. Open the 'Table Import For General Ledger Account Numbers' form. Select the 'GL Charge Account Numbers' in the 'Load Which Table' field. Select the 'Over-Ride Existing Table' in the 'Load Option' field. Select desired charge account file for import. Click [Import GL Account Numbers]. Verify the crystal report launched and a previously selected and correctly displays the 'Total Number of Rows in File' imported successfully. Click [Close Report]. Verify another 'Table Import For General Ledger Account Numbers' report launched that contains the account numbers which are missing in GP. (Please note: System will launch the report to display the account numbers under the missing in GP if the general ledger payment/adjustment account numbers are in GL dictionary but not in the CSV file.). Close the report. Select the 'GL Payment/Adjustment Account Numbers' in the 'Load Which Table' field. Select the 'Over-Ride Existing Table' in the 'Load Option' field. Select desired payment/adjustment account file for import. Click [Import GL Account Numbers]. Verify the crystal report launched and correctly displays the 'Total Number of Rows in File' imported successfully. Click [Close Report]. Verify another 'Table Import For General Ledger Account Numbers' report launched that contains the account numbers which are missing in GP. (Please note: System will launch the report to display the account numbers under the missing in GP if the general ledger payment/adjustment account numbers are in GL dictionary but not in the CSV file.). Close the report. Scenario 5: GL Integration - Dynamics GP - Validating 'Dynamics GP Comparison' in the ‘General Ledger Charge Account Numbers’ form Specific Setup: System updated with Avatar GL module. Registry Settings: The 'Enable Dynamics GP Integration' is set to 'Y'. Dictionary Update: File: G/L Interface (200) - Credit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (201) - Debit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. General Ledger Interface components: General ledger interface components are defined. Note the components. General Ledger Charge Account Numbers: General ledger credit/debit charge account numbers, default charge account numbers and general ledger interface components are defined. Note the account codes/values. GL Facility Defaults: The 'Output Path On Server For CSV File', 'Dynamics GP Input Path On Server' and 'Dynamics GP Output Path On Server' are populated with the valid paths for the input/output files for Dynamics GP. Note all the paths for later use. GP Account File: A CSV file is created in the format account number, account description and account type that contains GL charge account numbers exist in the system but not all. The account type is exactly the values of 'Charge' or 'Pmt/Adj'. The CSV file created is placed in the location defined as the 'Dynamics GP Input Path On Server' in the 'GL Facility Defaults' form. Note the account numbers included in the file. Please note: If the charge account number is in the GL dictionaries (Credit G/L Charge Account Number or Debit G/L Charge Account Number) but not in the input file then it is in the missing in GP section. If the account number is in the input file but not in GL dictionaries (Credit G/L Charge Account Number or Debit G/L Charge Account Number) then it is in the missing GL section. Steps Open the 'General Ledger Charge Account Numbers' form. Click the 'Print G/L Charge Table' item. Click the [Dynamics GP Comparison]. Validate the 'Missing in GP' section of the report displays the charge account numbers which are in the GL dictionaries, but they are not in the CSV file. Validate the 'Missing in GL' section of the report displays the charge account numbers which are not in the GL dictionaries, but they are included in the CSV file. Validate that the report does not display the charge account numbers which are in the GL dictionary and the CSV file contains them. Close the report. Click the 'G/L Interface for Charges' item. Select component and the component value for each of the components. In the 'Credit General Ledger Charge Account Number' field select desired account from the dropdown list. In the 'Debit General Ledger Charge Account Number' field select desired account from the dropdown list. Click [File General Ledger Pay/Adj Account Numbers]. Click the 'G/L Defaults for Charges' item. Select desired account from the 'Default Credit General Ledger Charge Account Number' dropdown list. Select desired account from the 'Default Debit General Ledger Charge Account Number' dropdown list. Click [File Default General Ledger Pay/Adj Account Numbers]. Go to the 'Print G/L Charge Table' section. Click [Print Crystal Report]. Verify the report displays all the components correctly with the value entered/selected for the component. Close the report. Close the form. Scenario 6: GL Integration - Dynamics GP - Validating 'Dynamics GP Comparison' in the ‘General Ledger Payment/Adjustment Account Numbers’ form Specific Setup: System updated with Avatar GL module. Registry Settings: The 'Enable Dynamics GP Integration' is set to 'Y'. Dictionary Update: File: G/L Interface (202) - Credit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (203) - Debit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. General Ledger Interface components: General ledger interface components are defined. Note the components. General Ledger Payment/Adjustment Account Numbers: General Ledger Payment/Adjustment Account Numbers and default Payment/Adjustment account numbers are defined. Note the account codes/values. GL Facility Defaults: The 'Output Path On Server For CSV File', 'Dynamics GP Input Path On Server' and 'Dynamics GP Output Path On Server' are populated with the valid paths for the input/output files for Dynamics GP will be placed. Note all the paths for later use. GP Account File: A CSV file is created in the format account number, account description and account type that contains accounts in the system but not all. Please note - the account type is exactly the values of 'Charge' or 'Pmt/Adj'. Note the account numbers included in the file. The CSV file created is placed in the path defined as the 'Dynamics GP Input Path On Server' in the 'GL Facility Defaults'. Steps Open the 'General Ledger Payment/Adjustment Account Numbers' form. Click the 'Print G/L Pay/Adj Table' item. Click the [Dynamics GP Comparison]. Validate the 'Missing in GP' section of the report displays the payment/adjustment account numbers which are in GL dictionaries, but in the CSV file. Validate the 'Missing in GL' section of the report displays the payment/adjustment account numbers which are not in the GL dictionaries, but in the CSV file. Validate that the report does not display the payment/adjustment account numbers which are in the GL dictionary and the CSV file contains them. Close the report. Click the 'G/L Interface for Pay/Adj' item. 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. Close the report. Close the form. Compile General Ledger Payment/Adjustment Interface File - CSV file Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following: Registry Settings (PM) User Definition GL Facility Defaults General Ledger Payment/Adjustment Account Numbers Print General Ledger Payment/Adjustment Interface File Detail Print General Ledger Charge Interface File Detail Dictionary Update (PM) Scenario 1: GL Integration - Dynamics GP - Registry Setting - Enable Dynamics GP Integration Steps Open the 'Registry Settings' form. Set the 'Limit Registry Settings' to the 'Enable Dynamics GP Integration'. Click [View Registry Settings]. Validate the 'Registry Setting' field contains 'Avatar GL->General Ledger Interface->->->->Enable Dynamics GP Integration'. Validate the 'Registry Setting Details' field contains '[FACILITY SPECIFIC] ------------------------------------------------------------------------------- Enter "Y" to enable Dynamics GP integration. This will add the fields 'Dynamics GP Input Path On Server' and 'Dynamics GP Output Path On Server' to the 'GL Facility Defaults' form. The output path will be used to send compiled files to Dynamics GP. The input path will be used to get Dynamics GP accounts for comparison with Avatar GL accounts through various forms. Enter "N" to disable Dynamics GP integration.'. Validate the 'Registry Setting Value' field is defaulted to 'N'. Click [Submit]. Click [OK]. Click [Yes]. Set the ‘Limit Registry Settings’ to the ‘Dynamics GP’. Click [View Registry Settings]. Set the ‘Registry Setting Value’ input box to ‘1’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’. Click [OK]. Set the ‘Registry Setting Value’ input box to ‘M’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘Yes’. Validate the message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘No’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘‘. Click [Submit]. Click [OK]. Click [Yes]. Set the ‘Limit Registry Settings’ to the ‘Dynamics GP’. Click [View Registry Settings]. Set the 'Registry Setting Value' input box to 'Y'. Click [Submit]. Click [OK]. Click [No]. Open the 'User Definition' form. Select desired user from the ‘Select User’ field. Click the ‘Forms and Tables’ item. Click [Select Forms for User Access]. Click ‘Avatar PM’ item. Verify that the 'General Ledger Interface' item exist. Verify that all the items are checked. Click [OK]. Click [Submit]. Click [No]. Open the ‘GL Facility Defaults’ form. Verify the ‘Output Path On Server For CSV File’ field exists. Verify the ‘Dynamics GP Input Path On Server’ field exists. Verify the ‘Dynamics GP Output Path On Server’ field exists. Click the light bulb icon of the ‘Dynamics GP Input Path On Server’ field and validate the help text contains ‘This path is used for Dynamics GP to add a file of accounts that can be pulled on demand by Avatar to compare with GL accounts.' Click the ‘Return To Form’ link. Click the light bulb icon of the ‘Dynamics GP Output Path On Server’ field and validate the help text contains ‘This path is used to output a CSV file of the Avatar GL compile for Dynamics GP to use.’. Click the ‘Return To Form’ link. Click [Discard]. Click [Yes]. Open the ‘General Ledger Charge Account Numbers’ form. Click the ‘Print G/L Charge Table’ item. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the ‘General Ledger Payment/Adjustment Account Numbers’ form. Click the ‘Print G/L Pay/Adj Table’ item. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the 'Registry Settings' form. Set the 'Limit Registry Settings' to the 'Enable Dynamics GP Integration'. Click [View Registry Settings]. Set the 'Registry Setting Value' input box to 'N'. Click [Submit]. Click [OK]. Click [No]. Open the ‘GL Facility Defaults’ form. Verify the ‘Dynamics GP Input Path On Server’ field does not exist. Verify the ‘Dynamics GP Output Path On Server’ field does not exist. Click [Discard]. Click [Yes]. Open the ‘General Ledger Charge Account Numbers’ form. Click the ‘Print G/L Charge Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘General Ledger Payment/Adjustment Account Numbers’ form. Click the ‘Print G/L Pay/Adj Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the 'Registry Settings' form. Set the 'Limit Registry Settings' to the 'Enable Dynamics GP Integration'. Click [View Registry Settings]. Set the 'Registry Setting Value' input box to ''. Click [Submit]. Click [OK]. Click [No]. Open the ‘GL Facility Defaults’ form. Verify the ‘Dynamics GP Input Path On Server’ field does not exist. Verify the ‘Dynamics GP Output Path On Server’ field does not exist. Click [Discard]. Click [Yes]. Open the ‘General Ledger Charge Account Numbers’ form. Click the ‘Print G/L Charge Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘General Ledger Payment/Adjustment Account Numbers’ form. Click the ‘Print G/L Pay/Adj Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Scenario 2: GL Integration - Dynamics GP - Validating 'Dynamics GP Comparison' in the ‘General Ledger Payment/Adjustment Account Numbers’ form* Specific Setup: System updated with Avatar GL module. Registry Settings: The 'Enable Dynamics GP Integration' is set to 'Y'. Dictionary Update: File: G/L Interface (202) - Credit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (203) - Debit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. General Ledger Interface components: General ledger interface components are defined. Note the components. General Ledger Payment/Adjustment Account Numbers: General Ledger Payment/Adjustment Account Numbers and default Payment/Adjustment account numbers are defined. Note the account codes/values. GL Facility Defaults: The 'Output Path On Server For CSV File', 'Dynamics GP Input Path On Server' and 'Dynamics GP Output Path On Server' are populated with the valid paths for the input/output files for Dynamics GP will be placed. Note all the paths for later use. GP Account File: A CSV file is created in the format account number, account description and account type that contains accounts in the system but not all. Please note - the account type is exactly the values of 'Charge' or 'Pmt/Adj'. Note the account numbers included in the file. The CSV file created is placed in the path defined as the 'Dynamics GP Input Path On Server' in the 'GL Facility Defaults'. Steps Open the 'General Ledger Payment/Adjustment Account Numbers' form. Click the 'Print G/L Pay/Adj Table' item. Click the [Dynamics GP Comparison]. Validate the 'Missing in GP' section of the report displays the payment/adjustment account numbers which are in GL dictionaries, but in the CSV file. Validate the 'Missing in GL' section of the report displays the payment/adjustment account numbers which are not in the GL dictionaries, but in the CSV file. Validate that the report does not display the payment/adjustment account numbers which are in the GL dictionary and the CSV file contains them. Close the report. Click the 'G/L Interface for Pay/Adj' item. 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. Close the report. Close the form. Compile General Ledger Payment/Adjustment Interface File - Pre-Compile Payment/Adjustment file Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following: Registry Settings (PM) User Definition GL Facility Defaults General Ledger Payment/Adjustment Account Numbers Print General Ledger Payment/Adjustment Interface File Detail Print General Ledger Charge Interface File Detail Dictionary Update (PM) Compile General Ledger Payment/Adjustment Interface File Scenario 1: GL Integration - Dynamics GP - Registry Setting - Enable Dynamics GP Integration Steps Open the 'Registry Settings' form. Set the 'Limit Registry Settings' to the 'Enable Dynamics GP Integration'. Click [View Registry Settings]. Validate the 'Registry Setting' field contains 'Avatar GL->General Ledger Interface->->->->Enable Dynamics GP Integration'. Validate the 'Registry Setting Details' field contains '[FACILITY SPECIFIC] ------------------------------------------------------------------------------- Enter "Y" to enable Dynamics GP integration. This will add the fields 'Dynamics GP Input Path On Server' and 'Dynamics GP Output Path On Server' to the 'GL Facility Defaults' form. The output path will be used to send compiled files to Dynamics GP. The input path will be used to get Dynamics GP accounts for comparison with Avatar GL accounts through various forms. Enter "N" to disable Dynamics GP integration.'. Validate the 'Registry Setting Value' field is defaulted to 'N'. Click [Submit]. Click [OK]. Click [Yes]. Set the ‘Limit Registry Settings’ to the ‘Dynamics GP’. Click [View Registry Settings]. Set the ‘Registry Setting Value’ input box to ‘1’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’. Click [OK]. Set the ‘Registry Setting Value’ input box to ‘M’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘Yes’. Validate the message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘No’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘‘. Click [Submit]. Click [OK]. Click [Yes]. Set the ‘Limit Registry Settings’ to the ‘Dynamics GP’. Click [View Registry Settings]. Set the 'Registry Setting Value' input box to 'Y'. Click [Submit]. Click [OK]. Click [No]. Open the 'User Definition' form. Select desired user from the ‘Select User’ field. Click the ‘Forms and Tables’ item. Click [Select Forms for User Access]. Click ‘Avatar PM’ item. Verify that the 'General Ledger Interface' item exist. Verify that all the items are checked. Click [OK]. Click [Submit]. Click [No]. Open the ‘GL Facility Defaults’ form. Verify the ‘Output Path On Server For CSV File’ field exists. Verify the ‘Dynamics GP Input Path On Server’ field exists. Verify the ‘Dynamics GP Output Path On Server’ field exists. Click the light bulb icon of the ‘Dynamics GP Input Path On Server’ field and validate the help text contains ‘This path is used for Dynamics GP to add a file of accounts that can be pulled on demand by Avatar to compare with GL accounts.' Click the ‘Return To Form’ link. Click the light bulb icon of the ‘Dynamics GP Output Path On Server’ field and validate the help text contains ‘This path is used to output a CSV file of the Avatar GL compile for Dynamics GP to use.’. Click the ‘Return To Form’ link. Click [Discard]. Click [Yes]. Open the ‘General Ledger Charge Account Numbers’ form. Click the ‘Print G/L Charge Table’ item. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the ‘General Ledger Payment/Adjustment Account Numbers’ form. Click the ‘Print G/L Pay/Adj Table’ item. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the 'Registry Settings' form. Set the 'Limit Registry Settings' to the 'Enable Dynamics GP Integration'. Click [View Registry Settings]. Set the 'Registry Setting Value' input box to 'N'. Click [Submit]. Click [OK]. Click [No]. Open the ‘GL Facility Defaults’ form. Verify the ‘Dynamics GP Input Path On Server’ field does not exist. Verify the ‘Dynamics GP Output Path On Server’ field does not exist. Click [Discard]. Click [Yes]. Open the ‘General Ledger Charge Account Numbers’ form. Click the ‘Print G/L Charge Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘General Ledger Payment/Adjustment Account Numbers’ form. Click the ‘Print G/L Pay/Adj Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the 'Registry Settings' form. Set the 'Limit Registry Settings' to the 'Enable Dynamics GP Integration'. Click [View Registry Settings]. Set the 'Registry Setting Value' input box to ''. Click [Submit]. Click [OK]. Click [No]. Open the ‘GL Facility Defaults’ form. Verify the ‘Dynamics GP Input Path On Server’ field does not exist. Verify the ‘Dynamics GP Output Path On Server’ field does not exist. Click [Discard]. Click [Yes]. Open the ‘General Ledger Charge Account Numbers’ form. Click the ‘Print G/L Charge Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘General Ledger Payment/Adjustment Account Numbers’ form. Click the ‘Print G/L Pay/Adj Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Scenario 2: GL Integration - Dynamic GP - Compile General Ledger Payment/Adjustment Interface File and Print General Ledger Payment/Adjustment Interface Detail File* Specific Setup: System updated with Avatar GL module. Registry Settings: The 'Enable Dynamics GP Integration' is set to 'Y'. Dictionary Update: File: G/L Interface (202) - Credit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (203) - Debit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. General Ledger Interface components: General ledger interface components are defined. Note the components. General Ledger Payment/Adjustment Account Numbers: General ledger credit/debit payment/adjustment account numbers, default payment/adjustment account numbers and general ledger interface components are defined. Note the account codes/values. File Explorer: Local folders are created to place the input/output CSV files. Note the paths of the folder. GL Facility Defaults: The following fields are populated with the valid paths of the input/output files for Dynamics GP. Note all the paths for later use. Output Path On Server For CSV File Dynamics GP Input Path On Server Dynamics GP Output Path On Server' GP Account File: A CSV file is created in the format account number, account description and account type that contains general ledger payment/adjustment accounts in the system but not all. Please note - the account type is exactly the values of 'Charge' or 'Pmt/Adj'. Note the account numbers included in the file. The CSV file created is placed in the path defined as the 'Dynamics GP Input Path On Server' in the 'GL Facility Defaults'. Steps Open the 'Compile General Ledger Payment/Adjustment Interface File' form. Set the 'Bill Period' field to a desired bill period. (i.e. The format of the bill period is MM/YYYY). Set the 'General Ledger Posting Date' to desired date. Set the field 'Pre-Compile' to 'No'. Click [Process]. Verify the 'Compile General Ledger Payment/Adjustment Interface File' report launches successfully. Verify the report displays the GL strings for the Payment/Adjustment account numbers with the specific information. Note the details displays on the report. Close the report. Close the form. Locate to the local folders are created to place output CSV file. Verify the CSV file matching the details shown on the 'Compile General Ledger Payment/Adjustment Interface File' report screen is generated and placed in both the paths setup for 'Output Path On Server For CSV File' and 'Dynamics GP Output Path On Server' in the 'GL Facility Defaults'. Open the 'Compile General Ledger Payment/Adjustment Interface File' form. Set the 'Bill Period' field to a desired bill period. (i.e. The format of the bill period is MM/YYYY). Set the 'General Ledger Posting Date' to desired date. Set the field 'Pre-Compile' to 'Yes'. Click [Process]. Verify the 'Compile General Ledger Payment/Adjustment Interface File' report launches successfully. Verify a 'Pre-Compile' report displays 'Pre-Compile. Please see 'Print General Ledger Payment/Adjustment Interface File Detail'. Close the report. Close the form. Open the 'Print General Ledger Payment/Adjustment Interface File Detail' form. Enter the 'Bill Period' previously specified. Click [Dynamics GP Comparison]. Verify a report launches successfully and displays only the account numbers in the compile that are missing from the GP file. Close the report. Click [Process]. Verify the report displays all applicable Payment/Adjustments within the billing period based on the data set up in the 'General Ledger Interface components' and 'General Ledger Payment/Adjustment Account Numbers'. Close the report. Close the form. Open the 'Crystal report' or any other SQL data viewer. Query the 'Select * from GL.compilepayadjintdetail' table for the client identified in the setup section. Verify the accounts and components displays correctly as defined. Close the 'Crystal Report'. Compile General Ledger Charge Interface File - CSV file Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following: Registry Settings (PM) User Definition GL Facility Defaults General Ledger Payment/Adjustment Account Numbers Print General Ledger Payment/Adjustment Interface File Detail Print General Ledger Charge Interface File Detail Dictionary Update (PM) COMPILE GENERAL LEDGER CHARGE INTERFACE FILE Scenario 1: GL Integration - Dynamics GP - Registry Setting - Enable Dynamics GP Integration Steps Open the 'Registry Settings' form. Set the 'Limit Registry Settings' to the 'Enable Dynamics GP Integration'. Click [View Registry Settings]. Validate the 'Registry Setting' field contains 'Avatar GL->General Ledger Interface->->->->Enable Dynamics GP Integration'. Validate the 'Registry Setting Details' field contains '[FACILITY SPECIFIC] ------------------------------------------------------------------------------- Enter "Y" to enable Dynamics GP integration. This will add the fields 'Dynamics GP Input Path On Server' and 'Dynamics GP Output Path On Server' to the 'GL Facility Defaults' form. The output path will be used to send compiled files to Dynamics GP. The input path will be used to get Dynamics GP accounts for comparison with Avatar GL accounts through various forms. Enter "N" to disable Dynamics GP integration.'. Validate the 'Registry Setting Value' field is defaulted to 'N'. Click [Submit]. Click [OK]. Click [Yes]. Set the ‘Limit Registry Settings’ to the ‘Dynamics GP’. Click [View Registry Settings]. Set the ‘Registry Setting Value’ input box to ‘1’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’. Click [OK]. Set the ‘Registry Setting Value’ input box to ‘M’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘Yes’. Validate the message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘No’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘‘. Click [Submit]. Click [OK]. Click [Yes]. Set the ‘Limit Registry Settings’ to the ‘Dynamics GP’. Click [View Registry Settings]. Set the 'Registry Setting Value' input box to 'Y'. Click [Submit]. Click [OK]. Click [No]. Open the 'User Definition' form. Select desired user from the ‘Select User’ field. Click the ‘Forms and Tables’ item. Click [Select Forms for User Access]. Click ‘Avatar PM’ item. Verify that the 'General Ledger Interface' item exist. Verify that all the items are checked. Click [OK]. Click [Submit]. Click [No]. Open the ‘GL Facility Defaults’ form. Verify the ‘Output Path On Server For CSV File’ field exists. Verify the ‘Dynamics GP Input Path On Server’ field exists. Verify the ‘Dynamics GP Output Path On Server’ field exists. Click the light bulb icon of the ‘Dynamics GP Input Path On Server’ field and validate the help text contains ‘This path is used for Dynamics GP to add a file of accounts that can be pulled on demand by Avatar to compare with GL accounts.' Click the ‘Return To Form’ link. Click the light bulb icon of the ‘Dynamics GP Output Path On Server’ field and validate the help text contains ‘This path is used to output a CSV file of the Avatar GL compile for Dynamics GP to use.’. Click the ‘Return To Form’ link. Click [Discard]. Click [Yes]. Open the ‘General Ledger Charge Account Numbers’ form. Click the ‘Print G/L Charge Table’ item. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the ‘General Ledger Payment/Adjustment Account Numbers’ form. Click the ‘Print G/L Pay/Adj Table’ item. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the 'Registry Settings' form. Set the 'Limit Registry Settings' to the 'Enable Dynamics GP Integration'. Click [View Registry Settings]. Set the 'Registry Setting Value' input box to 'N'. Click [Submit]. Click [OK]. Click [No]. Open the ‘GL Facility Defaults’ form. Verify the ‘Dynamics GP Input Path On Server’ field does not exist. Verify the ‘Dynamics GP Output Path On Server’ field does not exist. Click [Discard]. Click [Yes]. Open the ‘General Ledger Charge Account Numbers’ form. Click the ‘Print G/L Charge Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘General Ledger Payment/Adjustment Account Numbers’ form. Click the ‘Print G/L Pay/Adj Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the 'Registry Settings' form. Set the 'Limit Registry Settings' to the 'Enable Dynamics GP Integration'. Click [View Registry Settings]. Set the 'Registry Setting Value' input box to ''. Click [Submit]. Click [OK]. Click [No]. Open the ‘GL Facility Defaults’ form. Verify the ‘Dynamics GP Input Path On Server’ field does not exist. Verify the ‘Dynamics GP Output Path On Server’ field does not exist. Click [Discard]. Click [Yes]. Open the ‘General Ledger Charge Account Numbers’ form. Click the ‘Print G/L Charge Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘General Ledger Payment/Adjustment Account Numbers’ form. Click the ‘Print G/L Pay/Adj Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Scenario 2: GL Integration - Dynamic GP - Compile General Ledger Charge Interface File and Print General Ledger Charge Interface Detail File* Specific Setup: System updated with Avatar GL module. Registry Settings: The 'Enable Dynamics GP Integration' is set to 'Y'. Dictionary Update: File: G/L Interface (200) - Credit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (201) - Debit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. General Ledger Interface components: General ledger interface components are defined. Note the components. General Ledger Charge Account Numbers: General ledger credit/debit charge account numbers, default charge account numbers and general ledger interface components are defined. Note the account codes/values. File Explorer: Local folders are created to place input/output CSV file. Note the paths of the folder. GL Facility Defaults: The following fields are populated with the valid paths of the input/output files for Dynamics GP. Note all the paths for later use. Output Path On Server For CSV File Dynamics GP Input Path On Server Dynamics GP Output Path On Server' GP Account File: A CSV file is created in the format account number, account description and account type that contains general ledger charge accounts in the system but not all. Please note - the account type is exactly the values of 'Charge' or 'Pmt/Adj'. Note the account numbers included in the file. The CSV file created is placed in the path defined as the 'Dynamics GP Input Path On Server' in the 'GL Facility Defaults'. Steps Open the 'Compile General Ledger Charge Interface File' form. Set the 'Bill Period' field to a desired bill period. (i.e. The format of the bill period is MM/YYYY). Set the 'General Ledger Posting Date' to desired date. Set the field 'Pre-Compile' to 'No'. Click [Process]. Verify the 'Compile General Ledger Charge Interface File' report launches successfully. Verify the report displays the GL strings for the charge account numbers with the specific information. Note the details displays on the report Close the report. Close the form. Locate to the local folders are created to place output CSV file. Verify the CSV file matching the details shown on the 'Compile General Ledger Charge Interface File' report screen is generated and placed in both the paths setup for 'Output Path On Server For CSV File' and 'Dynamics GP Output Path On Server' in the 'GL Facility Defaults'. Open the 'Compile General Ledger Charge Interface File' form. Set the 'Bill Period' field to a desired bill period. (i.e. The format of the bill period is MM/YYYY). Set the 'General Ledger Posting Date' to desired date. Set the field 'Pre-Compile' to 'Yes'. Click [Process]. Verify the 'Compile General Ledger Charge Interface File' report launches successfully. Verify a 'Pre-Compile' report displays 'Pre-Compile. Please see 'Print General Ledger Charge Interface File Detail'. Close the report. Close the form. Open the 'Print General Ledger Charge Interface File Detail' form. Enter the 'Bill Period' previously specified. Click [Dynamics GP Comparison]. Verify a report launches successfully and displays only the account numbers in the compile that are missing from the GP file. Close the report. Click [Process]. Verify the report displays all applicable charges within the billing period based on the data set up in the 'General Ledger Interface components' and 'General Ledger Charge Account Numbers'. Close the report. Close the form. Open the 'Crystal report' or any other SQL data viewer. Query the 'Select * from GL.compilechargeintdetail' table. Verify an existence of the 'counter' field. Verify the SQL view contains correct value in the 'counter' column. Verify the SQL view displays accounts and components as defined in the setup. Close the report. Compile General Ledger Charge Interface File - Pre-Compile Charge file Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following: Registry Settings (PM) User Definition GL Facility Defaults General Ledger Payment/Adjustment Account Numbers Print General Ledger Payment/Adjustment Interface File Detail Print General Ledger Charge Interface File Detail Dictionary Update (PM) Compile General Ledger Payment/Adjustment Interface File COMPILE GENERAL LEDGER CHARGE INTERFACE FILE Scenario 1: GL Integration - Dynamics GP - Registry Setting - Enable Dynamics GP Integration Steps Open the 'Registry Settings' form. Set the 'Limit Registry Settings' to the 'Enable Dynamics GP Integration'. Click [View Registry Settings]. Validate the 'Registry Setting' field contains 'Avatar GL->General Ledger Interface->->->->Enable Dynamics GP Integration'. Validate the 'Registry Setting Details' field contains '[FACILITY SPECIFIC] ------------------------------------------------------------------------------- Enter "Y" to enable Dynamics GP integration. This will add the fields 'Dynamics GP Input Path On Server' and 'Dynamics GP Output Path On Server' to the 'GL Facility Defaults' form. The output path will be used to send compiled files to Dynamics GP. The input path will be used to get Dynamics GP accounts for comparison with Avatar GL accounts through various forms. Enter "N" to disable Dynamics GP integration.'. Validate the 'Registry Setting Value' field is defaulted to 'N'. Click [Submit]. Click [OK]. Click [Yes]. Set the ‘Limit Registry Settings’ to the ‘Dynamics GP’. Click [View Registry Settings]. Set the ‘Registry Setting Value’ input box to ‘1’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’. Click [OK]. Set the ‘Registry Setting Value’ input box to ‘M’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘Yes’. Validate the message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘No’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘’. Validate that the validation message contains ‘The selected value is not valid in the current system code for the following reason: Invalid response -- must be ‘Y’ or ‘N’. OK’ Click [OK]. Set the Registry Setting Value text input box to ‘‘. Click [Submit]. Click [OK]. Click [Yes]. Set the ‘Limit Registry Settings’ to the ‘Dynamics GP’. Click [View Registry Settings]. Set the 'Registry Setting Value' input box to 'Y'. Click [Submit]. Click [OK]. Click [No]. Open the 'User Definition' form. Select desired user from the ‘Select User’ field. Click the ‘Forms and Tables’ item. Click [Select Forms for User Access]. Click ‘Avatar PM’ item. Verify that the 'General Ledger Interface' item exist. Verify that all the items are checked. Click [OK]. Click [Submit]. Click [No]. Open the ‘GL Facility Defaults’ form. Verify the ‘Output Path On Server For CSV File’ field exists. Verify the ‘Dynamics GP Input Path On Server’ field exists. Verify the ‘Dynamics GP Output Path On Server’ field exists. Click the light bulb icon of the ‘Dynamics GP Input Path On Server’ field and validate the help text contains ‘This path is used for Dynamics GP to add a file of accounts that can be pulled on demand by Avatar to compare with GL accounts.' Click the ‘Return To Form’ link. Click the light bulb icon of the ‘Dynamics GP Output Path On Server’ field and validate the help text contains ‘This path is used to output a CSV file of the Avatar GL compile for Dynamics GP to use.’. Click the ‘Return To Form’ link. Click [Discard]. Click [Yes]. Open the ‘General Ledger Charge Account Numbers’ form. Click the ‘Print G/L Charge Table’ item. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the ‘General Ledger Payment/Adjustment Account Numbers’ form. Click the ‘Print G/L Pay/Adj Table’ item. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] exists. Click [Discard]. Open the 'Registry Settings' form. Set the 'Limit Registry Settings' to the 'Enable Dynamics GP Integration'. Click [View Registry Settings]. Set the 'Registry Setting Value' input box to 'N'. Click [Submit]. Click [OK]. Click [No]. Open the ‘GL Facility Defaults’ form. Verify the ‘Dynamics GP Input Path On Server’ field does not exist. Verify the ‘Dynamics GP Output Path On Server’ field does not exist. Click [Discard]. Click [Yes]. Open the ‘General Ledger Charge Account Numbers’ form. Click the ‘Print G/L Charge Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘General Ledger Payment/Adjustment Account Numbers’ form. Click the ‘Print G/L Pay/Adj Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the 'Registry Settings' form. Set the 'Limit Registry Settings' to the 'Enable Dynamics GP Integration'. Click [View Registry Settings]. Set the 'Registry Setting Value' input box to ''. Click [Submit]. Click [OK]. Click [No]. Open the ‘GL Facility Defaults’ form. Verify the ‘Dynamics GP Input Path On Server’ field does not exist. Verify the ‘Dynamics GP Output Path On Server’ field does not exist. Click [Discard]. Click [Yes]. Open the ‘General Ledger Charge Account Numbers’ form. Click the ‘Print G/L Charge Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘General Ledger Payment/Adjustment Account Numbers’ form. Click the ‘Print G/L Pay/Adj Table’ item. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Open the ‘Print General Ledger Payment/Adjustment Interface File Detail’ form. Verify the [Dynamics GP Comparison] does not exist. Click [Discard]. Scenario 2: GL Integration - Dynamic GP - Compile General Ledger Payment/Adjustment Interface File and Print General Ledger Payment/Adjustment Interface Detail File* Specific Setup: System updated with Avatar GL module. Registry Settings: The 'Enable Dynamics GP Integration' is set to 'Y'. Dictionary Update: File: G/L Interface (202) - Credit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (203) - Debit G/L Payment Adjustment Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. General Ledger Interface components: General ledger interface components are defined. Note the components. General Ledger Payment/Adjustment Account Numbers: General ledger credit/debit payment/adjustment account numbers, default payment/adjustment account numbers and general ledger interface components are defined. Note the account codes/values. File Explorer: Local folders are created to place the input/output CSV files. Note the paths of the folder. GL Facility Defaults: The following fields are populated with the valid paths of the input/output files for Dynamics GP. Note all the paths for later use. Output Path On Server For CSV File Dynamics GP Input Path On Server Dynamics GP Output Path On Server' GP Account File: A CSV file is created in the format account number, account description and account type that contains general ledger payment/adjustment accounts in the system but not all. Please note - the account type is exactly the values of 'Charge' or 'Pmt/Adj'. Note the account numbers included in the file. The CSV file created is placed in the path defined as the 'Dynamics GP Input Path On Server' in the 'GL Facility Defaults'. Steps Open the 'Compile General Ledger Payment/Adjustment Interface File' form. Set the 'Bill Period' field to a desired bill period. (i.e. The format of the bill period is MM/YYYY). Set the 'General Ledger Posting Date' to desired date. Set the field 'Pre-Compile' to 'No'. Click [Process]. Verify the 'Compile General Ledger Payment/Adjustment Interface File' report launches successfully. Verify the report displays the GL strings for the Payment/Adjustment account numbers with the specific information. Note the details displays on the report. Close the report. Close the form. Locate to the local folders are created to place output CSV file. Verify the CSV file matching the details shown on the 'Compile General Ledger Payment/Adjustment Interface File' report screen is generated and placed in both the paths setup for 'Output Path On Server For CSV File' and 'Dynamics GP Output Path On Server' in the 'GL Facility Defaults'. Open the 'Compile General Ledger Payment/Adjustment Interface File' form. Set the 'Bill Period' field to a desired bill period. (i.e. The format of the bill period is MM/YYYY). Set the 'General Ledger Posting Date' to desired date. Set the field 'Pre-Compile' to 'Yes'. Click [Process]. Verify the 'Compile General Ledger Payment/Adjustment Interface File' report launches successfully. Verify a 'Pre-Compile' report displays 'Pre-Compile. Please see 'Print General Ledger Payment/Adjustment Interface File Detail'. Close the report. Close the form. Open the 'Print General Ledger Payment/Adjustment Interface File Detail' form. Enter the 'Bill Period' previously specified. Click [Dynamics GP Comparison]. Verify a report launches successfully and displays only the account numbers in the compile that are missing from the GP file. Close the report. Click [Process]. Verify the report displays all applicable Payment/Adjustments within the billing period based on the data set up in the 'General Ledger Interface components' and 'General Ledger Payment/Adjustment Account Numbers'. Close the report. Close the form. Open the 'Crystal report' or any other SQL data viewer. Query the 'Select * from GL.compilepayadjintdetail' table for the client identified in the setup section. Verify the accounts and components displays correctly as defined. Close the 'Crystal Report'. Scenario 3: GL Integration - Dynamic GP - Compile General Ledger Charge Interface File and Print General Ledger Charge Interface Detail File Specific Setup: System updated with Avatar GL module. Registry Settings: The 'Enable Dynamics GP Integration' is set to 'Y'. Dictionary Update: File: G/L Interface (200) - Credit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. (201) - Debit G/L Charge Account Number - Contains dictionary codes and dictionary values. Note the account numbers / values. General Ledger Interface components: General ledger interface components are defined. Note the components. General Ledger Charge Account Numbers: General ledger credit/debit charge account numbers, default charge account numbers and general ledger interface components are defined. Note the account codes/values. File Explorer: Local folders are created to place input/output CSV file. Note the paths of the folder. GL Facility Defaults: The following fields are populated with the valid paths of the input/output files for Dynamics GP. Note all the paths for later use. Output Path On Server For CSV File Dynamics GP Input Path On Server Dynamics GP Output Path On Server' GP Account File: A CSV file is created in the format account number, account description and account type that contains general ledger charge accounts in the system but not all. Please note - the account type is exactly the values of 'Charge' or 'Pmt/Adj'. Note the account numbers included in the file. The CSV file created is placed in the path defined as the 'Dynamics GP Input Path On Server' in the 'GL Facility Defaults'. Steps Open the 'Compile General Ledger Charge Interface File' form. Set the 'Bill Period' field to a desired bill period. (i.e. The format of the bill period is MM/YYYY). Set the 'General Ledger Posting Date' to desired date. Set the field 'Pre-Compile' to 'No'. Click [Process]. Verify the 'Compile General Ledger Charge Interface File' report launches successfully. Verify the report displays the GL strings for the charge account numbers with the specific information. Note the details displays on the report Close the report. Close the form. Locate to the local folders are created to place output CSV file. Verify the CSV file matching the details shown on the 'Compile General Ledger Charge Interface File' report screen is generated and placed in both the paths setup for 'Output Path On Server For CSV File' and 'Dynamics GP Output Path On Server' in the 'GL Facility Defaults'. Open the 'Compile General Ledger Charge Interface File' form. Set the 'Bill Period' field to a desired bill period. (i.e. The format of the bill period is MM/YYYY). Set the 'General Ledger Posting Date' to desired date. Set the field 'Pre-Compile' to 'Yes'. Click [Process]. Verify the 'Compile General Ledger Charge Interface File' report launches successfully. Verify a 'Pre-Compile' report displays 'Pre-Compile. Please see 'Print General Ledger Charge Interface File Detail'. Close the report. Close the form. Open the 'Print General Ledger Charge Interface File Detail' form. Enter the 'Bill Period' previously specified. Click [Dynamics GP Comparison]. Verify a report launches successfully and displays only the account numbers in the compile that are missing from the GP file. Close the report. Click [Process]. Verify the report displays all applicable charges within the billing period based on the data set up in the 'General Ledger Interface components' and 'General Ledger Charge Account Numbers'. Close the report. Close the form. Open the 'Crystal report' or any other SQL data viewer. Query the 'Select * from GL.compilechargeintdetail' table. Verify an existence of the 'counter' field. Verify the SQL view contains correct value in the 'counter' column. Verify the SQL view displays accounts and components as defined in the setup. Close the report.	Topics • Registry Settings • GL • Print General Ledger Charge Interface File Detail
2023 Update 5 Summary \| Details GL.compile_charge_int_detail - Field validation Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following: Admission (Outpatient) Dictionary Update (PM) Financial Eligibility Client Ledger Posting/Adjustment Codes Definition COMPILE GENERAL LEDGER CHARGE INTERFACE FILE General Ledger Payment/Adjustment Account Numbers Print General Ledger Charge Interface File Detail Individual Cash Posting (PM) Compile General Ledger Payment/Adjustment Interface File Print General Ledger Payment/Adjustment Interface File Detail Scenario 1: Compile General Ledger Charge Interface File - Validating 'GL.compile_charge_int_detail' SQL table Specific Setup: System updated with Avatar GL module. 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. General Ledger Interface components are defined. Note the components. General Ledger Charge Account Numbers and default charge account numbers are defined. Note the account codes/values. Admission: An outpatient client is admitted, or an existing outpatient client is identified. Please note the client must be admitted in the outpatient program which is set up in the 'General Ledger Payment Adjustment Account Numbers' form. Note the admission date/program. Guarantor/Payors: An existing guarantor is identified. Note the guarantor's code/name. Financial Eligibility: Assign the guarantor to the client. Recurring Client Charge Input: 5-6 services are rendered to the client. Client Ledger: Make sure services are distributed to the guarantor assigned to the client. Individual Cash Posting: Post payments, adjustments and/ or transfers for 2-3 services. Note the posting date. Close Charges: Close the charges. Steps Open the 'Compile General Ledger Charge Interface File' form. Fill out all the required fields and make sure to set the field 'Pre-Compile' to 'Yes' Click [Process]. Verify a 'Pre-Compile' report displays the 'Print General Ledger Charge Interface Detail' message to view the details of the report. Open the 'Print General Ledger Charge Interface Detail' form. Enter the 'Bill Period' previously specified. Click [Process]. Verify the report displays all applicable charges within the billing period based on the data set up in the 'General Ledger Interface components', 'General Ledger Charge Account Numbers' and 'Default charge account numbers'. Open the 'Crystal report' or any other SQL data viewer. Query the 'SELECT * FROM GL.compilne_charge_int_detail' table for the client identified in the setup section. Verify an existence of the 'counter' field. Verify the SQL view contains correct value in the 'counter' column. Verify the SQL view displays accounts and components as defined in the setup. Close the report. Scenario 2: Compile General Ledger Payment/Adjustment Interface File detail - Validating 'GL.compile_payadj_int_detail' SQL table Specific Setup: System updated with Avatar GL module. Dictionary Update: File: G/L Interface (200) - Credit G/L Charge Account Numbers - Contains dictionary codes and dictionary values. Note the values. (201) - Debit G/L Charge Account Numbers - Contains dictionary codes and dictionary values. Note the values. (202) - Credit G/L Payment Adjustment Account Numbers - Contains dictionary codes and dictionary values. Note the values. (203) - Debit G/L Payment Adjustment Account Numbers - Contains dictionary codes and dictionary values. Note the values. Admission: An outpatient client is admitted, or an existing outpatient client is identified. Please note the client must be admitted in the outpatient program which is set up in the 'General Ledger Payment Adjustment Account Numbers' form. Note the admission date/program. Guarantor/Payors: An existing guarantor is identified. Note the guarantor's code/name. Financial Eligibility: Assign the guarantor to the client. Recurring Client Charge Input: 5-6 services are rendered to the client. Client Ledger: Make sure services are distributed to the guarantor assigned to the client. Individual Cash Posting: Post payments, adjustments and/ or transfers for 2-3 services. Note the posting date. Close Charges: Close the charges. Steps Open the 'General Ledger Interface Components' form. Select desired number of components for 'Number of Treatment String Items To Be Included Within General Ledger Interface Components' field. Select desired components. Note the selected components. Submit the form. Open the 'General Ledger Charge Account Numbers' form. Select component value for each of the components. Note the values. Select desired account from the 'Credit General Ledger Charge Account Number' field. Select desired account from the 'Debit General Ledger Charge Account Number' field. Click [File General Ledger Charge Account Numbers]. Go to 'G/L Defaults for Charges' section. Select desired account from the 'Default Credit General Ledger Charge Account Number' dropdown list. Select desired account from the 'Default Debit General Ledger Charge Account Number' dropdown list. Click [File Default General Ledger Charge Account Numbers]. Close the form. Open the 'General Ledger Payment/Adjustment Account Numbers' form. Select the component value for each of the components. Select desired account from the 'Credit General Ledger Pay/Adj Account Number' field. Select desired account from the 'Debit General Ledger Pay/Adj Account Number' field. 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]. Close the form. Open the 'Compile General Ledger Payment/Adjustment Interface File' form. Enter the billing period, GL posting date. Select 'No' for Pre-Compile. Print General Ledger Payment/Adjustment Interface File detail: Choose the same billing period from compile and process the results. Open the 'Crystal report' or any other SQL data viewer. Query the 'Select * from GL.compile_payadj_int_detail' table for the client identified in the setup section. Verify the accounts and components displays correctly as defined.	Topics • Claims Processing • GL • Print General Ledger Payment/Adjustment Interface
Update 5 Summary \| Details General Ledger Charge Interface File - Pre-Compile Note - These testing guidelines assume the user is skilled in the use of, at a minimum, the following: Dictionary Update (PM) Admission (Outpatient) Financial Eligibility Client Ledger Posting/Adjustment Codes Definition Individual Cash Posting (PM) COMPILE GENERAL LEDGER CHARGE INTERFACE FILE Print General Ledger Charge Interface File Detail General Ledger Payment/Adjustment Account Numbers Compile General Ledger Payment/Adjustment Interface File Print General Ledger Payment/Adjustment Interface File Detail Scenario 1: Compile General Ledger Charge Interface File - Validating 'GL.compile_charge_int_detail' SQL table Specific Setup: System updated with Avatar GL module. 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. General Ledger Interface components are defined. Note the components. General Ledger Charge Account Numbers and default charge account numbers are defined. Note the account codes/values. Admission: An outpatient client is admitted, or an existing outpatient client is identified. Please note the client must be admitted in the outpatient program which is set up in the 'General Ledger Payment Adjustment Account Numbers' form. Note the admission date/program. Guarantor/Payors: An existing guarantor is identified. Note the guarantor's code/name. Financial Eligibility: Assign the guarantor to the client. Recurring Client Charge Input: 5-6 services are rendered to the client. Client Ledger: Make sure services are distributed to the guarantor assigned to the client. Individual Cash Posting: Post payments, adjustments and/ or transfers for 2-3 services. Note the posting date. Close Charges: Close the charges. Steps Open the 'Compile General Ledger Charge Interface File' form. Fill out all the required fields and set the field 'Pre-Compile' to 'Yes'. Click [Process]. Verify the report contains a message to navigate to the 'Print General Ledger Payment/Adjustment Interface File detail' to view the details of the report. Close the report. Verify the field 'Pre-Compile' is set to 'Yes'. Click [Process]. Verify the reports processed successfully. Verify the report contains a message to navigate to the 'Print General Ledger Payment/Adjustment Interface File detail' to view the details of the report. Close the report. Set the field 'Pre-Compile' to 'No'. Click [Process]. Verify the GL strings for the charge account numbers are generated. Close the report. Close the form. Open the 'Print General Ledger Charge Interface Detail' form. Enter the 'Bill Period' previously specified. Click [Process]. Verify the report displays all applicable charges within the billing period based on the data set up in the 'General Ledger Interface components', 'General Ledger Charge Account Numbers' and 'Default charge account numbers'. Open the 'Crystal report' or any other SQL data viewer. Query the 'SELECT * FROM GL.compile_charge_int_detail' table for the client identified in the setup section. Verify an existence of the 'counter' field. Verify the SQL view contains correct value in the 'counter' column. Verify the SQL view displays accounts and components as defined in the setup. Close the report. Scenario 2: Compile General Ledger Payment/Adjustment Interface File detail - Validating 'GL.compile_payadj_int_detail' SQL table Specific Setup: Registry setting 'Enable Payment Acknowledgement' is set to 'No'. System updated with Avatar GL module. Dictionary Update: File: G/L Interface (202) - Credit G/L Payment Adjustment Account Numbers - Contains dictionary codes and dictionary values. Note the values. (203) - Debit G/L Payment Adjustment Account Numbers - Contains dictionary codes and dictionary values. Note the values. Admission: An outpatient client is admitted, or an existing outpatient client is identified. Please note the client must be admitted in the outpatient program which is set up in the 'General Ledger Payment Adjustment Account Numbers' form. Note the admission date/program. Guarantor/Payors: An existing guarantor is identified. Note the guarantor's code/name. Financial Eligibility: Assign the guarantor to the client. Recurring Client Charge Input: 5-6 services are rendered to the client. Client Ledger: Make sure services are distributed to the guarantor assigned to the client. Individual Cash Posting: Post payments, adjustments and/ or transfers for 2-3 services. Note the posting date. Close Charges: Close the charges. Steps Open the 'General Ledger Interface Components' form. Select desired number of components for 'Number of Treatment String Items To Be Included Within General Ledger Interface Components' field. Select desired components. Note the selected components. Submit the form. Open the 'General Ledger Payment/Adjustment Account Numbers' form. Select the component value for each of the components. Select desired account from the 'Credit General Ledger Pay/Adj Account Number' field. Select desired account from the 'Debit General Ledger Pay/Adj Account Number' field. 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]. Close the form. Open the 'Compile General Ledger Payment/Adjustment Interface File' form. Enter the billing period and GL posting date. Select 'No' for Pre-Compile. Click [Process]. Verify the GL strings for the Payments/Adjustments account numbers are generated. Return to the form. Select 'Yes' for Pre-Compile. Click [Process]. Verify the report contains a message to go to the 'Print General Ledger Payment/Adjustment Interface File detail'. Repeat Step # 31 through 33 again and verify the same results. Close the form. Open the 'Print General Ledger Payment/Adjustment Interface File detail' form. Choose the same billing period from compile and process the results. Verify the report displays all applicable payments/adjustments records within the billing period based on the data set up in the 'General Ledger Interface components', 'General Ledger Payments/Adjustments Account Numbers' and 'Default charge account numbers'. Open the 'Crystal report' or any other SQL data viewer. Query the 'Select * from GL.compile_payadj_int_detail' table for the client identified in the setup section. Verify the accounts and components displays correctly as defined. Close the 'Crystal Report'.	Topics • Claims Processing • GL • Print General Ledger Payment/Adjustment Interface

Avatar_GL_2024_Quarterly_Release_2024.02_Details.csv