Howdy, Stranger!
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
- 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
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Item Table, Run, Filter on Profit% Field
kwajahathydro
Member Posts: 88
Hi,
I have a question, when I run item table, look for the field called Profit%, I put a field filter with <>0, navision shows quite a number of records with some profit calculation inside. When I export those individual items to excel there are more than 1500 records with some values in the profit% field.
My question is if I want to do find and replace with all ZERO's what must I put in the find field, I am not able to replace all the field values with 0. how do i do it?
Regards
KH
I have a question, when I run item table, look for the field called Profit%, I put a field filter with <>0, navision shows quite a number of records with some profit calculation inside. When I export those individual items to excel there are more than 1500 records with some values in the profit% field.
My question is if I want to do find and replace with all ZERO's what must I put in the find field, I am not able to replace all the field values with 0. how do i do it?
Regards
KH
0
Comments
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
Yes! I want to set the profit% to Zero for all the items, how do i make use of replace all function from the table or if you can tell me how to write the simple patch report with that specific code in it.
Regards
KH
please contact your partner..please dont expect code from forum's if something went wrong then no one can help you..
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
When ever I have reported something for help, you have always mentioned to me that I am not a technical person, which I know. But whatever suggestions or help I have got from this forum, I have always tested in my local db first before I apply the same change to the production server.
If you are not able to help, fine I shall wait for others to reply me. My partner charges for each and everything so I am posting my questions on these forum. Ofcourse I do know there can be some issues where this forum cannot help but telling me which table to pull into the report (data item) and then on under which section what code to write so that the report can work like patch, where by it can zerorize the profit%, i dont think that its that difficult. I can do dataport for this but it will take more time so I thought of posting this question to the forum.
Now, after reading my reply above if you feel that I have good enough knowledge of Navision, advise me else can someone help me with this issue pls
Regards
KH