Does anyone know if there is an item and inventory table easily accessible, im trying to access this into Excel through SQL.
The Item table is direclty accessible via SQL.
Regarding Inventory, this is calculated applying a SUM on the Item Ledger Entry table (quantity field). There's no a table for that, you need to apply a query if you want to calculate that via SQL directly (at least filtering for Item No. and Location Code).
Check field 68 (Inventory) on Item table in NAV.
I thought this was the case, I did import it to excel and pivot it but then I cant use the data for what I want it to because of that.
I'm very new to SQL, so its all trial and error, writing code and query is beyond me
Load in Excel also the Item Ledger Entry table and from here you can have the Inventory when pivoting.
Yes it is ..
Business Applications communities