Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Please close the Project Closing window first to complete the closing process

Posted on by 880

This is an interesting one. Using the Project Closing window, anytime I select a particular contract, the prompt "Please close the Project Closing window first to complete the closing process" appears.

It's just this contract

I've cleared all activity tables (including PA000001) & cannot for the life of me figure out what's stuck with this project.

Any $.02 would be much appreciated.

pastedimage1618342900407v1.png

Categories:
  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,019 Moderator on at
    RE: Please close the Project Closing window first to complete the closing process

    Hi Kyle,

    it might not be an open Project window that's causing the message to pop up, but an actual record that is locked in a table.. could you please check if there is anything in the Dex_lck table ?

    When looking up the contract number in the PA Closing window, GP goes thru quite a range of SP's to do validation, and it seems to fail at one of them..

    Before you even get a chance to list the contracts, this is what runs in the background:

    /*  Date: 04/14/2021  Time: 14:20:47

    stmt(149028504):*/

    { CALL DYNAMICS.dbo.zDP_SY01600SS_1 ( 'sa', 'Fabrikam, Ltd.', 'PA_Contract_Lookup', 'Contract_Lookup' ) }

    /*  Date: 04/14/2021  Time: 14:20:47

    stmt(148976944):*/

    { CALL TWO.dbo.zDP_SY00700SS_1 ( 'Contract Lookup' ) }

    /*  Date: 04/14/2021  Time: 14:20:47

    stmt(149022176):*/

    SELECT COUNT(PACONTNUMBER) FROM TWO.dbo.PA01101

    /*  Date: 04/14/2021  Time: 14:20:47

    stmt(148959160):*/

    {CALL TWO.dbo.zDP_PA01101F_1(NULL,NULL)}

    Then comes a huge SELECT query that ends with :

    SELECT TOP 25 * FROM TWO.dbo.PA01101 WHERE PACONTNUMBER = 'ADAMPHOTEL' ORDER BY PACONTNUMBER ASC

    Followed by another one with :

    FROM TWO.dbo.PA01101 WHERE PACONTNUMBER = 'COHONET' ORDER BY PACONTNUMBER ASC

    As next comes several validations which might be one of the culprit to your pop-up:

    /*  Date: 04/14/2021  Time: 14:20:49

    stmt(148929688):*/

    { CALL TWO.dbo.zDP_PA000001SS_1 ( 7, 'COHONET' ) }

    /*  Date: 04/14/2021  Time: 14:20:49

    stmt(149021272):*/

    BEGIN DECLARE @num int EXEC TWO.dbo.zDP_PA000001SI 'sa', 7, 'COHONET', 7, 0, @num OUT SELECT @num END

    /*  Date: 04/14/2021  Time: 14:20:49

    stmt(149027600):*/

    { CALL DYNAMICS.dbo.zDP_SY02100SS_1 ( -1, 258, 6, 0 ) }

    /*  Date: 04/14/2021  Time: 14:20:49

    stmt(149032120):*/

    {CALL TWO.dbo.zDP_PA11900F_1(NULL,NULL,NULL,NULL)}

    /*  Date: 04/14/2021  Time: 14:20:49

    stmt(148959160):*/

    { CALL TWO.dbo.zDP_PA01101SS_1 ( 'COHONET' ) }

    /*  Date: 04/14/2021  Time: 14:20:49

    stmt(148926976):*/

    {CALL TWO.dbo.zDP_PA01201F_9('COHONET','','COHONET','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}

    /*  Date: 04/14/2021  Time: 14:20:49

    stmt(148955544):*/

    { CALL TWO.dbo.zDP_RM00101SS_1 ( 'COHOWINE0001' ) }

    I'd check the PA11900 table to see if there is any previou left over records, as this is the PA Project Closing HDR Work table, or by that matter, any PA1190x tables, as they are all linked to the PA closing process and should be empty in normal time.

    You could also run some checklinks across the PA module to see if there are any inconsistencies.. of course after full backup :-)

    PS: if you have GPPT, enable DEXSQL trace right before opening the lookup for the Contract #.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,339 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,177 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans