The rates tab is how the finance for the Consignment is managed.

Summary

The summary tab gives you an overview of the Consignment’s finances.

Credit Limit

• There is no credit limit attached to the account for this customer
• The account has been closed for this customer
• The account is approaching its credit limit
• The account is at its limit

If the account has a credit limit attached, the following information will be shown:

• The balance of the account on invoices that have been issued
• The balance of the account that has not yet been billed
• The used credit
• The credit limit

The uninvoiced balance shows to the total that is attached to consignments but has not been billed.

Settlement Terms

• The office from which the costs should be billed
  
• The currency the customer will be billed in
• The payment terms for the consignment
  

You can change the currency and payment terms and then click the  button.

To change the settlement office:

1. Select the  next to the settlement office
2. Select an address from your organisation in the address book dialog box
3. Click the  button
4. The click the  button to commit the change.

Cost & Revenue Summary

Gross Profit & Net Profit

• The total forecast cost of the consignment to your business
  
• The total revenue that will be charged to the customer
• The gross profit on the consignment
  • In actual currency
  • As a percentage of the cost to you
    

Invoices

The invoices panel shows any invoice that are linked to the consignment.

You see the following information:

• Reference
• Status
• When it was raised
• When it was due
• The total amount

Here you will also see credit notes here.

Costs

The cost tab shows the costs that are billed to your business from your suppliers.

This includes:

• Rate code
• Description of the rate
• The supplier
• State of the rate
  • E - Estimate
  • A – Actual
  • I – Invoiced
• The tax point date for the cost
• PO Reference 
  
• Invoice Reference
• Comments
  This includes manually entered comments and any information on how the rate subtotal is calculated.
• Currency
• Subtotal
  
•  Payable in original currency 
  

Purchasing Invoices 

Once the cost is linked to an invoice, it will be updated to the invoiced state and will no longer be editable.

Revenue

• Rate code
• Description of the rate
• State of the rate
  • E - Estimate
  • A – Actual
  • I – Invoiced
• Comments
  This includes manually entered comments and any information on how the rate subtotal is calculated.
• Currency
• Subtotal

Managing Costs & Revenue

To add revenue, click on the [ + ATTACH REVENUE ] button on the revenue tab.

Both buttons will open the properties for the rate you want to add. See the properties section below for more information.

Properties

The properties dialog is opened automatically when you attach a new rate.

You can also open it by right clicking on the rate you want to edit and selecting the  option.

Below is the properties dialog box for the revenue rates.

Once you have finished entering the rate information click the [ SAVE ] button at the bottom of the dialog box.

Paying Costs In Original Currency 

Costs can be processed in the original billable currency or the billing currency for the consignment. 

When are entering a cost and you select a currency that is not the consignment billing currency, the Payable in original currency option will be available as shown below. 

If the Payable in original currency is set the cost will be displayed and reported on in the currency entered rather than the consignment billing currency. 

The costs tab will show the total of each currency used on the consignment for costs, as shown above.

Automatic Value Calculation

• Fixed
• Weight
• Volume
• Volumetric Weight
• Chargeable Weight
• Loading Metres
• Factoring - % of total revenue
  
• Distance - manually entered
  
• % Total - This calculates a percentage of the total for the consignment for the selected rate category - typically used for surcharging

The fixed option does not trigger an auto calculation of the rate. Use this option when you are managing the rate entirely manually.

The other options link the QTY field to the consignment total value for the selected metric. You then only need to set the cost per unit and then CocoonOPS will automatically calculate the rate value.

When these metrics are changed for a Consignment, all linked Consignments will automatically be updated until they are invoiced.

Foreign Currency

This will then show the currency conversion options.

The exchange rate is pulled in from your settings and is automatically updated every 24 hours.

Enter the cost information in in the currency you selected and CocoonOPS will automatically convert it into the billing currency.

The foreign currency conversion information will be displayed in the comments section on the list of rates.

Automatic Revenue Calculation

This allows you to automatically create a linked revenue item based on the cost.

There are several models to choose from:

Then these models are used, the corresponding revenue item will be created and maintained based on the model selected and the parameters entered.

Removing Rates

Right click on the rate that you want to remove and select the  option.

Creating Invoices

To do this:

• Check the check boxes next to the rates that you want to include on the invoice (or use the box at the top of the column to select all)
• Click the button
• Select the  button

All of the selected revenue is then attached to the invoice, the invoice document is created and attached to the consignment and you will be taken to the invoice preview in the finance module.

Creating Credit Notes

When you create an invoice, in the total value of the invoice has a negative value, a credit note is created instead of a sales invoice.

Exporting Rates

You can do this by clicking on the [ EXPORT RATES ] button.

This will export all rates attached to the consignment.