Problem when customize sale order!

haihth
Member Posts: 32
Hi, All member
I have a problem when customize sale order:
- I add a column name "Box(integer)" to Sales Line table
- Quantity column = n * Box ( I have funtion GetQuantityForBox(Box) to count quantity, depend on Item No.)
I write some code to event OnValidate of Box column like that:
Quantity:= GetQuantityForBox(Box);
Validate(Quantity);
Everything seem OK. When customer input a number to Box column, the Quantity change right.
But problem is:
- When customer input for quantity , the system will show warning if item is out of stock ( system show form Check Availability-342)
- But when customer input for Box , the system change the quantity right, but don't show any warning althought this item is out of stock
How to make something to system will show warning when customer change Box amount and that Item is out of stock.
Anybody can help me ?
Thanks very much
(Sorry about my english)
I have a problem when customize sale order:
- I add a column name "Box(integer)" to Sales Line table
- Quantity column = n * Box ( I have funtion GetQuantityForBox(Box) to count quantity, depend on Item No.)
I write some code to event OnValidate of Box column like that:
Quantity:= GetQuantityForBox(Box);
Validate(Quantity);
Everything seem OK. When customer input a number to Box column, the Quantity change right.
But problem is:
- When customer input for quantity , the system will show warning if item is out of stock ( system show form Check Availability-342)
- But when customer input for Box , the system change the quantity right, but don't show any warning althought this item is out of stock
How to make something to system will show warning when customer change Box amount and that Item is out of stock.
Anybody can help me ?
Thanks very much
(Sorry about my english)
0
Comments
-
This is because of following code on Quantity OnValidate Trigger
CheckItemAvailable(FIELDNO(Quantity));
It will only check if you are directly validating quantity field not through coding..
try by addingCheckItemAvailable(FIELDNO(Box));
0 -
Hi mohana,
I'd done with your solution.
It work right.
Thanks very much0 -
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