π Backend SMS Module - Ability to distribute SMS messages from VisViva ecosystem.
π New Community Module - Added new module to the platform called 'Community'. The first new page of the Community section is called 'Announcements' to handle customer communication within VisViva.
π Terminal & Hedge Financial Forecast - Added two components to the Position Dashboard to show terminal cashflow forecast and hedge financial position in aggregate.
π Inventory Forecast Tool - Ability to forecast inventory levels based on scheduled rail car receipts. Used to calculate terminal capacity for rail car switches.
π Fix Contract String Parsing on External Systems Sync
π Allow Supporting Documents to Be Uploaded on Digitally Executed Contracts
π Dismiss Status Update on Contracts That Have Not Been Activated - A contract with a status of DRAFT that is revised will not increment the revision number or update the status to REVISED
π Counterparty Billing Contacts Edit - Fixed a bug where billing contacts were not populating on the Counterparty Edit Wizard.
π Dashboard Report Permission Filtering - Fixed a bug where dashboard reports were not limiting access by user permissions.
π NACHA File Generation on Invoice Details Page - Added capability to generate a NACHA file for a single invoice within the Invoice Details Page action button. To access, click the "down arrow" on the actions button in the top-right corner of the page header.
π Transactions Searching β Ability to filter transactions using a contract that has already completed. Before the search was limited to βACTIVEβ contracts.
π Derivative Terminal Details β Added the associated terminal to the Derivative Details page.
π Terminal Filter for Transactions Page β Ability to search/filter transactions by terminal.
π Bulk Settle Invoices β New βInvoice Settlement Wizardβ to allow for Erin to bulk update invoices.
π Automatic Invoice Settlement Reconciliation β Invoices for customers enrolled in ACH payment processing will automatically be marked as PAID to update credit utilization on their due date.
π Contract White Screen on Previous βClickββ For contract revisions, when a user clicked the βpreviousβ navigation button to the Contract Details step, the system would error out and produce a blank screen.
π Unable to Download Contracts on Mobileβ For mobile devices, the button to download a contractβs supporting documents was invisible.
π Contract Supporting Document Upload on Mobileβ For mobile devices, they were unable to upload documents.
π Transaction Details Input on Mobileβ Mobile devices were unable to update transaction details.
π Create Transaction Pop-up Distorted on Mobileβ Mobile users were unable to add transactions.
π Invoice Due Date Overrideβ The Invoice Details page now allows for invoices in a βDRAFTβ status to have their due date overridden by a user.
π Invoice Template Changeβ Amended the contract template.
π Contract Rolling For Date-range Gapsβ As mentioned above.
π Revision Modal on Contract Details β A new feature to interactively view the history of a contract by revision. You can access it by clicking on the βR-#β text on the Contract Details page. Note: only works if a contract has been revised. Example of contract David and I revised last night: VisViva | Contract: BM-22052 (blacklinemidstream.net)
π Contract Supporting Documents/File Uploadβ Added the ability to upload additional documents to a contract. Use case for this is to allow Jennifer to add additional documentation related to a deal after the contract has been activated.
π Optimized Position Dashboard Server Query β The Position Dashboard page load times have been excessively high due to a large number of queries against the database when calculating a contractβs unrealized margin. The optimized query moved the unrealized margin algorithm to the database to reduce the number of queries from [# of Contracts] O(n), to 2. The optimization was a huge success! The response time of the query reduced from 15-20 seconds to 800ms-1s. You can see in the attached screenshot the immediate reduction in response time for this page when the update was pushed. The large number of database calls accounted for 10s of execution time, with the optimized version the database calls account for 50ms of processing time.
π Fixed Financial Swap (Derivative) Exposure Logicβ Derivatives were showing the incorrect volume exposures for buys and sales. The logic just needed to be swapped.
π Optimize Position Dashboard Server Query (Almost complete) β The Position Dashboard page load times have been excessively high due to a large number of queries against the database when calculating a contractβs unrealized margin. The optimized query will push the unrealized margin algorithm to the database to reduce the number of queries from [# of Contracts] O(n), to 2. This is expected to reduce the Position Dashboard page load time from 15 seconds to less than 1 second, a ~15X improvement. This performance improvement has taken up most of the development time for 11/16, around 10 hours, and is expected to be complete 11/17.
π Position Information by Broker β The new βBrokersβ page now displays the number of βOPENβ positions, as well as the net volumetric position Blackline has with the broker.
π Fixed Invoice Due Date Calculation Logicβ The calculateInvoiceDueDate function was configured to roll invoice due dateβs forward, not backwards. Noticed by @Erin and @Jordan when generating invoices where their due date fell on Thanksgiving.
π New Invoice Aging Report β New daily report to mirror QB invoice aging report for easier system reconciliation.
π Transactions Now Searchable β Transactions are now searchable using the VisViva Search button in the header.
π Broker Functionality for Derivatives(Large Update) β Added the capability to create βBrokersβ in the system with Commission Rates. Brokers can now be selected when entering a Derivative. Will be used to generate commission rate reports, as well as sort Derivatives by Broker across VisViva.
π AC2 Fixed Inventory API Endpoint for Providenceβ The TPVision database at Providence was missing a required field in the Tank table for the /Tanks API endpoint. VisViva automatic inventory reconciliation service now working with both facilities.
π Fixed Valuations Component Text Colors β The valuations component on the Contract Details page was showing the incorrect text colors for purchase contracts.
π New Liftings by Price Method Daily Report β New daily report for David to manage fixed vs. float positions.
π Fixed Hedge Physical Position Component β Table was not showing all hedge positions. All positions now show on table.
π Automatic Derivative Position Closing Service β New service to automatically close hedge positions on end date when they βroll offβ.
π Fix Contract Back-date Bug β Fixed a bug where the Pricing Dates section on contract creation wizard was not allowing previous dates to be selected for contract scheduling.
π Fix Contract Wizard Input Sizing β Fixed bug on smaller displays that caused input field data to be cutoff (Reported by @Paul)
π Added Support for Derivative Notifications β Added support for derivative updates to the notifications service.
π Optimized Daily Dashboard Loading β Optimized the code for Daily Dashboard. Reduced page load times by ~50% (Previously averaged 900ms, now 450ms)
π Skeletal Loading on Daily Dashboard β Improved UX for page loads on Daily Dashboard. Now shows a βSkeletonβ loading page when fetching data.
π Added Terminal to Derivatives Page β Replaced the βEntityβ column in the Derivatives Page table with the associated terminal.
π Optimized Contracts Page Loading β Optimized code for the Contracts List page. 10X performance improvement. (Previously averaged 400ms, now 40ms)
Automated Terminal Inventory Updates β VisViva is now able to automatically fetch inventory levels from TPVision. Inventory gain/loss adjustments in VisViva will automatically occur at 02:00 ET daily, starting Saturday (tomorrow/tonight). The goal is to have automated inventory reconciliation occur at 00:03:59(12:03am) ET.
Invoice Due Date Override 90% Complete - @Erin The ability to override the system generated invoice due date is near completion. There is one bug that needs to be resolved, once resolved the feature will be included in the next version of VisViva. ETA: tomorrow afternoon.
New Database Index for Contracts Page β Added an index for the default filters on the Contracts page. Expected to drastically improve page load times. Current load times are averaging 750ms-1.2s.
New Database Index for Job Services β Added an index for the default search filters for the job service manager. Expected to reduce job service cycle times.
New Database Index for Inventory Entries β Expected to reduce Inventory Entries page load times.