Full Sail Partners Blog | Terri Agnew, CPA

Posts by Terri Agnew, CPA:

A Few of My Favorite Things About Deltek Vantagepoint Reporting

Posted by Terri Agnew, CPA on April 06, 2022

2022 - Vantagepoint Favorite Things-01-1

In my prior experience as a Controller of Architecture and Engineering (A&E) firms, I was often the “go-to” person for creating reports for PMs and Executives using Deltek Vision. Over time, I learned exactly which tab(s) the options were on for the various reports, which navigation menu item to choose to find the report base I needed, and even which color names were my favorites to use for the group headings.  Now with Deltek Vantagepoint, report creation has been made even easier with a few excellent enhancements. So, with the musical the Sound of Music in mind, let’s highlight the Deltek Vantagepoint report upgrades as “A few of my favorite things” …about reporting!  Feel free to “sing” along. 

Favorite Thing #1 - Organization of Reporting Menu

My first “favorite thing” may not be as pretty as “raindrops on roses” but it sure will save time!  Unlike Deltek Vision, Vantagepoint has only one Reporting option on the Navigation menu. All the standard base reports are now found on one “Reports” tab within Reporting. Likewise, all Saved Global/Personal reports will be listed on one “Favorites” tab. Instead of navigating through a dozen + menu items to find the report needed, now simply search for the report by name on either tab or filter by the type of report if you choose.    

For example:  Don’t scroll through the full list searching for the Time Analysis Report. Using the name of the report, start typing “time” in the search bar and “voila”, the report will populate.   

Screen Shot 2022-04-05 at 3.43.15 PM

Just even knowing the type of report rather than the name of the report, it can be filtered based on report type and list just those reports. This filter is like navigating the reporting menu tree in Vision.  

Graphical user interface, text, application, email

Description automatically generatedFavorite Thing #2 – No more than 4 Option Tabs!   

Unlike the many “whiskers on kittens”, there are no more than four tabs to review for reporting options.  In Deltek Vision, some reports had two tabs, and some had up to seven! In Deltek Vantagepoint, at most there are only four tabs. 

Screen Shot 2022-04-05 at 3.46.36 PM

Columns & Groups:   Always start by deciding how the report should be grouped/sorted and which columns are wanted on the report. Keep in mind the headings of the columns can still be changed just like as in Deltek Vision but now there is only one header, not a header line 1 and line 2.   

Options:  This tab contains all “other” options for the report selected. Time selections, activity options, budget options, financial detail options – if the report has the option, this is where to find them all!  Having all the options consolidated to one tab makes it easier when creating a report as the user can simply skim through the options available from top to bottom.  There is no need to go from tab to tab any longer! 

Chart:  Not all reports have the ability to utilize charts, so this tab is not always an option. However, if the report data makes sense to also be shown in a bar, pie or line chart, this is the tab to set it up. 

Layout:  This is the tab with the choice to override the report defaults for report layout (portrait vs landscape), paper size, font, borders, headings & footers.  Advanced tip:  If a user has special options for a report, consider adding the options selected as a note in the footer for a reference as needed. 

Favorite Thing #3 – Easy Searching for Columns & Groups  

My third “favorite thing” is how easy the column and group options can now be selected in Deltek Vantagepoint. This may seem basic but having one quick and easy selection area is as satisfying as some “crisp apple strudels” with my coffee. 

Does the user want to know part or all of the name of the column or to add YTD data columns only? Does the user want all columns for hours? Use the filter! It will save time as there is no need to scroll through the long list of column options. 

Screen Shot 2022-04-05 at 3.49.36 PM

Favorite Thing #4 – Colors for Grouping & Headers, now Actual Colors not Words!!   

Let’s face it, sometimes data is boring and can be hard to read if there is too much of it on one page!  Adding some color to grouping labels can help the eye focus in on a particular detail.  The new color selections in groupings & headers are related to my favorite thing #2Want a blue like “blue satin sashes”? In Deltek Vision, to figure out if that blue was cornflower blue or light steel blue, the user had to select the color by name, preview the report and decide if it was the color desired. Now the color selection actually shows the true color visually! 

Screen Shot 2022-04-05 at 3.51.36 PM

Another great place to use colors to brighten up a report is in the Column Heading. This option can be found on the “Layout” tab of reporting. Use a nice bright color to liven up what used to be a basic black & white report. Better yet… does the firm have an approved color palette? Find out the color codes for the firm’s colors and type in the code of the color to use in reports. Now reports will match the company branding. The user doesn’t have to be limited to the 140 colors shown in this grid. Here is a website that shows more color options:  Color Hex Color Codes (color-hex.com). Select a favorite color or the company’s brand color to liven up those reports! 

Favorite Thing #5 – Select Report Options, Records and Save the Report - All from One Screen! 

My last favorite thing about Deltek Vantagepoint reporting reminds me of “brown paper packages tied up with strings”. Deltek took three areas from Vision reporting and combined them to one page. In Deltek Vision, users had to go to one screen for Options, go back to the main reporting page and navigate to a second screen for the records selection, navigate again to the main reporting page and go to a third screen to save the favorite report. In Deltek Vantagepoint, all three of these reporting functions are executed from this main reporting screen! 

Screen Shot 2022-04-05 at 3.53.18 PM

Two more quick reporting tips… (1) don’t miss that the report title can be changed directly from this screen as well! Simply click on “Project Earnings” and rename this report to whatever makes sense for the organization.  (2) Users can also email the report directly from this main screen from the “Other Actions” options. 

