Skip to main content

Notifications

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) / Modified report will o...
Microsoft Dynamics NAV (Archived)

Modified report will only show 17 lines

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I have started of with report 718 Inventory - Sales Back Orders and done som modification, but yesterday i did even more changes and now the report will only show the first 17 lines.

What I have changed that i can think of:
Changed from portrait to landscape - had i for sometime and showed everything fine.

Moved item no. and describtion to same line as sales line information.

Deleted the blank row below to remove distance between rows.

On tablix Properties I have added a sorting -> DocumentNo_SalesLine - A to Z.

Used a filter that will only show values above 0.

Added some more fields with information from PO - that worked fine aswell at some point with more that 17 lines.

Some code behind to fill the information variables from PO.

0028.90718-Inventory-_2D00_-Sales-Back-Order-3.txt

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Modified report will only show 17 lines

    I found the issue - I filtered on Item to find the availble stock though BOM Component. The item is already filtered on and therefore i change the filter which is bad.

    I made a local variable of the record item and used that instead which solved it.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Modified report will only show 17 lines

    Vishal because the customer wants to see if the item in the report is already ordered in a PO and show how many items will arrive to stock.

    I did the PurchaseLine.Find('+') THEN BEGIN because I wanted it shown in other order that find('-').

    The field i filter to show values above is inside the Layout -> Tablix Properties -> Filters -> DisponibleInventoryTotal Integer < 0

    DisponibleInventoryTotal is a variable I calculate in the code - It calculates the availble stock.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Modified report will only show 17 lines

    Hi Nareshwar,

    Yes I have added alot beside the layout, I have attached the report in a .txt file in the first post. I added purchase order and a calculation to get available stock.

    I have tried to remove the filter you suggested, and it seems the problem is not with the 17 lines it will show.

    There is a Sales line that should be displayed in the report which is not half of the times.

    Example is the line below.

    If i filter with Order cat AFSEND it wont show.

    If i filter with Item no 70936 it will show.

    Item no Doc no. Order cat Cust Shp date
    70936 158316 AFSEND Cust name 14-06-16

    Yesterday I ran the report with filter on order cat and printet it - it had the sales line above.

    Today I ran the same report with same filter and wasnt show.

    I checked and the sales order is still there and not posted yet.

    Used this code in a codeunit to try see if its something wrong, but I will find the sales line when run the codeunit - aswell used this way in the report and still get the message that i found the sales line, but it wont show in the report.

    SalesOrderLine.SETCURRENTKEY("Document Type","Bill-to Customer No.");
SalesOrderLine.SETRANGE("Document Type",SalesOrderLine."Document Type"::Order);
SalesOrderLine.SETRANGE(Type,SalesOrderLine.Type::Item);
SalesOrderLine.SETRANGE("Shipment Date",0D,WORKDATE - 1);
SalesOrderLine.SETFILTER("Outstanding Quantity",'<>0');

SalesOrderLine.FIND('-');
REPEAT 
  IF(SalesOrderLine."Document No." = '158316') THEN
    MESSAGE('Found the sales line');
UNTIL SalesOrderLine.NEXT = 0;
  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Modified report will only show 17 lines

    Why do you check Purchase Lines for individual Items in Back Order reports? This could be one of the reason for reports not showing more data.

    PurchaseLine.SETRANGE("No.",Item."No.");

    PurchaseLine.SETRANGE(Type,PurchaseLine.Type::Item);

    IF PurchaseLine.FIND('+') THEN BEGIN

     

    Also, on which field, you applied the filter to show values above 0

  • Suggested answer
    Nareshwar Raju Vaneshwar Profile Picture
    Nareshwar Raju Vane... 5,596 on at
    RE: Modified report will only show 17 lines

    Hi,

    Also after previewing the report, go to Help -> About the Report to verify the data. These are the indications.

    Hope it helps.

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Modified report will only show 17 lines

    It is difficult to suggest anything exact, I would agree with Nareshwar to comment one by one filters and other modifications backwards to check the results. Normally, layout modifications should not lead to the situation you had described.

  • Suggested answer
    Nareshwar Raju Vaneshwar Profile Picture
    Nareshwar Raju Vane... 5,596 on at
    RE: Modified report will only show 17 lines

    Hi,

    My suggestion is to remove the filters you've created one by one and check whether there are more lines showing up. Especially the filter that will only show values above 0.

    Also, did you changed anything in the report other than the layout?

    Hope it helps.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,307 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans