EXPEDIENT SOFTWARE

Going beyond software performance.

Add IATA Costs

The Job/Consol Creditors screen can be used for any creditor that you owe money for.  When accessed from the Options menu in the Air Export Consol Registration screen and the creditor is CASS IATA the Freight for the Consol will be apportioned to all the House Bills on the Master based on weight. To view the breakdown per house bill click on the View Jobs and Amounts toolbar button .

Field Name

Description

Validation

Default

Header

Invoice Date

This is the date of the Creditors Invoice

Mandatory

Blank

Acc. Date

This is the accounting date in which you want the Creditors invoice to fall in

Mandatory

Blank

Due Date

This is the due date of when the invoice is due. The due date is based on the terms of the Creditor which is located in the Creditors Tab in the Customer Masterfile.

There is some validation on this date. The due date cannot take place before the invoice creation date. This can be amended by the user.

Optional

Invoice Date + Terms Days

Creditor

This is the Creditor in which the invoice is received from

Clicking on the will bring up a lookup from the customer master file (Where Creditor is selected)

Mandatory

Blank

Invoice Number

This is the Creditors Invoice Number

Mandatory

Blank

Currency

This is the currency in which the Creditor’s Invoice was received.

ONote: If Foreign Currency then you need to process payment via Banking Foreign Contra Payment.

If AUD then use Banking Creditor Cheques

Mandatory

AUD

Exch. Rate

This is the current Exchange Rate in which the invoice was received.

Mandatory

1.00 for AUD

Invoice Amount

This is the total amount as per the Creditor’s invoice

Mandatory

Blank

Invoice Line Type

This is the type of charge method on the invoice, Excluding GST or Including GST

Mandatory

Excl. GST

OK to Post?

This flag is used when the posting program is activated. If this is set to “No” then the invoice will be posted.

Defaults to Yes when a user adds, defaults to No when a Creditors Invoice is created from a Data Interface

Mandatory

Yes

Detail

C/H

This flags whether the below number is a consol or house bill

Blank

Defaults from Job/Consol

Job/Consol

This is the Job/Consol Number in which the Creditors invoice is based on. (Import & Export).

E.g.: If there is a consol with 4 house bills and the Creditor is a IATA Cass that bills Freight for the whole consol, then users can enter the Consol Number and the Total Invoice Amount. Expedient will portion the total amount to the 4 house bills based on the Volume (sea) or Kilograms (Air) for each house bill.

To view the break up you can click on the View Jobs and Amounts button . See below for the break-up of costs for each house bill (job)

Mandatory

Blank

Type

This is the department of the Job No / Consol No. This is for display purposes only.

N/A

Defaults from Job/Consol

Client

This is the Client Code for the job that has been entered. The word CONSOL will appear if a consol has been entered.

N/A

Defaults from Job/Consol

Cost Code

This is the Cost associated with the Creditors Invoice you are entering. Clicking on the will bring up a lookup from the Alpha Charge Code master file, which is found in Administration Menu.

Mandatory

Null

Account

This is the General Ledger Cost Code associated to the Alpha Cost Code.

N/A

Defaults from Cost Code

Description

This is the Cost Code Description

N/A

Defaults from Cost Code

Excl Amount

This is the amount on the invoice line excluding the GST Amount

N/A

Null

Incl Amount

This is the amount on the invoice line including the GST Amount

N/A

Null

Previous Billed

This is the amount of money that has already been billed on this invoice for the creditor. This is for display purposes only.

N/A

Defaults from Invoice /Creditor

Previous Cost

This is the amount of money that has previously been paid out on this invoice for the creditor

N/A

Defaults from Invoice / Creditor

Balance

This is the balance of money from the Previous Billed minus Previous Cost

N/A

Previous Bill – Previous Cost

GST On

Clicking this Check box will automatically add the GST to the line items. Use this feature if the Creditors Invoice you have received excludes the GST amounts on the line items.

Optional

Blank

Updated: April 18, 2016 — 6:46 am
EXPEDIENT SOFTWARE GUIDE © 2015