The GL line allows for any Analysis (An) Type to be used regardless of the account used on the line.
Currently we are executing sql statements to update past lines that have the wrong Analysis (An) Type for the account that is used. Below is how the ANALYSIS_TYPE is to be selected:
ACCOUNT starts with ‘1' and the ACCOUNT_TYPE is ‘A’ for Assets = ANALYSIS_TYPE = 'GLA'
ACCOUNT starts with ‘2' and the ACCOUNT_TYPE is ‘L’ for Liabilities = ANALYSIS_TYPE = 'GLL'
ACCOUNT starts with ‘3' and the ACCOUNT_TYPE is ‘Q’ for Equity = ANALYSIS_TYPE = 'GLF'
ACCOUNT starts with ‘5' and the ACCOUNT_TYPE is ‘E’ for Expenditures = ANALYSIS_TYPE = 'GLE'
ACCOUNT starts with ‘7' and the ACCOUNT_TYPE is