How do you import projects through IBM TRIRIGA integration?


Does anyone have experience in project integration (data transfer) from an external existing project through any IBM TRIRIGA integration module? Our templates and mapping have been identified, but the question is about reproducing the overall standard when a project is created. This seems hard. In order to have this project consistent in TRIRIGA, we think that we need to be consistent with the following:

  • Project and direct associations with business objects in perimeter
  • Associated purchase orders
  • Budget and their associated cost codes
  • Financial data and their associated computation

Any help and experience would be great, even if the answer is it’s too hard.

Without detailed knowledge on the user’s part, such as a fundamental knowledge of all of the application functionality, it would really be best to engage IBM Services to implement this integration. It’s not impossible, but it really would need a lot of care.

Continue reading

Advertisements

Can anyone help with TRIRIGA FileNet integration issues?


We have an IBM-hosted environment that will be connected to an IBM-hosted FileNet instance as the CMIS. After configuring everything, the connection is established and the containers are created in FileNet, but the actual file is not uploaded. Has anyone been able to have this integration work in their environment? Here is a snippet of the error log when CMIS integration is active…

This was most likely due to a misconfiguration on the TRIRIGAWEB.properties or CMIS side. TRIRIGA supports the CMIS 1.1 standard. IBM TRIRIGA can be configured to store documents in Enterprise Content Management (ECM) systems that support the Content Management Interoperability Services (CMIS) ECM gateway Version 1.1 of the CMIS standard, as established by OASIS.

These gateways are specific to the vendor of your particular ECM and should be installed accordingly, if one does not already exist in your organization. See the Support Matrix. IBM FileNet adheres to the CMIS 1.1 standard. So, as long as the FileNet version has support for 1.1, it is supported by TRIRIGA.

[Admin: To see other related posts, use the CMIS tag or ECM tag.]

Continue reading

Can anyone help with extracting data via Oracle SQL Developer?


Does anyone have any experience in extracting TRIRIGA data from the database directly through Oracle SQL Developer? I am trying to extract through SQL code, and combine in one table, the data from triSpace, triSpaceClassCurrent, and triSpaceStandardsSpec. The idea is to create a single table with all spaces, space classifications, and space standards.

[Admin: To see other related posts, use the Oracle tag or SQL tag.]

Continue reading

How does TRIRIGA tackle 2019 lease accounting change implications?


Are you getting ready to address the implications of the new lease accounting changes with TRIRIGA? Although FASB’s ASC 842 and IASB’s IFRS 16 will take effect in 2019, many organizations are only now beginning to realize the amount of effort required to meet the new standards…

The biggest changes to businesses will be the new Right of Use (ROU) Assets and Lease Liabilities that will hit balance sheets, as well as the intensely manual approaches and effort that many see before them. How many organizations are leveraging Integrated Workplace Management Systems (IWMS) to manage their real-estate holdings and automate these manual efforts?…

In order to help organizations comply with the new standards, and understand the implications of these changes, TRIRIGA continues to deliver a single integrated workplace management system with new enhancements in the next release. TRIRIGA supports the lifecycle of facilities management and will automate compliance activities to address changes that affect multiple teams and roles.

Here’s how TRIRIGA can help:

  • CFO and CAO: The release of IBM TRIRIGA 10.5.3 will provide a sub-ledger system for real estate and asset lease accounting that is able to generate journal entries out-of-the-box for ASC 840 and ASC 842 under US-GAAP as well as for IAS 17 and IFRS 16. It also covers period closings and report generation for the most common reports required under the new standards.
  • Real Estate and Fixed Asset Managers: The release of IBM TRIRIGA 10.5.3 separates the duties of a lease administrator and a lease accountant, allowing the lease administrator to enter contractual information, and then enabling the lease accountant to run classification tests, reassess lease decisions, and report on the ROU Asset and Lease Liability.
  • Facility Management, and Occupants: There are also new capabilities to improve day-to-day and occupancy experience. They can leverage a new Workplace Services offering that engages everyday employees through new mobile web apps that provide access to services managed by IBM TRIRIGA, anywhere, and on any device. This includes: a new Service Request app to submit work requests, a new Reservation app to quickly create reservations for individual workspaces or multi-attendee meeting rooms, and a new location-aware Workplace Services Portal to provide a single, unified access point for launching the apps and tracking status of requests…

