Storage charge setup and calculation
System has a facility to define the storage related tariffs including the free days and free pool which is applicable in some of the locations. Based on the container movements system will calculate the storage and store the charges in the system for Laden and Empty containers.
While calculating the storage system will consider the free days applicable, also in some locations for empty containers instead of charging per container basis, system will calculate based on the free pool Teus limit.
Expense Charge Master:
User can setup all costing related expense charges using this setup and identify the type of expense as shown below. All storage related charges to be defined first in the BL charge master and the type should be identified as disbursement.
User can select the expense(disbursement) charge code and identify the mode of expense, collection charge code is not mandatory and its kept for generating comparison report between collection and expenses. For storage user needs to identify the Supplier account and Group as per finance.
The mode of the charges can be
1. Fixed
2. Port Charges
3. Transporter
4. Storage
If the mode is selected as Fixed, user can define the charges based on the supplier, container type in the expense charges master itself.
Separate master definition available for defining the Port wise Charges, Transporter wise charges, and Storage charges
Equipment Move & Charge Link
For each expense charge, the possible movements needs to be linked using this setup. User can select the From Move and To Move in order to link with the Expense charge code.
In case of storage, user need to link the move charge code as per Equipment control setup for Free days and Storage Tariff. This is applicable for Laden and Empty container related charges as shown below.
The above two setup is mandatory in the cost module in order to calculate the charges.
I. Free Pool
System has a facility to define the Free pool in order to calculate the Empty storage Charges. User can defined the applicable Teus limit and Charges per Teus. System will build the summary based on the free pool flag identified in the move type master.
User can identify whether storage is based on free pool or storage tariff using the following config.
As shown below, user can enter the free pool setup with the Teus limit and applicable charges per Teus. User needs to link the charge code for empty storage as per the move charge setup in Equipment control.
II. Port Free Days
Port free days applicable in each port/terminal can be defined here. User needs to maintained separate move charge for laden and empty containers.
For each container type, user can define the applicable free days with the validity and also for DG and OOG, separate free days can be defined as follows.
III. Storage Tariff
Storage tariff for containers will be maintained here, system has a facility to define the tariff by tiers based on the days.
Storage tariff will be maintained based on container type, COC/SOC and Service wise(FCL/LCL/EMPTY) as shown below
For DG and OOG, additional rates applicable can be easily identify based on the Type as follows,
Percentage : System will apply the percentage on the basic rate in order to calculate the additional charges applicable for DG and OOG
Factor : System will multiply the number of times on the basic rate
Fixed Amount : System has a facility to add the fixed amount applicable for DG and OOG in addition to the basic rate
The above charges to be defined for Laden and Empty storage separately, if the tariff is different for Import and Export separately. User needs to maintain different move charges codes and accordingly Equipment Move – charge link to be maintained separately.
IV. Cost Calculation
This process will be executed on a periodical basis, system will extract all the moves based on the Move – Charge link and calculate the cost. This process used to calculate for the expenses which are identified as Storage.
For each move, system will compare with the tariff setup and calculate the accruals. For any exceptions, if any details not available system will show the appropriate error messages during cost calculation as shown below.
User can double click on the remarks in order to see the full error message details as shown below. After correcting the setup, the calculation can done again. Once the calculation is done, user can commit the calculation. Error transactions can be corrected and process again to calculate the accruals.
Estimation Query(Cost):
Using this query user can view the calculated accrual details as shown below, it will show all the details for each container movement.
User can also view the applicable taxes by clicking the <tax> button and the following details will be displayed.
Also once the Supplier invoice processed based on the accrual, user can view the accounting details by clicking the <Accounted> button as shown below.
E3(Laden) and E4(Empty) Report:
For E3 and E4 reports, user needs to make the report grouping by linking the charge codes belongs to Laden and Empty storage separately as shown below. Also they can identify the order in which the charge codes should appear in these two reports.
E3 Report Setup:
E3 Report Output:
E4 Report Setup:
E4 Report Output:
Supplier Invoice Based on Estimate
Using this process user can post the supplier actual invoices against the accruals, system will update the accrual details and post to the respective vessel voyage as shown below. Also user can generate the comparison reports for Actual versus Accrual.
User can select the Vessel, Voyage, Port, Container and Charge code, these all not mandatory parameters. System will bring the pending accruals and allow the user to select the transactions. System has a facility to book partial amount and greater than the accrual amount calculated in the system. Such entries can be viewed using the comparison reports.
AP Voucher Query:
User can view the supplier invoice posted in the system using the AP Voucher query as shown above, it will also show the taxes wherever its applicable.
AP Voucher:
Journal Voucher:
Voyage Ledger:
______End of Document______