Flow field Not Updated

(0) Share

Report

Posted on by Community Member

Hi,

I Created a Field Called "Send Back comment" . its a flow field In Sales Header table I try to Populate the same Field With another Table "Sales Document Reject Comment"field Called "Comment" Both fields are Type is text But it was Showing Empty On my page.

CalcFormula is (Lookup("Sales Document Reject Comment".Comment WHERE (Document No.=FIELD(No.),Document Type=CONST(Sales Order))).

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

If the calcformula is correct (I assume so), try refreshing the calculation in your page (OnAfterGetRecord):

Rec.CALCFIELDS("Send Back comment");

CurrPage.UPDATE(FALSE);

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for your Valuable Suggestion Mr.Stefano,but it still showing Empty.

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

Is the CalcFormula correct? Try running the SalesHeader table and check if the FlowField is correctly calculated. If it’s empty also on the table, the problem is the CalcFormula that’s incorrect.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Yes,In sales Header Table The Flow Field was not populated .

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

If so there’s an error in the query of your CalcFormula. I suggest to check that or post here a screenshot of your tables and what do you want to do.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Problem Solved Thanks Ji

Was this reply helpful? Yes No
MBrodie1979 20 on at

Like (0)

Report

How did you solve this ?

Was this reply helpful? Yes No