Share
Reporthow to get the credit and Debit balances in GL Account history and Account Summary in Apart from 0 values.
*This post is locked for comments
You’re offline. This is a read only version of the page.
790
how to get the credit and Debit balances in GL Account history and Account Summary in Apart from 0 values.
*This post is locked for comments
Baltazar, you should likely repost this to the Microsoft Dynamics NAV community.
If I need to create a report outside of navision to see account balance from SQL server, could you help me?
Nizamudeen,
On item 1 - you need to know which account has activity for the 2013 year, in order to see data in the History Summary window.
On item 2 - you need to enter and match an invoice to your PO to see GL transactions in the Purchases and Payables accounts associated with your POP transaction. Entering and saving purchase order does not create any GL transactions.
Thanks for your Quickly Responses.
1)As of year 2013 it was completed Year end closing process.For that 2013 year transactions also i am unable to see.Is there any way to see that transaction amounts in Account summary or history.
2)i posted one pop order transaction in 2014 year is this possible to see the transaction in Account History or Summary.
It appears as though your inquiry is related to the following windows:
Financial > Inquiry > Summary OR History Summary
In either window:
Look up or type in the desired account in the Account field.
Use the Drop Down list to choose the correct year in the Year field.
Open years are viewed using the Summary window.
History (Closed) years are viewed using the History Summary window.
Make sure there are posted transactions for the account in the period and year you are reviewing the Summary or History Summary information for.
Transactions must be POSTED in order to appear in the Summary window.
As Mahmoud pointed out, the year-end closing process must have been performed in order for amounts to show in the History Summary field. The year-end close process must also have been performed in order for the year to appear in the drop-down list in the History Summary Year field.
You should always have a backup prior to closing a year. This process can be performed in Financial > Routines > Year-End-Closing. The Year-End-Closing window will also tell you when the closing process was last run, and what the current open year is.
Hello Nizamudeen
When closing the financial year through year-end closing, financial journals for the open year is transferred into the historical tables. Have you performed the year-end closing for the financial module for the selected year ?
Your feedback is highly appreciated,
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
