Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, Power Apps, Power Automate, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 Timeline
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I want to setup the Customer Account Statement with different bank accounts as payment instruction dependent on the Customer Group
Customer Group 10: Bank Account XXX
Customer Group 50: Bank Account YYY
How do I do this?
Do I need to create a custom report
You can try to leverage "Print management" to setup specific bank accounts. E.g below
To setup AR > setup > form > form setup. on general tab click 'Print management, Create override and setup per below.
You can setup multiple overrides and specify criteria when they should be applied. above is for customer group 10. See output below
The text can be entered in single line. you have to play with it and see if it meets your requirements. this is out of the box functionality. However if you need to do something else, it would require customization.
Please see the feedback of Satish on the print management settings that can help you getting your requirement fixed.
Yet, I wonder why do you need that. What makes those customer groups so much different that you want to make them pay on different bank accounts. Can you spend a couple of words on that. Just wondering...
Many thanks and best regards,
Thanks Satish, at first I hit the copy option which did not give me the Condition field and went round in circles but then realised I had to select the New option. This will work in the interim but I need to learn how to create a fully customised report for other requirements
Hey Ludwig, we have a client that uses different Customer Groups to define certain functions within the company that require payment into different bank accounts.
This will put a footer comment as to what Bank Account for the customer to pay the account to.
I need to learn how to create reports using Report Designer to provide more dynamic features and conditions. Do you have a link that is a good guide for this?
Links below provide good details to get started:
Link below details different options available. provides a good starting point and then you can start to focus on particular reporting type.
Hey Satish, still learning. I've looked at those links and many others but I still think this is quite convoluted.
I can see there are 2 reports:
CustAccountStatementExt.Report this is the default report
CustAccountStatementExtModern.Report this was created by someone else who has left.
Is there a way I can access these and edit them within Dynamics 365 Finance?
I have installed VS SSDT 2015 and have created a new project and created a DataSource with the connection string of the instance name
I'm not sure if this is the right approach and not sure of how then to open these reports so I can edit them.
I have alot of experience with creating SSRS reports connecting to SQL databases, so keen to work out what I'm missing.
It would be so much easier like in Dynamics Field Service where you can modify Word templates and link them to fields via XML
Try to go through link below. It explains how to edit existing SSRS report. To modify existing modified report, load that project and then follow steps per below:
I think this link is the closest to answering my question but it still doesn't specifically say that you can edit the CustAccountStatementExtModern template somehow in VS to add the function of conditions around the Customer Group
This link comment I think pretty well sums up the lack of complete function across both legacy and Modern:
Why aren't these designs the default designs for the application suite reports?
We are maintaining the legacy solutions for two primary reasons:
Modern designs don't include code. Although the legacy solutions use embedded Microsoft Visual Basic (VB) code to recognize configuration keys and honor regulatory requirements that vary by region, the modern report designs offer much less flexibility. The benefit of a simple design that has minimal code behind it comes at the expense of reusability across regions.
Modern designs aren't available for all business documents. There is a gap between the supported business documents and the availability of modern report designs. Although the legacy designs aren't as aesthetically pleasing, they provide a sense of consistency.
I've proven this by setting the Forms > Print Management setup > Customer account statement to both Ext and ExtModern
There also has to be a Branding setup using CustAccountStatementExt
CustAccountStatementExt: This doesn't show the logo but does allow the Condition for Customer Group
CustAccountStatementExtModern: This shows the logo but doesn't allow the Condition for Customer Group
So this function of Dynamics 365 Finance is really rubbish. It seems to be out of a 1994 easy listening music song book.
The complicated route to modify a statement to show some extra text is beyond painful and I've wasted so much time to get here.
Business Applications communities