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