Price populate Issue
souravb
Member Posts: 135
Hi,
i have crearted a menu item, "get job price" in Purchase Quote under Line. It calculates the total price of a job from Job Budget Line and would populate the amount in the "Direct unit cost" field in Purchase Quote line. I am able to calculate price, but unable to populate it in the Purchase Quote line. I have created a process only report to do this with the code:
//CALCULATE TOTAL PRICE FOR A JOB
TotalPrice:=0.0;
GVJobBudgetLine.SETRANGE(GVJobBudgetLine."Job No.",GVJobNo);
IF GVJobBudgetLine.FIND('-') THEN
REPEAT
TotalPrice:=TotalPrice+GVJobBudgetLine."Unit Price";
UNTIL(GVJobBudgetLine.NEXT=0);
//CALCULATE TOTAL PRICE FOR A JOB
GVJobBudgetLine = Record of Job Budget Line.
Plz help
0
Comments
-
Ok, this is the part for calculating the price, but where you have some code which will store the result into the quote line? (you know, the two line which will assign the value into the field (or validation instead just assign) and for modifying the record in db...)0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
