Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Answered

DEFERRAL FUNCTIONALITIES

Posted on by 45

Hi everybody,

I have a problem with deferral functionalities:

I created a deferral template , I want to defer an expense in  12 future period. The deferral template is set in this way : calculation (straight line)  - start date posting date

In my example the posting date is 01/08/2016 and NAV correctly create the 12 registrations with different posting date from 01/08/2016 - 01/09/2016-....    to   01/07/2017

I have a problem with the G/L Book ledger : General ledger book entry are only in 2016 , and this is not corretct since the amount of the registrastion posted in a certain year in the G/L Book ledger must be equal to those in the general ledger entry.

Could you help me in some way?

Thank you very much

  • Alessandro JM Profile Picture
    Alessandro JM 45 on at
    RE: DEFERRAL FUNCTIONALITIES

    Thank you very much for your help. I tested it as well and It works

    Best regards

  • Suggested answer
    Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on at
    RE: DEFERRAL FUNCTIONALITIES

    hi,

    i have the fix, all works fine.

    Change Log                                                  6. september 2016

    Old version BEFORE

    New version  AFTER

    --------------------------------------------------------------------------------

    +------------------------------------------------------------------------------+

    | OBJECT Codeunit 12 Gen. Jnl.-Post Line                                       |

    +------------------------------------------------------------------------------+

    ---------- Before (BEFORE) ---------- Codeunit 12 ---------- Function InsertGLBookEntry

         GLBookEntry.SETRANGE("Transaction No.",NewGLEntry."Transaction No.");

         GLBookEntry.SETRANGE("G/L Account No.",NewGLEntry."G/L Account No.");

         GLBookEntry.SETRANGE("Document No.",NewGLEntry."Document No.");

         GLBookEntry.SETRANGE(Positive,NewGLEntry.Positive);

         GLBookEntry.SETRANGE("Source Type",NewGLEntry."Source Type");

         GLBookEntry.SETRANGE("Source No.",NewGLEntry."Source No.");

    ---------- After  (AFTER) ------------------------------------------------------

         GLBookEntry.SETRANGE("Transaction No.",NewGLEntry."Transaction No.");

         GLBookEntry.SETRANGE("G/L Account No.",NewGLEntry."G/L Account No.");

         GLBookEntry.SETRANGE("Document No.",NewGLEntry."Document No.");

    +     GLBookEntry.SETRANGE("Posting Date",NewGLEntry."Posting Date");

         GLBookEntry.SETRANGE(Positive,NewGLEntry.Positive);

         GLBookEntry.SETRANGE("Source Type",NewGLEntry."Source Type");

         GLBookEntry.SETRANGE("Source No.",NewGLEntry."Source No.");

    --------------------------------------------------------------------------------

    +------------------------------------------------------------------------------+

    | OBJECT Table 12144 GL Book Entry                                             |

    +------------------------------------------------------------------------------+

    ---------- Before (BEFORE) ---------- Table 12144 ---------- Fields ------------

    Document No.=FIELD(Document No.),

    Positive=FIELD(Positive),

    Source Type=FIELD(Source Type),

    -                                                                                            Source No.=FIELD(Source No.)));

                                                      CaptionML=ENU=Amount;

                                                      Editable=No;

                                                      AutoFormatType=1 }

    ---------- After  (AFTER) ------------------------------------------------------

                                                                                                Document No.=FIELD(Document No.),

                                                                                                Positive=FIELD(Positive),

                                                                                                Source Type=FIELD(Source Type),

    +                                                                                            Source No.=FIELD(Source No.),

    +                                                                                            Posting Date=FIELD(Posting Date)));

                                                      CaptionML=ENU=Amount;

                                                      Editable=No;

                                                      AutoFormatType=1 }

    --------------------------------------------------------------------------------

    ---------- Before (BEFORE) ---------- Table 12144 ---------- Fields ------------

                                                                                                        Document No.=FIELD(Document No.),

                                                                                                        Positive=FIELD(Positive),

                                                                                                        Source Type=FIELD(Source Type),

    -                                                                                                    Source No.=FIELD(Source No.)));

                                                      CaptionML=ENU=Debit Amount;

                                                      BlankZero=Yes;

                                                      Editable=No;

    ---------- After  (AFTER) ------------------------------------------------------

                                                                                                        Document No.=FIELD(Document No.),

                                                                                                        Positive=FIELD(Positive),

                                                                                                        Source Type=FIELD(Source Type),

    +                                                                                                    Source No.=FIELD(Source No.),

    +                                                                                                    Posting Date=FIELD(Posting Date)));

                                                      CaptionML=ENU=Debit Amount;

                                                      BlankZero=Yes;

                                                      Editable=No;

    --------------------------------------------------------------------------------

    ---------- Before (BEFORE) ---------- Table 12144 ---------- Fields ------------

                                                                                                         Document No.=FIELD(Document No.),

                                                                                                         Positive=FIELD(Positive),

                                                                                                         Source Type=FIELD(Source Type),

    -                                                                                                     Source No.=FIELD(Source No.)));

                                                      CaptionML=ENU=Credit Amount;

                                                      BlankZero=Yes;

                                                      Editable=No;

    ---------- After  (AFTER) ------------------------------------------------------

                                                                                                         Document No.=FIELD(Document No.),

                                                                                                         Positive=FIELD(Positive),

                                                                                                         Source Type=FIELD(Source Type),

    +                                                                                                     Source No.=FIELD(Source No.),

    +                                                                                                     Posting Date=FIELD(Posting Date)));

                                                      CaptionML=ENU=Credit Amount;

                                                      BlankZero=Yes;

                                                      Editable=No;

    --------------------------------------------------------------------------------

    best regards.

  • Alessandro JM Profile Picture
    Alessandro JM 45 on at
    RE: DEFERRAL FUNCTIONALITIES

    Thank you very much Roberto! I hope the fix will solve the problem. Thanks

  • Suggested answer
    Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on at
    RE: DEFERRAL FUNCTIONALITIES

    hi,

    Update

    Microsoft has released a fix today for testing, tomorrow i will test the solution.

    I'll know ASAP.

  • Alessandro JM Profile Picture
    Alessandro JM 45 on at
    RE: DEFERRAL FUNCTIONALITIES

    Thank you very much. I wait your news...

  • Suggested answer
    Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on at
    RE: DEFERRAL FUNCTIONALITIES

    hi,

    I confirm that might be a bug.

    Microsoft replied the issue on Cronus ITA Db, the isssue has been turned to the development team today.

    I'll know as soon as I have news.

  • Suggested answer
    Rabin Profile Picture
    Rabin 2,976 on at
    RE: DEFERRAL FUNCTIONALITIES

    Hi

    Looks like bug for me... Let Roberto consult Microsoft then probably we will have better overview...

    ----------

  • Suggested answer
    Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on at
    RE: DEFERRAL FUNCTIONALITIES

    hi Alessandro,

    I tested now on Cronus ITA CU 8.0, you are right!

    Tomorrow I will ask to Microsoft to check if is a bug (and if there's a fix available in this case) or if a ByDesign" solution related to structure of table 12144 GL Book Entry.

    I'll know. soon.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,914 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,549 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans