Configuration flag CFGEnableActInvDetProrationByItin must be enabled, and you must have an interface license.
For reporting purposes, Cargo Itinerary Allocation enables you to allocate voyage invoice line items to specific ports in the cargo itinerary.
Expenses are allocated to Load ports, and revenues are allocated to Discharge ports.
Note: For Vessel Daily Cost and Voyage Bunker Cost journal entries, all detail line items are expenses.
If the vendor or customer on a detail line item matches any Counterparty on the Cargo Itinerary Allocation form, only allocation line items corresponding to that counterparty are selected.
For each row to which you want to allocate the invoice line item, either:
Edit its Alloc %. The edited value appears blue, and the row is selected.
Select its S check box. Allocation % automatically calculates; if BL/Disch Qty is not entered, CP Qty is used: Alloc % = BL/Disch Qty / Total Quantity
The Amount allocated to each row populates with the prorated amount: Amount = Invoice Details Line Item Amount × Alloc %
If there is a single discharge port, 100% of each line item amount is allocated to the discharge port for its associated Cargo.
If there are multiple discharge ports for a specific Cargo tied to a specific invoice line item, then the line item amount is prorated between the discharge ports. Proration is done by the discharge quantity: The BL Qty from Cargo Handling is used when it exists and, if it does not exist, then the nominated Cargo Qty is used.
When the invoice is a Relet Invoice (Source Code RINV) and the voyage type is RELT:
If there is only one discharge port, then 100% of the line item amount is allocated to the discharge port for the linked Cargo.
If there are multiple discharge ports, then the allocation of the line item is prorated between the discharging ports. Proration is done by the discharge quantity: The BL Qty from Cargo Handling is used when it exists and, if it does not exist, then the nominated Cargo Qty is used.
Do one of the following:
Click OK to apply a specific detail line’s allocations.
Click OK Apply to All to apply selected percentage values for a given detail line to all other lines in the invoice.
After an invoice is posted, its Cargo Itinerary Allocation cannot be changed.
Reporting on Cargo Itinerary Allocation
To report on Cargo Itinerary Allocation, in the Report Designer, create a report that includes the Financials Invoice > Financials Invoice Details > Cargo Itinerary Allocation table.
Cargo Itinerary Allocation data can also be interfaced with. For more information, see the Messaging Service Manual.
Enable Invoice Det Proration by Itinerary
When enabled, turns on functionality in the system to allocate voyage related invoice detail amounts to related cargo itinerary line items, prorated by quantity. This includes a new Cargo Itinerary Allocation form, accessible from the Transaction Data Entry and Journal Entry forms.
Uses the Charterer's view instead of the standard Cargo form. When enabled:
Enable Cargo Handling Trade No
Note: CFGEnableMultiGrade must also be enabled.
Y = If multigrade cargoes are enabled, adds a Trade No. column to the Voyage Estimate Itinerary Cargo tab, Voyage Fixture, Voyage Manager, Cargo Itinerary/Options tab, and (when config flag CFGEnableActInvDetProrationByItin is enabled) Cargo Itinerary Allocation form. Additionally, if cargo transfers are enabled, the column is added to the Transfers tab. This is a free-text field, where users can enter identifiers for a trade associated with the given cargo lifting.
R = All the functionality of the Y setting is enabled, except that the Trade No. column is read-only.
Cargo Handling Trade No Title
Provides an override for the column title of the Trade No. column, which is enabled with CFGEnableCargoHandlingTradeNo. Leaving the setting blank causes the column title to remain Trade No.
Default Invoice Itinerary Alloc to Disc
When enabled alongside CFGEnableActInvDetProrationByItin, the Cargo Itinerary Allocation will default all transactions to the Discharge Ports.
Apply Cargo Itinerary Allocation % to all invoice detail lines
When enabled, you can apply selected percentage values for a given detail line to all other lines in the invoice by clicking the “OK (Apply to All)” button within the Details grid on the Financials Invoice form.