• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Joining the F41021, F4211, F4311

chinelo

Member
Can anyone please offer ideas on how to link the three tables above in a
UBE? The problem I keep coming up against is one of the many-to-many joins
on item number.
What I'm after is the sum of PQOH (F41021), the sum of UOPN (F4311), the sum
of UORG (F4211) by item number. Data selection should allow options by DRQJ
and LTTR (F4211), PDDJ (F4311), LOTS (F41021), where F41021.MCU equals a
certain value. I also need to be able to calculate the sum of PQOH + the sum
of UOPN - the sum of UORG for every ITM.
I've tried using three different BSVWs in a tabular report but the business
views keep falling over - the values are different with each run.
We're running 733 BTW.
Thanks in advance.
Chinelo.
 
Top