{"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":"df56a16a-a2d6-43cd-8c2a-a18d0152b99e"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"9b13f650-ed7b-46a1-92d7-ebfb5e51f05c"}},{"type":"heading","attrs":{"level":2},"content":[{"text":"Capability","type":"text"}]},{"type":"paragraph","content":[{"text":"This Import will allow the User to add or update Charges on GLAs for Billing. ","type":"text"},{"text":"In order to add a Charge to a GLA, the ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"'Bill'","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"strong"}]},{"text":" flag of the ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"GLA Catalog","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}},{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/spaces/pcr360wiki/pages/499158126"}}]},{"text":" must already be set.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"paragraph","content":[{"text":"By default this import will always Add new charges, not Update existing charges. Care should be taken, as this can create duplicate charges.","type":"text"}]},{"type":"paragraph","content":[{"text":"There is an optional UPDATE Flag that can be set to force the import to do Updates instead of Adds.","type":"text"}]},{"type":"paragraph","content":[{"text":"The import cannot delete existing charges, but it can set an existing MRC charge Stop Date to end the charge.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Matches On","type":"text"}]},{"type":"paragraph","content":[{"text":"For adds and updates, the import will need the '","type":"text"},{"text":"GLA Full Codes","type":"text","marks":[{"type":"strong"}]},{"text":"' to find the GLA record to apply the charge to.","type":"text"}]},{"type":"paragraph","content":[{"text":"For updates, the import needs to find the charges to update.","type":"text"}]},{"type":"paragraph","content":[{"text":"At minimum, you must provide the GLA, Charge Catalog and Charge Type. You can also optionally provide the Start Date, Override Amount, and Quantity. ","type":"text"}]},{"type":"paragraph","content":[{"text":"If the values you provide match more than one charge, then all of those that match will be updated.","type":"text"}]},{"type":"paragraph","content":[{"text":"Alternatively, you can provide the GLA Charge RECID, and this will override all other key values to find the exact GLA Charge to update.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Fields","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"GLA Full Codes","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":"heading","attrs":{"level":4},"content":[{"text":"Charge Catalog Name","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Conditionally Required","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"em"}]},{"text":" (unless Charge Catalog Full Name is provided instead)","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":"The default value is 'blank'.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"The Charge Catalog Name expects just the name, and will only work if the name is unique in the whole catalog.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"The GLA_CHARGE_TYPE flag can also be used to help define which catalog you are trying to use.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"NOTE:","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"},{"text":"Instead of mapping the Catalog Name or the Catalog Full Name, the Catalog can be set in the Import Record Format.","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"If the Import Record Format has a value and it is also mapped, the mapped value takes precedence.","type":"text","marks":[{"type":"em"}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Charge Catalog Full Name","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Conditionally Required","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"em"}]},{"text":" (unless Charge Catalog Name is provided instead)","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":"The default value is 'blank'.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"This is the full hierarchical path of the Charge Catalog.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"This should be used if the Catalog Name is not unique.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"The GLA_CHARGE_TYPE flag can also be used to help define which catalog you are trying to use.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":2}}],"content":[{"text":"NOTE:","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"},{"text":"Instead of mapping the Catalog Name or the Catalog Full Name, the Catalog can be set in the Import Record Format.","type":"text","marks":[{"type":"em"}]},{"type":"hardBreak"},{"text":"If the Import Record Format has a value and it is also mapped, the mapped value takes precedence.","type":"text","marks":[{"type":"em"}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Owner Contact Customer Number","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is String.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Owner Contact First Name","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":"Passes in the First Name of Contact Owners.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Owner Contact Last Name","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":"Passes in the Last Name of Contact Owners.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Owner Dept. Hierarchy","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":"Import matched the Department Hierarchy Code, not the Name.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"For a multi-level Department Hierarchy the Full Path of the Hierarchy ","type":"text"},{"text":"MUST","type":"text","marks":[{"type":"strong"}]},{"text":" be used.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"For example, if the Department, XYZ, is a child to Department, Billing, the Owner Department Hierarchy field should be Billing, XYZ.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Bill Date","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is Date.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"The default value is today's date.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"The Bill Date can come from a mapping or from the import file selection form.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Mapping takes precedence.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"This becomes the Transaction date for NRCs and the Start Date for MRCs. For ARCs (Alternate Recurring Charges), the Bill Date will get copied to both the Start Date and Recurring Date.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"The Bill Date import field is now Deprecated. It will still work, but the following new three date fields should be used instead.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Transaction Date","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":"The default is Today's Date.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"This is the Transaction Date for NRCs. Filling this field for MRCs or ARCs will cause an error.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"This field is currently ignored by Update attempts. If Charges are desired to be Updated in Bulk via an Import, the User must delete the original files from PCR-360 that created the Imported Charges then re-upload the corrected File back into PCR-360.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Start Date","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":"The default is Today's Date.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"This is the Start Date for MRCs and ARCs. Filling this field for NRCs will cause an error.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"This field is currently ignored by Update attempts. If Charges are desired to be Updated in Bulk via an Import, the User must delete the original files from PCR-360 that created the Imported Charges then re-upload the corrected File back into PCR-360.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Recurring Date","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":"The default is Today's Date.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"This is the Recurring Date for ARCs. Filling this field for NRCs or MRCs will cause an error.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"This field is currently ignored by Update attempts. If Charges are desired to be Updated in Bulk via an Import, the User must delete the original files from PCR-360 that created the Imported Charges then re-upload the corrected File back into PCR-360.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Billing Group","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 is an override to the charge Owner's Billing Group.","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":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"This overrides the Charge Catalog Description.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Override Amount","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is ","type":"text"},{"text":"Number","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"This is only allowed if the Charge Catalog entry allows overrides.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Prorate","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":"Default Value is False.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Quantity","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Datatype is ","type":"text"},{"text":"Number","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":".","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Stop Date","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type is Date.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Default value is 'blank'.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Used for MRCs only and is ignored for NRCs.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"New Override Amount","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type is ","type":"text"},{"text":"Number","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"This is only allowed if the Charge Catalog entry allows overrides.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If you map the New Override Amount and provide a blank value, then any existing Override Amount on the charge will be removed.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Used for UPDATE only.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"New Quantity","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type is ","type":"text"},{"text":"Number","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Used for UPDATE only.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"RECID","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type is ","type":"text"},{"text":"Number","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":".","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Used as a lookup for Charge updates.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Billing Group Override","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type is String.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Default value is 'blank'.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"The value must match an existing Billing Group.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"This is an override. It should only be provided if an override of the Billing Group is desired from the Department Hierarchy or Contact Owner.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Child Records","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"GLA","type":"text"}]},{"type":"paragraph","content":[{"text":"GLA Charges are a Child record of ","type":"text"},{"text":"GLA Imports","type":"text","marks":[{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/spaces/pcr360wiki/pages/498207637"}}]},{"text":". As such, they can only be added to an existing GLA.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Flags / Conditional Logic","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"GLA_CHARGE_TYPE:","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Default value is 'blank'.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"This flag is only needed if there are multiple Charges with the same Names that have different types.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If this is set, it must be set to the code of one of the CHARGE_TYPE List Values from the ","type":"text"},{"text":"List Values","type":"text","marks":[{"type":"link","attrs":{"href":"https://pcr360.atlassian.net/wiki/display/PCR360/.List+Values+v2018.1"}}]},{"text":" grid.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"The only allowed values are the System Use Values: MONTHLY_RECURRING, NONRECURRING, QUARTERLY, SEMI_ANNUAL, and ANNUAL_RECURRING.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"UPDATE:","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":"Default value is \"false.\"","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"If set, this import will UPDATE existing records. If the import cannot find an existing record to UPDATE, it will error.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"This can be used to set Stop Dates on MRCs, change Override Amounts, Quantity, Description, GLA, or Prorate flag.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"EFFECTIVE_DATE:","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Data type is String.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Default Value is TODAY","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Allowed values are BACKDATE and TODAY.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"This flag is used to determine the date that an updated charge will stop and restart.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"Alternate Recurring Charges (Quarterly, Semi-Annual, and Annual), when updated, will always use BACKDATE as the Effective Date.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"This flag is only used when updating existing charges. If the import is adding a new charge, then this flag is ignored.","type":"text"}]},{"type":"paragraph","marks":[{"type":"indentation","attrs":{"level":1}}],"content":[{"text":"See the ","type":"text"},{"text":"Notes ","type":"text","marks":[{"type":"link","attrs":{"href":"/wiki/pages/resumedraft.action?draftId=17861998#GLAChargesImports-Notes"}}]},{"text":"for more details.","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 or had multiple matches 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":"

Error : Could not find provided Billing Group <BILLING_GROUP>
Error : Could not find provided Contact name <fname> <lname>
Error : Could not find provided Contact number <customerNumber>
Error : Could not find the Dept Hierarchy for <deptHierarchy>
Error : "No Matching Charge Catalog entries for '<chargeCatalogName>'
Error : "Multiple Matching Charge Catalog entries for '<chargeCatalogName>'
Error : Invalid GLA '<gla>'
Error : Full Charge Catalog Path <CHRG_CATALOG_FULL_NAME> is Invalid
Error : Charge Type <CC_CHARGE_TYPE_CODE> is Invalid
Error : Invalid Charge Catalog '<chargeCatalogName>'

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"cloak","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"81bddda3-f946-4a5a-bbdf-bccc714bd338"},"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":"Error : Could not find provided Billing Group ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Could not find provided Contact name ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Could not find provided Contact number ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Could not find the Dept Hierarchy for ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : \"No Matching Charge Catalog entries for ''","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : \"Multiple Matching Charge Catalog entries for ''","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Invalid GLA ''","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Full Charge Catalog Path is Invalid","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Charge Type is Invalid","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Invalid Charge Catalog ''","type":"text"}]}]}]}]}],"version":1}}}}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The value provided from another table is Inactive","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":"e1bb00a3-6f1f-465a-8f28-4e475d594000"},"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":"

