Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Answered

Auto update of Description field in Sales line

Posted on by

Description filed in Sales line

The 'Description' filed is auto filled when choosing an item in 'No.' field. in sales line.

The issue is when choosing the 'Variant code' in same line , the 'Description' filed value is getting updated(Replaced) with Variant code description. Below explained with pic

Before Choosing the 'Variant code' in Lines. (Note - The variant code is assigned to Item in Sales price book)

pastedimage1661483192794v2.png

After choosing the 'Variant code ' in Lines.

pastedimage1661483362314v3.png

So this reflects in Sales invoice printout too. Need Solution why the description filed is getting updated and how to avoid this and capture(retain) the item description itself in line.

Categories:
  • RE: Auto update of Description field in Sales line

    Thanks for the solution, I utilized the 2 Description field available in Item variant. Now able to get Item Description in Sales invoice.

    pastedimage1661737877554v1.png

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,423 User Group Leader on at
    RE: Auto update of Description field in Sales line

    If you want the description of the item to print on the sales line, make the description of the variant the item description. No coding necessary

  • Suggested answer
    Amit Baru Profile Picture
    Amit Baru 3,025 on at
    RE: Auto update of Description field in Sales line

    Hi

    Make extension of Sales Line table and write code "Onvalidate" trigger of Variant field. for retaining the Items description in Sales Line.

    Regards

    Amit Sharma

    www.erpconsultors.com

    linkedin.com/in/amit-sharma-94542440/

    Pls press Yes if info is useful.

  • RE: Auto update of Description field in Sales line

    Thanks for the response, in sales line the item description field is replaced by field 'Description (3, Text)' from table = Item Variant (5401), but luckily we got 2 Description field in Item variant table 5401. So I Used both , as below In Description 1 given Item description and in Description 2 given Variant description.

    pastedimage1661498558907v1.png

    below is the output for Same Item before and after using  2 Description fields,

     pastedimage1661498756122v2.png

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,155 on at
    RE: Auto update of Description field in Sales line

    On going you may want to use the main description on the variant. Failing that you could use item references to hold a differing description for the item and variant combination. To resolve the previous entries either have a developer update values or create a report extension for the sales invoice report and have it get the item description if the sales invoice line has a variant code

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,025 Moderator on at
    RE: Auto update of Description field in Sales line

    Hi,

    you need to take help from your developer to replace the description back from Item description even if there is a item variant available.

    Thanks.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,647 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans