mibuso.com
Home› NAV Three Tier
Options

"Balance" fields in Payment Jrnl. not updating

djswimdjswim Member Posts: 277
edited 2011-11-17 in NAV Three Tier
This is a vanilla 6.0 install (no service packs, no add-ons), virtually brand new. In the payment journal, there are checks listed ready to be printed/posted, but the "Balance" and "Total Balance" fields at the bottom of the screen aren't updating. I feel like I saw this years ago, but can't remember the solution, and a search of the forum didn't help much (probably because the words in the query are used so often).

Surely someone else has seen this... the form has not been modified.

As always, thanks in advance for your time!
"OMG ALL MY DATA IS GONE"
"Show All..."
"Oh..."

Answers

  • Options
    djswimdjswim Member Posts: 277
    By the way, forgot to mention above, this is in the 6.0 Classic client, not the RTC.
    "OMG ALL MY DATA IS GONE"
    "Show All..."
    "Oh..."
  • Options
    SavatageSavatage Member Posts: 7,142
    Take out the "Balance Acct. No." and see if the Balance & Total Balance Change.

    We have the Balance Acct No stored in the General Journal Batch Table so those fields never calc for us beacuse a balance acct already exists.

    This was really annoying and back in 2005 - we added a "Journal Total" to the bottom:
    viewtopic.php?f=14&t=7692
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • Options
    SavatageSavatage Member Posts: 7,142
    edited 2011-11-17
    Another useful change we made to this form:
    After the entry of the account number the Apply entry form automatically opens so you can pick.
    OnAfterValidate() //Of "Account No."
AutoOpenPaymentEntries;

[u]Create Function[/u]
AutoOpenPaymentEntries()
PurchSetup.GET;  //Added a boolean to setup table to turn on & off
IF PurchSetup."Auto Open Payment Journal"
 THEN BEGIN
  CREATE(WshSHell);
  WshSHell.SendKeys('+{f9}');
  CLEAR(WshSHell);
END;

    WshSHell=Automation='Windows Script Host Object Model'.WshShell
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • Options
    djswimdjswim Member Posts: 277
    Perfect =D> . Thank you for that, I knew it was something simple but it's been years.
    "OMG ALL MY DATA IS GONE"
    "Show All..."
    "Oh..."
  • Options
    SavatageSavatage Member Posts: 7,142
    We've used & changed Nav for so long sometimes I forget they are Mods :)

    It's Like "It should do that!"
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
Sign In or Register to comment.