Style Sheet experts - HELP!!

WallaceNails
Member Posts: 5
My company is new to using Navision and we have had some succes making company specific documents using the Style Sheet program into Mocrosoft Word.
Here is the problem I need solved:
The "line" feature of the Style Sheet program will allow you to create a table in Word on a form like a quote or a purchase order. This will create a line for all the line items in your quote/order. However, I cant figure out how to make it give a total.
I end up with this great form that has quantity and unit price which gives me a total line price for each line on the table, but I have no way of getting a total quote price by adding up all the lines.
None of the selections under "field name" will give me the option of adding up all the lines. I need some code or some trick to get the program to add up all my lines in the entire quote/order and give me a total price.
Can someone help?
Thanks!
Here is the problem I need solved:
The "line" feature of the Style Sheet program will allow you to create a table in Word on a form like a quote or a purchase order. This will create a line for all the line items in your quote/order. However, I cant figure out how to make it give a total.
I end up with this great form that has quantity and unit price which gives me a total line price for each line on the table, but I have no way of getting a total quote price by adding up all the lines.
None of the selections under "field name" will give me the option of adding up all the lines. I need some code or some trick to get the program to add up all my lines in the entire quote/order and give me a total price.
Can someone help?
Thanks!
0
Answers
-
Problem solved!
The field name I was looking for is located in the header.
Thanks Ian!0 -
Hi,
I have the same problem described by WallaceNails i.e"The "line" feature of the Style Sheet program will allow you to create a table in Word on a form like a quote or a purchase order. This will create a line for all the line items in your quote/order. However, I cant figure out how to make it give a total.
I end up with this great form that has quantity and unit price which gives me a total line price for each line on the table, but I have no way of getting a total quote price by adding up all the lines.
None of the selections under "field name" will give me the option of adding up all the lines. I need some code or some trick to get the program to add up all my lines in the entire quote/order and give me a total price."0 -
I have the same problem.
Please, could you explain us how did you solve this problem?
Thank you,
David.0 -
There are two (totalled) fields in the header that are automatically calculated once the document is released :
Amount
and
Amount Incl. VAT0
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