Commodity Business Operation Lifecycle
Advisory

Advisory Services

Business Process Optimization

Energy Risk Management

Software Selection

Program Management

Renewables

Power Purchase Agreement (PPA) Management

Data Enablement Analytics
Data Transformation

Data Driven Success

Data Transformation

Analytics & Reporting

Database

Analytics & Reporting

Managed Services

Allegro

RightAngle

Other CTRM Products

Expertise on Demand

Allegro

RightAngle

Other CTRM Products

Testing Services

Testing Services

Business Process Outsourcing
CTRM Journey

CTRM Journey

CTRM Training

CTRM Implementation

CTRM Implementation

CTRM Upgrades

Allegro

RightAngle

Other CTRM Products

ISO Services
Life At ValueCreed

Consultant's Journey

Culture

Employee Training
Programs

Wellness

Entrepreneurship

Learn by Example

Workcation

Gaming Zone

Client Training

Client Training

Careers

Careers

Digital Transformation

Cloud Services

Intelligent Automation

Boosts Efficiency and Flexibility

RightAngle Customizations for Inventory Reporting Process

Enhance Inventory Management with RightAngle Customizations

Looking to view and analyze live inventory data across multiple terminal locations?

With RightAngle customizations, you can now streamline the inventory reporting process by creating multiple reports that provide users with comprehensive insights into their inventory positions. The real-time reporting capabilities of our customizations help to proactively manage inventory positions and mitigate any potential risks. Users can now quickly view and analyze the live inventory data across multiple terminal locations, which is further drilled down to the tank level, which enables better-informed trading decisions and improves operational efficiency.

Pre-Customization Challenges

Manually comparing the terminal inventory data with the inventory transactions in the RightAngle recon groups.

Updating the physical inventory maintenance with inventory balances from various storage facilities at multiple locations.

Reconciling inventory transactions in the Recon groups requires multiple dedicated resources to compare data from various sources, including terminals and 3rd party applications.

Inventory data from different reports were being copied/exported from the RightAngle by the users into an Excel sheet manually daily.

Value Creed's Diverse Customization Solutions

Customized jobs and reports help to make the inventory management process more efficient by providing the users with the necessary inventory data in a timely and accurate manner. The custom reports eliminate the need for manual searching and sorting through multiple reports, saving time and reducing the risk of errors. They are designed to automate inventory updates, ensuring that the data is accurate and updated, reducing the risk of missed trading opportunities and operational risks.

Below are the custom jobs that can be developed for the users which can streamline the BUSINESS PROCESS immensely:

Custom Physical Inventory Balance jobs in RightAngle automate the input of daily tank readings, saving time and reducing errors. They calculate total volume accurately for specific products, locations, and deal details. Bottoms readings prevent tank levels from dropping too low, ensuring smooth operations. The Recon Tool enables efficient month-end closing by reconciling inventory. These jobs can import inventory data from different file formats, enhancing their versatility. Overall, they improve inventory management, streamline processes, and increase accuracy in RightAngle.

The custom job, Terminal Inventory, streamlines the import of terminal data files into the RightAngle system. It automates the process by receiving the data file, handling various formats, and importing it into a staging table. The data is validated and a .csv file is generated with valid BOL information. This file is used for inventory reconciliation. The automation saves time, reduces errors, and eliminates the need for manual data import.

The Terminal Inventory Recon job compares terminal movement data with inventory transactions in RightAngle. Previously, relying solely on RightAngle calculations led to discrepancies between displayed and actual inventory data. This manual process was time-consuming and error-prone. The custom solution automates the import and comparison of terminal data with inventory transactions. Discrepancies are flagged as “Disputed,” and missing transactions are labeled as “Missing.” This process saves time, reduces errors, and enables users to resolve discrepancies for accurate month-end inventory closing, resulting in cost and time savings.

