Put barcode get price

foxclub
foxclub Member Posts: 16
in NAV Three Tier
Hello
I am writing an external query.
Please i want to put barcode then get unit price including vat.
Which tables could i use in my query
I found price in table sales price, then barcode where could i find?

Answers

  • SanderDk
    SanderDk Member Posts: 507
    Barcode is in Item Cross Reference, if you can find the value inside your NAV client, then you can "Zoom"/About this page and there you can find your Table name
    For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.
  • foxclub
    foxclub Member Posts: 16
    not found in Item Cross Reference sorry
  • SanderDk
    SanderDk Member Posts: 507
    You are not using standard NAV then?
    For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.
  • SanderDk
    SanderDk Member Posts: 507
    What version of NAV are you using?
    For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.
  • foxclub
    foxclub Member Posts: 16
    Dynamics Nav 2018 (windows client)
  • SanderDk
    SanderDk Member Posts: 507
    where do you go in NAV to find the bar codes?
    For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.
  • foxclub
    foxclub Member Posts: 16
    Thanks
    I go through retail items.
    I found table named Barcodes I think it is good
  • SanderDk
    SanderDk Member Posts: 507
    if you have something called retail items, you are not using NAV standard.
    For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.

Categories