Open Forum

Latest Discussion Posts

  • Profile Picture

    RE: HATB SQL

    Actually you do not need it if you specify those all those ten ending variables as null. Example:  @I_cEndCustomerNumber = ' ', If you look at the sproc, there is an "if then" statement that says for each range ending variable if the input value is ...

  • Profile Picture

    RE: HATB SQL

    Thank you Thaddeus,  Both of your suggestion are a huge help.  I can now run the HATB. What is the parameter value 'þþþþþþþþþþþþþþþ'? ------------------------------ Rick Roen Seeds by Design Willows CA ------------------------------

  • Profile Picture

    RE: HATB SQL

    One other thing to help you out here Rick, Th input parameters for the HATB report are stored by index (RTGRSBIN) in the RM00700. So if your user sets their report options in the window and saves it into the RM00700 then you can get the inputs there ...

  • Profile Picture

    RE: HATB SQL

    Richard, You must provide all the inputs: Here is an example that will return a record set. In my case 544 rows based on parameters input USE [TWO] GO DECLARE @return_value int EXEC @return_value = [dbo].[seermHATBSRSWrapper] @I_dAgingDate = N'2020-12-31 ...

  • I'm wondering if anyone knows how I could summarize my rows on my ME P&L report by the first segment.  Below is an example of what we're seeing, and the preference would to have all accounts starting with 7920 to present on the same row.  Does anyone ...

  • Profile Picture

    RE: HATB SQL

    There are about 35 input params for this sp, but they all have default values.  When I fill out a few, like below, I still get no results. Any idea of what I need to enter for the other params? ------------------------------ Rick Roen Seeds by Design ...

  • Profile Picture

    RE: HATB SQL

    Check to make sure you are filling out the parameters correctly. Thanks, and with Kindest Regards, ...

  • Profile Picture

    RE: HATB SQL

    I have run this stored procedure and it returns with a value of 0.  Note: I used just a few of the input params like date range.   It seems like the SP is writing the results to a temp table: "CREATE TABLE #RMHATBAP( [APFRDCNM] [char](21) NOT NULL, [APFRDCTY] ...

  • Welcome to the GPUG Community!

    This is your hub for unbiased knowledge exchange between Dynamics GP users. Are you taking advantage of all the group has to offer?

Community Blogs

  • Hi  We are in the process of implementing BOM for GP2016. We are trying to substitute a component for a finished item when doing an assembly. We noticed that the substitute button on the bottom right of the assembly is grayed out. Would anyone know why ...

  • Profile Picture

    PPV Report

    Hi, I'm new to Great Plains, and I'm looking to get a better grasp on the purchase price variances we're incurring.  Is there a standard report I can run which will show me the item number and description that was purchased, the standard cost of the ...

  • Haven't had issues  with version upgrades or year-end upgrades in the past. I have encountered a number of custom reports that now have errors such as  "Frame "RM Statement Long Form" of report "RM Statement Long Form" references a non-existant Picture." ...

Black Belt Series

Thank you to Our 2020 Local User Group Sponsors

absolute value logoDocStar logo docuphase logointegrity logokwiktag logomekorma logonodus logoPowerGP Online logorockton logorsm logowolters kluwer logoavid xchange logo