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

Created by Weina Lee, Modified on Fri, 11 Sep, 2020 at 9:02 AM by Weina Lee

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

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article