HITB report is erroring out after updating customer to Dynamics GP 18.3.
SSRS Report Error
An error has occurred during report processing: (rsProcessingAborted)
Query execution failed for dataset ‘HITB’. (rsErrorExecutingCommand)
Procedure or function seeHITB has too many arguments specified.
Previous Issue with HITB after GP update
This stored procedure needed to be modified last year after an update because checkboxes were added for Item Quantity and Amount in HITB report in GP Report Writer. The fix was adding QTYONHND int NOT NULL when @ temptable is created and when ivCreateHistoricalIVTrialBalance is called, the new parameter @I_fIncludeZeroQtyValue input parameter needed a value by either adding an input for users on the report itself or setting a default value of 1 (true).
Thank you in advance!
Scott