Share
ReportHi, 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
You’re offline. This is a read only version of the page.
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
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
hi,
search for "VAT report" in RTC client and follow:
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.
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.
All responses (
Answers (
4,560
