Matrix Form to Excel

bekio
bekio Member Posts: 204
edited 2011-05-11 in NAV/Navision Classic Client
Hello Everyone,

I am using Items by location to export to excel. I have seen a lot of posts but no one has an solution.
I have used also navision send to excel button, but it does not send all the form to excel, just dhe fields that are from Item tabel, but not the matrix variable.
I have seen also the Account Shchedule, but it is depended on some tabels, it uses Analysis Line and some other tabels to get information wich account schedule to send to excel, and than calculats values depended on fields(columns) that are in that account schedule.

My questions is can i refer to variable in matrix to get the value for each item and each location.
I am using default navision Items by Location form.

Or does someone had to do send to excel this form, and how you did?

Thanks in advice.

Comments

  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
    Generally I used to reduce the width of columns until i can see all columns in matrix form..you can remove navigation pane and try to fit all columns in form and try

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • bekio
    bekio Member Posts: 204
    mohana_cse06 wrote:
    Generally I used to reduce the width of columns until i can see all columns in matrix form..you can remove navigation pane and try to fit all columns in form and try


    I don't understand it, can you explain it more. How did you send it to excel, can you describe in some steps.

    Thanks mohana,
    :?

Categories