If you are using Fixed Allocation Accounts in Microsoft Dynamics GP, there is only a standard report which shows the distribution accounts against one of the accounts. These reports are not very user friendly and can;t be exported to Microsoft Excel in usable way.
Below is a SQL View which can be added to a reporting tool such as SmartList Designer, or a refreshable Excel report, which…
