Dynamics 365 Finance

It is possible to use advanced date queries in views and entities as described here. However, these date queries only make sense when they are evaluated dynamically: in the current solution, the date queries are stored as a static date that is determined during the database synchronisation (typically as a part of the installation of a release).

It would be good if this behaviour was changed to use dynamic dates instead, based on the current datetime (and the timezone).

An example of a view that is defined as "all invoices with an invoice date in the future":

In the current solution, the view looks like this:

select INVOICEDATE from CUSTINVOICETABLE

  where INVOICEDATE > '2022-08-17 06:35:15'

With a dynamic date determination, it could look like this:

select INVOICEDATE from CUSTINVOICETABLE

  where INVOICEDATE > SYSDATETIME()

Thus, the change should take place in the database synchronisation, where the views/entities are created.

The feature "Awareness between ledger settlement and year-end close"

Enforces the users to settle on the same account and same year.

At the year end user must settle the open account against the year-end closing transaction.

This feature solves so many problems in closing the year and revaluation.

The only problem with this feature is that if you made cross-year settlements in previous years the feature doesn’t allow you to proceed.

I hope that this feature will be upgraded, and a new parameter will set the validity of the feature so I can use it, since there is no way I can open settlement from the last three years.

When activating the credit management checkpoint 'Release to warehouse' for blocking rules, when a sales order line is released to warehouse the total amount of the sales order is checked an not the amount of only the released sales order line(s). When the checkpoint 'Packing slip' is used, only the amount of the sales order line is checked, so both options works different.

Also when you release the sales order line with the 'Release to warehouse' credit hold checkpoint, the total sales order is released for credit hold and not only the sales order line you want to release to warehouse.

The suggested idea is to let the 'Release to warehouse' checkpoint work so that only:

• the released sales order line values will be checked and not the total sales order value.
• only the sales order line will be released for credit hold that needs to be released to warehouse and not the total sales order.

When using the Invoice register, the Due date will not be updated based on the setup on the Purchase order header. The Due date from the Purchase order header is not going to be updated on the Pending vendor invoice. It will not be possible to maintain the due date manually.

We have posting layer in General ledger module. 

We have custom posting layer 1 to 7 .However we do not have a provision to name the layers from the screen itself.

We had a provision to rename posting layers in Project module ->Project parameters in AX 2012 , from the screen itself, where we can rename the posting layers which in turn updates the labels.

Similarly we should have an option to rename the labels for Custom Posting layer 1 to 7 from the UI itself without customization. This would be helpful for reporting

When I try to generate a free text invoice from subscription billing schedule the sales tax group of the customer is not inherited to the free text invoice an I get an error message that the free text invoice can not be created.

The sales tax group should be inherited from the customer.

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,-.

After the release 10.0.32 the rounding process in the conversion of the amounts of the Credit/Debit to the Accounting currency/Reporting currency sometimes (when some combination of amounts and exchange rates are used) generates unbalanced transactions.

I experienced this problem during the Process allocation request where the system generates automatically some unbalanced transactions, this also happens using the general journals.

In my example the accounting currency of the company was EUR and the allocation journal lines were in USD (Exchange rate 0.920302).

I had a line with a debit amount of 5,000.00 and three lines in the credit amount of 2,519.50, 2,033.50 and 447.00.

In USD the journal is balanced but in the Currency section and the Reporting Currency section, the amounts in EUR for Debit and Credit are respectively 4,601.51 and 4,601.50 with a Balance of 0.01.

If I try to post the journal the system doesn't block me and generates a voucher with a unbalanced transaction.

This example is easily replicable also in a general journal entry using the same amounts and exchange rate.

This problem causes a lot of issues during the posting of allocation journals generating a considerable number of unbalanced vouchers.

I raised a question to Microsoft that recognized the problem but didn't plan a fix for it.