{"type":"doc","content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{"outline":{"value":"true"},"style":{"value":"none"}},"macroMetadata":{"macroId":{"value":"e66c62ed-b513-4d29-a521-58f76aceb434"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"9874a94b-4d81-48e9-bd2d-c5bca9f686fb"}},{"type":"heading","attrs":{"level":2},"content":[{"text":"Capability","type":"text"}]},{"type":"paragraph","content":[{"text":"This Import allows the User to INSERT new records or UPDATE existing GLAs into the ","type":"text"},{"text":"GLA Catalog","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/pcr360wiki/pages/17243485"}}]},{"text":" grid.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Matches ON","type":"text"}]},{"type":"paragraph","content":[{"text":"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.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Fields","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Format","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is String","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Formats can not be more than 14 characters in length","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"The default GLA will be what any picker or grid should default to if a GLA is not explicitly selected","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Format Defaults to the value of the Configuration Option: ","type":"text"},{"text":"GLA_FORMAT_DEFAULT","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/pcr360wiki/pages/17245460"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Must be a valid GLA Format from the Configuration Option: ","type":"text"},{"text":"GLA_FORMATS","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/pcr360wiki/pages/17245460"}}]},{"text":".","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"GLA Account","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Required ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"strong"}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is ","type":"text"},{"text":"Hierarchical String","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/wpEQAQ"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"CANNOT","type":"text","marks":[{"type":"strong"}]},{"text":" be Updated.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"A combination of all the GLA Components in a single string with individual Components separated by the value stored in ","type":"text"},{"text":"GLA_CONCATENATOR","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/pcr360wiki/pages/17245460"}}]},{"text":".","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"GLA Description","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is ","type":"text"},{"text":"Hierarchical String","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/wpEQAQ"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"A combination of all the GLA Component Descriptions in a single string with individual Descriptions separated the value stored in ","type":"text"},{"text":"GLA_CONCATENATOR","type":"text","marks":[{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/OYUQAQ"}}]},{"text":".","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Speed Code","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is String.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Speed Codes ","type":"text"},{"text":"cannot","type":"text","marks":[{"type":"strong"}]},{"text":" be duplicated.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Any attempt to duplicate a Speed Code will result in an ","type":"text"},{"text":"error","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Description","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is String.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Revenue","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is ","type":"text"},{"text":"Boolean","type":"text","marks":[{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/0JEQAQ"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Defaults to True [1].","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Permitted Values are 1, True, or Yes set the Flag to True.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"All other values enter as False [0].","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"A GLA must be Revenue, Expense, or Both. If you set both flags to False, you will get an error.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If you don't set the Revenue or Expense flag when creating a new GLA, then the Expense flag will get set.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"After a GLA is created, you can update the Revenue and Expense flags to True, but you cannot update them to False. If you try to update either of these flags to False, you will get an error.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Expense","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is ","type":"text"},{"text":"Boolean","type":"text","marks":[{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/0JEQAQ"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Defaults to True [1].","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Permitted Values are 1, True, or Yes set the Flag to True.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"All other values enter as False [0].","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"type":"hardBreak"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"A GLA must be Revenue, Expense, or Both. If you set both flags to False, you will get an error.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If you don't set the Revenue or Expense flag when creating a new GLA, then the Expense flag will get set.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"After a GLA is created, you can update the Revenue and Expense flags to True, but you cannot update them to False. If you try to update either of these flags to False, you will get an error.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Bill","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is ","type":"text"},{"text":"Boolean","type":"text","marks":[{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/0JEQAQ"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Defaults to False [0].","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Permitted Values are 1, True, or Yes set the Flag to True.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"All other values enter as False [0].","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Ledger","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is ","type":"text"},{"text":"Boolean","type":"text","marks":[{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/0JEQAQ"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Defaults to False [0].","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Permitted Values are 1, True, or Yes set the Flag to True.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"All other values enter as False [0].","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Taxable","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is ","type":"text"},{"text":"Boolean","type":"text","marks":[{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/0JEQAQ"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Defaults to False [0].","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Permitted Values are 1, True, or Yes set the Flag to True.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"All other values enter as False [0].","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Customer Number","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is String.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"This field will let you add a Contact to the GLA. This import will always append Contacts to the GLA. It will never remove or replace a Contact.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If a Customer Number is provided, it must exist already for it to be added to the GLA.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If it does not exist, it causes a warning.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Contact Primary","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is ","type":"text"},{"text":"Boolean","type":"text","marks":[{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/0JEQAQ"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Defaults to True [1].","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Only used if Customer Number is provided.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Permitted Values are 1, True, or Yes set the Flag to True.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"All other values enters as False [0].","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Status","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is ","type":"text"},{"text":"Boolean","type":"text","marks":[{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/0JEQAQ"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Defaults to Active [1].","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Permitted Values are 1, True, Yes, or Active set the Status to Active.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"All other values enter as Inactive [0].","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Street Address","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is String.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If any of the Address fields are filled, they all become ","type":"text"},{"text":"Required","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"em"}]},{"text":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}}]},{"text":"except for the Address2 field.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Address2","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is String.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"City","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is String.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"State","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is String.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"States/Provinces use standard 2 Letter Abbreviations for US/Canada and 3 Letter Abbreviations for Mexico.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Zip Code","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is String.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Country","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Default value: \"","type":"text"},{"text":"United States","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"\"","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is String.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"By default, the allowed values are United States, Canada, Mexico, or Other International.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"You can add additional values in the ","type":"text"},{"text":"(2024.1) List Values","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/pcr360wiki/pages/17242851"}}]},{"text":" table using Type ADDRESS_COUNTRIES.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Address Type","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is String.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Blank values are ","type":"text"},{"text":"NOT","type":"text","marks":[{"type":"strong"}]},{"text":" allowed.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Permitted values are from the ADDRESS_TYPE ","type":"text"},{"text":"(2024.1) List Values","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/pcr360wiki/pages/17242851"}}]},{"text":": Billing, Warehouse, or Office.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Any values added by a User to the ADDRESS_TYPE List can also be used.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Values not in the List are not added.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Do not use Column Mapping if there are possible blank values for Address Type use Conditional assignment instead.","type":"text","marks":[{"type":"em"}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"type":"hardBreak"}]},{"type":"codeBlock","attrs":{"language":"java"},"content":[{"text":"if ([12])[GLA_ADDRESSES.ADDRESS_TYPE] = [12];","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"AR Type","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is String","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Must be one of the AR_TYPE ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}}]},{"text":"List Type Values","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}},{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/wIQQAQ"}}]},{"text":". Common values are Employee, International Student, County Extension as well as others.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Requires the 'Accounts Receivable' license, otherwise that line in the import file will ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}},{"type":"em"}]},{"text":"fail","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"em"}]},{"text":". For more information see the ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}},{"type":"em"}]},{"text":"AR Wiki page","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}},{"type":"em"},{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/KIQQAQ"}}]},{"text":".","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}},{"type":"em"}]},{"type":"hardBreak"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"AR Status","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is String","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Must be one of the AR_STATUS ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}}]},{"text":"List Type Values","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}},{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/wIQQAQ"}}]},{"text":". Common values are Pre-paid, Payment Plan, Hold on Account as well as others.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Requires the 'Accounts Receivable' license, otherwise that line in the import file will ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}},{"type":"em"}]},{"text":"fail","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"em"}]},{"text":". For more information see the ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}},{"type":"em"}]},{"text":"AR Wiki page","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}},{"type":"em"},{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/KIQQAQ"}}]},{"text":".","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}},{"type":"em"}]},{"type":"hardBreak"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Service Fee Percent","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is String","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Requires the 'Accounts Receivable' license, otherwise that line in the import file will ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}},{"type":"em"}]},{"text":"fail","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"em"}]},{"text":". For more information see the ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}},{"type":"em"}]},{"text":"AR Wiki page","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}},{"type":"em"},{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/x/KIQQAQ"}}]},{"text":".","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}},{"type":"em"}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Child Records","type":"text"}]},{"type":"paragraph","content":[{"text":"GLA Charges are a Child record of ","type":"text"},{"text":"GLA Charges","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/spaces/pcr360wiki/pages/17243500"}}]},{"text":". They are handled on a separate Import File.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Flags / Conditional Logic","type":"text"}]},{"type":"paragraph","content":[{"text":"APPEND_ADDRESS","type":"text","marks":[{"type":"strong"}]},{"text":":","type":"text"},{"type":"hardBreak"},{"text":"Default Value = True. If the APPEND_ADDRESS flag is False AND if there are any other Addresses on this GLA that have the same Address type, remove them. If this Address is not already on this GLA with the same Address type, add it. APPEND_ADDRESS, as described above, allows an Address of the same type to be appended to the Address list.","type":"text"}]},{"type":"paragraph","content":[{"text":"GLA_ALLOW_UPDATE","type":"text","marks":[{"type":"strong"}]},{"text":":","type":"text"},{"type":"hardBreak"},{"text":"Defaults Value = True. If this is set to false, the Import ignores any GLA records in the input that already exist.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Errors","type":"text"}]},{"type":"paragraph","content":[{"text":"When an Import Line fails, it is usually because the Line falls into one of the following categories:","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The value provided from another table was not found within the Database","type":"text"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toggle-cloak","parameters":{"macroParams":{"__bodyContent":{"value":""}},"macroMetadata":{"macroId":{"value":"d6db053b-4cb2-46f2-84f0-041ed12383ea"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://compositiontabs.bobswift.appfire.app/assets/img/composition80x80.png"}}],"title":"(Legacy) Toggle Cloak"}}}}],"version":1}}}}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

Warning : Could not find the Contact for <CUSTOMER_NUMBER>

Warning : Invalid blank Street Address
Warning : Invalid blank City
Warning : Invalid blank State
Warning : Invalid blank Zip Code
Warning : Invalid state <state> in address
Error : Service Fee Percent must be numeric
Error : Service Fee Percent must be greater than zero
Error : Not Accounts Receivable
Error : GLA Format '<format>' is not valid
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>")

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"cloak","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"b1ba810f-afec-4cae-b67a-82fb8f809f36"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://compositiontabs.bobswift.appfire.app/assets/img/composition80x80.png"}}],"title":"(Legacy) Cloak"}}},"content":[{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Warning : Invalid blank Street Address","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Warning : Invalid blank City","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Warning : Invalid blank State","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Warning : Invalid blank Zip Code","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Warning : Invalid state in address","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Service Fee Percent must be numeric","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Service Fee Percent must be greater than zero","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : ","type":"text"},{"text":"Not Accounts Receivable","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : GLA Format '' is not valid","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Value not present in LISTS table for AR_TYPE, value(\"\")","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}}]},{"text":"Value not present in LISTS table for AR_STATUS, value(\"\")","type":"text","marks":[{"type":"textColor","attrs":{"color":"#1a1a1a"}}]}]}]}]}]}],"version":1}}}}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The System was unable to save the record","type":"text"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"extension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toggle-cloak","parameters":{"macroParams":{"__bodyContent":{"value":""}},"macroMetadata":{"macroId":{"value":"9ff065c2-f7d5-41ab-8b17-2699b4f0d2b9"},"schemaVersion":{"value":"1"},"placeholder":[{"type":"icon","data":{"url":"https://compositiontabs.bobswift.appfire.app/assets/img/composition80x80.png"}}],"title":"(Legacy) Toggle Cloak"}}}}],"version":1}}}}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

Warning : Failed to save Address record <errorMessage>
Warning : Failed to Add GLA Address record; <errorMessage>
Error : Failed to save GLA record; <errorMessage>

If you experience any of these Errors, without another accompanying Message about what might have caused the Save Failure, please submit a Ticket to PCR.

Browser not supported