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?
If 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.