Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 317 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Reports Giving Different Results
owiccrossett
Member Posts: 13
Hi,
I am a new user to Navision and have been trying to teach myself as much as possible but I am stuck on a report.
I have two different companies that are using the same report. It is a packing List that essentially just shows what is on a sales order. My problem is that when I view the report in one company it looks great, on the other company it gives me different results such as the field "Unit of measure" puts and entry on each line even the ones that are blank.
it looks like this:
Item No. Unit of Measure
Item 1 Each
Item 2 Each
Item 3 Each
Each
Item 4 Each
Item 5 Each
Now I do want that line that is blank to be blank because for our customers it shows a different group of items we are selling. In the other company the same report gives this as the results:
Item No. Unit of Measure
Item 1 Each
Item 2 Each
Item 3 Each
Item 4 Each
Item 5 Each
Which is exactly what I want.
Is there some global features that have not been "turned on" in the one company that causes this error?
Anything would be a help. Thanks in advance.
:?
I am a new user to Navision and have been trying to teach myself as much as possible but I am stuck on a report.
I have two different companies that are using the same report. It is a packing List that essentially just shows what is on a sales order. My problem is that when I view the report in one company it looks great, on the other company it gives me different results such as the field "Unit of measure" puts and entry on each line even the ones that are blank.
it looks like this:
Item No. Unit of Measure
Item 1 Each
Item 2 Each
Item 3 Each
Each
Item 4 Each
Item 5 Each
Now I do want that line that is blank to be blank because for our customers it shows a different group of items we are selling. In the other company the same report gives this as the results:
Item No. Unit of Measure
Item 1 Each
Item 2 Each
Item 3 Each
Item 4 Each
Item 5 Each
Which is exactly what I want.
Is there some global features that have not been "turned on" in the one company that causes this error?
Anything would be a help. Thanks in advance.
:?
0
Comments
The unit of measure variable is probably not cleared when it's printing the blank line.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
Mobile: +44(0)7854 842801
Email: david.cox@adeptris.com
Twitter: https://twitter.com/Adeptris
Website: http://www.adeptris.com
I used the formula:
IF TempSalesLine.Quantity = 0 THEN
CLEAR(RestockText);
And it worked...
IF TempSalesLine.Quantity = 0 THEN
CurrReport.SKIP;
Mobile: +44(0)7854 842801
Email: david.cox@adeptris.com
Twitter: https://twitter.com/Adeptris
Website: http://www.adeptris.com