General Posting Setup

shankar25_12_82
Member Posts: 45
I have a sales account in General posting setup, I wan't to uniquely loop my G/l Account to get the sum of balance without using temp tables...Is there any solution?
0
Comments
-
Have you tried using a flowfield?Ufuk Asci
Pargesoft0 -
Let know me clearly.. the situationAnil Kumar Korada
Technical Consultant0 -
Im using flowfield to caliculate the sum. but my query is I have a general posting setup table having field of Sales account.. same account can be repeated for several general posting setup in different position or some other account can also be there....now I want to get the total balance of the sales account..by uniquely filtering the sales account field value. I know this can be achieved by having temp table, but I want this solution without creating temp table.......
for example
General posting setup table records
Sales account field contains values like 10001,10000,10001,15000,10000,10001,10000,20000
I need a total sum of the balance of the account no 10001,10000,15000,200000 -
1. way: You can use an accountnofilter in the flowfield. (You have to change the no relation if possible)
2. way: Create a totaling field for this sales account. Make the flowfield's ValueIsFilter property True.Ufuk Asci
Pargesoft0 -
ufuk wrote:1. way: You can use an accountnofilter in the flowfield. (You have to change the no relation if possible)
2. way: Create a totaling field for this sales account. Make the flowfield's ValueIsFilter property True.
Hi want to print these Sum in my Report..
........0 -
Hi want to print these Sum in my Report..
It doesn't matter. Once you create a flowfield then you can use it whereever you want.Ufuk Asci
Pargesoft0
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