ISO20022 Bank statements from Sharepoint folder
The Bank statement setup for ISO20022 is based on a composite entity utilizing xml- and xslt-template files to interpret the ISO20022 Camt053 file. The import is bases on browsing and selecting a xml-file from a specific folder on the PC. An improvement would be to utilize the Electronic Reporti...
Foreign Currency Revaluation Layer and Dimension
Run Foreign Currency Revaluation in AP/AR and realize that: Posting layer is always Current, even if you have postings in layers. Operations or Tax. It should be desirable to revaluate in all layers. In consequence, financial dimensions are not inherited, which should be desirable as well. Ref...
Automate Paying Calculated Commission
Would be nice to be able to calculate commission and then pay it through a click of a button or have the commission show up on the vendor payment proposal.
Payment advice sent by e-mail
When generating payments, it is not possible to send the payment advice by e-mail as the report is not a Print Management report and there is no option to choose Vendor purpose. Payment advice should be added in print management to have the option available to send it via e-mail and set a refere...
Need to get the opening balance from Previous Bank Statement
All the BAI2 bank statement files in AUS and NZ do not have opening balances field. With the current out of box function, all the customer in the AUS & NZ are facing the challenge that imported bank statements have no opening balance value.
This function suggestion request is...
Camt.054C credit notification - the exchange rate on the import file should be considered during import in the Payment Journal
When importing customer payments in D365 F&O from camt054C files (payment method ISO20022) the incorrect exchange rate is used. The journal uses the system exchange rate in D365 instead of the exchange rate from the bank statement file (camt054C). Need to import the bank exchange rate to have ...
Filter EFT file details by Payment Journal Batch
In big organizations, where several users are working on payments it would be very useful to filter EFT file details by batch, to avoid overlapping between different groups of jurisdiction. Now, EFT details are grouped by Bank Account number, ignoring the fact that batches are there to allow us t...
Add support for addenda lines to NACHA CCD+ and CTX file formats
The current implementation of CCD and CTX NACHA payments does not allow remittance details (i.e. invoice and detail amount paid) to be transmitted as part of the file. Instead, the current implementation only supports only a single detail record containing the total paid for that payee and gen...
Camt. 54 file which supports different date/time formats
In Advanced bank reconciliation, when importing bank statement file, the system uses a transformation files to convert the bank file in XML (e.g.Camt.54 )format for mapping in D365FO. The Camt. 54 file supports UTC date/time format which allows only time from 00:00 to 23:59. Many banks use diffe...
Functionality to automatically update exchange rate in payment journal lines
When updating exchange rate, there is no option to update massively all lines of payment journal with the new exchange rate.
Administrator
Importing bank statements from SharePoint folder is supported in 10.0.36.