Page Comparison

...

The GLA Import uses the full GLA Account string to match against any existing GLAs. If no match is found, the record from the Import File will INSERT. If a match is found, the other fields of the Import can UPDATE.

Fields

Format

Datatype is String

Formats can not be more than 14 characters in length

The default GLA will be what any picker or grid should default to if a GLA is not explicitly selected

GLA Account

Required

Datatype is String.

...

Multiple levels of a hierarchy "path" (like Locations, GLAs, and Catalogs) are connected by the HIERARCHYPATH_SEPARATOR string. The default value for this string is right angle-brace (>) with a space on either side: " > "

...

A combination of all the GLA Component Descriptions in a single string with individual Descriptions separated the value stored in GLA_CONCATENATOR.

Multiple levels of a hierarchy "path" (like Locations, GLAs, and Catalogs) are connected by the HIERARCHYPATH_SEPARATOR string. The default value for this string is right angle-brace (>) with a space on either side: " > "

...

if ([12])[GLA_ADDRESSES.ADDRESS_TYPE] = [12];

AR Type

Datatype is String

Must be one of the AR_TYPE List Type valuesValues. Common values are Employee, International Student, County Extension as well as others.

Requires the 'Accounts Receivable' license, otherwise that line in the import file will fail. For more information see the AR Wiki page.

AR Status

Datatype is String

Must be one of the AR_STATUS List Type valuesValues. Common values are Pre-paid, Payment Plan, Hold on Account as well as others.

Requires the 'Accounts Receivable' license, otherwise that line in the import file will fail. For more information see the AR Wiki page.

Service Fee Percent

Datatype is String

Requires the 'Accounts Receivable' license, otherwise that line in the import file will fail. For more information see the AR Wiki page.

Child Records

GLA Charges are a Child record of GLA Charges. They are handled on a separate Import File.

...

• Error : GLA Format '<format>' is not valid
• Error : Failed to save GLA record; <errorMessage>
• Error : Not Accounts Receivable
• Error : Value not present in LISTS table for AR_TYPE, value("<AR_TYPE>")
• Error : Value not present in LISTS table for AR_STATUS, value("<AR_STATUS>")
  
• Error : Service Fee Percent must be numeric
• Error : Service Fee Percent must be greater than zero

These errors do not indicate the record failed to Save, but generate warnings. The Child data associated with the warnings do not save:

...