Sales Line Table

Hi All,

I’m new to Nav but experienced in ERP systems. Can someone explain why the sales lines table in Nav doesn’t seem to have an Item reference in it, other than the description. I can see the item code exists in the invoice line table as No_ but why isn’t it in the sales line table?

Thanks in advance!

Cheers

Dave

Hey Dave,

I think you missed something. In Sales Line Table select Type as Item then in the No Field you will see list of all Items and the one item you will select its description will automatically get populated.

Thanks

Blog - https://rockwithnav.wordpress.com/

Hi,

Thanks for the reply. I don’t mean in the application I’m looking at the data in the sales line table in SQL and there is not a No_ column and no item code, just a description column? I want to report on sales orders lines with item / description and to join the items code to other tables.

Thanks

Dave

Hey Dave,

See the below screenshot, I belief you too would be executing the same Query. Here

Red Box Indicate type 2 means it’s a Item Line.

Green Box shows list of all Items as Type we have selected is 2 which means Item.

Yellow Box indicates the description of each and every Item.

Hope this Helps.

Thanks

Blog - https://rockwithnav.wordpress.com/

Hi, Right got you! I must be blind I couldn’t even see the No_ column !

That’s very much.

Dave