Cannot select a record in On-hand inventory checks (InventSumDeltaDim). Check type: Reservation. The SQL database has issued an error

(0) Share

Report

Posted on by SumyoM

In the Mobile App, while receiving the Purchase Orders, getting the below error message

Cannot select a record in On-hand inventory checks (InventSumDeltaDim). Check type: Reservation.
The SQL database has issued an error.
Object Server Azure:
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Index 'I_8669TTSITEMDIMIDX' on table
'INVENTSUMDELTADIM' (specified in the FROM clause) does not exist.
SELECT T2.ITEMID,T2.INVENTDIMID,T2.RECID FROM INVENTSUMDELTADIM T1 WITH ( INDEX(I_8669TTSITEMDIMIDX)) CROSS JOIN INVENTSUM T2 WITH ( UPDLOCK) WHERE (((T1.PARTITION=5637144576) AND (T1.DATAAREAID=N'uk01')) AND (T1.TTSID=?)) AND (((T2.PARTITION=5637144576) AND (T2.DATAAREAID=N'uk01')) AND ((T1.ITEMID=T2.ITEMID) AND (T1.INVENTDIMID=T2.INVENTDIMID))) OPTION(LOOP JOIN)

Please let me know what is this issue about

I have the same question (0)

All responses (1)

Answers (0)

Martin Dráb 237,996 Most Valuable Professional on at

Like (1)

Report

First of all, try running Dynamics 365 > Synchronize database (in Visual Studio).

Was this reply helpful? Yes No