Account Analysis Pivot Macro: Advanced Features

Tags WyoCloud

This guide will cover:

  • Tips and advanced features of the Account Analysis Pivot Macro.

 

This guide covers features available within Account Analysis Pivot Macro.  In order to utilize these features, you must first run the macro per the directions outlined in the Running the Account Analysis guide.  Features which require budget information to be included when running the report are noted below.

 

Expanding details of pivot tables

There are two pivot tables included within the Account Analysis Report, one located on the AASummary tab, and one on the BudgetSummary tab (if budget information is included when running the report). From either tab, simply double click on any numerical value to open a new tab with the full details.

The full details of what makes up that number will open into a new tab. See Appendix: Column Definitions for details.

 

Customizing Details Shown in Expanded View

By default all available data for transactions is displayed when expanding transactional details by double clicking on a numerical value within a pivot table.  However, you may not find all columns helpful for your needs.  For example, you may only want to show the combined charge string of the transaction, not each segment displayed in its own column.  You may adjust the columns displayed by using the Data Select tab.

 

The Data Select tab includes all column headers available.  To indicate whether you’d like a given column included in your expanded transactional details, click on the cell under the column header (in row 5).  Use the drop down arrow to toggle between 1 and 0.  Selecting 1 indicates that you would like to view this column when viewing expanded details.  0 indicates you’d like this column hidden.  See Appendix: Column Definitions to assist in identifying which columns to include.

After selecting which columns you would like included, return to a tab which includes a pivot table (AASummary or BudgetSummary).  Select the numerical field you’d like expanded details on, then select Show Selected Details at the top of the page.

This opens the transactional details in a new tab, only including the data columns you indicated on the Data Select tab.

 

Adding Data Not Currently in WyoCloud

The Account Analysis report includes the most complete and up to date transactional data available within WyoCloud.  However there maybe circumstances where you are aware of transactions, such as IDT journal entries, that have not yet been posted in the system.  You may use the Add Data feature to review your accounts with these transactions taken into account.

 

From the Process tab, select Add Data.

 

In the Add Data pop up window, enter all information for the transaction you’d like to add to the report.  When complete, click Insert Line.

This adds the line to the full report and will be included within the details on all tabs.  The Add Data window remains open to add additional lines. The lines will be shown as encumbrances Click Exit when you are done adding lines.

 

Appendix: Column Definitions

After clicking on a value to expand full details or the CombinedData tab, the following columns are included:

 

Column Name

Data Included

P_Period_From

Reflects the starting month of the report (as input when scheduled).

P_Period_To

Reflects the ending month of the report (as input when scheduled).

Balance_Type

Will show if transaction represents an actual or encumbrance (if encumbrances were included when running report)

Accounting_Code_Combination

Full accounting chart string.

Code_Combination_Description

Written version of the accounting chart string.

Period_Year

Year of the period.

Period_Number

Corresponds with the month of the fiscal year (ie: July = 1, August = 2).

Period_Name

Name of the period (month).

Period_Start_Date

First day of the period.

Period_End_Date

Last day of the period.

Balancing_Segment

Entity

Natural_Account_Segment

Natural Account

Cost_Center_Segment

Organization

Balancing_Segment_Desc

Written version of Entity.

Natural_Account_Segment_Desc

Written version of Natural Account.

EnTITY

Entity

Natural account

Natural Account

fund class

Fund Class

fund source

Fund Source

Expense class

Expense Class

program

Program

activity

Activity

future

Future

GL_Date

The date the transaction was posted to the General Ledger (GL).

Created_By

Who entered into the GL. Note if this column shows serviceuw.integration this is a feeder file such as Banner, Telecom, Copier, Postal or Payroll.

Creation_Date

When the transaction was initially entered into the system.

Last_Update_Date

When the transaction was last updated.

Header_ID

This is a system generated number.

Header_Description

Description which was entered at the header level when the user entered the transaction.  The exception is those that say Journal Import indicate integrations or journal entries.

JE_Category_Name

Type of entry the transaction was given when it was entered.

JE_Source_Name

The source of the journal entry.

GL_Batch_Name

This is the name of the batch in the GL which can be utilized to search for more details within the system.

Posted_Date

The date the transaction first occurred within the system.

GL_JE_Name

This is the kind of journal entry.

GL_Line_Number

Journal line number.

Line_Number

The line number of the journal entry.

Orig_Line_Number

Original journal or subledger line number.

Line_Description

Description which was entered at the line level when the user entered the transaction.

GL_Transfer_Date

Date when the journal entry is transferred to the GL.

Completed_Date

Subledger journal entry completion date.

Transaction_Number

The number of the transaction.

Application_Name

Indicates the application in the system which was used to process the transaction.  Ie: Payables: Invoices, Purchasing: Reqs and POs, Project Costing: PPM (grants).

Event_ID

This is system generated information.

Event_Date

This is system generated information.

Event_Class_Name

The accounting event that originated the journal entry (ie: credit memo, period end accrual).

Event_Type_Name

The action taken relating to the accounting event that originated the journal entry (ie: credit memo validated, invoice cancelled, invoice validated).

Accounting_Class_Name

Accounting class assigned to the subledger journal entry line.

Party_Number

Supplier Number.

Party_Name

Supplier Name.

Party_Site_Number

Number assigned to the supplier’s address.

Party_Site_Name

Supplier’s address. Note: this appears as Order / Remit for transactions paid electronically.

INCLUDE_ACCT_WITH_NO_ACT

This are the filter options you selected when you scheduled the report.

BALANCE_TYPE_DSP

This are the filter options you selected when you scheduled the report.

FILTER_CONDITIONS_ATT

This are the filter options you selected when you scheduled the report.

FILTER_CONDITIONS_OPT

This are the filter options you selected when you scheduled the report.

Accounted_DR

A debit posted to the General Ledger (GL).

Accounted_CR

A credit posted to the General Ledger (GL).

COST_CENTER_DESC

Written Organization name

ORG

Numerical Organization

Balance

Balance of Debits minus Credits.

Was this helpful?
0 reviews

Details

Article ID: 62427
Created
Mon 9/17/18 3:56 PM
Modified
Mon 9/17/18 3:58 PM