EXPEDIENT SOFTWARE

Going beyond software performance.

Creating a Shipper’s Invoice (AU)

After you have created a job, you can create a Shipper’s Invoice. Expedient allows user to create a Shipper’s Invoice from the Export Job Registration Screens. This is used in the EDN Creation of Commodity Lines process.

This can be performed in 2 ways. The first method is directly from the Export Job Registration Screen. From this screen ensure you have the job you want to link the Shipper’s Invoice to. Click on the Shipper’s Invoice tool bar button or use the link in the Options menu.

The screen can also be accessed from Air or Sea Export Forwarding > CMR Functions > Export Shippers Invoice

By clicking the button or typing A will place the cursor in the input screen in Add Mode.

 

OPlease Note: If you access this via the CMR Functions menu then you will need to input the Job Number in yourself, otherwise if this screen is accessed via the Job registration screen, the job number and associated information is automatically populated in Add Mode.


Field Name

Description

Validation

Default

Summary Tab

Job No

This is the Job Number in which you wish to create the Shipper’s Invoice for

Mandatory

Defaults from Job Registration Screen

Client

This is the client you wish to create the Shipper’s Invoice for

Mandatory

Defaults from Job Registration Screen

Invoice No

This is the Shipper’s Invoice Number. Once this is input, then the Details Tab appears, allowing you to add the Shipper Invoice lines.  

You can email the Shipper’s invoice using the CSV file format. To activate this, firstly go into the Customer Masterfile and find the customer you want to load the Shipper’s Invoice for. From the Options Drop down Menu, select Client Options. This will present you with the following screen:

Ensure the Shipper Invoice Masterfile has been ticked.

This will then allow you to email and load invoices.

Email the CSV File to: shipinv@<yourdomain>.com.au

To see the CSV file Specification select Help from this screen. Once this is loaded you will be able to view the Downloaded invoices by clicking the lookup within this field.

NOTE: The Invoice Number cannot be amended once an EDN has been raised.

Mandatory

Blank

Goods

This is the goods that appear on the Shipper’s Invoice

N/A

Job Registration

Invoice Date

Date of the Shipper’s Invoice. This will default to ‘today’ and can be updated to the real invoice date.

Optional

Today

Packages

This is the total number of packages

N/A

Job Registration

Invoice Type

This is the Purchase Terms (INCOTERMS). Use the to search from the INCOTERMS Masterfile. An option to print the Incoterms on the Bill of Lading and Sea Waybill is provided, if this field is populated.

Mandatory

Blank

Currency

This is the currency as it appears on the Shipper’s Invoice

Mandatory (if not AUD)

Blank

Exchange Rate

This is the exchange rate used at the time of the Shipper’s Invoice received

Mandatory (if not AUD)

Blank

Freight / Insurance / Origin/ Destination

These are the charges relating to the Shipper’s Invoice

Mandatory (if not AUD)

Blank

Invoice Information

No. Inv Lines

This counts the number of Invoice lines, either entered in the Details Tab manually, or from the CSV/TXT File you have loaded via the Load File button. This is a no entry field and for display purposes only

N/A

Actual number of lines

Inv Amount

Enter the Total Invoice Dollar Amount. This must equal the Entered Amount to balance the Supplier’s Invoice

Mandatory

Blank

Entered Amount

This totals the dollar amount entered in the Details Tab. This must equal the Inv Amount. This is a no entry field and for display purposes only. If these are not equal you will receive the below message. You can still save the Supplier’s Invoice.

N/A

Actual amounts entered

Invoice Qty

Enter the Total Invoice Qty of pieces. This must equal the Entered Qty to balance the Shipper’s Invoice

Mandatory

Blank

Entered Qty

This total the qty amount entered in the Details Tab. This must equal the Invoice Qty. This is a no entry field and for display purposes only

N/A

Actual Qty’s entered

Details Tab

Part No

This is the Part Number that appears on the Invoice. This will be automatically populated if the Load File button was successful.

You can also click on the button to list all Export Parts on file

See below zoom screen:

Select one of the parts that you want to add to the Shipper Invoice Line.

OPlease Note: The Re-Query Button allows you to perform another search for any parts for that Customer (excludes the Shipper from this selection). Clicking OK will search for all parts for that Customer regardless of Shipper.

Mandatory

Blank

Quantity

This is the Quantity of the part that appears on the invoice line.

Mandatory

Blank

Amount

This is the total line amount for the part that appears on the invoice line.

Mandatory

Calculated if the Quantity and Unit Price are entered

Order No

This is the Order Number as ordered by the customer

Optional

Blank

Country

This information is pulled from the Parts Masterfile.

Mandatory

Parts Masterfile

Weight

This is the weight of the part line item

Mandatory

Blank

AHECC

This is the AHECC Code of the part

Mandatory

Parts Masterfile

TLF

This is the Export TLF for the Part Number. This is a no entry field. This information is drawn from the Parts Masterfile, Export TLF information. If the part does not have an associated Export TLF then this field will display *****

See below If the Part is unclassified you can still save the invoice. Once you have done this you can click on the Classify Button This will allow you to classify the part with the correct TLF Code. 

Mandatory

Parts / TLF Masterfile

Updated: April 1, 2016 — 12:42 am
EXPEDIENT SOFTWARE GUIDE © 2015