Finance Utilities
Introduction to Finance Utilities
Introduction to Finance Utilities
The release notes describes the features that are either new or changed.
The DXC Finance Utilities module provides enhanced functionalities to Microsoft Dynamics 365 for the following:
The Cash and Bank Management department can build bank statement format matching with the bank account statement files generated by Bank(s). The finance utilities provide a simplified platform to define the bank statement format definition for various file types. DXC Finance Utilities supports the following formats:
The Custom format provides some flexibility on configuring additional formats.
The Bank account statements can then be imported into Dynamics 365 based on the statement format definitions.
Matching rules can be executed either during or after the import, to automatically match the bank statement transactions to Dynamics 365 bank transactions. Also, bank transactions can be automatically created, posted and reconciled based on configured matching rules.
Finance utilities minimises the manual actions required for reconciling bank account statement(s) with bank transactions processed in Dynamics 365FO.
The Sundry Payment modification gives the user the ability to enter a supplier name and address on an individual invoice allowing these details to be used on a cheque payments, as well as one-off BSB and Account Number for EFT Payments. Therefore, many one- time vendor invoices can be stored on one sundry vendor record but allowing for separate payments without a change to the vendor record information. This also makes it possible to pay all sundry invoices in one payment proposal.
The BPAY method of payment modification provides the ability to set BPAY required fields on the Vendor and Company bank account. Flagging the method of payment as BPAY, sets the BPAY fields as mandatory for invoice transactions.
When invoice transactions are created for vendors with a BPAY method of payment, the BPAY fields are auto populated from the Vendor details. The BPAY fields can also be entered or edited at time of invoice entry. Posting validation confirms all mandatory BPAY fields are entered else the posting will fail.
Within the Vendor payment proposal, grouping also occurs for the new BPAY field.
Where the Method of payment file uses Generic electronic Export format, the Generate payments file can be sent to a secure location like ftp, ftps, sftp, azure blob or api endpoint.
See link for more details.
File can be PGP encrypted (optional).
A custom-built report has been developed to provide a Payment advice to vendors upon processing an EFT payment run. The report will show the vendor bank account details where the payment is deposited as well as the invoice numbers paid, what amount and what discount applied. This remittance advice report works in conjunction with the Smart Send function.
Finance utilities have added additional fields to Vendor approval and Vendor bank account approval on the Accounts payable parameters.
This provides companies the option to submit changes to these fields to the standard vendor approval workflows.
Provides the ability to automatically create a Purchase invoice for Product receipt(s)
Note: Only applicable to Australia.
Where the company has registered to use ABN lookup Web API and the legal entity setup in D365, it is possible to lookup and validate customer and vendor’s ABN in D365.
Note: Only applicable to New Zealand.
Where the company has enabled IRD number validation for the legal entity.
Ability to set multiple references against customers. These references can be used in the following scenarios:
Detail:
Ability to use Customer’s payment terms when posting Interest notes.
Note: Additional licensed feature included in AR Utilities
Enhancement to import customer remittance files using data entity Customer payment journal.
Ability to import budget file with monthly columns. The modification gives the user the ability to set the budget import file’s format and financial dimensions included in the file.
Modification allows users to automatically save the electronic reporting file to a secure location like ftp, ftps, sftp, azure blob or api endpoint.
Finance utilities include data entities to support its enhancements to D365. The data entities include Finance utilities tables and also enhances existing standard entities.
The following roles are included in the Finance utilities module:
See our FAQ for general information and troubleshooting.
Have a suggestion for new product or new feature for existing product? Suggest a New idea