The team are excited to announce our enhanced Sales Quoting and Rating Module. This new Module is available at no additional charge for those customers using our Billing Module.
The Sales Quoting and Rating Function include the following:
- Company Tariff: The ability to store standard company level sell rates that are to be used in creating Customer Quotes and where Customer Rates don’t exist, to be used in Job Auto Rating.
- Customer Rate: The ability to store customer specific sell rates that are to be used in creating customer quotes and in Job Auto Rating
- Customer Quote: The ability to create a customer quote based on customer rates or company tariff information. Includes the functionality to provide multi trade lane quotations and to be sent to the customer in XLS displaying each trade lane in each tab.
COMPANY TARIFF
The Company Tariff can be used for the following:
Storing the Companies Suggested Sell Rates;
- Origin,
- Freight ;
- Destination (Customs/Transport)
Import / Export Job Auto-Rating
Creating Customer Rates
The Rate Account Code Zoom will show specific Rate Codes depending on the Rate Group, if the Tariff is Import or Export and if the Tariff is Air or Sea
CUSTOMER RATE
The Customer Rate can be used for the following:
- Storing the Customers Rates; Origin, Freight and Destination (Customs/Transport)
- Import / Export Job Auto-Rating
- Adding Rates from the Company Tariff via the Retrieve Company Tariff Button
- Using existing Customer Rates to add/update a quote
- The Rate Account Code Zoom will show specific Rate Codes depending on the Rate Group, if the Rate is Import or Export and if the Rate is Air or Sea
CUSTOMER QUOTE
Customer Quotes can be created by adding Rate Account Codes in manually or via the Retrieve Rate Button.
- The Retrieve Rate function retrieves the Rate Information from the Company Tariff or Customer Rate.
- A quote can include multiples trade lanes across multiple Modes
- An approved quote will then add the relevant customer rates, and expire those existing rates
- The Quote output can be XLS or PDF
- The XLS Quote output displays each trade lane on individual tabs
- The quotes include a cover page and terms and conditions page
Masterfile Changes and Setup
The below highlights the Masterfile changes and what requires set up by the site representative. The Expedient team will migrate as much as possible; however the site representative must check this prior to go live.
ALPHA CHARGE CODE MASTERFILE
Rate Account Codes
- The Rate Account Codes Masterfile has been merged within the Alpha Charge Code Masterfile
- If using the Code for billing then a Rate Account Code must be setup against the Alpha Charge Code in the GL Code range; 2300 to 2799 & 4000 to 4299.
- The Rate Account Code can be setup for Air & Sea Jobs and assigned to specific Rate Groups and Methods
Data migration of Rate Account Codes
- Looks at the existing Rate Account Codes Masterfile and populates the Rate Account Code / Rate Group / Sea / Air into the new table THEN
- Cartage is assigned the Rate Group of Destination and Origin (air/sea)
- Duty is assigned the Rate Group of Destination (air/sea)
- Any remaining Charge codes that don’t have a rate account code populate 2 records Sea and Air with Rate Group of Freight
Import Service Type Invoicing Terms
This is a new feature that allows users to assign the charge code to invoice as disbursement or final for customs/forwarding or customs only. These default in the charges tab on the Job but can be amended. Can also be stored against the customer Masterfile for customers that have different invoicing terms
- This determines which Invoice Type (Disbursement & Final) to assign to the Rate Account Code; whether Forwarding or Customs are being actioned; this will apply against ALL Customers
- The Invoicing Terms Group does not apply to the Duty Charge Code
- The Service Type Invoicing Terms only applies to the Import Air and Sea Jobs
Data Migration Import Service Type Terms
- All charge codes between 2300 and 2799 set to Final Terms EXCEPT DUTY
Import Invoice Service Type Mapping Group (per Customer – Customer Masterfile)
- This Invoice Mapping Group only applies to the Import Air and Sea Jobs
- This Group does not apply to the Duty Charge Code
- On a Customer Level, this Group determines which Invoice Type (Disbursement & Final) to assign to the Rate Account Code; whether Forwarding or Customs are being actioned
Invoice Agency Charge Code
- Indicates whether Agency is to be billed in the Charges Tab for Import Jobs.
- This field only applies to Account No’s in the 4000 series
Each site must update the Alpha Charge Code Screen to set one code to Agency. This is used to remind users, when invoicing.
CUSTOMER MASTERFILE
Duty Configuration Amount
- This field has been added to the Debtors Tab in the Customer Masterfile
- The Duty Amount entered in this field, determines if Duty will be billed on the Disbursement or Final Invoice
JOB REGISTRATION CHANGES
Toolbar and Option Re-organisation – Please see the Release Note Toolbars and Options Reorganisation
Charges Button moved to a Tab
The charges button has now been moved to a Tab on the Job Registration Screen and all auto rating functions moved to the Charges Toolbar
See below screenshot and description of each group:
The new tab includes the following:
Charges Lines behaviour
- For consistency across the charges screen and the invoice, once an invoice has been created, those charges will be linked via the invoice number and not be editable by operators
- If an invoice is created, and a full reversal on that invoice has occurred, the charges are then unlinked to the invoice number and become editable
See Reset Invoice Number/s option in the Charges Toolbar
- User is in View Mode AND;
- All “AR” Accounts Receivable Transactions equal 0 AND;
- Each Billing Code Match equals 0 AND; (e.g., FR = $100 FR = -$100)
- No money has been paid out against the job AND;
- All Debtors invoices on the Job have been posted
- After an invoice is created, new charges are able to be added in the Charges screen
- Disbursement and Final Invoices can be created at the same time from the Charges Screen.
Rate Account Codes
- The Rate Account Codes field has been added to the Charges Tab (First Column) and be used to populate the Charge Code.
- The Rate Account Code Zoom will show specific Rate Codes depending if the Job is Import, Export and Air or Sea
- When the Rate Account Code has been entered in the Charges Tab, the system will check the Customer Masterfile to retrieve the Invoice Type, if the Code is not found then the system will check the Alpha Charge Code Masterfile; Import Service Type Invoicing Terms
Disbursement & Final
- These check boxes indicates which Invoice Type to assign to the Charge Code
- They can be manually or automatically updated
- The Disbursement & Final check boxes are populated based on the Charge Code setup in the Alpha Charge Masterfile and/or Customer Masterfile
- Duty is determined by the Duty Configuration Amount and Invoice Payment Terms in the Customer Masterfile
- The Disbursement or Final check boxes will be populated once the Local Amount / FX Amount has been entered
Invoice Creation
- Option to Create the Disbursement & Final Invoice at the same time
- Option to Create Disbursement Invoices Only or Create Final Invoices Only
- The invoice will display the sum of the charge codes based on the Rate Acct Code. This allows operators to see the costs and sell amounts whilst rolling up charges on the invoice
Invoice Information Group
- This Group shows all UNPOSTED and POSTED Invoices (includes Credit Notes) that have been created against the Job Number
- If an Invoice is created directly in the Debtors Invoice then it will be shown in the Invoice table
DAFF Paid Amount
- The DAFF Paid Amount field has been added to the Charges Tab in the Import Job
- This information is retrieved from the DAFF Paid field in the Nature 10/20
New Charges Toolbar Option
A new Charges Toolbar has been added to the Import and Export Job Registration Screens. These options allow for the below functions. The Auto Rating Functions are only available in update mode.
Duty Conditions
When the Duty Charge Code is entered in the Charges Tab of the Import Job, the Actual Total Paid Amount will auto-populate under the following conditions;
- Total Amount is paid to Customs from the Brokers Bank Account
- Entry Status = CLEAR, ATD FINALISED or FINALISED (Customs Entry)
- EDI Status is not W (Withdrawn) or P (Prelodge)
- EFT Receipt is sent from Customs
If the EFT Receipt has not been received from Customs and the Duty Charge Code is entered in the Charges Tab, then the Total Amount will auto-populate based on the following conditions;
- Entry Status = CLEAR, ATD FINALISED or FINALISED
- EDI Status is not W (Withdrawn) or P (Prelodge)
- Owner EFT = NO
General Import Job Changes
- Job Number added to Job Details tab
- Field validation screen message – on Add mode, if certain mandatory fields are not entered, as screen pop up with the list of empty fields that need entering will appear.
Cont. Search button replaced by ability to search within container details tab by hitting Find
Export Job Registration Changes
Charges Button moved to a Tab
Charges Lines behaviour
- For consistency across the charges screen and the invoice, once an invoice has been created, those charges will be linked via the invoice number and not be editable by operators
- If an invoice is created, and a full reversal on that invoice has occurred, the charges are then unlinked to the invoice number and become editable
- After an invoice is created, new charges are able to be added in the Charges screen
- Disbursement and Final Invoices can be created at the same time from the Charges Screen.
Invoice Information Group
- This Group shows all UNPOSTED and POSTED Invoices (includes Credit Notes) that have been created against the Job Number
- If an Invoice is created directly in the Debtors Invoice then it will be shown in this Group
Rate Account Codes
- The Rate Account Codes field has been added to the Charges Tab (First Column)
- When the Rate Account Code has been entered in the Charges Tab the system will check the Customer Masterfile to retrieve the Invoice Type, if the Code is not found then the system will check the Alpha Charge Code Masterfile; Import Service Type Invoicing Terms
Invoice Creation
- Option to create the Disbursement & Final Invoice at the same time
- Option to Create Disbursement Invoices Only or Create Final Invoices Only