"Balance" fields in Payment Jrnl. not updating

djswim
Member Posts: 277
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!
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..."
"Show All..."
"Oh..."
0
Answers
-
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..."0 -
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=76920 -
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'.WshShell0 -
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..."0 -
We've used & changed Nav for so long sometimes I forget they are Mods
It's Like "It should do that!"0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions