Versions Compared

Key

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

...

  • Rates type - an equivalent to an importing page from earlier versions. While importing, at least 1 sheet must be of Rates type. For this type, the following columns are mandatory:
    1. Dst Code/Code Name - indicate at least one of them
    2. Rate
    3. Effective Date - if you don't indicate this column, the Effective Date, specified in the Code Rules information block, will be applied to imported rates.
  • Src Codes type - this type allows a user to perform the import to the code deck attached to the rate table. For this, indicate source codes/code names in the two columns: Src Code and Src Code Name. If selected, both columns must be specified.
  • Codes type - this type allows a user to perform the import to the code deck attached to the rate table. For this, indicate destination codes/code names in the two columns: Code and Code Name If selected, both columns must be specified.


Warning
titleWarning
  • Codes and Src Codes sheet types require the Import all codes (update existing) mode of Update Code Deck from Advanced Settings.

Starting from JeraSoft Billing v3.18.0, the user has an option to select the Skip this sheet option for the system to ignore the respective sheet during import. More about sheet types configuration here.

...

Screenshot: Import History output

Image AddedImage Removed

ColumnDescription
Date
Time and date of import execution
User Login
Login of a user who executed the import
File 

Import file. By clicking on the icon, the file will be downloaded

TotalTotal amount of imported rows
NewTotal amount of rates with New type
IncreasedTotal amount of rates with Increased type
DecreasedTotal amount of rates with Decreased type
UnchangedTotal amount of rates with Unchanged type
A-Z ClosedNumber of rates, closed by A-Z import
A-Z StashedNumber of rates, stashed by A-Z import
StatusStatus of import procedure (success/failed)

icon

When clicked on, deletes respective import data from the system

Info
titleNote

Only the latest Import can be undone.


The imported rates are divided into the following types: Unchanged, Increased, Decreased, New. By clicking on the respective numbers of rates, you can see filtered rates by type (see screenshot above) in the Rates section.

...