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
- 300 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Weighted average balances
nay_chi_soe_tun
Member Posts: 4
I'm trying to set up a report in AX 3.0 to give me the weighted average balances of selected GL/creditor/debtor accounts on a given date (e.g. as at 31/12/07) within a date range (e.g. 1/7/07..31/12/07).
I've done a quick fix by doing it in Excel through Atlas however there are thousands of customers and the data retrieval is quite slow. The other option would be to have multiple smaller files but it is quite impractical. New account numbers are needing to be manually added to the files, and so on.
I have non-existent experience with AX reports and spending significant time navigating through AX tables. ](*,)
If there's anyone who has done this before, please help me out.
I've done a quick fix by doing it in Excel through Atlas however there are thousands of customers and the data retrieval is quite slow. The other option would be to have multiple smaller files but it is quite impractical. New account numbers are needing to be manually added to the files, and so on.
I have non-existent experience with AX reports and spending significant time navigating through AX tables. ](*,)
If there's anyone who has done this before, please help me out.
0