Skip to main content
Skip table of contents

Jobs import

Jobs imported in Awery have a certain quantity of parameters that can be imported into the system.

File format to import - xls, xlsx, csv

The first line of the file should contain column names.

The data table must be on the first tab of the file.

Names and types must exactly match those entered in the system.

When adding unsupported columns, if one of the columns is missing, when changing the order of the columns, the import will not work

This is the list of parameters that can be imported into the system:

Field name

Data format

Value

ROW_TYPE

Header / Transaction

Determination of the type of data written in the row.

Сan be of two types: Header / Transaction

TYPE

Invoice/Purchase Invoice/Additional Charges or other types of jobs in the system

Type of jobs.

Must be an exact match with the data entered into the system

JOB_DATE

yyyy-mm-dd (2021-01-04)

Job creation date

CONTRACTOR_TYPE

customer/crew/fas/vendor or other types in the system

Type of the contractor.

Must be an exact match with the data entered into the system

CONTRACTOR

AIR LOGISTICS HK or other contractor in the system

Name of the contractor.

Must be an exact match with the data entered into the system

DR_CURRENCY

USD/EUR or other currency in the system

Abbreviation of currency which is available from the debtor list.

Must be an exact match with the data entered into the system

CR_CURRENCY

USD/EUR or other currency in the system

Abbreviation of currency which is available from the creditor list.

Must be an exact match with the data entered into the system

COMPANY

Awery Demo Company

Company name.

Must be an exact match with the data entered into the system

COMPANY_BANK

CASH UAH

Name and currency of the Company bank.

Must be an exact match with the data entered into the system

SUBTYPE

Air Freight/General or other subtype in the system

Subtype of jobs.

Must be an exact match with the data entered into the system.

DR_CURRENCY_RATE

Numbers

Debtor rate from account 

CR_CURRENCY_RATE

Numbers

Creditor rate from account

EFFECTIVE_DATE

yyyy-mm-dd (2021-01-04)


DUE_DATE

yyyy-mm-dd (2021-01-04)

The due date of the bill

REFERENCE_NO

Text, free format


NOTES

Text, free format

Comment to the document

STATUS

OK or other status in the system

The status of the document

Must be an exact match with the data entered into the system.

TEAM

Name of team, text format

The name of team group

Additional field

DR_ACCOUNT

Number separated by a comma

The name of an account which is selected for the debit side.

DR_AMOUNT

Number separated by a comma

The debit amount in the transaction or sum of the debit amounts of all the transactions of a job.

CR_ACCOUNT

Number separated by a comma

The name of an account which is selected for the credit side.

CR_AMOUNT

Number separated by a comma

The credit amount in the transaction or sum of the credit amounts of all the transactions of a job.

PRICE

Number separated by a comma

Price per unit of the serviceT

QTY

Number separated by a comma

Number of pieces in a package

DEBITOR_TYPE

company or other type in the system


Must be an exact match with the data entered into the system.

DEBITOR

Awery Demo Company

The name of a contractor of the selected DR. Account

Must be an exact match with the data entered into the system.

CREDITOR_TYPE

crew or other type in the system


Must be an exact match with the data entered into the system.

CREDITOR

Test Company

The name of a contractor of the selected CR. Account.

Must be an exact match with the data entered into the system.

STATION

Office or other type in the system

Station  is used to manage your warehouse data. 

Must be an exact match with the data entered into the system.

DEPARTMENT

Text

Department names must match the data in the system

UNIT

kg 

As a measure of weight

TAX

Number

Based on % in tax options settings to the transaction amount.

Must be an exact match with the data entered into the system.

DESCRIPTION

Text, free format

Description of a job displays in the Description column. 

DR_CONTROL_JOB_AMOUNT

Number

Sum of all dr amount

CR_CONTROL_JOB_AMOUNT

Number

Sum of all cr amount

TRANSACTIONS_NUM

Number

The number of transactions in the job



To do the Jobs import


  1. Path: Home →  Jobs List → button Import from XLS


2. On the import page you can:

1) drag the file you want to import

2) select and download the file

3) view the data before uploading and adjust it

4) import data

5) view conditions for correct download


After all the parameters were assigned to the data content, you can switch to the next tab and select manually which Jobs will be imported and press Import


Example

Import_Jobs_example.xlsx

 Spreadsheet

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.