The Auto Agree custom job automates the process of marking inventory transactions as agreed in recon groups, eliminating manual work for users. It compares terminal data with recorded transactions, marking matches as agreed and discrepancies as disputed. Missing transactions are deleted once their relevant BOLs are available. Previously, manually marking transactions was time-consuming and overwhelming. The Auto Agree job saves up to 4 hours of daily manual work, reducing resource costs. It improves accuracy and speed in month-end closing activities, ensuring a balanced inventory.

Configuring the core report distribution task, the distribution of inventory-related reports in RightAngle can be streamlined. Users can now receive the reports in the format they prefer, without having to manually export and save them for analysis. The task automatically sends the reports to users via email and saves a copy in a shared folder at specified intervals, saving a significant amount of time and effort.

The custom 3rd Party Inventory outbound job sends the inventory data such as the quantity, schedules, WACOG value, and more details from RightAngle to a 3rd party tool in a certain format that is accepted by the tool. This helps the users to maintain their data across multiple tools to aid their business. Depending on the number of transactions this can save 6 to 8 hours daily and avoid any manual errors and discrepancies.

Below are the custom reports that we have developed to streamline the INVENTORY MANAGEMENT in RightAngle for the business:

The Physical Inventory Balance Report provides an overview of the tank-level inventories that are interfaced with RightAngle through the Physical Inventory Interface. The report is generated by an aggregation task that sums up all tank readings for a given product, location, and deal detail, which are then stored in the Physical Inventory Maintenance report. 

This report also displays the estimated inventory at the end of each day, which the workbench calculates based on schedules for specific deals and the type of transaction (buy/sell).

The Terminal Data Staging Interface report retrieves data from the terminal inventory jobs and imports it into RightAngle with complete, error, and invalid status. This report serves as a filter to ensure that only valid files and data are imported for inventory reconciliation. 


The staging table ensures that only the valid BOLs are imported and that users are presented with relevant data in the main report. This helps to minimize clutter and streamline the reconciliation process while ensuring that data accuracy is maintained.

The Search Terminal Inventory Recon Interface report is a crucial tool for users to maintain a balanced inventory. This report compares the net quantity of terminal data with inventory transactions and updates the inventory recon status as missing, unreconciled, agreed, or disputed. 

 

Key Results

Value Creed’s proposed solutions can make the current process efficient for the users by reducing manual efforts, improving accuracy, providing timely information, empowering better decision-making, and generating cost savings for the business.

Automation of Processes

The automation of various jobs and reports has led to a significant reduction in manual efforts. our custom solution will save up to 90% of the time when compared to manual intervention needed for importing, exporting, and comparing the inventory data across multiple systems for correctness.

Improved Accuracy

The automated jobs and reports ensure that the data is accurate and up to date. This helps in avoiding manual errors and discrepancies that can be costly for the business.

Decision Timeliness

The reports provide users with timely information about inventory balances, terminal data, and inventory reconciliations. This helps in making informed decisions and taking corrective actions and users to make better business decisions.

Decision Timeliness

The reports provide users with timely information about inventory balances, terminal data, and inventory reconciliations. This helps in making informed decisions and taking corrective actions and users to make better business decisions.

Value Creed Services Deployed

Value Creed provides a comprehensive range of services to deliver a one-stop solution that meets the client’s needs and improves their business processes.

Solution Design

Creating a solution design that meets the client's requirements and incorporates best practices for optimal performance.

Data Integration

Integrating data from multiple sources and developing data integration solutions to ensure the accuracy and completeness of the data.

Key benefits

Custom Reports & Jobs Development

Developing custom solutions in the RightAngle tool to automate and streamline the client's business processes.

BPO

Project Management

Managing the project and ensuring that it is completed on time, within budget, and meets the client's requirements.

Business Analysis

Understanding client requirements, gathering information, and analyzing data to identify improvement areas.

Quality Assurance & Testing

Ensuring the quality and reliability of the developed solutions through rigorous testing and quality assurance processes.

Recommended Resources

Ready to get started?

Explore our suite of solutions designed to empower your trading and risk management functions. Partner with us for a transformative CTRM experience that drives success in today’s ever-evolving markets.