Skip to main content
Question

How to display PMBudget and PMRegister details in single GI

  • Feb 20, 2024 9:20 AM UTC
  • 3 replies
  • 116 views
  • Translate All

Forum|alt.badge.img

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

Laura03
Captain II
Forum|alt.badge.img+20
  • Captain II
  • Feb 20, 2024 10:44 AM UTC

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

Translate

Forum|alt.badge.img
  • Author
  • Semi-Pro III
  • Feb 20, 2024 11:34 AM UTC

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.

Translate

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • Mar 29, 2024 8:17 PM UTC

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

Translate