[Admin: To see other related posts, use the FASB tag or IFRS tag.]

Continue reading

Verdantix: Who are benefiting from the changes in lease accounting?


In early 2016, the US Financial Accounting Standards Board (FASB) and the International Financial Accounting Standards Board (IASB) issued new lease standards, which require companies to include lease obligations in their balance sheets. The new standards take affect 1 January 2019 and will impact all companies that have leases for real estate or equipment and file financial statements…

For many years, IWMS software providers have provided real estate, leasing, and portfolio capabilities, which include modules that integrate details of leases and contracts with existing financial and accounting systems to provide a central database for real estate financial planning and analysis and to create the correct entries for the accounting system. The new FASB/IASB accounting standards bring the spotlight on the role of software in managing leases.

A review of the deals in the public domain shows that providers such as Accruent, Lucernex, and Qube are already swooping in on opportunities to help companies mitigate risk by ensuring compliance to these new leasing standards. In the last few months, Lucernex has announced several new contracts with retailers such as Bouclair, DXL, Bashas’ Family of Stores and Suburban Propane. Accruent has been selected by CTIL, Tillys and Sephora in just the last few weeks. We are also witnessing other IWMS vendors improving their capabilities for accurate lease calculations in accordance with the new lease accounting standards. For example, in April, Planon software received validation from a Big Four accounting firm that its leasing calculations engine was in accordance with the IASB/FASB requirements…

[Admin: This post is related to the 08.01.16 post about the competitors of IBM TRIRIGA. To see other related posts, use the FASB tag or IFRS tag.]

Continue reading

Planon: How can RE managers take control of their RE portfolios?


In principle, every organisation is made up of four production factors: the capital, the people who work there, technology, and information (data). The real estate manager’s role in the organisation is becoming steadily more significant, partly because of the disruptive changes in Corporate Real Estate. One might suggest that real estate can now be regarded as the fifth production factor. How does a real estate manager gain control over his biggest cost item: the real estate portfolio?

Striking a balance

As a new and fifth production factor, real estate plays an important role in your organisation. Did you know that Corporate Real Estate (CRE) represents on average around 20-25% of a balance sheet? That 60% of organisations lack transparency in their real estate portfolios? And that no fewer than 2 out of every 3 real estate managers lack control over their real-estate-related processes? It’s up to the real estate manager himself to make a positive change to these statistics, and to tackle the challenges that lie ahead

The world is changing

From 1 January 2019, publicly listed companies are required to include on their balance sheets any rental contracts that run for longer than a year. With the introduction of the new lease accounting standards, the debt position on your balance sheet could rise by up to 20%. These new regulations therefore exercise a direct influence over your portfolio strategy. Accurate administration, reliable calculations and compliant reports are an absolute necessity. The need to regain control over your real estate will be made all the more urgent by the disruptive changes currently occurring in the world around us…

[Admin: To see other related posts, use the Planon tag or Leases tag.]

Continue reading

IV96178: Initial impairment should not compare FMV with stored FMV


The impairment functionality should start as a comparison between the fair market value (FMV) as entered by the user in the Review Assumptions, and the current amortized cost basis of the right of use (ROU) asset for the selected fiscal line item (FLI) period (i.e. ROU asset value in the FLI for the corresponding fiscal period).

Currently, TRIRIGA is comparing the FMV as entered by the user in the Review Assumption, to the FMV as stored/displayed in the Accounting Summary section of the Accounting tab. The impairment should be triggered when the FMV as entered by the user is less than the ending ROU asset in the corresponding fiscal period.

We needed to fix the impairment comparison against the amortized cost (asset value) for the current and new lease accounting standards. Moving forward, the initial impairment calculation no longer compares with the existing fair market value (FMV). Instead, a change was made to compare against the amortized cost.

[Admin: To see other related posts, use the FMV tag or FLI tag.]

Continue reading