Capability

The 'Charge Catalog Import' allows Users to update and Import records into the Charge Catalog grid. Since the Import Process does not know if a new Charge is desired, or an Existing Charge needs to be updated, it is important to remember to set the Update Existing Charges flag if you want to update a Charge.

Matches On

The Charge Catalog Import matches on the Charge Catalog Full Path Name and the Charge Type. If there is no match, the record from the Import will INSERT. If there is a match, the remaining fields can UPDATE.

Fields

Full Path Name

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

Parent Charge Type

Datatype is List, must be one of the CHARGE_TYPE values.
Defaults are Monthly Recurring, Nonrecurring, Annual Recurring, Semi-Annual Recurring, and Quarterly Recurring.
This is only used to help find the correct parent record. It is not saved.

Description

Datatype is String.

Charge Type

Conditionally Required if INSERT.
Datatype is List, must be one of the CHARGE_TYPE values.
Defaults are Monthly Recurring, Nonrecurring, Annual Recurring, Semi-Annual Recurring, and Quarterly Recurring. See the List Values wiki page for more information.

Amount

Conditionally Required if INSERT and Allow Override is false.
Datatype is Number.
Since the Import Process does not know if a new Charge is desired, or an Existing Charge needs to be updated, it is important to remember to set the Update Existing Charges flag if you want to update a Charge.

Qty Type

Conditionally Required if INSERT.
Datatype is String.
Value MUST be one of Disabled, Whole, or Fractional.

Allow Override

Datatype is Boolean.
Defaults to False.

Taxable

Datatype is Boolean.
Defaults to False.

Bill Forward

Datatype is Boolean.
Defaults to False.

Bill Backward

Datatype is Boolean.
Defaults to False.

Revenue GLA

Conditionally Required if INSERT.
Datatype is String.
Value must be an existing GLA.

Revenue Object Code

Conditionally Required if INSERT.
Datatype is String.
Value must be an existing Object Code.

Expense Object Code

Conditionally Required if INSERT.
Datatype is String.
Value must be an existing Object Code.

Expense Type

Conditionally Required if INSERT.
Datatype is List, must be one of the EXPENSE_TYPE values.
Defaults are Default, Usage, Equipment, Labor. See the List Values wiki page for more information.

Status

Datatype is Boolean.
Defaults to Active.

Child Tables

Billing Group Override

Billing Group Override Billing Group

Datatype is String.
Value must be an existing Billing Group.

Billing Group Override Revenue GLA

Datatype is String.
Value must be an existing GLA.

Billing Group Override Revenue Object Code

Datatype is String.
Value must be an existing Object Code.

Billing Group Override Expense Object Code

Datatype is String.
Value must be an existing Object Code.

Billing Group Override Clear

Datatype is a Boolean
This controls how items are added to the Billing Group Override list.
By default, if a Billing Group Override value is provided, then the first record for a specific Charge Catalog will first clear the Billing Group Override list. Then each successive record for that Charge Catalog will append to the Billing Group Override list.
If the 'Billing Group Override Clear' flag is set to false, it will prevent the first occurrence from clearing the list.
If the 'Billing Group Override Clear' flag is set to true, it will clear the list even if a new Billing Group Override value is not provided.
Note: If Billing Group Override Billing Group is provided, then require at least any one of Billing Group Override Revenue GLA, Billing Group Override Revenue Object Code, or Billing Group Override Expense Object Code.

Billing Group Pricing

Billing Group Pricing Billing Group

Datatype is String.
Value must be an existing Billing Group.

Billing Group Pricing Amount

Conditionally Required if the Billing Group Pricing Billing Group is provided.
Datatype is Number.

Billing Group Pricing Clear

Datatype is Boolean.
This controls how items are added to the Billing Group Pricing list.
By default, if a Billing Group Pricing value is provided, then the first record for a specific Charge Catalog will first clear the Billing Group Pricing list. Then each successive record for that Charge Catalog will append to the Billing. Group Pricing list.
If the 'Billing Group Pricing Clear' flag is set to false, it will prevent the first occurrence from clearing the list.
If the 'Billing Group Pricing Clear' flag is set to true, it will clear the list even if a new Billing Group Pricing value is not provided.

GLA Component Pricing

