RSS

Customizations May Not Be Taboo Anymore

Posted by

Recently, I met with a customer who was considering implementing a new PeopleSoft module. The attendees included a functional executive, several of her managers, and two IT managers. At the beginning of the meeting, the executive announced that no matter what was decided, she did not want any customizations to the software.

Generally, history and experience have taught us that avoiding customizations are a good policy. Upgrading or updating customized software can be challenging. However, the new features of PeopleTools 8.56 and 8.57 mean that customizations aren’t always an automatic NO. Two new features that give you the flexibility to change the appearance and function of a page are Page and Field Configurator and Drop Zones. They allow you to create custom fields within a page and still easily move to future PUM updates. Below is a brief description of each in layman’s terms.

Page and Field Configurator

The Page and Field Configurator allows you to change the look and function of a page without the need for customizations. It gives you the ability to hide fields or even an entire page that are not necessary to your specific needs. It also allows you to change the look and behavior of any field by changing the field label, making it required, or adding a default value in the field. These changes happen through configuration settings. Therefore, they stay configured during PUM updates making the update process easier.

Drop Zones

Drop Zones give you the ability to add your own fields to delivered Fluid pages without having to customize the component. In simplified terms, a placeholder is inserted into the Fluid page at the time of design. The placeholder is a protected area which allows you to create your own fields which are not impacted with PUM updates. PeopleSoft has already created Drop Zones on many Fluid pages to help with the initial design and implementation.

In conclusion, these are empowering tools which can expand the capabilities of your existing software. Some customers have used these features to reduce the amount of customized software. Additionally, some have used it to add needed functions without customization. This is a very high-level overview of these capabilities. Good, new options now exist for organizations that want to try to eliminate customized software or for those that were opposed to customizations. I encourage you to look at the details of these features.

Please follow this link for an instructional blog on how to use Page and Field Configurator:  https://blog.miproconsulting.com/2018/10/page-and-field-configurator/

Please follow this link for an instructional video on how to use page and field configurator:  https://blog.miproconsulting.com/2018/10/configurator-instructional-video/

To read more about MIPRO Consulting, click here.

My Favorite PeopleSoft Lease Administration Transactions, Part I

Posted by

Welcome! I would like to introduce my next blog series, “My Favorite PeopleSoft Lease Administration Transactions.” With the new accounting rules taking effect this year, I’ve had plenty of opportunity to work with PeopleSoft Lease Administration using PUM 27 to 30 (especially PUM’s 28 to 30 over the past six months). As a consultant and an accountant, I’ve been very impressed with the ability of PeopleSoft’s Lease Administration to effectively handle both complex and routine lease transactions.

Each installment in this blog series will feature a different one of my favorite transactions. My results will be verified through an example transaction accompanied by a detailed accounting walk-though.

Without any further introductions, let’s jump right in!

My first favorite transaction is amending a multi-asset lease to remove an asset. In this example, the number of leased assets is reduced from three assets to two assets. I performed this amendment in two different ways. In scenario #1, I removed the asset as of the current date. In scenario #2, I back-dated the amendment by one month to the prior month. Often in the real world, lease amendments do not get recorded in the system until after the fact. Scenario #2 was designed to simulate this real-world circumstance.

As expected, both scenarios of the amendment produced verifiable results.

For this example, the lease data included:

  • Lease Term – 07/01/2018 – 06/30/2021
  • Payment – $2,800.00 per month before the amendment
    • 3 Assets @933.33per month
    • 100,800 total (36 x 2,800) = 100,800
  • Borrowing rate – 5%
  • ROU Capitalized Cost per asset $31,141.32

As stated earlier, the amendment consists of removing one of the assets from the lease. The amendment(s) were performed on 12/01/2018 in the system using the following two scenarios:

  • Scenario 1 – In December, the lease was amended effective 12/01/2018.
  • Scenario 2 – In December, the lease was amended effective 11/01/2018 (back-dated).

New payment amount after removing an asset $1,866.67 ($2,800 x 2/3).

If we look at the lease when it was created, we can see that the ROU asset balances per asset are $31,141.32.

Below is an image taken directly from PeopleSoft’s Lease Administration. The Lease Administration payment schedule from the base rent page shows the monthly rent and the amortization. Take note that this schedule is for the entire lease and not just for one asset. 

The Excel table I created (shown in the screenshot below) breaks down the amortization by asset in the two right hand columns. I used this offline Excel calculation to verify the results of the lease amendment calculations in both scenarios.

