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

All responses (7)

Answers (1)

MBrodie1979 20 on at

Like (0)

Report

RE: Flow field Not Updated

How did you solve this ?
Community Member on at

Like (0)

Report

RE: Flow field Not Updated

Problem Solved Thanks Ji
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

RE: Flow field Not Updated

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.
Verified answer

Community Member on at

Like (0)

Report

RE: Flow field Not Updated

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

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

RE: Flow field Not Updated

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.
Community Member on at

Like (0)

Report

RE: Flow field Not Updated

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

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

RE: Flow field Not Updated

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

Rec.CALCFIELDS("Send Back comment");

CurrPage.UPDATE(FALSE);