Demurrage Settlement

Note: Most of demurrage settlement is done separately outside of OTM and not settled along with the transportation bill except for detention charges.

The "Demurrage Financial Report" generates either the demurrage settlement or liability details based on your selection for report type.

• Settlement & Not Approved: This generates a demurrage settlement bill either for a monthly or bi-weekly period and can be used to compare (manually) the actual demurrage bill sent by the service provider to determine the deviation, if any, before releasing the demurrage payment. Settlement & Not Approved, is when you have all the events and calculate the final charges, but they have not been approved.
• Settlement & Approved: Charges are considered approved when the action is run to approve the final results and the status is set so they are not considered again. The demurrage transaction status will be DT_APPROVAL_APPROVED.
• Liability: It provides liabilities of all the assets that remain un-terminated or un-attended and the charges they are accruing. It can be used at the end of a financial period to recognize liabilities.
  
  Proactively, you can run it daily or weekly to see what charges are accruing and to help manage them.
• Plan Type: You can also use the "Plan type" option to generate a straight plan or average plan. This affects the display of Debit Days and Cost as well as the display and calculation of their totals.
• Straight plan: charges are calculated and reported for each individual car. Straight plan considers all the demurrage transactions for a particular selected period. However, if a demurrage transaction has negative debit days and negative cost, it will display them as zero and corresponding calculation of their sum will also be done taking them as zero.
• Average plan considers both the positive and negative debit days for a selected period. Hence, the debit days, sum of the debit days, the cost and the total cost for a particular selected period will be the sum total of all individual demurrage transaction charges (both positive and negative).

Denormalized fields can be used for mapping to the report if you define them in the Tracking Event Agent Action 'Create/Update Demurrage Transaction'.

For ease of use, when running the report, you can use a saved query as an input parameter rather than having to enter all the input parameters each time. See the Report Designer’s Guide on the Oracle Help Center for details.