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:

Business Central

All responses (2)

Answers (0)

Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 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
gdrenteria 12,065 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