Skip to main content
Question

How to display PMBudget and PMRegister details in single GI

  • 20 February 2024
  • 3 replies
  • 61 views

Forum|alt.badge.img
  • Semi-Pro II
  • 218 replies

Hello Community,

I have been looking to display the values from PMBudget & PMRegister tables in a single GI, but the rows & values are getting duplicated from the PMRegister table. How to resolve this?

 

Thanks in advance.

3 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • February 20, 2024

Hello,

When a GI displays fewer, or more lines than we need, the cause is nearly always the Relationship tab, the join.

Please show us your join and how the Project Budget is configured . In Projects, the join could be Project and Task and Account Group and potentially Inventory item depending on how the project budget is configured. Budgets can be project to date or monthly.

Thank you.

Laura


Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • 218 replies
  • February 20, 2024
Laura02 wrote:

Hello,

When a GI displays fewer, or more lines than we need, the cause is nearly always the Relationship tab, the join.

Please show us your join and how the Project Budget is configured . In Projects, the join could be Project and Task and Account Group and potentially Inventory item depending on how the project budget is configured. Budgets can be project to date or monthly.

Thank you.

Laura

Hey @Laura02 ,

Attaching here the XML file of the GI.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2622 replies
  • March 29, 2024

Hi @Harry were you able to find a solution? Thank you!


Reply


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