Nav 2009 R2
Hi,
I am trying to write a report in Crystal (tried Jet Express, not flexible enough) what i am trying to do is compare G/L entries from a Sales Invoice Line to costs that are posted into the G/L i.e.
The Link is the Global Dimension Code 2
We have a Sales Code 6110 - So the Sales Invoice Line can say £500
Against this we post from a General Journal a Labour charge against this of £100
What i want is to bring in the Customer Information from the Sales Invoice Header & the Line Details from the Sales Invoice Line
The G/L has an entry No, which is the only other Column apart from the Global Dimension which looks like i could use, but i do not know what table links to this.
I have tried the Analysis View Entry 365 as we have set this up as an analysis, it just does not give enough information.
Thanks
*This post is locked for comments
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156