Hello - I am trying to create a Project Balance GI and link in the PO associated for each transaction line, but it seems to just create duplicate lines. Below are the tables I have joined now that seem to work. Does anyone know how I can also pull in PO without having it duplicate?
Best answer by ashleyb
Hi Benjamin,
Bryan’s suggestions were helpful, but I ended up adding the project codes to a detailed purchase orders GI instead,
Thank you,
Ashley
+6If there's multiple POs associated with PMProject or ARRegister it's going to duplicate lines.
In that case you need to group it and use Min or Max aggregates of fields you are pulling in.
If you are also trying to get a sum as well as a min In this scenario, sometimes you can divide by a count.
If you need to use aggregates in a formula be sure to aggregate them by themselves in an earlier line first.
These types of GIs can be quite frustrating and run slow.
Until we can create Derived tables with GIs, it's just not an easy GI.
Depending on the use case, an alternative may be to add a side panel to show related POs.
+4
Did you end up getting a resolution for this?
Hi Benjamin,
Bryan’s suggestions were helpful, but I ended up adding the project codes to a detailed purchase orders GI instead,
Thank you,
Ashley
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
