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

Gerben Mulder

Gerben Mulder

Joined: 8/27/2019

  • Ledger settlement -> remaining accounting amount automatically posted to exchange rate/loss account

    Tue, 27 Aug 2019 11:42:23 GMT – Dynamics 365 Finance – Completed 

    Currently it is not possible to settle two transactions (General ledger -> periodic -> Ledger settlement) when the transactions amount (for example €) is net-zero and the accounting currency (for example USD) isn't zero. First transaction: +€100 = +$111 Second transaction:. -€100 = -$109 Actually D365 should settle these transactions and post the realized exchange rate gain/loss automatically to one of the main accounts which have been setup in the Accounts for currency revaluation (general ledger -> ledger setup -> ledger)

  • Remove validition of Audit file

    Wed, 21 Apr 2021 12:04:08 GMT – Dynamics 365 Finance – Under Review 

    Sometimes a company doesn't have any customer or vendor data/transactions. Only general ledger transactions have been posted in this entity. While running the Audit file (NL) an error will be thrown: Financial period X does not contain an openings balance. The root cause of this error is because of the validation of the audit file functionality: both temporary tables ledgerAuditFileOpeningBalanceSubLedgerLinesTmp and ledgerAuditFileTransactionSubLedgerTmp are empty. These tables are populated in the methods fillOBCustSup() and fillTransSubLedger() correspondingly of the LedgerAuditFileDataTransformation class. These methods analyze customer and vendor transactions. The report is failing on the data validation stage due to missing customer and vendor transactions in the legal entity. Desired situaton: if the legal entity does not contain customer/vendor transactions the Audit file (NL) should be generated successfully.

  • Collection fee based on a percentage of the collection letter value

    Thu, 09 Mar 2023 11:03:52 GMT – Dynamics 365 Finance – Rejected 

    In the Netherlands it is mandatory to apply the WIK (Wet Incassokosten/Law Collection Fee) on a collection. This is a fee which can be calculated based on a percentage of the outstanding balance stated on the collection letter.


    The minimum fee amount is €40,- and the maximum fee is €6.775,-. However in between the fee is calculated based on a percentage:

    To 2.500 -> 15%

    The next 2.500 -> 10%

    The next 5.000 -> 5%

    The next €190.000 -> 1%

    Above €200.000 -> 0.5% with a maximum of €6.775,-.


    We considered using the standard functionality, however this fee is fixed. Secondly we considered to use the interest note functionality, however this is a different document than the collection letter. Thereby this functionality is working slightly different, it is calculating the percentage per range based on the total of the collection letter. So in case the collection letter value is €3.000,- (and we apply the same logic as stated above), the calculated percentage is 10% instead of 15% based on the first €2.500 and 10% over the last €500,-.