Displaying Unit Price along with Discounted Price on Invoice
howieb4
Member Posts: 28
Hi. I not versed in Visual Studio or Report Builder, but I am thinking this should be a simple mod. The Sales invoice currently just prints the net price that the customer is paying, whether there is a line discount or not. But I would like to print on the Invoice the Unit Price from the Item card and then the discounted price. I can't seem to find the field to add to the report to make this happen. There is a UnitPriceToPrint but that's doesn't do what I want.
Can anyone tell me what fields need to be added to the report, or point me to a previous posting that addresses this, or a similar one?
Thanks in advance
Can anyone tell me what fields need to be added to the report, or point me to a previous posting that addresses this, or a similar one?
Thanks in advance
0
Comments
-
I'm pretty new myself, but here goes.
You bring over the price from the item card.
Open up the report in design mode. Under the DataItem "Sales Invoice Line" add a new DataItem and select the Item table as the table. Highlight it and select Properties. Under DataItemLink, link the "No." field on the item card to the "No." field on the sales invoice line.
Then highlight that data item and click "Field Menu" and add the "Unit Price" field.
Now when you go into visual studio, that field will be available to chose.
Hope this helps.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