Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

For a multi-level Department Hierarchy the Full Path of the Hierarchy MUST be used.

For example, if the Department, XYZ, is a child to Department, Billing, the Owner Department Hierarchy field should be Billing, XYZ.

Bill Date

Datatype is String.

...

Override Amount

Datatype is String Number.

This is only allowed if the Charge Catalog entry allows overrides.

...

All other values enter as False [0].

Quantity

Datatype is String Number.

Stop Date

Data type is String.

...

New Override Amount

Data type is String Number.

This is only allowed if the Charge Catalog entry allows overrides.

Used for UPDATE only.

New Quantity

Data type is string Number.

Used for UPDATE only.

RECID

Data type is String Number.

Used as a lookup for Charge updates.

Effective Date

Data type is String.

Expected values are Backdate and Today.

Billing Group Override

Data type is String.

...

UPDATE:

Default vales is UPDATE

If set, this import will UPDATE existing records.

If the import cannot find an existing record to update, it will error. If the UPDATE flag is set, the import only updates existing charges.

This can be used to set Stop Dates on MRCs, change Override Amounts, Quantity, Description, GLA, or Prorate flag.

Effective Date

Data type is String.

Expected values are Backdate and Today.

See the Notes for more details.

Warnings and Errors

The following warnings display if the Service Charge UPDATE fails:

...

  • Error : Unable to convert '<BILL_DATE>' into a valid date
  • Error : Unable to convert '<STOP_DATE>' into a valid date
  • Error : Failed to save GLA_Charges record; <errorMessage>

Notes
Anchor
Notes
Notes

  • Any GLA Charge MUST have a valid Owner, either a Contact or a Department Hierarchy.
  • By default the GLA Charges import always adds new charges. It never updates or removes charges. This can create duplicates.

...