It is always a nightmare for us whenever there is client going to create a new Analytical Accounting (AA) budget even the in the latest version of GP2012 . To make things worse, it has 3 levels of hierarchy.
Example:
First Level = 20 Outlet
Second Level = 30 Department
Third Level = 10 Sub-Department
Assigning accounts into each of level is taking forever. Don't even say by the time the Budget is ready for export, I don't think Excel can handle the amount of data which generated from it.
Advice given from Microsoft is just to minimize the data that are going to be analysed, but looking at the client's nature of business, it is impossible.
Just wonder, have you guys ever met similar case like this? Any workaround solution?
Regards,
Kelvin Hew
*This post is locked for comments