Error : Trying to use Inactive Charge Catalog <chargeCatalogName>

Error : Blank or Missing GLA
Error : No owner provided
Error : Missing required Owner or Billing Group
Error : Missing Charge Catalog"
Error : Missing Billing Group"

Warning: Not updating Prorate flag because new Stop Date is before today
Warning: Not updating Amount because new Stop Date is before today
Warning: Not updating Override Amount because new Stop Date is before today
Warning: Not updating Quantity because new Stop Date is before today
Warning: Not updating Billing Group Override because new Stop Date is before today
Warning: Not updating Contact Owner because new Stop Date is before today
Warning: Not updating Dept Hierarchy Owner because new Stop Date is before today
Error : GLA '<gla>' is not Billable
Error : Dept Hierarchy <deptHierarchy has no Billing Group
Error : Contact <fname> <lname> has no Billing Group
Error : Trying to assign amount for Non-Overidable Charge
Error : Unable to convert '<BILL_DATE>' into a valid date
Error : Unable to convert '<STOP_DATE>' into a valid date

","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: Not updating Prorate flag because new Stop Date is before today","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Warning: Not updating Amount because new Stop Date is before today","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Warning: Not updating Override Amount because new Stop Date is before today","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Warning: Not updating Quantity because new Stop Date is before today","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Warning: Not updating Billing Group Override because new Stop Date is before today","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Warning: Not updating Contact Owner because new Stop Date is before today","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Warning: Not updating Dept Hierarchy Owner because new Stop Date is before today","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : GLA '' is not Billable","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Dept Hierarchy has no Billing Group","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Trying to assign amount for Non-Overidable Charge","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Unable to convert '' into a valid date","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Error : Unable to convert '' into a valid date","type":"text"}]}]}]}]}],"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":"

