export of item-card >> F9 >> report?

tom885214569
tom885214569 Member Posts: 7
edited 2009-11-05 in NAV/Navision Classic Client
hi,

im looking into a method / logic to export the data called "Item-Turn Over". u can see the data when u click F9 on the item-card. there is a report called "ItemTurnOver", but it doenst deliver what i need. what i need is to export the F9 view for around 1500 items.
can anyone help?

i do have ODBC access to the system.


thx

Comments

  • matttrax
    matttrax Member Posts: 2,309
    I don't believe you'll find this functionality out-of-the-box. NAV only comes with a hand full of dataports and XMLports.

    You'll most likely have to build something custom to do that for you.
    Matt Traxinger - ArcherPoint
  • tom885214569
    tom885214569 Member Posts: 7
    hi matt, yeah i thought so. but to be honest, i cant figure out the alorithm / tables / etc whats behind that form/view.
    i dont have a full license, we are basically just "users". u dont know how that view gets calculated?


    thx
  • matttrax
    matttrax Member Posts: 2,309
    They are semi-complicated calculations. Generally, though, you can start with the Value Entry table. That will contain the financial information about items include cost and other values.
    Matt Traxinger - ArcherPoint
  • kapil4dynamics
    kapil4dynamics Member Posts: 591
    Or u can use Sales Analysis that will export the data for all Items. Only Profit u will have to calculate. Rest of the field and its data per Item wud come.
    Kapil Khanna

Categories