Looking at the Cumulative Obligation reduction column, we see that the balance (as of 11/30/2018) is $4,051.51. This represents the amount of Obligation/ROU reduction on the asset before it would be removed from the lease (using first scenario 12/01/2018 amendment date). We also see a balance of $3,234.45 on 10/31/2018. This corresponds to the amount of Obligation/ROU reduction on the asset (if the amendment was back dated to 11/01/2018 as in scenario #2).

Shown below are screenshots from my PeopleSoft Lease.

  • In scenario #1, using the 12/01/2018 as the effective date, you can see PeopleSoft Lease Administration correctly calculated the amended ROU/Capitalized down to the penny at $4,051.51. This exactly matches the verification amount from my Excel spreadsheet above.
  • Also, in scenario #2, the PeopleSoft amended calculation of $3,234.45 exactly matches my verification amount.

Updated PeopleSoft ROU/Capitalized cost amounts from scenario #1 (12/01/2018):

Updated PeopleSoft ROU/Capitalized cost amounts from scenario #2 (backdated to 11/01/2018):

Seeing how the ROU numbers tied out for both scenarios is why this is one of my favorite transactions in PeopleSoft Lease Administration. Although the transaction was slightly complex, Lease Administration handled it as expected.

Now, let’s look at the payments!

In scenario #1 (with effective date 12/01/2018), you can see the system begins the new lower payment with December.

In scenario #2 (with the back dated amendment of 11/01/2018), the system identifies the November payment was previously made at the higher amount. It corrects November to the lower amount through a credit memo.

In scenario #1 (with 12/01/2018), the new lower payment amount starts with December.

On the other hand, in scenario #2 (with 11/01/2018), the new lower payment amount is back-dated in November with the original higher November payment being reversed out with a credit.

In conclusion, PeopleSoft has done a great job with the details, especially from an end-to-end accounting perspective.  Using my off-line calculations I was able to verify my lease amendment results against the journal entries and the payment information.  It was great to have the audit trail and see all the details!

As always, thank you for reading and be sure to read my next installment in this series & our other Lease Administration Blogs.

Steven Brenner, CPA
Senior Principal Consultant
MIPRO Consulting

Supplier Scorecard

Posted by

The enhanced Supplier Scorecard feature was delivered in FSCM PUM Image 29. It is now possible to define and incorporate Key Performance Indicator (KPI) questions and Weighted Scores into templates and evaluations for a supplier. This enhancement allows you to view and analyze objective and subjective questions with a completed Supplier Evaluation Scorecard. You can […]

2019 Sources of PeopleSoft Info and Networking

Posted by

It might surprise you that organizations are still selecting PeopleSoft as a brand-new solution for their financials, supply chain, and human resources system. These “net new customers” choose PeopleSoft over other options to replace their current ERP systems. Personally, I am aware of two in the last thirty days. The PeopleSoft community continues to be […]

Simple Journal

Posted by

A new Journal Entry feature in Fluid was delivered in FSCM PUM Image 29 called Simple Journal. Through configuration, this feature allows customers to restrict and control the fields displayed on the Fluid Journal page. These setting are based on the need or function of the user. It simplifies the data entry from an end-user […]

Planning to implement your ASC842/IFRS 16 lease accounting solution in 2019? PeopleSoft can help!

Posted by

Since 2019 is now upon us, some organizations have already implemented PeopleSoft Lease Administration. Some are in the final stages for go-live preparation. Some organizations have not yet started to implement a solution and are targeting 2019 to do so. The good news is that PeopleSoft has you covered regardless of your project go-live target […]

It’s still not too late to implement PeopleSoft Lease Administration for January 1, 2019 and be ready for the new ASC 842 & IFRS 16 accounting rules!

Posted by

I would like to remind everyone that the deadline for compliance with the new ASC 842 & IFRS 16 rules is fast approaching. My headline is a bold statement, but it can hold true if you can answer yes to the following questions: Have you already identified all your leases, including the payment schedules? Do […]

How to Get Rid of Stress While on a Business Trip

Posted by

Feel stressed out while traveling? You aren’t alone. Learning to get rid of stress is essential when traveling. According to a study by CWT Travel Solutions Group (CWT), the top three triggers for stress when traveling can be grouped into three main areas: 1. Lost Time. It’s difficult, or downright impossible, to get work done while traveling, especially […]

Administering Simplified Analytics Video

Posted by

Two weeks ago, we published a blog on administering simplified analytics. To watch a video demonstrating how to create a simplified analytic and make it available to the end user on a Fluid tile, click here or on the photo below: Additionally, if you would like more information on simplified analytics, please email me at Larry.zagata@miproconsulting.com. To read […]

Administering Simplified Analytics

Posted by

Our previous blogs have focused on the creation of a Simplified Analytic. Now, we would like to show you how administering Simplified Analytics works and how to make them available to end users. Simplified Analytics are a great way to open up reporting to the masses. You can control the query behind the scenes. You […]

PeopleTools 8.57

Posted by

On September 21, 2018, PeopleSoft released PeopleTools 8.57. It marked the first time a release was generally available in the Cloud before on-premise environments. Using the Cloud Manager, customers may subscribe to the PeopleTools 8.57 channel to automatically download the release in addition to available PeopleTools patches. Based on the 8.57 release notes, the following […]