Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K 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
- 317 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 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.6K 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
account schedule usage
mark_christs
Member Posts: 156
Dear All,
I would like to create cash flow report for every year from Jan. - Dec. and total / line of all months. I also want to put currency rate in 2 currencies i.e. USD and JPY to LCY and put it in the report footer section, but I don't know how to do that.
For my cash flow, Could I use account schedule to write cash flow report, sttement budget of cashflows yearly, COGS report (beginning - others), Period cost report, revenue project sales estimation (completed project,existing project, forecasted project and total project revenue) and Progress of project report for service department (contains : cash in, cash out,COGS, GASE expense, investment fixed asset, AVAILABLE CASH) ? How to do that, I mean is the account schedule provide me to do those ?
I am thankful for your answers beforehand.
rgds,
Mark
I would like to create cash flow report for every year from Jan. - Dec. and total / line of all months. I also want to put currency rate in 2 currencies i.e. USD and JPY to LCY and put it in the report footer section, but I don't know how to do that.
For my cash flow, Could I use account schedule to write cash flow report, sttement budget of cashflows yearly, COGS report (beginning - others), Period cost report, revenue project sales estimation (completed project,existing project, forecasted project and total project revenue) and Progress of project report for service department (contains : cash in, cash out,COGS, GASE expense, investment fixed asset, AVAILABLE CASH) ? How to do that, I mean is the account schedule provide me to do those ?
I am thankful for your answers beforehand.
rgds,
Mark
0
Comments
With the actual Navision version, you can only create CF statements with Cash in, Cash out and Cash avaiable. Because the account schedule is based on GL accounts you can add the cash accounts to the schedule.
But the payment entries on bank accounts do not have a link to to the cost type (like FA or COGS or salaries etc.) because you could pay different invoices with one payment entry or you even could have different type of costs on one invoice.
I tried to create a CF statement with Navision but I could not find a solution. It is hard to believe but it seems that Navision is not able to create CF statements. Any ideas or experiences are welcome.
Regards