Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Pin in a specific field/column of purchase line

Posted on by Microsoft Employee

Good morning, I need to know if there's a way to insert a new item in purchase line starting in the column "nº". I need this because with bar codes pistol is easier than type "produto" in the column "Tipo" and then go to column "Nº".

z3wjlvqy9zir.png


thanks a lot!

*This post is locked for comments

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    RE: Pin in a specific field/column of purchase line

    Just edit Page 54 and change the order or the fields (if you want to do that as default for everyone), otherwise (if it must be for a single user) change the order directly in the UI by opening a Purchase order, going on the line subpage, click on the top right on the subpage, select Customize and from here you can set the field order as you want.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Pin in a specific field/column of purchase line

    and how to do that in the page i need to work? I need to alter in the source table purchase line? or is another way? I'm afraid of doing that and alter the remain structure..

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    RE: Pin in a specific field/column of purchase line

    Ok but you can place it as a second column. Otherwise no way.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Pin in a specific field/column of purchase line

    I need the type, by default is a product but it can be changed understand?

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    RE: Pin in a specific field/column of purchase line

    Hide the Type and set No as first column. Type value assignment will be handled via code.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Pin in a specific field/column of purchase line

    Ok but what I need to do to always start in this column? When I need to inser a new product in the purchase line it need s to begin at the item column number ("nº")

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    RE: Pin in a specific field/column of purchase line

    You’ve to handle the Purchase Line No OnValidate trigger and, as first line of code, set the Type field to Item (Producto in your language). Then standard code can be used as is.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Pin in a specific field/column of purchase line

    I have the page Purchase Order (page 50) and i want in the purchase lines to start typing the product in the column "nº" which is the product number understand?

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    RE: Pin in a specific field/column of purchase line

    You want to place a text field in the Purchase Header and then, when a value is entered, insert the Purchase Line with No = the value inserted in the Header field?

    If so, yes it possible with a customization. Create a Code(20) field in the Header and in the OnValidate of this field, you can trigger a function that inserts the Purchase Line.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans