Small and medium business | Business Central, N...

Importing Bank of America Lock Box file into Dynamics 365 Business Central

(0) Share

Report

Posted on by dc7669

We are migrating to Dynamics 365 Business Central for our Invoicing system.

In our old in-house system, we have a process to import Bank of America Lock box file into our in-house system. The lock box file will have check number, check amount and whatever written on the memo field of all the checks received.

I found in https://docs.microsoft.com/en-us/dynamics365/business-central/bank-how-setup-bank-statement-service that it is possible to import Bank Statement into Dynamics 365 Business Central. But, I am told that Bank Statement does not have the information in the memo field. So, this may not be very helpful.

So, does that mean that we need a customization to do this import function? Anyone out there has done similar thing with Business Central?

Thanks!

dc7669

All responses (3)

Answers (0)

Suggested answer

Marco Mels on at

Like (0)

Report

RE: Importing Bank of America Lock Box file into Dynamics 365 Business Central

Hello,

You are 100% right. So hopefully your ISV will be able to implement a solution for you soon.

Thanks.
dc7669 35 on at

Like (0)

Report

RE: Importing Bank of America Lock Box file into Dynamics 365 Business Central

Hi Marco,

We are working with a partner/ISV at the moment.

The Lock Box file is coded. The partner will first need to decode the file, which is tedious/time consuming, and then do the postings in Business Central.

If the tool for decoding lock box file is already there, why re-invent the wheel, right?

For postings in Business Central, the partner will need to develop the process for us. There is no way around it due to customization we already did to our BC.

dc7669
Suggested answer

Marco Mels on at

Like (0)

Report

RE: Importing Bank of America Lock Box file into Dynamics 365 Business Central

Hello,

This is a typical question for a partner or ISV that can provide assistance or bring forward their extensions.

Thanks.