Support : User Guide
Operations : Inventory
Inventory Tracking

To enable inventory tracking, go to Operations and then to the Voyage/MTM Group tab.

CoreTRM is able to keep track of inventory in a storage tank. The system uses MTM Group to track inventory. To start tracking Inventory, you can start from Operations and search for the MTM Group of the buy deal that will be loaded to the Storage Tank.

For Example, we have a Physical Buy deal of $250,000 BBL.

Operations Inventory Voyage/MTM Group

From Voyage/MTM Group, click Pencil Edit Button and check the box Track Inventory. In addition, you can also rename the MTM Group to the storage tank name and click Save Button button.

*For month end tracking purpose, it is recommended to rename MTM Group to storage tank name + month and year.*

Operations Inventory Voyage/MTM Group Update

Go to Inventory tab of the MTM Group that you have enabled inventory tracking. From here, you will now be able to see that an inventory record has been created. In this example, we have received 250,000 BBL into this storage tank.

Operations Inventory tab

Next we can start selling the inventory quantity. We can do this by matching (or dragging) the sell trade MTM Group into this Inventory enabled MTM Group.

1. Identify the sell trade. For example, below is a sell trade of 100,000 BBL to ARAMCO TRADING.

Operations Inventory Sell Trade

2. From the transactions tab of the sell trade, hold and drag the transaction to the MTM Group of the Inventory enabled MTM Group.

Operations Inventory Sell Transaction

Operations Inventory Sell To MTM Group

3. Once you have drag the sell transaction to the inventory enabled MTM Group, go back to the Inventory tab of the inventory enabled MTM Group. From here you will be able to see a new discharge record of 100,000 BBL from the storage tank.

Operations Inventory Buy Sell

In addition, you will be able to see that the system automatically calculate both the "Weighted Average Price" and "Moving Weighted Average Price".

Create Inter-Tank Transfer

You are able to create transfer between 2 storage tank using the inter-tank transfer function.

1. Go to the Inventory tab of the MTM group that you wish to transfer quantity from.

2. Click on Inter Tank Transfer Button.

3. From the pop up, select the date, Buy or sell, the target MTM Group(Inventory), Quantity, units, contract ref and contract type. Then click Create ITT Buttonbutton.

For Example, Transfer 10,000BBL to MTM Group "SG Terminal 3" using contract ref "transfer01".

Operations Inventory Create ITT

After the transfer, the inventory tab will create a discharge record of 10,000BBL.

Operations Inventory After ITT

Close Tank at Month End

You are able to close each tank at month end. Techincally, Closing the tank month end will be the same as inter-tank transfer. So that you move all the quantity to a new MTM Group for another month. So it is recommended to name your MTM Group with the storage tank and the month/year.

To close the inventory at month end, click on Close Tank at Month End Button.

From the pop up, select the date, Buy or sell, the target MTM Group(Inventory), Quantity, units, contract ref and contract type and then click on Create ITT Button button.

For example, closing the "SG Terminal 3 Aug 22" tank(MTM Group) and transfer the balance to "SG Terminal 3 Sep22" tank (MTM Group).

Operations Inventory Close Month End

Revalue Inventory

You can revalue the inventory, by clicking on Revalue Inventory Buttonbutton.

The system will revalue the inventory using the latest updates including price changes.