sbradley 11/5/2020 1:12:31 PM

(stored proc) seeHITB is erroring after 18.3 update

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!



Version: All
Section: Dynamics GP, Report Writer, SQL Scripts, SSRS

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables