Hi all,
I am new to Microsoft Dynamics and creating a report in Tableau based on NAV-data.
Can any of you tell me what the different dimension values in the field "Document Type" in the Purchase Line table stand for?
To illustrate, I figured that value 2 is equal to an invoice. Microsoft Navision is not showing figures, which leads to the confusion.
Thanks in advance!
Tom
*This post is locked for comments
Thanks Suresh, that's what I needed!
These are all the available options for the Document Type
Quote,Order,Invoice,Credit Memo,Blanket Order,Return Order and In SQL they are represented by Integer
so 0 -> Quote, 1 - Order, 2- Invoice, 3 - Credit Memo, 4- Blanket Order, 5 - Return Order
Yes it's comparable with SQL. I would like to know which values relate to for instance invoice, quote, order etc.
If I connect to the Microsoft SQL database I don't see these labels, just figures like 0, 1 or 2.
Thanks in advance!
Are you trying to do something in SQL??
In NAV and in Sales Line you will find Document Type as - Quote, Order, Invoice and so on.....
did answer for the wrong field :-)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (