Inventory on Item List

(1) Share

Report

Posted on by RO-22071332-0

Hello,

I have extended the locations table and added global dimensions 1 (branch) and 2 (department). Would like the items list to show inventory in locations which belong to a certain branch. How do i go about modifying this:

field(50903; /Branch Inventory/; Decimal)

{

CalcFormula = Sum(/Item Ledger Entry/.Quantity WHERE(/Item No./ = FIELD(/No./),

/Global Dimension 1 Code/ = FIELD(/Global Dimension 1 Filter/),

/Global Dimension 2 Code/ = FIELD(/Global Dimension 2 Filter/),

/Location Code/ = FIELD(/Location Filter/),

/Drop Shipment/ = FIELD(/Drop Shipment Filter/),

/Variant Code/ = FIELD(/Variant Filter/),

/Lot No./ = FIELD(/Lot No. Filter/),

/Serial No./ = FIELD(/Serial No. Filter/),

/Unit of Measure Code/ = FIELD(/Unit of Measure Filter/),

/Package No./ = FIELD(/Package No. Filter/)));

Caption = 'Inventory';

DecimalPlaces = 0 : 5;

Editable = false;

FieldClass = FlowField;

}

N/B: will create a inventory field for each branch

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (2)

Answers (0)

Gerardo Rentería Ga... 25,078 Most Valuable Professional on at

Like (0)

Report

Inventory on Item List

Hi

You could use this "TableFilters" as a "constant expression", setting the dimension value to 1.

CalcFormula Property - Business Central | Microsoft Learn

Best regards

Gerardo

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Inventory on Item List

Hi,

Your calcformula property seems correct , but if you are still unable to reterieve the result first check if you have the data basis on the filter you provided else I would suggest to write the code OnAfterGetRecord to get the exact values.

Thanks

Nitin

Was this reply helpful? Yes No