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

tom885214569

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

matttrax

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.

tom885214569

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

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.

kapil4dynamics

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.