G/L Entry- Remaining amount = 0 Open = True!!!

hazem
hazem Member Posts: 187
edited 2009-05-08 in NAV/Navision Classic Client
Hello,

I know that when the "remaining amount" is null, "Open" must be false on entries but...
In some G/L entries, i have "Remaining amount" = 0 and Open = True!!
Is it possible? If yes, can you give me an explanation of that?

Thanks

Comments

  • ssingla
    ssingla Member Posts: 2,973
    I have found no fields in Table 17 named as "Remaining Amount" or "Open". I guess the field if present will be a part of Localization. Can you tell the field numbers.
    CA Sandeep Singla
    http://ssdynamics.co.in
  • chris_johnson
    chris_johnson Member Posts: 22
    Do we assume that this is the Remaining Amount in the Customer Ledger Entry?

    Is it possible that the field is simply formatted that it shows 0.00 in the remaining amount but could actually be 0.0012 for example.

    In other words, could this because of number formatting that it shows 0 and because of a very small amount that it shows open?
  • Alex_Chow
    Alex_Chow Member Posts: 5,063
    Yeah, the remaining amount and open fields on the G/L table would not make sense in the accounting world.

    It must be a customization, in which case, you'll need to contact your local solution center to troubleshoot.
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
  • ssingla
    ssingla Member Posts: 2,973
    Yeah, the remaining amount and open fields on the G/L table would not make sense in the accounting world.

    Well it do make sense in accounting world. It is basically used for reconciling payables and reciveables which are non customer/vendor related. SAP provides such functionality.
    CA Sandeep Singla
    http://ssdynamics.co.in
  • Alex_Chow
    Alex_Chow Member Posts: 5,063
    It doesn't make sense in the General Ledger. The purpose of the general ledger is to accumulate the transactions for each respective G/L accounts.

    In the pen and paper days, you do not record what the customer owe you on the General Ledger.
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
  • ssingla
    ssingla Member Posts: 2,973
    One Example:
    For the year end provisions made in the accounts you would always like to see which provision made has been cleared/settled off. Loans and advances are another example.
    In the pen and paper days, you do not record what the customer owe you on the General Ledger.
    What I mentioned was non Customer/vendor related receiveable/payable.
    CA Sandeep Singla
    http://ssdynamics.co.in
  • ssingla
    ssingla Member Posts: 2,973
    I think we are going Off Topic
    CA Sandeep Singla
    http://ssdynamics.co.in
  • vanrofi
    vanrofi Member Posts: 272
    I have the same fields in table 17.
    They are numbered
    Enabled Field No. Field Name Data Type Length Description
    Yes 11302 Remaining Amount Decimal
    Yes 11303 Closed by Entry No. Integer
    Yes 11304 Closed at Date Date
    Yes 11305 Closed by Amount Decimal
    Yes 11306 Applies-to ID Code 20

    this means that it is part of localisation, and in this case it is electronic banking I believe (Isabel in Belgium).

    The Open and remaining data is consequent in my database, I think you should check on updates or so?
    Don't think it really hurts, it is just a matter of filtering by the system, where it uses Open = false to skip most records.

    A report should fix this : if Remaining amount = 0 then Open := true modify (false)

    do you have a belgian version in Tunis?
  • David_Singleton
    David_Singleton Member Posts: 5,479
    Alex Chow wrote:
    Yeah, the remaining amount and open fields on the G/L table would not make sense in the accounting world.

    Actually that's not true. Its important to remember that this is an international forum, not just a US forum. I have come across this requirement often, and have implemented the change for some clients, but it does seem more country specific than say industry specific, so I can understand that you have not come across a client that needs this. The need generally arises not so much from day to day business needs, but more from the audit process, and it's during the audit process that the application is made.
    David Singleton

Categories