Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / DEFERRAL FUNCTIONALITIES
Microsoft Dynamics NAV (Archived)

DEFERRAL FUNCTIONALITIES

(1) ShareShare
ReportReport
Posted on by Alessandro JM 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

*This post is locked for comments

  • 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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
EH-09052238-0 Profile Picture

EH-09052238-0 1

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans