How can I update the bank account in Customer Account Statement depending on Customer Group

(0) Share

Report

Posted on by Dave123

119

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

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

Hi David,

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.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi DavidWakeman,

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,

Ludwig

Was this reply helpful? Yes No
Dave123 119 on at

Like (1)

Report

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

Cheers!

Was this reply helpful? Yes No
Dave123 119 on at

Like (0)

Report

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?

Cheers!

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

hi David,

Links below provide good details to get started:

docs.microsoft.com/.../ssrs-report

Link below details different options available. provides a good starting point and then you can start to focus on particular reporting type.

docs.microsoft.com/.../create-nextgen-reporting-solutions

Was this reply helpful? Yes No
Dave123 119 on at

Like (0)

Report

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

thanks,

Dave

Was this reply helpful? Yes No
Suggested answer

Satish Panwar 14,671 Moderator on at

Like (0)

Report

Hi Dave,

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:

locusit.com/.../

Was this reply helpful? Yes No
Dave123 119 on at

Like (0)

Report

Thanks Satish,

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.

thanks,

Dave

Was this reply helpful? Yes No