Options

Put barcode get price

foxclubfoxclub Member Posts: 16
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

  • Options
    SanderDkSanderDk Member Posts: 497
    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.
  • Options
    foxclubfoxclub Member Posts: 16
    not found in Item Cross Reference sorry
  • Options
    SanderDkSanderDk Member Posts: 497
    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.
  • Options
    SanderDkSanderDk Member Posts: 497
    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.
  • Options
    foxclubfoxclub Member Posts: 16
    Dynamics Nav 2018 (windows client)
  • Options
    SanderDkSanderDk Member Posts: 497
    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.
  • Options
    foxclubfoxclub Member Posts: 16
    Thanks
    I go through retail items.
    I found table named Barcodes I think it is good
  • Options
    SanderDkSanderDk Member Posts: 497
    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.
Sign In or Register to comment.