AnsweredAssumed Answered

Invoice with elastic description

Question asked by HelderM on Oct 11, 2018
Latest reply on Oct 11, 2018 by HelderM

Hi everyone,

I am facing new challenge in my FM_Sales_Solution, which is based on the following tables:
INVOICES ( Id, Date,Name, total_ItemsValues Etc..)

ITEMS ( Fk_Invoice; Fk_Products; Qtt; L_Price, Valuesline)

PRODUCTS( Id; ProductName, Description; SalesPrice)


The printed invoice is based on the Items table as it should be. Some Product that I sale, has long description text, some details comes in multiple lines( some takes 1 line, others more than 10 lines).

I need to show the Descriptions of each product in the invoice line.


How can I do, if the amount of data in the Description field is variable?


Thank you.