GLA Component Pricing Format

This is Required if any GLA Component Pricing field is provided.
Datatype is String.

GLA Component Pricing Component 1 (through GLA Component Pricing Component X)

Datatype is String.
There will be as many of these fields available to map in an import as the largest number of GLA Components of the GLAs you have configured.

GLA Component Pricing Amount

Conditionally Required if any GLA Component Pricing field is provided.
Datatype is Number.

GLA Component Pricing Clear

Datatype is Boolean.
This controls how items are added to the GLA Component Pricing list.
By default, if a GLA Component Pricing value is provided, then the first record for a specific Charge Catalog will first clear the GLA Component Pricing list. Then each successive record for that Charge Catalog will append to the GLA Component Pricing list.
If the 'GLA Component Pricing Clear' flag is set to false, it will prevent the first occurrence from clearing the list.
If the 'GLA Component Pricing Clear' flag is set to true, it will clear the list even if a new GLA Component Pricing value is not provided.

Flags

Update Existing Charges

Datatype is String, expected values are today, backbill, and retain.
Default value is 'retain'.
This flag tells the import process what to do with existing charges when an existing Charge Catalog is updated.
'today' - existing charges will stop with yesterday's date, and a new charge will start with today's date.
'backbill' - existing charges will stop with the date of the last bill, and a new charge will start with the day after the last bill date.
'retain' - existing charges will not be changed.

Note: The Billing Group Pricing fields can only be used if you have Billing Group Pricing configured.
The GLA Component Pricing fields can only be used if you have GLA Component Pricing configured.

Errors

These errors display if the record save fails:

Error : Blank Charge Catalog Name
Error : Invalid Parent Charge Type '<PARENT_CHARGE_TYPE>'
Error : No Parent Charge Catalog found for '<PARENT_CHARGE_CATALOG>', type '<PARENT_CHARGE_TYPE>'
Error : Multiple Charge Catalogs found for '<PARENT_CHARGE_CATALOG>'
Error : Multiple Matching Charge Catalog entries for '<FULL_PATH_NAME>'
Error : Invalid 'Use Quantity' value '<USE_QUANTITY>'
Error : Missing Charge Type for new Charge Catalog Record
Error : Missing Expense Type for new Charge Catalog Record
Error : Missing Revenue GLA for new Charge Catalog Record
Error : Missing Revenue GLA for new Charge Catalog Record
Error : Missing Revenue Object Code for new Charge Catalog Record
Error : Missing Expense Object Code for new Charge Catalog Record
Error : Specified Billing Group Override with blank Revenue GLA, Revenue Object Code, and Expense Object Code
Error : Specified Billing Group Pricing fields but Billing Group Pricing is not configured
Error : Specified Billing Group Pricing with blank Amount
Error : Some GLA Component Pricing fields are provided, but GLA Component Pricing is not configured
Error : GLA Component Pricing GLA Format is blank
Error : Specified GLA Component Pricing with blank Amount
Error : GLA Component Pricing GLA Format '<GLA_FORMAT>' is not valid
Error : GLA Component Pricing GLA Format '<GLA_FORMAT>' has <GLA_NUM_ITEM> components, but component <LARGER_COMPONENT_NUM> was specified
Error : Invalid Update Existing Charges flag '<UPDATE_EXISTING_FLAG>'
Error : Failed to save Charge Catalog record; <errorMessage>

Capability

Matches On

Fields

Full Path Name

Parent Charge Type

Description

Charge Type

Amount

Qty Type

Allow Override

Category

Taxable

Bill Forward

Bill Backward

Revenue GLA

Revenue Object Code

Expense Object Code

Expense Type

Status

Child Tables

Billing Group Override

Billing Group Override Billing Group

Billing Group Override Revenue GLA

Billing Group Override Revenue Object Code

Billing Group Override Expense Object Code

Billing Group Override Clear

Billing Group Pricing

Billing Group Pricing Billing Group

Billing Group Pricing Amount

Billing Group Pricing Clear

GLA Component Pricing

GLA Component Pricing Format

GLA Component Pricing Component 1 (through GLA Component Pricing Component X)

GLA Component Pricing Amount

GLA Component Pricing Clear

Flags

Update Existing Charges

Errors

Browser not supported