I need help in exporting the Net G/L change for three years from Navision. I need the 12 months net change in one excel worksheet for one company. I need each net g/l change amount for each month for each account to be displayed horizontally and grouped by each period.
Example:
Period Account # Amount $
1/31/11 1010 $100,000
1/31/11 1011 $50,000
2/28/11 1010 $65,000
2/28/11 1010 $35,000
I can export the periods in diffenrent columns but not in the same column. Any help would be greatly appreciated.
Thanks
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi,
Are you using Jet Reports? I would think you could replicate the periods with the NL function from the Navision Date table and then replicate the G/L Accounts from the G/L Account table and then use the GL function to get the net changes. Does that help?
Regards,
Hughes -
Jet Reports Historic Posts You might also look at the shared reports, specifically this one http://community.jetreports.com/viewtopic.php?f=13&t=1025 as a starting point for creating such a report.
Please sign in to leave a comment.