Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Suggested answer

How do you get Document type and description using sql

Posted on by 2
This seems to be a regular issue not explained well anywhere in NAV Dynamics.
Could use a simple lookup table to do this with but it appears to be baked into software itself
which seems to be insane approach to database design.
 
How do we get these Document Types and their matching description without having 
to hunt the internet for no answers.
 
Working in Nav Dynamics 2016 to do custom reports
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 62,018 Super User on at
    How do you get Document type and description using sql
    Hi, If you are referring to the Sales Header table, I hope the following information can also give you some tips.
    0 = Quote
    1 = Order
    2 = Invoice
    3 = Credit Memo
    4 = Blanket Order
    5 = Return Order
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,172 Super User on at
    How do you get Document type and description using sql
    Yeah, the Document Type caption is "baked" into the system itself. 
    In SQL it is stored just with a number to represent which Document type it is (starting from 0, 1, 2 etc)
    And Document Types can differ in different tables. 
    For example Customer or Vendor Ledger Entries, have these document types.
    Where 0 is blank, 1 is Payment, 2 is Invoice etc.



    But for example Item Ledger Entries can have these Document Types:
    Where 0 is Blank, 1 is Sales Shipment, 2 is Sales Invoice etc.
  • Judy Profile Picture
    Judy Microsoft Employee on at
    How do you get Document type and description using sql
    Moved to NAV forum.

Helpful resources

Quick Links

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,632 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 224,528 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans