How to link a field value from 1 table to another table’s field ? : QNE Software Sdn. Bhd.

How to link a field value from 1 table to another table’s field ? Print

Created by: Weina Lee

Modified on: Fri, 11 Sep, 2020 at 9:02 AM

Example

Created a [xx] in Stock (QnEBS.BO.Stock.Stocks) and in Sales Invoice (QnEBS.BO.Sales.SalesInvoiceDetails)

then wish to link the value key in Stock (QnEBS.BO.Stock.Stocks) to Sales Invoice (QnEBS.BO.Sales.SalesInvoiceDetails)

Solution:

1. Go to QnEBS.BO.Sales.SalesInvoiceDetails and expand it

2. Right click on EvaluateExpressions

3. Select Add > MemberEvaluateExpression

4. Key in as below

EvaluateExpression = [Stock.xx]

EvaluateMember = xx

Id = xx_value

5. Save and re-open QNE Optimum

6. If you test key in an amount (999.99) into Stock.xx

7. When go to Sales Invoice and select the Stock Item, the value of xx will automatically show out according to what you key into Stock.xx

Refer attachment for detail

Weina is the author of this solution article.

Did you find it helpful? Yes No

How to link a field value from 1 table to another table’s field ? Print