Avatar GL 2024 Monthly Release 2024.01.01 Summary

The registry setting 'Enabled Dynamics GP Integration' is added.

Value Added: The registry setting 'Enable Dynamics GP Integration' is added to allow users to send compiles to Dynamics GP and to receive accounts from the Dynamics GP to compare with the accounts in Avatar GL.

The fields 'Dynamics GP Input Path On Server' and the 'Dynamics GP Output Path On Server' are added to the 'GL Facility Defaults' form when the registry setting ‘Enable Dynamics GP Integration' is set to 'Y'.

Value Added: The configuration fields are added in the 'GL Facility Defaults' to set up the integration between Avatar GL and Dynamics GP (Great Plains) to compare general ledger charge and payment/adjustment account numbers.

The 'Dynamics GP Comparison' option is added in the 'Print General Ledger Charge Interface File Detail' form and in the 'Print General Ledger Payment/Adjustment Interface File Detail' form to compare the data to 'Dynamics GP' when the Pre-Compile is set to 'Yes'.

Value Added: This new API call reads in data from the GP file and compares them with Avatar GL codes.

The 'Table Import For General Ledger Account Numbers' form is updated to support Avatar GL integration to the 'Dynamics GP'.

Value Added: System is updated to launch a report that shows missing charge and payment/adjustment account numbers in Avatar GL that are not found in the CSV file on the input path of the server.

The command button 'Dynamics GP Comparison' is added to the 'General Ledger Charge Account Numbers' and 'General Ledger Payment/ Adjustment Account Numbers' forms.

Value Added: The 'General Ledger Charge Account Numbers' and 'General Ledger Payment/Adjustment Account Numbers' forms are enhanced to support the Avatar GL integration to Dynamics GP.

The system generates and places a CSV file in the local output paths defined for the 'Dynamics GP' in the 'GL Facility Defaults' form.

Value Added: The 'Compile General Ledger Payment/Adjustment Interface File' is enhanced to support comparison of the information in the compile to the Dynamics GP via CSV file when (Pre-Compile = No).

The 'Dynamics GP Comparison' option is added in the 'Print General Ledger Payment/Adjustment Interface File Detail' form to compare the payment/adjustment file compiled from the 'Compile General Ledger Payment/Adjustment Interface File' form to 'Dynamics GP'

Value Added: The report displays the account number from the compile that are missing in Dynamics, or that is inactive in 'Dynamics GP'. This will give the users a chance to update Dynamics GP with the account numbers.

The system generates and places a CSV file in the local output paths defined for the Dynamics GP in the 'GL Facility Defaults' form.

Value Added: The 'Compile General Ledger Charge Interface File' is updated to support comparison of the GL accounts included in the compile to the Dynamics GP via CSV file.

The 'Dynamics GP Comparison' option is added in the 'Print General Ledger Charge Interface File Detail' form to compare the charge file pre-compiled from the 'Compile General Ledger Charge Interface File' form to 'Dynamics GP'.

Value Added: The report displays the account number from the compile that are missing in Dynamics, or that is inactive in 'Dynamics GP'. This will give the users a chance to update 'Dynamics GP' with the account numbers.