Purchase BACS Export File

(0) Share

Report

Posted on by James De Filippo

Hi,

I've got a customer that wants to export their Payment Journal to their online bank.

I can see there is information on the AMC Banking extension but wondered if their was other options?

Thanks

James

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report
James,

Positive Pay export functionality within BC. Easy setup as follows, I am using Cronus

Choose the  icon, enter Bank Accounts, and then choose the related link.

Open the card for the bank that you want to use Positive Pay for.

In the Positive Pay Export Code field, enter BANKOFAMERICA-PP.

Close the page.

To export a Positive Pay file

Choose the  icon, enter Bank Accounts, and then choose the related link.

Select the bank account that you want to export a Positive Pay file for.

Choose Positive Pay Export action.

The Positive Pay Export page opens displaying payments that have been made for the bank account since the last upload date, as shown in the Last Upload Date and Last Upload Time fields.

In the Cutoff Upload Date field, specify a date before which payments are not included in the exported file.

Choose the Export action.

On the Export File page, choose the Save button, and then save the file to a convenient location.

Upload the file to your electronic bank site.

Write down or copy the confirmation number that is displayed when the file upload is successful.

To view exported Positive Pay records

Choose the  icon, enter Bank Accounts, and then choose the related link.

Select the bank account that you want to view Positive Pay export records for.

Choose the Positive Pay Entries action.

On the Positive Pay Entries page, you can see all the Positive Pay export records for the bank account.

In the Confirmation Number field, enter, for each export record, the confirmation number that you receive when the file upload to the bank is successful.

To view the related payment lines, choose the Positive Pay Entry Details action.

To reexport Positive Pay files

Choose the  icon, enter Bank Accounts, and then choose the related link.

Select the bank account that you want to reexport Positive Pay files for.

Choose the Positive Pay Entries action.

Select the line for the Positive Pay export file that you want to reexport.

On the Positive Pay Entries page, choose the Reexport Positive Pay to File action.

There are other choices in BC, in the US Version (I.e. CitiBank).

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No
Suggested answer

JAngle 133 on at

Like (1)

Report

Data exchange definitions or a xmlport are the other common options if you don’t want to use an off the shelf product. I’d say the latter is easier to implement but the former has a nicer editing experience if you don’t want to code.

details on either are here: community.dynamics.com/.../how-to-export-data-to-csv-files

Was this reply helpful? Yes No
James De Filippo 90 on at

Like (0)

Report

Hi Steve,

Thanks for getting back to me.

Unfortunately, I don't have the option of 'Positive Pay Export Code' under the Bank Account tab.

Further investigation online, it appears the option may have been removed for the UK release(Probably should have made my region clear!). See below:

docs.microsoft.com/.../deprecated-features-uk

Thanks

James

Was this reply helpful? Yes No
James De Filippo 90 on at

Like (0)

Report

Hi Josh,

Thanks for getting back to me.

This looks like what i need!

Thanks

James

Was this reply helpful? Yes No
James De Filippo 90 on at

Like (0)

Report

Hi Josh,

Do you have a link that will help me to format the 'Amount' field, correctly.

Need to output the 'Amount' as follows:

0000024000

^(£240)

Thanks

James

Was this reply helpful? Yes No
Suggested answer

zoom2gaurav 30 on at

Like (0)

Report

Hi James,

I manage this by using the multiplier field in the field mapping. you can check the below setting. I multiplied the amount by 100.

Was this reply helpful? Yes No