Auto update of Description field in Sales line

(0) Share

Report

Posted on by Chandra Moulee

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)

After choosing the 'Variant code ' in Lines.

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:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

JAngle 159 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Chandra Moulee on at

Like (0)

Report
Copy link

Link copied!

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.

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

Was this reply helpful? Yes No
Suggested answer

Amit Baru 3,043 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Dallefeld 233 User Group Leader on at

Like (2)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Chandra Moulee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No