Featured Post

Dynamics GP 2018 - Upcoming Features

We are counting the days for Dynamics GP 2018 release which is promising to introduce a new set of features that have been highly recogniz...

Monday, November 23, 2015

Analytical Purchase Requisition Entry - Dimension Code Lookup is not working

With the introduction of GP 2013 R2, a new feature came along to integrate Analytical Accounting with Purchase requisitions so that the requested can enter associated dimension code values. It was working just perfectly without any issues. 

Although, when testing the same functionality in GP 2015 R2, there is a tiny issue encountered with the lookup button on the Analytical Purchase Requisition Entry window, it seems the lookup for dimension codes is not working at all. 

Here is the original Scenario in GP 2013 (Perfect, without any issues)
  • Go to Transactions > Purchasing > Purchase Requisitions
  • Create a new requisition with items.
  • On the line item level, enter an account that is linked to Analytical Accounting
  • Click on the AA button in order to open the Analytical Purchase Requisition Entry
  • On the Dimension Code field, click on the "Look up" button to retrieve a list of available dimension codes
  • A window including all dimension codes pops up, from which you can choose.

Purchase Requisition Entry - GP 2013

Analytical Purchase Requisition Entry - GP 2013
Applying the same scenario on GP 2015 R2

While applying the same steps mentioned above, you are going to miss the lookup button 

Purchase Requisition Entry - GP 2015

Analytical Purchase Requisition Entry - GP 2015

Technical Perspective (SQL Profiler)

Apparently, when the loop up button (in GP 2013) is clicked, the trace shows appropriate code being run on the SQL server. On the other hand, clicking the same button in GP 2015 shows nothing on the trace.
Here is the code retrieve in GP 2013

SELECT TOP 25
        aaTrxDimID ,
        aaTrxDimCodeID ,
        aaTrxDimCode ,
        aaTrxDimCodeDescr ,
        aaTrxDimCodeDescr2 ,
        NOTEINDX ,
        INACTIVE ,
        DEX_ROW_TS ,
        DEX_ROW_ID
FROM    GP13R.dbo.AAG00401
WHERE   ( aaTrxDimID = 1
          AND INACTIVE = 0
        )
ORDER BY aaTrxDimID ASC ,
        aaTrxDimCode ASC
go
SELECT TOP 25
        aaTrxDimID ,
        aaTrxDimCodeID ,
        aaTrxDimCode ,
        aaTrxDimCodeDescr ,
        aaTrxDimCodeDescr2 ,
        NOTEINDX ,
        INACTIVE ,
        DEX_ROW_TS ,
        DEX_ROW_ID
FROM    GP13R.dbo.AAG00401
WHERE   ( aaTrxDimID = 1
          AND INACTIVE = 0
        )
        AND aaTrxDimID = 1
        AND aaTrxDimCodeID = 1
ORDER BY aaTrxDimID ASC ,
        aaTrxDimCodeID ASC
go



If you have encountered the same issue, you may share your vote on MSConnect to get this fixed by the support team, here is the MsConnect link. (ID: 2048691, Analytical Purchase Requisition Entry - Dimension Code Lookup)

Best Regards,
Mahmoud M. AlSaadi

No comments:

Post a Comment