TMC Dynamics GP Experts

Search

TMC Dynamics GP Clients

“Thank you for the FRx training…it was the most useful training I have had in years. FRx has streamlined processes that used to take me hours each month. If you hadn’t offered the free FRx class, I would never have scheduled the individual training because I would not have known what I was missing. .I am only sorry I waited so long to get the training. And, Julie is great to work with. Thanks so much.”

- Deborah Shapiro, CFO
Geary's Beverly Hills

see another client testimonial

Create Your Own Financial Account Inquiries

Use the Account Rollup Inquiry window to view segment-based inquiries using options you created in the Account Rollup Inquiry Options window. You can view for open or historical years. This allows you to create a custome inquiry, specific to your needs, and then recall that inquiry at any time.

  • Account Rollup Inquiry

Inquiry > Financial > Account Rollup
Enter or Select Option ID
Click ‘Modify’ Button to Open Account Rollup Inquiry Options Window to Create Segment Based Inquiry
Click ‘Redisplay’ to View Previously Created Inquiry

Rollup 

  • Specify Segments and Type of Information to View

Inquiry > Financial > Account Rollup > ‘Modify’ Button
Select Sort By: Segment
Select Number of Columns in Lookup
Enter Column Heading(s)
Select Column Type
Select Budget for Budget Type Column
Enter Calculation Formula for Calculated Type Column
Select Segment(s) to Query
Click ‘Inquiry’ Button

2

  • Specify Calculation for Calculated Column

Inquiry > Financial > Account Rollup > ‘Modify’ Button > Click Expansion Arrow When Calculated Column Type is Selected
Select Columns and Enter Constants and Operators for Calculation

3

Tags: ,

View Posts by Tag

One Response to “Create Your Own Financial Account Inquiries”

  1. [...] articles CategoryLimit Default Posting Accounts in AP - Tips & Tricks: How to articles CategoryCreate Your Own Financial Account Inquiries – Tips & Tricks: How to articles CategoryCreating Advanced Lookups in GP 10.0 – [...]

Leave a Reply

Help desk software