Small and medium business | Business Central, N...

Flow Field Cal Formula

(1) Share

Report

Posted on by RB-10051553-0

Hi,

I need to create flow field on purchase line to map Direct Unit Cost from "Purchase Price" table. In order to do this I have to match the Item No, Buy-From Vendor No_ with "Purchase Line" table, and make sure price's are in the current Date Range. Here is My Code below, I am getting error's on this can some one please help. I haven't done CalcFormula with multiple conditions before.

field(50015; "DirectUnitCost"; Text[100])

{

Caption = 'Direct Unit Cost';

FieldClass = FlowField;

Editable = False;

CalcFormula = Lookup("Purchase Price"."Direct Unit Cost" where("Item No_" = field("Item No."),("Vendor No_" = field("Buy-From Vendor No."), Current Date >=field("Ending Date")));

}

Categories:

Microsoft Dynamics NAV

All responses (7)

Answers (0)

Ramiz 344 on at

Like (0)

Report

Flow Field Cal Formula

Hi,

You can view that information in the purchase line details factbox.
Suggested answer

Khushbu Rajvi. 4,753 on at

Like (1)

Report

Flow Field Cal Formula

The current date cannot be directly used as a filter since it requires a constant value. To work around this, you can create a calculated field as a variable, compute its value in the OnAfterGetRecord trigger of the page, and then use it for filtering. This field will exist only at the page level, not in the underlying table.

https://community.dynamics.com/forums/thread/details/?threadid=4be67ff7-818d-4e08-820b-064ebc77cdf8
PC-25110502-0 9 on at

Like (0)

Report

Flow Field Cal Formula

Hi,

The problem is the "Current Date" part of your code.

You can't use a function in a CalcFormula, needs to be a field & some type of filter.
RB-10051553-0 30 on at

Like (0)

Report

Flow Field Cal Formula

These are the errors I am getting, it may be I am not using the "Current Date" function correctly I wanted to match "Ending Date" against the todays Date.

And the other error is this one
Suggested answer

Khushbu Rajvi. 4,753 on at

Like (1)

Report

Flow Field Cal Formula

https://yzhums.com/5802/

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-creating-flowfields-and-flowfilters
gdrenteria 12,338 Most Valuable Professional on at

Like (0)

Report

Flow Field Cal Formula

Hi

what is the error message?

Best

GR
Suggested answer

Praveen S 26 on at

Like (0)

Report

Flow Field Cal Formula

Hello,

Due to version upgrade in business central, Purchase Price Objects has been upgraded with new table hierarchy

Please use Price List Line table to fix this issue and based on your requirement change the Where Clause filters accordingly.

Below Warning for reference,

Table 'Purchase Price' is marked for removal. Reason: Replaced by the new implementation (V16) of price calculation: table Price List Line. Tag: 16.0.ALAL0432

Hope this Helps!

Kind Regards,

Praveen S

Congruent Info-tech - https://www.congruentsoft.com/