Requirement: In the case of any comparison purpose in the script, how can we differentiate each line when there are multiple item lines with the same item? For that, we can create a saved search and include a Formula text column in the results using the expression {number}||’_’||{line}. Here, the {number} represents the document number… Continue reading How can we append the line number with the invoice number using a saved search?
Tag: concatenate
Concatenate the Date field in Excel
When the date field is concatenated with any text field in excel, in the result field the date formate may change. The date value may also be converted to some other format. To avoid this convert the date field to the text field while concatenating. Ex: COCATENATE(TEXT(C2,”dd/mm/yyyy”),E2) In this formula, the date value in C2… Continue reading Concatenate the Date field in Excel