Answered

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:

Other

Sales

All responses (6)

Answers (0)

Chandra Moulee on at

Like (0)

Report

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.
Suggested answer

Dallefeld 11,423 User Group Leader on at

Like (2)

Report

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 3,025 on at

Like (0)

Report

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.
Chandra Moulee on at

Like (0)

Report

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.

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

JAngle 33,155 on at

Like (1)

Report

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 21,025 Moderator on at

Like (0)

Report

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.