Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 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
Options
show shipment report without show return order in 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 orderno 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 orderno quantity
11 20 30
19 21 50
20 32 25
meaning i dont want any document no returned because returned order must be negative value to cancelled order that make by wrong so that i dont 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 .
please help me
thanks
this is shipment report with return order(all values in table sales shippment line table) as following:
doc no orderno 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 orderno quantity
11 20 30
19 21 50
20 32 25
meaning i dont want any document no returned because returned order must be negative value to cancelled order that make by wrong so that i dont 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 .
please help me
thanks
0
Comments
What about return order in shipment line is there any customization or could you be more clear?
Return orders (as in purchase return orders AND sales return orders) have their seperate table:
Return receipt line and Return shipment line.
However, based on the little extract of your data, it seems that sometimes shipments are reversed. (trough the undo shipment functionality) But I assume the last 25 pieces on your goal dataset is an error.
To filter out those lines (and the origin) place a filter on quantity: <0
For those other lines (the positive ones), use another recvar to check if a similar line excist within the same document with the quantity = quantity *-1
|To-Increase|