web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Reports Tutorial in Mi...
Microsoft Dynamics NAV (Archived)

Reports Tutorial in Microsoft Dynamics Nav

(0) ShareShare
ReportReport
Posted on by Community Member

Dear Experts

Can u help me by providing good links on Tutorials on making reports in Microsoft Dynamics Nav?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mouli Kaku Profile Picture
    Mouli Kaku 517 on at

    www.packtpub.com/.../microsoft-dynamics-nav-2015-professional-reporting

  • Suggested answer
    AJAnsari Profile Picture
    AJAnsari 5,754 on at

    If you're a Microsoft Partner or a NAV Customer current on your enhancement plan, you can find report writing and other e-Learning resources at no extra cost from Microsoft PartnerSource (mbs.microsoft.com/PartnerSource) or Microsoft CustomerSource (mbs.microsoft.com/CustomerSource).

    I hope this helps. If my response has answered your question, please verify by clicking Yes next to "Did this answer your question?"

  • Suggested answer
    Tina Menezes Profile Picture
    Tina Menezes 2,582 on at

    Hi,

    You can refer the How Do I?  video series on Microsoft PartnerSource and also check the below msdn link for the written steps on developing reports:

    https://msdn.microsoft.com/en-us/library/dd338686(v=nav.90).aspx

    Also you can check some of my blog links:

    https://tinamenezes.wordpress.com/2017/08/05/tricks-to-perform-grouping-of-records-in-reports-of-dynamics-nav/

    https://tinamenezes.wordpress.com/2017/08/02/procedure-to-repeat-table-header-rows-on-every-page-of-a-report-in-dynamics-nav/

  • Suggested answer
    CDsilva Profile Picture
    CDsilva 4,188 on at

    Hi,

    You can learn from Dynamics Learning portal, under the course

    81067AE: Development Environment Introduction in Microsoft Dynamics NAV 2017 and Dynamics 365 - Module 8

    or refer

    msdn.microsoft.com/.../dd355370(v=nav.90).aspx

  • Community Member Profile Picture
    Community Member on at

    Hello MAM,

    Could you please help me out in Inventory Availability report. I want to filter the report customer wise .

    The Customer filter should reflect on Monthly Schedule,Sale Quantity, Gross Requirement.

    I am Sending you the following code please see if you can provide any solution to this

    if you wants more details please ask.

    -----------------CODE----------------------------------------------------------------------------------

    OnInitReport()

    OnPreReport()

    ItemFilter := Item.GETFILTERS;

    PeriodText := Item.GETFILTER("Date Filter");

    OnPostReport()

    Item - OnPreDataItem()

    GetCurrentKey := CURRENTKEY;

    Item - OnAfterGetRecord()

    IF NOT UseStockkeepingUnit THEN BEGIN

     IF "Reordering Policy" IN ["Reordering Policy"::Order,"Reordering Policy"::"Lot-for-Lot"] THEN

       "Reorder Point" := 0;

     CalcNeed(Item,GETFILTER("Location Filter"),GETFILTER("Variant Filter"),"Reorder Point");

    END;

    Item - OnPostDataItem()

    Stockkeeping Unit - OnPreDataItem()

    IF NOT UseStockkeepingUnit THEN

     CurrReport.BREAK;

    SKUPrintLoop := 0;

    Stockkeeping Unit - OnAfterGetRecord()

    SKUPrintLoop := SKUPrintLoop + 1;

    IF "Reordering Policy" IN ["Reordering Policy"::Order,"Reordering Policy"::"Lot-for-Lot"] THEN

     "Reorder Point" := 0;

    CalcNeed(Item,"Location Code","Variant Code","Reorder Point");

    Stockkeeping Unit - OnPostDataItem()

    CalcNeed(Item : Record Item;LocationFilter : Text[250];VariantFilter : Text[250];ReorderPoint : Decimal)

    WITH Item DO BEGIN

     SETFILTER("Location Filter",LocationFilter);

     SETFILTER("Variant Filter",VariantFilter);

     SETRANGE("Date Filter",0D,WORKDATE);

     CALCFIELDS(

       "Qty. on Purch. Order",

       "Qty. on Sales Order",

       "Planning Receipt (Qty.)",

       "Scheduled Receipt (Qty.)",

       "Planned Order Receipt (Qty.)",

       "Purch. Req. Receipt (Qty.)",

       "Qty. in Transit",

       "Trans. Ord. Receipt (Qty.)",

       "Reserved Qty. on Inventory");

     BackOrderQty :=

       "Qty. on Purch. Order" + "Scheduled Receipt (Qty.)" + "Planned Order Receipt (Qty.)" +

       "Qty. in Transit" + "Trans. Ord. Receipt (Qty.)" +

       "Planning Receipt (Qty.)" + "Purch. Req. Receipt (Qty.)" + "Qty. on Sales Order";

    WITH Item DO BEGIN

     IF Item.GETFILTER("Date Filter") <> '' THEN

       SETFILTER("Date Filter",PeriodText);

     IF Item.GETFILTER("Location Filter") <> '' THEN

       SETFILTER("Location Filter",Item.GETFILTER("Location Filter"));

     //SETRANGE("Date Filter",0D,31129999D);

     GrossRequirement :=

       AvailToPromise.CalcGrossRequirement(Item) +

       AvailToPromise.CalcOutboundReservations(Item);

     ScheduledReceipt :=

       AvailToPromise.CalcScheduledReceipt(Item) +

       AvailToPromise.CalcInboundReservations(Item);

     END;

     CALCFIELDS(

       Inventory,

       "Planning Receipt (Qty.)",

       "Planned Order Receipt (Qty.)",

       "Purch. Req. Receipt (Qty.)");

     ScheduledReceipt := ScheduledReceipt - "Planned Order Receipt (Qty.)";

     PlannedOrderReceipt :=

       "Planning Receipt (Qty.)" +

       "Planned Order Receipt (Qty.)" +

       "Purch. Req. Receipt (Qty.)";

    //Sale Quantity//

    WITH Item DO BEGIN

     IF Item.GETFILTER("Date Filter") <> '' THEN

       SETFILTER("Date Filter",PeriodText);

     IF Item.GETFILTER("Location Filter") <> '' THEN

       SETFILTER("Location Filter",Item.GETFILTER("Location Filter"));

        CALCFIELDS("Sales (Qty.)");

     END;  

     SaleQuantity := "Sales (Qty.)";

    //Sale Quantity End//

     ProjAvailBalance :=

       Inventory +

       PlannedOrderReceipt +

       ScheduledReceipt -

       GrossRequirement;

      // Inventory

      CurrentStock :=

         Inventory;

     //MonthlySchedule

     MonthlySchedule := SaleQuantity + GrossRequirement;

     Month := CALCDATE('CM');

     InvtReorder := ProjAvailBalance < ReorderPoint;

    END;

    InitializeRequest(NewUseStockkeepingUnit : Boolean)

    UseStockkeepingUnit := NewUseStockkeepingUnit;

  • Suggested answer
    4BzSoftware Profile Picture
    4BzSoftware 6,073 on at

    Hi Mpapreja,

    Below links are very good:

    www.youtube.com/watch

    www.youtube.com/watch

    www.youtube.com/watch

    www.youtube.com/watch

    www.youtube.com/watch

    www.youtube.com/watch

  • CDsilva Profile Picture
    CDsilva 4,188 on at

    Hi Sarabjot,

    I've answered you on your Community question

  • Community Member Profile Picture
    Community Member on at

    Hello

    Please find the output of the report

    In this 3 field we need to add Customer filter . For example we need Customer wise (October Schedule, Balance Schedule and Despatched Quantity)

    Customer Filter

    No. Customer Part No. Description UOM October Schedule Balance Schedule Despatched Quantity Current Stock at Store In Transit Qty Must Be Despatch From - JSR/LKW

    ALAB8341001-H B8341001 AIR BRAKE NOS 30 15 15 0 0 -15

    ALAB8341001-HN B8341001 AIR BRAKE NOS 35 35 0 10 0 -25

    ALABB0F05414-H B0F05414 B0F05414-SA OF MODULAR HOSE NOS 1 0 1 0 0 0

    ALABB0F10003-H B0F10003 AIR PIPING KIT NOS 1 0 1 0 0 0

    ALABB0F15803-HN B0F15803 B0F15803-SA OF HOSES  LOOSE KIT NOS 75 55 20 0 0 -55

    ALABB0F19101-HN B0F19101 B0F19101 NOS 150 0 150 0 0 0

    ALABB0F27806-H B0F27806 MODULAR HOSE NOS 84 50 34 0 0 -50

    ALABB0F27806-HN B0F27806 MODULAR HOSE NOS 55 55 0 21 50 16

    ALABB0F31922-HN B0F31922 MODULAR HOSE NOS 195 75 120 0 40 -35

    ALABB0F34701-H B0F34701 SA OF MODULAR HOSE KIT NOS 26 12 14 0 0 -12

    ALABB0F34701-HN B0F34701 SA OF MODULAR HOSE KIT NOS 12 6 6 25 0 19

    ALABB8334302-H B8334302 B8334302-MODULAR HOSE ASSEMBLY NOS 6 0 6 0 0 0

  • Community Member Profile Picture
    Community Member on at

    suvidhablogpost.wordpress.com/.../report-designing-in-nav-20132013-r2-beginner

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
TAHER_El_Mehdi Profile Picture

TAHER_El_Mehdi 2

#1
sliderxb Profile Picture

sliderxb 2

#1
broberts Profile Picture

broberts 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans