Pages

Wednesday, May 4, 2016

Dynamcis GP 2015 - Financial Year End Closing Hangs | Process Failure


While closing the year in Dynamics GP 2015, the system hangs completely at step three just after performing the basic initial validation, It seemed that it was processing, but in fact there was no single process on the SQL Server (SQL Profiler). The following troubleshooting were considered : 
  1. Connectivity/ Network Issue (as I was performing the closing on the client side)
  2. SQL Server - Corrupted Master or Transnational data 
Connectivity/ Network Issue 
Starting with the first potential cause, I have restored the original backup, and proceeded with closing the year on the SQL server in order to omit any possibility of connectivity/network issue. Although, I have had the exact same results >> The system hangs at step three of the financial closing without proceeding or giving any error on the application level.

SQL Server - Corrupted Master or Transnational data

Following up this case, it was obvious that there is specific issue with the data that is causing the year-end closing to stop resulting with complete hang of the application. 

As I have checked the General Ledger tables, records in GL20000 for the year being closed was there and didn't move to the history tables GL30000, which in turn was empty for this specific year.

Here is the code at which the system stops proceeding any further:


BEGIN
    DECLARE @stored_proc_name CHAR(26);
    DECLARE @retstat INT;
    DECLARE @param23 NUMERIC(19, 5);
    DECLARE @param24 INT;
    DECLARE @param25 INT;
    SET NOCOUNT ON;
    SELECT  @stored_proc_name = 'COE.dbo.glYearEndCloseMain';
    EXEC @retstat = @stored_proc_name 2015, 2016, 1, 'SAR', '', 0, 'AVERAGE',
        'CLOSE', 6137, 'GLTRX00002694', 'DYNSA', '##0560435', '##0650435',
        '##0700435', 94, 570, 1, 6137, 6137, 0, '2015.12.31', '2015.01.01',
        @param23 OUT, @param24 OUT, @param25 OUT;
    SELECT  @retstat ,
            @param23 ,
            @param24 ,
            @param25;
    SET NOCOUNT ON;
END;  

Several parts of the stored procedure above (glYearEndCloseMain) referred to currency translation as shown below:
  • MC40000
  • glYECCreateBBFTranslationOpen
  • glYECCreatePLTranslationOpen
As I have checked the Multi currency setup in Dynamics GP, It was clear that there are several setup lines for the currency transaction as shown below:

Dynamics GP | Currency Translation Setup

I have proceeded by removing the translation setup above completely (after restoring the original backup of the company) and then proceeded with the financial year end closing. The result was just perfect, the closing went so smoothly without hanging for a single second. 
 
Year End Closing - Complete

Best Regards, 
Mahmoud M. AlSaadi

1 comment:

  1. BE SMART AND BECOME RICH IN LESS THAN 3DAYS....It all depends on how fast 
    you can be to get the new PROGRAMMED blank ATM card that is capable of
    hacking into any ATM machine,anywhere in the world. I got to know about 
    this BLANK ATM CARD when I was searching for job online about a month 
    ago..It has really changed my life for good and now I can say I'm rich and 
    I can never be poor again. The least money I get in a day with it is about 
    $50,000.(fifty thousand USD) Every now and then I keeping pumping money 
    into my account. Though is illegal,there is no risk of being caught 
    ,because it has been programmed in such a way that it is not traceable,it 
    also has a technique that makes it impossible for the CCTVs to detect 
    you..For details on how to get yours today, email the hackers on : (
    atmmachinehackers1@gmail.com ). Tell your 
    loved once too, and start to live large. That's the simple testimony of how 
    my life changed for good...Love you all ...the email address again is ;
    atmmachinehackers1@gmail.com

    ReplyDelete