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

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Praveen S 26 on at

Like (0)

Report

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/

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,236 Most Valuable Professional on at

Like (0)

Report

Hi

what is the error message?

Best

GR

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,604 Super User 2025 Season 2 on at

Like (1)

Report

https://yzhums.com/5802/

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-creating-flowfields-and-flowfilters

Was this reply helpful? Yes No
RB-10051553-0 30 on at

Like (0)

Report

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

Was this reply helpful? Yes No
PC-25110502-0 75 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,604 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Ramiz 597 on at

Like (0)

Report

Hi,

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

Was this reply helpful? Yes No