SQL View to Report on Fixed Allocation Accounts – azurecurve
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…
Continue Reading Ian Grieve’s Article on their blog
SQL View to Report on Fixed Allocation Accounts – azurecurve
Blog Syndicated with Ian Grieve’s Permission
More About This Author
Array
- Dyn365GP6 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Use a New Role Center for Collection Management
- Dyn365GP6 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Ensure Accurate Inventory Valuation by Controlling Cost Adjustment
- Dyn365GP3 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: See Improved Usability for Warehouse and Inventory
- Dyn365GP3 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Automate the Reminders Process in Collections