How would you link this scenario if you wanted results
to show GLPeriodAmount by fiscal year compared to GLBudget amount by fiscal year. Understanding there may not be records for in all of the amount accounts.
What table should I start with and is my record selection
impacting the results?
Maybe I need to look at doing a running total to get the correct results?
Thank You Dgilz,
I do have auto linking off.
I am starting with these 3 tables linking with inner joins
GLPeriod > GlAcct GLBudget
Company Company Company
Div Div Div
Dept Dept Dept
Chart Chart Chart
Fiscal Year...
Hello,
Here is my challenge I am trying to do a comparison of a financial statement Current Period Debit /credit to a budget. I am linking 3 tables together GL period balance,
GL Budget and GL account. I have tried this 2 ways first
Starting with the GL Period linked to the GL Account this...
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.