Small and medium business | Business Central, N...

Conditions on Text Field

(0) Share

Report

Posted on by SammySevens

130

Hello BC Community

I want to create a multiline description field for purchase lines that:

equals purchaselines.multilinedescription if purchaseHeader.QuoteNo. <> '' (NULL/BLANK) - this means that it came from a purchase quote process
OR equals item.description if document type = '' (BLANK)

The use case is the base description field in Purchase Lines gets overwritten during our purchase quote process (user overwrites as we use generic part names (E.g. TOOL) to order one off items). Our management finds this field too small and difficult to read, so want to make a text field that is multiline = true.

Therefore if it is a purchase quote - the multilinedescription field should be '' (so user can fill it in), but if a purchase order is generated, the purchaseline.multilinedescription should = item.description

Thank you

**MODIFIED MY BULLETS - ORIGINAL REQUEST WAS REVERSED"

All responses (4)

Answers (0)

Jarrod Case on at

Like (0)

Report

RE: Conditions on Text Field

Hey SammySevens, excellent. Jeffrey Bulanadi - I'll let you answer this one if your about. Jeff is one our senior developers.
SammySevens 130 on at

Like (0)

Report

RE: Conditions on Text Field

Hi JC,

I'm relatively proficient in AL programming (controls engineer turned BC developer) - creating the field in the table extension, and visualizing it on the page (along with Multi-Line enabled) are working ok.

The issue I'm dealing with is specifically around the AL customizations required to perform the logic I've indicated in my bullet points. Do you have any examples of that, or some insight on how I could customize that?

Thank you
Suggested answer

Manan_Shah 1,457 on at

Like (0)

Report

RE: Conditions on Text Field

Hi,

I suggest you can use Purchase Line Comments option to add details of Item in Multiple lines. As I am not too sure but in Purchase Line it's not easy to add field for Multi line also it's not easy to for viewing.

You can add comment Purchase line wise.

Hope this will help.

Many Thanks,
Manan
Suggested answer

Jarrod Case on at

Like (1)

Report
RE: Conditions on Text Field

[quote user="SammySevens"]
Hello BC Community

I want to create a multiline description field for purchase lines that:

equals purchaselines.description if purchaseHeader.QuoteNo. <> '' (NULL/BLANK) - this means that it came from a purchase quote process

OR equals '' (BLANK) if document type = 'Quote'

The use case is the base description field in Purchase Lines gets overwritten during our purchase quote process (user overwrites as we use generic part names (E.g. TOOL) to order one off items). Our management finds this field too small and difficult to read, so want to make a text field that is multiline = true.

Therefore if it is a purchase quote - the multilinedescription field should be '' (so user can fill it in), but if a purchase order is generated, the purchaseline.multilinedescription should = item.description

Thank you
[/quote]

Hi SammySevens ,

We do this via an extension - see below:

Per the above it expands the new description to 2048 characters.

if you have a partner they can build one for you being a 'Per Tenant Extension' or PTE. We provide a multi-line description on item cards (for it groups for example with complex descriptions) and we also update the merge templates for invoices to include this on the quote, Sales Order or Posted Sales Invoice. Other documents like picks/shipments keep the single line description.

You cannot do this easily without the customisation.

I hope this helps.

Thanks in advance,

JC

Please confirm I've answered your question by clicking 'yes'