Item Table, Run, Filter on Profit% Field

kwajahathydro
kwajahathydro Member Posts: 88
edited 2012-10-22 in NAV/Navision Classic Client
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

Comments

  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
    You want to set Profit% to 0 for all Items?

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • kwajahathydro
    kwajahathydro Member Posts: 88
    Hi Mohana,

    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
  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
    I guess you are not technical person..
    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
  • kwajahathydro
    kwajahathydro Member Posts: 88
    Mohana,

    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

Categories