Notifications
Announcements
No record found.
Hi, I need to try and get all financial transactions for the previous fiscal year out of NAV for my auditors.
Is there a certain way to do this?
Thanks
*This post is locked for comments
Few ways to do this,
1. Go to general ledger entries page ( Search for general ledger) and then set the filters for relevant posting period. Then export them to excel.
2. Create a dataport or XML port for G/L entry table and then export data from the table.
3. Go to Chart of account and then go to show entries and then clear the filter for G/L account and then add Posting period filter.
If you want to get the details of sub ledgers, then go to Customer, Bank, Vendor ledger entries pages and add a filter to relevant date period and export it to excel.
Or else you can export data using a xml port or dataport.
msdn.microsoft.com/.../dd338846.aspx
hi,
search for "VAT report" in RTC client and follow:
msdn.microsoft.com/.../hh937835(v=nav.70).aspx
Hi,
Go to Chart of account and drill down any value and reach the General ledger entry screen.
Remove all filters from General Ledger entry form, except required Posting date range, and copy/paste or export (Ctrl + E) all the lines to Excel. This will give you all GL entries in that date range.
Alternatively if you have some SQL knowledge then you can write TSQL scripts which do that. I have a bunch, doing that and more, adding Shortcut dims which are stored in other table, replacing all Codes with their respective Descriptions and so on.
The same with Vendor, Client, BankAcc and FA ledgers.
Regards,
Saurabh Shah
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
