ONYX REPORTING LTD.
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters
Search

TGIF Brainteaser - April 12

12/4/2015

0 Comments

 
Picture
Thank God it's Friday!  OK, I missed Friday by a couple days, but who doesn't like a good Jet Reports challenge?

As I was riding the bus back to Bristol after an onsite in London, I was appreciating the fact that when it comes to Jet Reports, often times there are more than a couple ways of getting the job done.  The true test of a good Jet consultant is not only the ability to build reports, but also to analyze reports and identify how it could have been done more efficiently or understand when it will fall apart.  The good news is that the Direct to SQL connector for on premise NAV installs eliminates a lot of need for optimization!

But anyway, without further ado I present, the TGIF challenge: Item Sales by Customer.

For Sales Analysis purposes I need a report that shows all items sold on an Invoice Line or returned on a Credit Memo line grouped by the Customer.  If a customer bought and returned an item, I don't want to see the item twice.

In other words, In my report, I want to see all unique combinations of Sell-To Customer No. and No. for Sales Invoice and Credit Memo Lines. 
Picture
The challenge criteria are:
  • Only use any combination of the following tables: Customer, Item, Sales Invoice Line and Sales Cr.Memo Line.
  • Do not rely on Conditional Hide to hide rows without data.
  • Only use up to 3 NL() functions to aid replication.  Use any number of GL(), NF(), or NP() functions.  Note: The NL("SUM")'s for "Num Credited" and "Num Invoiced" don't count.

Lastly for those of you pursuing JCT or JCP certifications:
Ignoring the challenge criteria opens up several ways to build this report.  Assuming the report will consume several thousand records, identify the methods which might produce a more efficient report in NAV 2009, NAV 2013 On Premise versus Cloud.  


Message me at http://www.onyxreporting.com/contact.html with the right response.

The first 5 (correct) respondents will receive half an hour of free Report Writing Services or 15% off your next training.
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Profile Picture Jae Wilson
    View my profile on LinkedIn

    Stay Informed.

    * indicates required

    RSS Feed

    Categories

    All
    Automation
    Basic Training Series
    Business Intelligence
    Connect
    Dashboard
    Data Pipeline
    Data Science
    Domo
    Excel Tricks
    Executive Training & Leadership
    Extract
    Jet Enterprise
    Jet Essentials
    New Release
    NP Function
    Onyx Reporting
    Planning
    Power Pivot
    Python
    Report Writing
    Statistics And Analytics
    TimeXtender
    Visualization

London, UK
jae@OnyxReporting.com
+44 747.426.1224
Jet Reports Certified Trainer Logo
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters