Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Add Check(s) Total to Payment Journal
Savatage
Member Posts: 7,142
I posted this in the newsgroup
http://www.microsoft.com/Businesssolutions/Community/Newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.navision&lang=en&cr=US
but will soon be lost forever there. So I'd figure I'd post it here in case someone needs it.
PS(Navision Native)
..........................................................................
Thanks to KINE...... (slight change from
http://www.mibuso.com/forum/viewtopic.php?t=7190 )
Here's how you can do it.
Payment Journal->Design
Create A function "UpdateSums" and add the code
BEGIN
GenJnlLine.COPY(Rec);
GenJnlLine.CALCSUMS(Amount);
JournalAmt := GenJnlLine.Amount;
END
On the OnAfterGetCurrRecord()
add..
UpdateSums;
===============
Notes.
JournalAmt is a variable type Decimal
Table 81 Gen. Journal Line add Amount to the SumIndexFields in Keys
Add your variable to the form.
http://savatage99.googlepages.com/TotalTheEntries.jpg
http://www.microsoft.com/Businesssolutions/Community/Newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.navision&lang=en&cr=US
but will soon be lost forever there. So I'd figure I'd post it here in case someone needs it.
PS(Navision Native)
..........................................................................
Thanks to KINE...... (slight change from
http://www.mibuso.com/forum/viewtopic.php?t=7190 )
Here's how you can do it.
Payment Journal->Design
Create A function "UpdateSums" and add the code
BEGIN
GenJnlLine.COPY(Rec);
GenJnlLine.CALCSUMS(Amount);
JournalAmt := GenJnlLine.Amount;
END
On the OnAfterGetCurrRecord()
add..
UpdateSums;
===============
Notes.
JournalAmt is a variable type Decimal
Table 81 Gen. Journal Line add Amount to the SumIndexFields in Keys
Add your variable to the form.
http://savatage99.googlepages.com/TotalTheEntries.jpg
0
Comments