web
You’re offline. This is a read only version of the page.
close

Øyvind Berg-Olsen Solutions architect

Øyvind Berg-Olsen

Joined: 8/1/2023

  • OData entity BusinessDocumentTaxTransactions with all currency amounts

    Thu, 23 Jun 2022 08:59:31 GMT – Dynamics 365 Finance – New 

    The OData entity BusinessDocumentTaxTransactions only includes the basis amount in transaction currency.

    D365FO allows to report tax in a currency different from the transaction and accounting currency and to make this entity complete it should include all three currency amount groups:

    ACCOUNTING CURRENCY

    • Amount Origin
    • Actual sales tax amount
    • Actual nondeductible sales tax

    SALES TAX - CURRENCY

    • Amount origin
    • Actual sales tax amount
    • Actual nondeductible sales tax

    TRANSACTION CURRENCY

    • Amount origin
    • Actual sales tax amount
    • Actual nondeductible sales tax


  • Import bank statement files for Advanced bank reconciliation from a Sharepoint folder

    Fri, 19 Aug 2022 11:24:51 GMT – Dynamics 365 Finance – Completed 

    The bank file i.e. ISO20022 camt053 files reside in Sharepoint but the import bank statement does not support Sharepoint, only browsing for files.

    It is possible to set up an electronic reporting source entry which connects to document types defined with Sharepoint addresses.The import of bank statement should also have the functionality to automatically move files based on the setup below as already exists for ISO20022 Camt054 and ISO20022 Pain.002 files:


    Source settings / Sharepoint in Electronic reporting source

    • Document type for input sources
    • Document type for imported files
    • Document type for files with warnings
    • Document type for failed files


  • Update status of Autogiro payment lines by importing a ISO20022 Camt.054C file

    Mon, 13 Nov 2023 12:31:35 GMT – Dynamics 365 Finance – New 

    Autogiro is used for direct debet payment and we would like to update the payment journal lines with a confirmation of bank payments executed, based on the ISO20022 Camt.054C format. By matching the paymentID to existing payment lines it should be possible to distinguish between existing Autogiro lines and new customer payments.This should be done by importing the Camt.054C file into the Payment transfers page similar to this Swedish functionality:


    "Bankgirot Autogiro returns format for the direct debit payment format of the same name. These messages can be imported as a response to direct debit messages that were previously exported. Currently, these payments are represented in Operations as payment journal lines with a Sent status. To import a file, complete the following steps.

    Go to the Payment transfers page.

    Click Return file-customer.

    In the dialog box, select corresponding method of payment, and then browse to the location of the file to import.

    After you import the return file, the payments should be updated to the status Approved."