Question

How to display PMBudget and PMRegister details in single GI

  • 20 February 2024
  • 3 replies
  • 42 views

Userlevel 4
Badge

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

Badge +18

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

Userlevel 4
Badge

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.

Userlevel 7
Badge

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

Reply


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