Error : Failed to save GLA_Charges 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.

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"bodiedExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"cloak","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"a95b344a-6e0c-4cd6-bfb0-7f4951c415ac"},"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":"Error : Failed to save GLA_Charges record; ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"If you experience any of these Errors, without another accompanying Message about what might have caused the Save Failure, please ","type":"text"},{"text":"submit a Ticket to PCR","type":"text","marks":[{"type":"link","attrs":{"href":"https://jira.pcr.com/servicedesk/customer/portal/12/create/192"}}]},{"text":".","type":"text"}]}]}],"version":1}}}}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Notes","type":"text"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"Notes"},"legacyAnchorId":{"value":"id-(2024.2)GLAChargesImports-Notes"}},"macroMetadata":{"macroId":{"value":"1fcab2e0-6eb4-4565-a3bb-a3375159aad8"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"788618d6-dcde-4fb5-b1ce-2a4f3ce95490"}}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Any GLA Charge ","type":"text"},{"text":"MUST","type":"text","marks":[{"type":"strong"}]},{"text":" have a valid Owner, either a Contact or a Department Hierarchy.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"By default the GLA Charges import always adds new charges. It never updates or removes charges. This can create duplicates.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If the UPDATE flag is set, the import will only update existing charges. This can be used to set Stop Dates on MRCs, or change Override Amounts, Quantity, Description, GLA, or Prorate flag.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If an NRC has been billed, it cannot be updated in any way.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"For an existing Monthly Recurring Charge, if you update the GLA, Amount, or Quantity, it will stop the existing Charge and create a new Charge with the appropriate changes. The date of this stop and start is determined by the Effective Date flag. If this is set to 'TODAY', then it will stop the existing charge with yesterday's date, and start the new charge with today's date. If it is set to 'BACKDATE', then it will use the date that the existing charge has been billed through.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If you update existing Alternate Recurring Charges (Quarterly, Semi-Annual and Annual), they will stop and start like MRCs, but they will always behave as if the Effective Data is set to 'BACKDATE'.","type":"text"}]}]}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"children","parameters":{"macroParams":{"style":{"value":"h6"},"sort":{"value":"title"}},"macroMetadata":{"macroId":{"value":"49fc0618-4e3d-40c8-92c0-5e0b87f43c92"},"schemaVersion":{"value":"2"},"title":"Child pages (Children Display)"}},"localId":"7eb3ebf5-9101-41ef-a141-6b3046c0b1f2"}}],"version":1}

Browser not supported