some error in code of report

ahmedba
Member Posts: 424
i have shipment report with return order in report :
this is shipment report with return order(all values in table sales shippment line table) as following:
doc no order no quantity
12 15 50
12 15 50-
11 20 30
19 21 50
20 32 25
20 32 -25
WHAT I NEED IS :
1-i want to show shipment report without return order as following:
doc no order no quantity
11 20 30
19 21 50
20 32 25
meaning i don't want any document no returned because returned order must be negative value to cancelled order that make by wrong so that i don't want to display returned in report.
this report based on sales shipment header and sales shipment line table how i write code to make this result .
i write this code on pre section on report to solve the problem but i not reached the result
Sales Shipment Header, Body (1) - OnPreSection()
SalesShipmentLine.Set Range("Document No.","No.");
SalesShipmentLine.Set Filter(Quantity,'<%1',0);
If SalesShipmentLine.Find First then
If Not Show Neg then
Curr Report.SHOW OUTPUT(False);
Else
If Show Neg then
Curr Report.SHOW OUTPUT(False);
this logic i want to write code with it
1-search for positive quantity
2- if you found similar document number with negative value then select it
please help me
thanks
this is shipment report with return order(all values in table sales shippment line table) as following:
doc no order no quantity
12 15 50
12 15 50-
11 20 30
19 21 50
20 32 25
20 32 -25
WHAT I NEED IS :
1-i want to show shipment report without return order as following:
doc no order no quantity
11 20 30
19 21 50
20 32 25
meaning i don't want any document no returned because returned order must be negative value to cancelled order that make by wrong so that i don't want to display returned in report.
this report based on sales shipment header and sales shipment line table how i write code to make this result .
i write this code on pre section on report to solve the problem but i not reached the result
Sales Shipment Header, Body (1) - OnPreSection()
SalesShipmentLine.Set Range("Document No.","No.");
SalesShipmentLine.Set Filter(Quantity,'<%1',0);
If SalesShipmentLine.Find First then
If Not Show Neg then
Curr Report.SHOW OUTPUT(False);
Else
If Show Neg then
Curr Report.SHOW OUTPUT(False);
this logic i want to write code with it
1-search for positive quantity
2- if you found similar document number with negative value then select it
please help me
thanks
0
Comments
-
[Topic moved from 'NAV Three Tier' forum to 'NAV/Navision Classic Client' forum]Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions