Thanks everyone for your help.
Nick, you got the closest. When we used the GLMASTER to link the FBDETAIL with an equal join and then linked GLAMOUNTS to that with a left outer join, we got our data to show. I'm not sure it is going to work in reverse, if I have actual, but no budget, but it...
Hi Guys.
Ok, I tried removing most of my links. I just left the link on ACCT_UNIT and ACCOUNT with a left outer join and I still get the same results.
I tried removing each of those links individually too, but that gave me a bigger mess.
Haven't given up hope yet though.
Beth
Hi Naith.
Currently I am joining from FBDETAIL to GLAMOUNTS, but we have tried it each and every possible way.
As far as dependencies go, I'm hoping I understand what you mean, but I'll explain what I've noticed so far. In either of the tables, the account number does not exist unless there...
Hi Nuffsaid.
I'll do my best to describe what is happening, I'm only a lowly accountant.
I am reporting off of an Oracle database. My tables are coming from Lawson, which is our accounting program. I am trying to report actual vs budget.
I've taken the report down to the most basic tables...
I'm writing a report comparing budget to actual by account number. My budget data shows up fine until I add data from the actual table; at which point my budget disappears if I did not have actual activity. Can anyone help??
Thanks much.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.