Hi Everyone,
Whenever I click on below path,
Inventory Management > Inquiries > On hand
below error list pops up,
Cannot select a record in ().
The SQL database has issued an error.
SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]The EXECUTE permission was denied on the object 'sp_WHSOnHand', database 'CWM_AX2012R3_TST', schema 'dbo'.
SQL statement: DECLARE @AVAILPHYSICAL numeric(32, 16);
DECLARE @AVAILORDERED numeric(32, 16);
EXECUTE sp_WHSOnHand
@DATAAREAID = N'301',
@PARTITION = 5637144576,
@ITEMID = N'CNSPCK002',
@LEVEL = 0,
@INVENTSITEIDLEVEL = 1,
@INVENTLOCATIONIDLEVEL = 2,
@INVENTSTATUSIDLEVEL = 3,
@WMSLOCATIONIDLEVEL = 4,
@LICENSEPLATEIDLEVEL = 5,
@AVAILPHYSICAL = @AVAILPHYSICAL output,
@AVAILORDERED = @AVAILORDERED output;
SELECT @AVAILPHYSICAL as [AVAILPHYSICAL],
@AVAILORDERED as [AVAILORDERED];
How this can be resolved? Please help.
