Bank rec - suggesting lines wont pull open items

rj5570
rj5570 Member Posts: 157
edited 2009-07-15 in Navision Attain
I have items marked open in the ledger entries, but they wont pull in as suggested lines.

i think they were on a bank rec before but the rec was deleted before posting....i think its from somoene starting and deleteing to restart a rec.

where should i look to get these items to pull back into the rec?
- So it Goes.

Comments

  • Ian_Piddington10199
    Ian_Piddington10199 Member Posts: 167
    You need to look at the Open and Statement Status fields on the Bank Account Ledger Entries. For a entry to be picked up it has to be Open in the Statement Status and in whatever date range you are specifying in the Suggest routine

    regards

    ian
    Regards

    Ian
  • rj5570
    rj5570 Member Posts: 157
    ok where would i look for that and can i change that?

    i am using the native database too

    rj
    - So it Goes.
  • nunomaia
    nunomaia Member Posts: 1,153
    In bank card you can see bank ledger entries by selecting ledger entries.

    Dates in statements are related to posting date, you can also see if line is already recociliated by looking at open field.
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • rj5570
    rj5570 Member Posts: 157
    yes i am aware of that, and thats what i am saying in my first post, that in the ledger entries, they are marked as open. ;)

    where can i see the statement status field? and how can i change the status field is my question
    - So it Goes.
  • Ian_Piddington10199
    Ian_Piddington10199 Member Posts: 167
    The statement status isn't normally shown on the ledger lines, you will need to either have the form modified to include them, zoom the lines individually or look int he table.

    Regards

    Ian
    Regards

    Ian
  • nunomaia
    nunomaia Member Posts: 1,153
    In bank ledger entries you have 3 fields:
    - Statement Status
    - Statement No.
    - 10000

    Has Ian_Piddington said those fields are hidden. You must change form to display those fields or make zoom.
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • rj5570
    rj5570 Member Posts: 157
    ok I am back.

    how do you modify the statement status, statement no., and statement line?

    I went into the table and ran it. I tried to change it in there but said that it can not be changed. it says "Bank Ledger Can not be changed in this Form"

    By the way I have "God" rights and I even made a role for just that table and added it to my admin account.
    - So it Goes.
  • Alex_Chow
    Alex_Chow Member Posts: 5,063
    I don't believe you can modify the bank ledger entry table without a developer's license.

    If you do, you can simply create a process only report to blank those fields out, or modify the OnValidate trigger for these fields.

    But before, you modify any ledger tables, make sure you test in a test database and test the hell out of it.
    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
  • rj5570
    rj5570 Member Posts: 157
    no I do not have a developers licenses

    so how do i fix this. this almost seems like a bug. its not right that if you delete the rec it keeps the ledger items marked as on a rec that does not exist.

    ](*,) :-k :bug:
    - So it Goes.
  • Alex_Chow
    Alex_Chow Member Posts: 5,063
    rj5570 wrote:
    no I do not have a developers licenses

    so how do i fix this. this almost seems like a bug. its not right that if you delete the rec it keeps the ledger items marked as on a rec that does not exist.

    ](*,) :-k :bug:

    You'll need to consult with your solution partner regarding this. They should know what to do.
    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
  • rj5570
    rj5570 Member Posts: 157
    bummer thats BS, that means it will $$$$

    so there is no solution for deleting a bank rec that is already started without a developer's licenses or calling my support and paying 150 bucks to have this fix.

    man that really stinks!
    - So it Goes.
  • Savatage
    Savatage Member Posts: 7,142
    What happens is you try to create a statment or bank rec using those same numbers that were part of the original that was deleted?.. will those entries re-appear?
    If so are they changable?
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • Alex_Chow
    Alex_Chow Member Posts: 5,063
    I think you're dealing with a bug in your current version. Even if you fix it yourself, chances are, this problem will reoccur again.

    It's best to consult with your partner to get a permenent fix for this.
    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
  • rj5570
    rj5570 Member Posts: 157
    ok, thanks,

    at least i have a confirmation that it sounds like a bug!

    anyone has some :bug: spray?
    - So it Goes.
  • rj5570
    rj5570 Member Posts: 157
    Savatage wrote:
    What happens is you try to create a statment or bank rec using those same numbers that were part of the original that was deleted?.. will those entries re-appear?
    If so are they changable?

    wow, great ideal, will try that!
    - So it Goes.
  • micky
    micky Member Posts: 1
    ok, thanks,

    at least i have a confirmation that it sounds like a bug!

    anyone has some :bug: spray?

    Hi, rj5570, tell us all how you solved this matter? Maybe you already found some "spray" against it? :D It would be nice to know all news =D>

    Thanks,
    micky
    Simulation pret

Categories