Finance | Project Operations, Human Resources, ...

ER Generate electronic documents - BACS for AR

(0) Share

Report

Posted on by DianaE

155

Hi Guys,

Hope you are all good today! :)

I have been trying to copy the set up we have for our Purchase Ledger BACS payments (https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/tasks/er-electronic-payments) but within the Sales Ledger.

I would need the same BACS set up within the Electronic Reporting to be used in the Methods of Payment BACS in the Sales Ledger basically.

I have tried creating a brand new configuration within the Electronic Reporting set up, copying the BACS format from the Purchase Ledger whilst trying to modify the formulas to look at the Customer details and not at the vendor details, this is the current set up within the BACS payment file in the Purchase ledger:

- - transaction = model.Payments
    - vendBankRouteNum = @.CreditorAgent.RoutingNumber
    - vendBankAccNum = @.CreditorAccount.Identification.Number
    - Destination Account Type
    - Bacs Code
    - bankRouteNum = @.DebtorAgent.RoutingNumber
    - bankAccNum = RIGHT(@.DebtorAccount.Identification.Number, 8)
    - Free Format
    - Amount = @.InstructedAmount
    - bankName = @.DebtorAgent.Name
    - id = model.FirstPaymentRecord.UltimateDebtor.Name
    - vendName = @.Creditor.Name
ERVendOutPaymControlReport?
PaymentAdviceReport? = '$PaymentsForCoveringLetter'

The system will not allow me to change the formula within this to look up at the customer tables, I am not sure if is even possible to copy this set up but for it to be picked up in the Sales Ledger methods of Payment?

Essentially we are looking at a quicker way of refunding our customers which is closely matching the same way we would process Supplier Payments, extracting a document in an XML format which thereafter gets uploaded to our bank and gets paid.

Do you know if this set up is possible, and if so, do you know of any Microsoft documents or guides on how to set this up?

I have only found documents for the AP side of things. :(

Thanks a lot for your time! :)

Diana

I have the same question (0)

All responses (4)

Answers (0)

DianaE 155 on at

Like (0)

Report

RE: ER Generate electronic documents - BACS for AR

Hi Laura,

Thank you very much for the help above. I have tried my best to match off anything that I can see in the BACS Vendor side to the new copy of it in the Customer side.

I do not have the PaymentAdviceReport and I also am not a developer and do not really understand how to modify any bindings and connections for these.

I have added the ERVendOutPaymentControlReport but because of the other file missing, the system cannot save my changes to the setup.

Do you know if this is something that a Developer should look into instead of myself?

I am really sorry for being a headache, this is just a little out of my knowledge and I am having some issues to get at the bottom of it all.

Each time I try to save my progress I get an error message about the Payment Advice Report bindings and I have no idea where to start. :/

If this is too complex to explain or it needs a developer, that is not an issue at all, I will maybe contact our Gold Partner and see if they can help at all.

I was really hopeful I maybe could have figured this out with your help, but probably my knowledge is a little limited on this particular set-up.

Thanks again, and I hope you are going to have a lovely day!

Thanks,

Diana

Was this reply helpful? Yes No
Laura Manache on at

Like (1)

Report

RE: ER Generate electronic documents - BACS for AR

Hi Diana,

For Debtor Name you should bind the node with the element from Mapping > model> Payments > Debtor> Name.

Considering the customer requirements, you can use "ERVendOutPaymControlReport" and "PaymentAdviceReport", but you will need to re-bind the fields connections for all those elements as well. Also, you may need to design the Excel templates, then re-import the templates so that the GER framework to populate the nodes accordingly by reading the cells from Excel files. For more details about Excel templates please consider the following documentation and please also check the task guide from the article.

docs.microsoft.com/.../modify-electronic-reporting-format-reapply-excel-template

I hope this information might help and please have a lovely day ahead.

Was this reply helpful? Yes No
DianaE 155 on at

Like (0)

Report

RE: ER Generate electronic documents - BACS for AR

Hi Laura,

Thank you so much for all above details, you have made my day!!

I have tried following your instructions as closely as possible but I have never had to copy one of these setups before so I am finding myself a little stuck.

I have done all above steps until point 3.4, I keep getting some error messages when I am trying to follow instructions on point 3.5.

I am just having difficulties binding back all needed items.

I am not sure what I might have done incorrectly.

Also, understandably you have left out the "ERVendOutPaymControlReport" and "PaymentAdviceReport", but what files would you be using for these? Would the same files contained in the original AP version of the BACS payment work?

Do you happen to have a view of how the binding should be looking all together?

Really sorry if it is a lot to ask, I am just not extremely familiar with this way of configuring an electronic file.

Thank you very much once again!

Diana

Was this reply helpful? Yes No
Suggested answer

Laura Manache on at

Like (2)

Report

RE: ER Generate electronic documents - BACS for AR

Hi Diana,

Thank you for reaching out to Microsoft community. There will be few recommended options you may have here:

1. To create a new configuration from scratch and to replicate the mapping to be similar as it is done into the existing BACS (UK). This will prevent any further performance issues and to avoid having any remained mappings or fields if you choose to derived and adjust the existing BACS (UK). Please note that you will need to select 'CustomerDirectDebitInitiation' for the data definition.

2. Please raise the request on Microsoft ideas portal since the product group considers and reviews with priority the items logged on the portal. Additionally, multiple customer will benefit of this feature. Link to idea portal that could be use: experience.dynamics.com/.../

3. Customize the existing BACS (UK) following the below recommended steps:
3.1. derive "derived BACS" from BACS (UK)
3.2. open the derived config in Designer (please note that for a simplify example we removed "ERVendOutPaymControlReport" and "PaymentAdviceReport")
3.3. select Mapping from the right side, and then click on model > edit

3.4. from 'Definition' parameter select 'CustomerDirectDebitInitiation' (for AP / Vendor ledger, data definition is set as 'CustomerCreditTransferInitiation' and this should be changed)

3.5. re-bind the fields connections considering the similar fields for AR (instead the ones from AP) from the new data definition 'CustomerDirectDebitInitiation' we selected previously

3.6. save and complete the "derived BACS" configuration
3.7. verify Method of payment to be set as "Bacs" and when we generate the payment, the file with customer payment is generated as well.

Please let me know if this helps or if you need any other information, and we will be more than glad to assist further.

With kind thoughts,
Laura

Was this reply helpful? Yes No