Conventional manual methods and third-party systems might not provide the needed real-time accuracy for inventory costs and valuation. Additionally, calculating costs for individual units of inventory, especially within a range of contracts, can be time-consuming. The introduction of RightAngle’s latest version, S21.1, featuring the Daily WACOG by Contract capability, addresses the need for accurate, real-time inventory valuation.
Unlike traditional methods that struggle to reflect daily commodity price fluctuations, the new feature in the latest version of RightAngle closely aligns inventory valuation with market dynamics, benefiting businesses with high daily sales volumes. Implementing inventory valuation methodology of WACOG in an integrated system like RightAngle streamlines inventory management and enhances risk and accounting practices. We recommend that our clients embrace RightAngle’s WACOG method, as it offers a comprehensive remedy for efficient inventory management. This solution capitalizes on industry-specific attributes, tailoring options, and alignment with regulations, all of which combine to enhance effectiveness, accuracy, financial gains, and competitiveness.
Challenges in managing inventory costs accurately are widespread. Manual methods can lead to inefficiencies, errors, and compliance risks that affect decision-making. The absence of real-time inventory data visibility can hamper competitiveness, and the complexities of calculating costs for liquid products are a recognized concern.
Current complexities involve disjointed systems, manual calculations, lack of integration with workflows, and the inability to capture frequent price fluctuations inherent in liquid commodities, which ultimately leads to inaccurate cost estimates. Additionally, the continuous flow nature of liquid commodities makes precise inventory tracking difficult, as factors like shrinkage, blending, and measurement inaccuracies can lead to discrepancies in quantity and cost assessments. Managing inventory across various storage facilities, determining appropriate pricing points for cost allocation, and adhering to regulatory standards further contribute to the complexity of the process.
Commodity companies will employ specialized ETRM software and other peripheral systems to address some of these challenges however even then other issues like maintaining data integrity, resource-intensive inventory data updates, error-prone reconciliation processes, and the manual marking of transactions are prevalent in accurately tracking inventory costs and value.
Selecting RightAngle for implementing WACOG inventory valuation for liquids commodities offers several advantages over other ETRM solution alternatives. The integration of WACOG modeling into RightAngle is customized to suit the business’s needs, utilizing the platform’s robust reporting capabilities. This encompasses features like contract-based cost tracking, flexible pool-based cost calculations, and daily WACOG reports for precise cost insights.
To maximize the utility of RightAngle’s inventory valuation capabilities, we recommend crafting bespoke reports within the platform that consolidate diverse inventory data points. By doing so, businesses can streamline their inventory management processes effectively. A notable case involves our creation of tailored reports for a client within RightAngle, where we amalgamated data from various sources. For instance, this approach integrated information from multiple reports, yielding insights into tank-level inventory through the Physical Inventory Interface. This encompassed valuable details, including estimates of daily end-of-day inventory. Furthermore, our solution seamlessly incorporates the Terminal Data Staging Interface, which validates terminal data to facilitate reconciliation. Moreover, the Search Terminal Inventory Recon Interface was utilized to meticulously compare terminal net quantity against transaction records, ensuring the continual updating of reconciliation statuses to promote a well-balanced inventory control system.
Additionally, RightAngle solution provides risk assessment via daily WACOG risk mark-to-market reports. Notably, the “Use Zero Values to Market for WACOG” function refines inventory valuation accuracy. Additional advantages include prior period adjustments, efficient accounting, seamless system integration, tailored reporting, and real-time data access for adaptive decision-making. This tailored implementation ensures accurate cost management, risk assessment, and reporting while catering to the client’s distinct operational requirements.
We advise clients to focus on unique business contexts and leverage RightAngle’s specialized capabilities in WACOG by contract, WACOG by pool, and Daily WACOG calculations. This tailored approach, aligned with industry best practices, sets our recommended implementation of RightAngle features apart from other available options and ensures that it precisely meets the client’s current situation and needs.
The utilization of RightAngle for WACOG implementation for an organization brings a multitude of advantages, specifically tailored to meet the unique needs of the liquid energy industry:
WACOG by Contract provides detailed cost insights for better financial control. WACOG by Pool offers market-responsive cost calculations.
RightAngle recalculates daily WACOG, aligning cost structures with market fluctuations. Crucial for industries like retail fuel, ensuring accurate decisions and risk management.
RightAngle's customization aligns tools with business goals, enhancing performance without compromise.
Seamlessly integrating RightAngle optimizes data flow, boosting efficiency across functions.
Leverage specialized WACOG reporting for real-time informed decisions and market competitiveness.
RightAngle tailors to client needs, offering a dedicated team for success. Partner with experts for a comprehensive solution that drives success.
Let Us Know
When migrating from PowerBuilder to the .NET version of Right Angle, there can be several challenges that arise for reports, especially if they involve heavy use of PIVOT, filtering, and data structuring in PowerBuilder, along with landscape/portrait orientations. The challenges primarily stem from the differences in the underlying technologies, programming languages, and reporting frameworks used in PowerBuilder and .NET.
Migrating PowerBuilder reports to the .NET version of Right Angle presents several challenges due to differences in technologies, programming languages, and reporting frameworks. Understanding these challenges is essential to ensure a successful migration process. In the following section, we will explore the key challenges that arise during this migration and how Value Creed, a trusted expert in report migration, can provide expertise and solutions to overcome these challenges.
Challenge:
Our Expertise:
Challenge:
Our Expertise:
Challenge:
Our Expertise:
Challenge:
Our Expertise:
Challenge:
Our Expertise:
Challenge:
Our Expertise:
To gain insights into the challenges that can arise when migrating from a PowerBuilder version of a report to a .NET version, let’s explore a practical scenario:
One of our clients, who was using RightAngle’s S11 version, relied on a highly customized report created in PowerBuilder. This report held significant importance for their schedulers as it was distributed to them on a daily basis.
Here’s an overview of the customized PowerBuilder report:
The PowerBuilder version of the report was designed with intricate features such as complex pivoting, grouping, and filtering logic. It operated on a dataset that included several query columns. Additionally, the report was formatted in landscape orientation.
The objective was to replicate the same report with its familiar appearance and functionality in the upgraded S21 version. However, when attempting a straightforward migration of the report’s backend logic to .NET, the outcome fell significantly short of the expected outcome.
Value Creed’s proficiency in report migration proves invaluable in this scenario. Our team of RightAngle SMEs took charge of customizing the .NET version of the RightAngle report using the report designer tool. With their expertise, they made extensive modifications, leveraging various features including computed query columns, external query columns, dynamic queries, and the available UI tools.
The end result was a meticulously crafted report that closely resembled the original one from S11.
Migrating PowerBuilder reports to the .NET version of Right Angle poses several challenges due to differences in technologies, languages, and reporting frameworks. Value Creed’s expertise in report migration is invaluable in overcoming these challenges. Through extensive modifications and leveraging the capabilities of the .NET reporting framework, our team of RightAngle SMEs successfully customized the .NET version of the report for our clients.
Let Us Know
When embarking on an upgrade, it is crucial for clients to dedicate an upfront focus to their business prerequisites and how these align with their overarching vision for operational longevity. Rather than treating the upgrade as a purely technical necessity, businesses should view it as an opportune moment to reevaluate their overall objectives, strategies, and aspirations.
During a recent upgrade, a prominent midstream services provider company endeavored to migrate and disseminate reports to end users in the familiar format as before. However, our team of RightAngle experts were able to recognize that given the architecture redesign of S21, the reports would not generate in the exact format and cause significant disruptions to daily operations.
Despite time constraints surrounding the S21 migration, Value Creed adeptly undertook the project, not only addressing the immediate requirement but also ensuring a seamless migration of these critical reports. This endeavor safeguarded the planned S21 transition and precisely catered to the client’s needs.
Successful migration of the Mark-To-Market (MTM) report
Implementation of a versatile and customizable reporting system
Smooth and uninterrupted transition to S21
Collaborating with the client to conduct an in-depth evaluation of their business prerequisites in conjunction with their envisioned future state helped elevate the upgrade from a mere technical chore to a strategic initiative. This empowered the client to adapt, innovate, and thrive in a dynamic business landscape.
Before delving into the developmental, testing, and deployment phases of the migrated reports, our team took comprehensive measures to align on the requisites. Despite working within a tight timeframe, we ensured a thorough comprehension of project specifications prior to advancing to the subsequent stages.
Our Advisory services will not only help you guide your operations but also help you achieve your vision by taking all stakeholders into consideration. With our services, you can confidently evaluate your decisions before implementing any technical changes, unlocking multiple benefits from our comprehensive solutions.
Our team is made up of industry-leading CTRM experts who help you model new business requirements to ensure a future-proof setup. Our commitment to CTRM technology is reflected in our upgrade services, which empower you to customize and enhance performance. Our primary focus is to optimize functionality across the board, aligning with market demands through a holistic solution.
Our advisory approach entailed an exhaustive evaluation of the business’s reporting strategy, capabilities, and needs, resulting in the identification of new imperatives. Following the design of a comprehensive roadmap, we evaluated the advantages of report migration. Through successful enhancements of the critical “Mark to Market” (MTM) report within the stipulated time frame, we were able to drive increased user adoption with increased usability ensuring a seamless transition to S21.
Contact us today to learn more about our upgrade and advisory solutions.
Performance Challenge A well-known chain of gasoline service stations located across the Southern United States wanted to change CTRM platforms to address new business demands
After a diversified energy company based in New York encountered multiple barriers and challenges in upgrading its CTRM system, it turned to Value Creed for
How Value Creed’s Seamless CTRM Upgrade Powered a Global Energy Company’s Growth Goals CTRM Productivity Gains Enable Trading Productivity Boost When a major natural gas production
Customize & improve business processes with Value Creed’s Services
Have you ever had to build customizations around deferred invoicing, complex risk calculations, or pricing provisions?
Due to the complex nature of the ETRM industry; Risk, Accounting, and Cash Applications rely heavily upon 3rd party tools for functions such as robust inventory valuations, WACOG calculations, and taxing functionalities. The unavailability of these tools in the older RightAngle versions encourages businesses to strongly consider an upgrade to the latest version.
Additionally from an IT standpoint, PowerBuilder or a hybrid system results in Increased Server Load and hampers stability making custom code deployment troublesome. Along with standards to be followed for SOX Compliance, the previous security manager doesn’t allow for individual task/ BA security thus increasing risk significantly.
There are numerous benefits to upgrading to the latest version, such as the new Search WACOG by Contract Summary/ Detail reports. This new feature helps reduce dependency on external applications, reduces Human Errors, and provides a better understanding of the company’s Risk Position. This will additionally replace reports such as search inventory values and provide a consolidated report with advanced core fields to facilitate advanced risk calculations.
New ways to customize the risk solution, including quantifying the risk level on the portfolio level and modifying the accounting periods on common reports, lead to increased efficiency and productivity. Dependence on 3rd Party Customizations like deferred invoices and unique auto matcher scenarios for business needs can now be handled with core functionality in the latest version.
Inventory Valuation processes have more advanced logic, allowing them to utilize the WACOG calculations set for the particular transaction.
Daily WACOG by Contract is a new inventory valuation method available in S21.1. When accounting for inventory, Daily WACOG considers the fluctuations in commodity prices as new builds enter storage for each business day. The actual cost of inventory recalculates daily, and the cost of product sold out of inventory is priced at the inventory’s weighted average on the day of the draw. This allows Daily WACOG to more accurately reflect the value of sold products each day and benefits the accounting and risk practices (protects risk metrics from distortions due to high market volatility over time) of certain businesses, like retail fuel, which experience high daily sales volumes.
The module integrates with the accounts payable and accounts receivable modules in RightAngle, allowing businesses to manage bank information and view a cash available report that includes information on receivables from invoices. This helps to validate records and prevent the application of more cash than the receivable total amount or balance of cash received. Additionally, the module provides tools for creating write-offs and managing open items effectively.
Some of the key functionalities included in the RightAngle Cash Application & Disbursement module are:
Allows for increased capabilities around managing at the tank level and ensures the Tank Level information in the IWB header section and columns in the grid that contain tank level information or consider heels in their calculation (Pumpable Inventory, Heels/Unavailable, Tank Minimum, Tank Maximum, Projected Available Ending) are accurate when aggregating
Credit/Rebill configuration processes have been automated now for Sales transactions.
System updates to the invoicing processes/Reports to better utilize and track Deferred Invoices in the application.
The transition from PowerBuilder to .NET is tied closely to the increase in performance/stability. It enables a user-friendly interface and more sound core logic. The addition of .NET code allows users for easier customization/code deployments
This feature allows you to grant users specific licenses to unique models (such as credit centers) without giving them the full core license. This not only saves money on the number of core licenses needed but also will help regulate the available data to these users
Each new version of RightAngle that is released brings with it enhancements to core logic, more efficient processes, and improved technology to increase the performance (speed) and stability (uninterrupted sessions) of the application.
This item allows security access for individual Task Scheduler tasks to be given to groups. This way, only specific users can run critical tasks such as snapshots, alleviating a lot of risk of accidental runs by less familiar users.
Individual security settings for all internal business associates, which allows users to be part of singular or multiple groups. This is a critical item for SOX compliance, as well as other regulations on data access.
Transactional data, having so many variables involved, is a large chunk of available database space. Being able to archive this data will increase system performance by not overloading the databases, leading to quicker queries, increased database longevity, etc.
(Integration/performance testing)
Migration of all customizations
end-to-end quality checks, documentation, etc
Let’s Us Know
Training is integrated from inception to the end of the project. We engage the users in training during phases 1 and 2 of the upgrade process. Our team will work side by side with the users to validate the system, and provide informal one-on-one training as well as knowledge-sharing sessions, essentially helping the users “learn by doing”.
Just as testing does not begin with UAT, training does not begin with UAT. During the Upgrade Assessment phase, we establish a collaborative culture with the message, “Endur expertise is on site, feel free to engage with your questions about Endur.” We engage the users during phases 1 and 2 of the upgrade process. In addition to the training embedded in our methodology, formal training at the start of UAT is provided. We edit our training materials to use actual examples to provide a meaningful training experience. The training experience does not end at go-live.
The training approach has four elements to execute training. The first element is Training Plan & Documentation. During this, a training plan is developed based on the impact assessment and changes. The second element is testing the training material and identifying individual training needs and deficiencies. The third element focuses on training delivery, where the training participation is tracked. The last element is about refreshing and reinforcing training which details additional training if required.
Our Hyper Care team will ensure that your users are trained in any new functionality or changes to the system. It’s a support phase that follows immediately after the Upgrade Go-Live to ensure seamless adoption.
Leverage a partner with best-in-class functional and technical expertise to manage and deploy your upgrade on time and on budget.
This blog summarizes the enhancements made to the user interface of Allegro Horizon’s crude, NGL’s and refined products functionality and help users understand the various benefits of moving to the .NET core version, where in the logistics data gets valued in Valuation and Net Valuation that enhances performance significantly ensuring more consistent results.
The Logistics UI has been powered by various subsets of UIs to get information
Since the UI has been equipped with various parameters, users have easy access to the information like:
Improved locational hierarchy enabling users to track Locations, Sub-Locations, and Tanks in a hierarchical manner. Users can also set up to mirror the physical and logical organization of customer assets, delivery locations, and receipt locations.
More efficient and user-friendly scheduling around pipelines and in handling high-volume truck operations.
Realtime Position and P&L Reporting with automated line/transit loss and gain recognition helping users avoid manual errors.
Manage multiple inventory types within a tank with the ability to assign tank types like Lease, Storage, and Blending.
Better Exposure Reporting with an improved ability for users to execute aggregate hedging across high-volume liquid operations with complex pricing.
Enhanced net valuations for individual tanks without having the tank set up as its own location allowing a better understanding of inventory costs and value across time periods.
Separation of Tank/pile capacity, volume, and inventory tracking specifying tank capacity, liquid volume, and what portion of liquid volume has to be tracked and valued as inventory enabling users to deal with market disruptions.
The complexity and volatility of the crude and refined markets require traders and marketers to have real-time information supporting their unique trading requirements. Value Creed’s expertise in CTRM implementations and upgrades can help you leverage the new and updated functionalities allowing the maximum benefit for trading and risk management functions.
Leverage a partner with best-in-class functional and technical expertise to manage and deploy your upgrade on time and on budget.