After adjusting a lease via the lease adjustment wizard, the lease end date should update in the lease details page. Currently only updates in the book.

Can we be alerted when the Financial Reporting  MRDB and AXDB gets out of sync?

Business Justification:

We are continuing to experience issues with the FR - accounting is having to check data in FR every time FR reports are refreshed before certifying the report for consumption. We reported this in case 2312040040006743 - we know that there is a known issue that can occur when MRDB and AXDB get out of sync. We also know how to fix it - by resetting the datamart

How can we trust the data in the FR due to this issue? Checking FR report every time they are generated is not practical.

Per an Idea suggested in April 2022 - the Product team was focusing on "eliminating the need for data mart resets".

Does not look like this has made any progress. Hence the need for system help .This issue with FR is eroding confidence in FR reporting & has raised the risk of inaccurate financial reporting for our organization.

Business process/setup

Company is based in UK but this might occur in different entities location

Company use Date of VAT register global feature: Tax point date (Date of VAT register) - Finance | Dynamics 365 | Microsoft Learn

Company run ‘settle and post” based on Date of VAT register

Company post vendor invoices with the automatic fill of Date of VAT register as document date

Due to the delay in receiving invoices there might be documents that are posted in current month but with date of vat register in one of previous periods, example, Posting date: 10/30/2023, Date of VAT register (document date) 15/07/2023

Till the document is posted in the system ‘settle and post sales taxes” has been run for all previous periods – original and as well correction. 

User do not want to run ‘settle and post’ for each month, but identify all transactions that has not been included in settlement, change the Date of VAT register to current period and include in last declaration. 

NOTE: Running ‘settle and post” for each previous month is time consuming, not efficient and require to submit corrections for all periods to Tax Office.

Issues

Issue 1: Not easy to find what transactions have not been included in any of previous ‘settle and post sales taxes and find all that has not been included. 

Issue 2: Not able to find out from where the difference is coming on VAT account if we check Trial Balance, Accounting source explorer. 

Current way of control

Right now, user must run 2/3 (sales tax list, sales tax transactions) reports and filter transactions on “Maintain VAT register transactions” to identify the transactions and discrepancies.

Go voucher by voucher to check if it was included in ‘settle and post”

Note, that we can only count on the “version” on the sales tax transactions/Maintain VAT register transactions which is not sufficient, because in each previous period ‘settle and post’ could be run several time (original and latest corrections), so the version for each month will be different and we cannot use this for filtering. 

There is no other information about if and where the sales tax transaction ahs been included in ‘settle and post” periodic task. 

Possible improvements: 

Possible improvements that will help to reconcile ledger and sales tx sub ledger and also identify transactions that has been posted after the ‘settle and post”

1. Create 2 new columns in table — VAT Settlement Voucher and VAT Settlement Date. 

2. Populate data to 2 new columns When using Settle and post sales tax process into TaxTrans. 

3. Add these 2 new columns to posted Sales Tax, Maintain VAT Register Transactions and Voucher Transactions. 

4. Add Date of VAT Register to Accounting Source Explorer, Ledger Settlements and Voucher transactions. 

5. Add Document Date to Maintain VAT Register Transactions 

6. Block functionality to change Date Of VAT Register after Settle and post sales tax was done 

(VAT Settlement Voucher column is filled) in Maintain VAT Register transactions. 

Please provide a method in X++ that we can call to determine if the current environment is a production environment or not.

To Microsoft Team,

I am seeking your assistance in the development of a structured process for the creation of an API database import mechanism from Tier 1 Environment to Tier 2 Environment. The establishment of this database migration procedure is deemed imperative and promises to be advantageous not only for our customers but also for the testing engineers involved.

Your guidance and expertise in this matter would be greatly appreciated.

When

1. utlizing Dual Write, map Customers V3 (accounts)
2. Tax Exempt Number is set mandatory by configuration in F&O

Creation of accounts cannot be performed in CE, i e Dual Write's integrated customer master scenario is thus broken. In order to walk the talk, this issue needs resolution.

Above is due to the fact that Tax Exempt Number is a supported table that needs to be referenced in F&O, whilst it is a single field in CE. There is no ability to insert the record in the supporting table in F&O from a synchronised text field in CE

According to the Dual Write product team, above issue belongs the Accounts Receivable product team. Thus this entry.

Today is out of scope the record 1601 for the generation of the fiscal SPED.

This record 1601 (OPERATIONS WITH ELECTRONIC PAYMENT INSTRUMENTS (VALID FROM 01/01/2022) depending on each federative unit, its generation may be mandatory from 2023.

See the page 301

Link:  http://sped.rfb.gov.br/estatico/83/641EFB2FC0E317FFF8A5A5D09E3C874F3CDB04/Guia%20Pr%c3%a1tico%20EFD%20-%20Vers%c3%a3o%203.1.3.pdf

The Asset Leasing module is not able to account for partial months.  Not all leases start at the beginning or end of the month. As a result, business either has to modify the lease schedule to reflect what the module is capable of handling.

At present, the system supports configuring alerts at the individual batch job level, enabling notifications for job completion, failure, or cancellation. However, it lacks native functionality to set alerts at the batch group level. As a result, when dealing with batch groups containing hundreds of jobs, each job must be configured separately to enable alerts making the process time-consuming and inefficient. We're therefore exploring a solution that enables more streamlined monitoring and faster issue resolution.

Issue Context: In Dynamics 365 Finance and Operations (D365FO), when importing general journal lines using “Data Management” or “Excel Add-Ins,” it has been identified that the UUID field (CFDIUUID_MX) —required by Microsoft’s Mexican localization— is not available in the standard data entity General Journal Account Entry. Although this field exists in the journal lines interface, it is not exposed for mass import/export operations.

Operational Impact:

• Affects multiple Mexican companies.
• The absence of the field prevents compliance with Mexican fiscal requirements.

Key Findings:

• The UUID field appears in the journal lines screen for Mexican users but is not available in the data entity for import.
• The “Insert Columns” feature allows manual addition of the field, but this is not viable for bulk operations.
• It has been confirmed that the CFDIUUID_MX field is missing from both the import template and the field mapping in the entity.

Expected Outcome:

• Modify the General Journal Account Entry entity to include the UUID field (CFDIUUID_MX).
• Ensure it is available for both data import and export actions.
• Make the field visible in the Excel Add-In template by default.