INVENTWAREHOUSEONHANDAGGREGATEDVIEW view definition inconsistent between Tier 1 and Tier 2 - 10.0.19

(0) Share

Report

Posted on by d365rocks

Hi,

In an implementation project with App version of 10.0.19, I see difference between the view definition of INVENTWAREHOUSEONHANDAGGREGATEDVIEW view in Tier 1 vs Tier 2.

Tier 2 has the correct view definition as described in the InventWarehouseOnHandAggregateViewBuilder class, where the value of 'AvailableOnHandQuantity' is '(INVENTWAREHOUSEONHANDVIEW.ONHANDQUANTITY - CALCULATIONS.RESERVEDONHANDQUANTITY)'.

While in Tier 1, the value shows '(CAST ((0) AS NUMERIC(32, 6)))'

I don't see any feature related checks in the class that builds the view. Also, there are no extensions for the view.

This view is part of the 'InventWarehouseOnHandV2Entity' definition which is used for calculating the On hand inventory in POS using a real time service call to HQ.

Any clues on this behavior is much appreciated.

I have the same question (0)