Enjoy the Enhancements of Deltek Vantagepoint 

While Deltek Vantagepoint users cannot all sing with the voice of Julie Andrews in the Sound of Music, they can certainly benefit from this list of “my favorite things.” In fact, users may discover more to add to this list! In the meantime, let these Deltek Vantagepoint enhancements make reporting a lot easier because like Maria said when feeling sad, “I simply remember my favorite things and then I don’t feel so bad.”   

 


Click the image below to learn how to add the powerful, feature-rich ERP to your toolbox and get your team working on the same page of the same book.

New call-to-action

Solve Common Problems with Deltek Vantagepoint AP Voucher Lookup

Posted by Terri Agnew, CPA on September 01, 2021

For accounting professionals, the AP voucher is the single source of truth for tracking supplier invoices. An AP voucher has information from a supplier like the firm amount that is due, terms for payment, signatures of authorized firm representatives, and more. Keeping this information up to date and correct is critical, however, errors and other changes do occur.

  • Is there an invoice that was accidentally entered twice and one needs to be voided/reversed one?
  • Was tax, shipping or another amount missing on an invoice and now it is already posted?
  • Is an entered invoice amount incorrect and need to be corrected?

AP Voucher Review image

If this sounds familiar, it’s because these are all common issues that come up in the AP world. Typically, AP associates will enter a new voucher to correct these items and then reverse or add/subtract to the value of an original invoice. By doing this, two vouchers are entered for the same invoice number, often by adding a letter or number to the original invoice number. When the invoice is paid, the associate needs to remember to select both vouchers to pay the entire correct amount of the invoice. In the case of a duplicate invoice, there isn’t a “void voucher” option like there is void check or void client invoices.

However, there is a better solution - utilize “Voucher Lookup” to edit an AP voucher easily & smoothly!

Using Deltek Vantagepoint AP Voucher Lookup

Once an AP Voucher is posted Deltek Vantagepoint, it isn’t very evident that there is an option to edit the voucher. But there is! Voucher lookup is a great tool that is not as widely used as it should be.

When using AP Voucher lookup, Vantagepoint “attaches” the new voucher detail lines to the original voucher by utilizing the same voucher number and voucher header. When the corrected voucher is attached to the original there won’t be two vouchers for the same invoice to reconcile in vendor review or select in payment processing! As a result, vendor records are kept clean!

Examples of Deltek Vantagepoint AP Voucher Lookup:

Issue 1: Whoops! Two vouchers were entered for the same invoice and one of them needs to be reversed.

Deltek Vantagepoint AP Voucher Tips Solution: Enter a new AP transaction, use voucher lookup, and reverse the original lines. This AP entry will be linked or “attached” to the original voucher, not creating a new voucher but editing the original, making a zero-dollar total invoice. The steps are as follows:

  1. Go to Transaction Center > Transaction Entry > AP Vouchers. Either start a new batch (if using batches) or a new transaction (if using single transaction posting).
  2. Select the vendor. Don’t enter the rest of the header data!
  3. Go to the top right under “Other Actions” and select “Voucher Lookup”.
    1. A list of the vouchers for this vendor will appear.
    2. Select the original voucher for the invoice that needs to be edited.
    3. In the top of the list there is a search box that can be used to find an amount, voucher or invoice number and it will search for any matches from the existing vouchers.
  4. Next, select the voucher that requires editing. The voucher header information will populate from the original voucher… this is where the linking comes in.
  5. At this point, anything entered in the voucher details below will add to the original voucher line items. If the original entry had three lines and another it added, four lines will appear in the voucher review.
  6. In this example, the original voucher needs to be reversed entirely.
    1. To reverse lines, go back to “Other Actions”, select “Copy/Reverse Lines”.
    2. Check the box in the top header row to select all voucher detail lines.
    3. Click “Reverse All”.
    4. This selection will bring these lines into the voucher detail as a negative, using the same project coding. Which is simple, FAST, and does not require re-keying of line items!
    AP Voucher 2
  7. Post voucher as usual.
  8. In voucher review, the original line items and the additional link items entered during the Voucher Lookup will appear.
  9. In this example, the overall voucher is now zero and the total lines in the voucher are 12.

Deltek Vantagepoint AP Voucher Tips

Issue 2: Need to add an additional line for tax, shipping or other charges missed on original entry?

Solution: Do all steps from above, except line 6, don’t use the Copy/Reverse function. Simply add the lines needed to add to the voucher detail. Any lines that are added will link/attach to the original voucher and add/subtract to the original voucher amount.

Issue 3: Need to correct an amount in the original voucher?

Solution: Do everything above, including Copy/Reversing Lines. It is suggested to reverse the line(s) that were entered incorrectly and then enter the correct amount so there is a good audit trail. After reversing the line(s) that were entered in error, add the correct lines in the same voucher. Every line that is reversed and/or add will still link/attach to the original voucher and add/subtract to the original voucher amount.

Solve Common Accounting Challenges with Deltek Vantagepoint

Deltek Vantagepoint does more than making AP voucher corrections easy. Need to bill a client interest on a past due invoice? Check out this mini demonstration to learn how and make sure to explore all the free Vantagepoint content available on the Full Sail Partners’ website. Additionally, Full Sail Partners is dedicated to the success of its clients. Use the image link below to contact Full Sail Partners with questions about Vantagepoint.

Reach Full Sail Partners

 

 

Latest Posts