Skip to main content
Solved

Generic inquiry pivot table help to show revenue & expense

P
Varsity I
Forum|alt.badge.img

Hi,

 

I've created a below generic inquiry, and I would like to setup a pivot table using the concatenation formula.

To illustrate, if you examine the screenshot provided, you'll notice that "VLDD80" represents the product code, and there's a corresponding project ID configured in the setup.

My objective is to establish a new pivot table that relies on a combination of both the product code and project ID. how can i achieve this?

 

 

I want the pivot table output as shown in below screenshot. 

 

 

For some reason, I’m not able to attach the GI, but it will great, if someone can help me on this.

 

Thanks .

Best answer by Naveen Boga

Hi @psoni1585 I see that you have commented the Expense and Revenue fields in the GI, but just tried with the currency amount field along with formula and seems showing as expected. 

Please find the below screenshot for your reference.

 

 

 

Expected Results

 

 

View original
Did this topic help you find an answer to your question?

5 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • lauraj46
  • Captain II
  • 506 replies
  • October 12, 2023

Hi @psoni1585 ,

You should be able to use the formula field as a Row on your pivot table.  Please attach the XML for your GI and I would be glad to take a look.

Laura

Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
P
Varsity I
Forum|alt.badge.img
  • psoni1585
  • Author
  • Varsity I
  • 43 replies
  • October 12, 2023

Hi Laura,

 

Thanks for your reply to my post.

I’m not able to attach the XML file of GI. it’s below message. Any idea how can i attach or send XML ?

 

Thanks .

 

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • 2624 replies
  • October 13, 2023

Hi @psoni1585 file uploads don't support special characters in the title. Please rename with no special characters and it should work. 

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
P
Varsity I
Forum|alt.badge.img
  • psoni1585
  • Author
  • Varsity I
  • 43 replies
  • October 16, 2023

Hi @lauraj46

 

I’ve attached GI for your reference. 

 

Thanks

Pankaj Soni 

1 Attachments
Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Naveen Boga
  • Captain II
  • 3377 replies
  • Answer
  • October 16, 2023

Hi @psoni1585 I see that you have commented the Expense and Revenue fields in the GI, but just tried with the currency amount field along with formula and seems showing as expected. 

Please find the below screenshot for your reference.

 

 

 

Expected Results

 

 

Naveen B
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved