Jose Manuel Rey Benlloch

An error message "A number sequence has not been set up for the reference internal invoice in the area Accouns payable" is received when posting a purchase order in the invoice pool. In this case, the customer/the customer's accounting department must enter the order each time and assign a number range group to the order. Only then can the booking be made via the invoice pool. Given the number of invoices, this procedure is very time-consuming, and this workaround is not acceptable for the customer.

Our expectation is that the logic of the invoice pool should also function in the same way as the chronological number range group. 

Converting Excel to MT940 every month using some Third-party tool is cumbersome, we believe that Microsoft can add more flexibility to customer by adding more formats to ABR statement ER formats.

This request stems from the challenges our customers are facing when attempting to convert Excel bank statements to MT940 format for importing into Dynamics 365 system.

As you are aware, our customers rely on the efficiency and accuracy of their financial data integration with D365. However, a recurring issue has emerged where Excel bank statements, which are commonly provided by banks, need to be converted into the MT940 format before they can be imported into Dynamics 365 system. This conversion process can be cumbersome and error-prone for many of our users.

To address this challenge, we are exploring the possibility of creating a seamless solution that would allow our customers to directly import Excel-based bank statements into D365 without the need for manual MT940 conversion. Specifically, we are interested in:

• Deriving existing ABR Statement model, MT940 mapping, and MT940 format into Excel, ensuring that all relevant data fields, relationships, and formatting are preserved.

• Establishing a standardized Excel format that aligns with the requirements of our system, making it easier for our customers to import their bank statements without errors.

We believe that this enhancement would significantly improve the user experience for our customers and reduce the complexity.

Once the invoice is paid, the VAT information must be included in the SII report. However, the system doesn’t update the information reported when the invoice is registered.

We expect a new message item line to generate when the “GenerateMessageItem” is activated. The line should have at least the following information:

·        Processing (control name: ItemsGroup_Processing): SII

·        Message item type (control name: ItemsGroup_ItemType): PagosProveedor

·        Message item status (control name: ItemsGroup_ItemStatus): Creado

We understand this new item will be managed inside the system page with the “EvaluationFields” and the “GenerateMessageVP” actions, in case of vendor invoice. 

We expect something similar to the intracommunity operations process: the generation of a second item related to the FacturasProveedores document. But, in this case, the document should generate after the payment of the invoice and should include the VAT information. 

An ability to use Expense deferral functionality from Subscription billing module in Invoice register journals or Invoice approval journals.

We know that it works with PO invoices and Invoice journals, but we can’t locate any setups for Invoice registers and/or Invoice approval journals, which are also standard and very much used functionality, specifically in very large organizations that are using Invoice import. As our clients do, they are using one of the most well known ISVs to import vendor invoices – ExFlow, that uses Invoice registers and Approval journals functionality.

Our request is a setup or even a manual way to use Subscription billing expense deferrals with this standard functionality and when is it planned for as it is not one client that is concerned about it and asking for it.

When enabling the "Project invoice proposal performance enhancement feature" in the "Project management and accounting parameters" a new setup for "Invoice"

"Display available transactions automatically" is available to set the default value.

But in the "Project invoice proposals" when creating a new proposal the "Display available transactions automatically" is greyed out.

For single invoice automatically would be fine.

But for a collective invoice, many filters has to be entered. And for every field the system automatically try to display the result. But this takes several minutes.

The best would be, when the "Display available transactions automatically" would not be greyed out in the create invoices proposal form.

Workaround: "Project invoice proposal performance enhancement feature" disabled

Since the period close process always happens on the 10th of the month in our company, sometimes those days are weekends. In order to avoid accountants having to work on the weekend, we would like the possibility to schedule the Bank FCR in advance (for example on Friday), or even as a recurring job to run on the 10th of every month.

This is already possible with all other foreign currency revaluations in the system: AP, AR and general ledger so we would like to use the same logic with Cash and bank revaluation.

We are already live with our implementation, and have been for quite some time, but the fixed month close date is a recent requirement, which is why this issue was never reported before.

Is it possible to schedule this function to run on a specified date/time in the future?

As per Microsoft documentation, the following asset leasing books should be configured in the system for Dual reporting requirements:

https://learn.microsoft.com/en-us/dynamics365/finance/asset-leasing/dual-reporting

- IFRS 16 book (Posting layer=Custom layer 1)

- Statutory book (Posting layer= Current)

- Statutory reversal book (Posting layer = Customer layer 1)

We would like to do the following setup on our project:

- IFRS 16 book (Posting layer=Current)

- Statutory book (Posting layer= Custom layer 1)

- IFRS 16 reversal book (Posting layer = Customer layer 1)

Three books are required to report under both statutory reporting and IFRS reporting.

- The IFRS 16 book creates the journal entries according to the rules for that are required for IFRS 16 under current layer.

- The statutory book records the lease payment according to the rules for cash-basis accounting under custom layer 1

- The IFRS reversal book reverses the IFRS16 journal entries under custom layer.

If we want to use the Statutory figures to run the same trial balance, the IFRS 16 accounting journal entries must be reversed, and the Statutory journal entries must be posted. To reverse the IFRS16 journal entries we should create a IFRS16 reversal book that has the same setup as the IFRS16 book but an opposite posting profile.

The issue is that we couldn't find any way to do the specific setup for the IFRS 16 reversal book in the Asset leasing posting accounts on the Asset leasing parameters page (Asset leasing > Setup > Asset leasing parameters).

We have been utilising this Microsoft data migration approach document for opening lease balance migration

https://community.dynamics.com/blogs/post/?postid=df76953f-bb2c-405a-ad21-cabcf82d742d

It is not possible to use the historical lease transactions to arrive at the lease balance, so we are utilising "option 2" from one of the Microsoft approach documents to bring the lease in at a "point in time".

We utilise a 4-4-5 financial calendar and are linking finance leases to fixed assets. This means that the fixed assets can depreciate on a weekly financial calendar to calculate 4-4-5 correctly and the monthly lease postings can occur in the lease module.

Because of 4-4-5, the cutover date at go-live will not always be a month end, it will be a period end.

Example:

Period end date of 27/10/2023.

Using this as an example, we are populating on the lease the lease commencement date of 27/10/2023 and according to the article.

In line with the article, we need to create a payment schedule line with zero amount to cover the period between the cutover date, and the date or next payment.

However, in doing so, we are encountering errors. Some leases have a quarterly compounding interval and quarterly payments. 

When setting up the payment schedule, we are getting error messages relating to the payment frequency of the payment schedule line must be quarterly if the compounding interval is quarterly.

Example:

Lease commencement date 27/10/2023

Next actual payment date 29/12/2023

So we are entering the below in the payment schedule:

Lease commencement date 27/10/2023

Payment schedule line 1 = 27/10/2023 for 2 months at zero amount with Quarterly payment frequency

Payment schedule line 2 = 27/12/2023 for 2 days at zero amount with quarterly payment frequency. 

Payment schedule line 3 = 29/12/2023 for 16 months at the payment amount with quarterly payment frequency.

This then gives an error saying: For period interval Days, payment frequency must be Monthly

When we then set the payment frequency to be monthly, we encounter another error message when trying to create the payment schedule.

Payment frequency should not be more frequent than the compounding interval. 

It does not seem possible to setup the lease to accommodate for quarters where there is a timing difference between the cutover date and the next payment date.

Our customer is using deferrals on sales orders for different items/types of sales and with different templates. For some items/order types, sales orders are created manually, and transaction deferrals are maintained on the sales order line, prior to invoicing. For other items, sales orders are created via integration, invoiced in batches and recognition done via the Recognition processing menu item.

Currently it is not possible to easily trace from the original customer transaction (the invoice posting) to the final accounting (deferred) ledger transaction; the possibility to reuse the voucher number from the invoice voucher to the deferral transaction would be an option – otherwise maybe some kind of “related voucher” function could be introduced. Currently looking at the customer transaction for the invoicing does not leave the possibility to identify to which sales account the value has actually been posted.

Project journal reversed with the change funding source at project contract, system does not reverse the journal with the original funding source financial dimension. Due to this it causes the inconsistency for the reconciliation.

Please refer to Issue 886210