Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Report from G/L

Posted on by 2,445

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans