Dynamics 365 Finance

We have a legal entity with VAT registration in DK, DE and LT.

We use transfer orders to transfer between our own warehouses located in DK, DE and LT. That part works fine (VAT is calculated correct and information to Intrastat is also correct)

The issue is:

We also use transfer orders to ship items to and from subcontractors in other EU countries than DK, DE and LT.

We have a warehouse created for each subcontractor with the country of the subcontractor. Vendor account on the subcontractor is the subcontractor vendor account.

Issue:

D365FO do not find Counterparty tax regsistration when we ship

D365FO do not find any tax information when we receive

When we have a tax combination " Group and group Item' with a sales tax code shared between them with a Zero Rate it throughs an error that the tax combination is not valid.

This happened because the result of the combination is Zero, so the tax code validation read the combination as a wrong one.

To resolve that we need to turn the toggle for "Check sales tax code " to None or Warning.

But this is not the best option as we need the validation when we have a wrong combination to prevent users from proceed also we need to use the Zero rate so we trace which transactions were posted using this VAT code >tracing error or missing tax transactions becomes easier.

So the suggestion would be to remove the Zero tax code form the validation as long as the setup for the sales tax code, Item and group is correct it should proceed as normal with no error. 

After posting a project invoice, the system occasionally (randomly) unexpectedly creates an orphaned record resembling the original invoice, but with a voucher containing over 30,000 random lines. Microsoft provided a cleanup procedure to delete this record and confirmed it would also remove related data if any postings existed. The root cause analysis was not done, assuming it was a one-time issue likely triggered by background processes. Since the issue is happening occasionally, the idea is to find out why it is happening, what is triggering the generation of orphan records and to prevent that from happening rather than to perform the manual clen-up every time the system generates the orphan record (which needs to be searched for manually since there is no notification that such record has been created in the system).

In the control tab at the top of the bank reconciliation worksheet screen, the difference between what has been selected should be displayed; this would make it easier to identify the other amounts to be reconciled.

At this moment, we can only see the total amount selected, not the difference.

There are too many criteria to reconcile banking transactions, which cancel each other out.

We need to be able to reconcile bank transactions that cancel each other out, including summarized transactions (by payment reference, for example). At this moment, D365 allows to reconcile only the "Others" document type.

And not to have so many matching criteria (same payment references, same transaction type, same document type).

There are business cases, where we can sell to or buy from a customer/vendor, who has no VAT ID at all, but is in EU country. In this case, if the check on VAT IDs is set to validate EU countries, we won´t be able to post the invoice for such partners.

There should be a possibility to set a parameters, which put an additional criteria to this check.

I can imagine to have it on Cust/Vend groups or directly on customers/vendors.

For now, you would need to use Dummy IDs, what´s wrong.

Create and post a Free text invoice (export invoice) with a foreign customer

Open the export invoice print copy –

Actual result:

Total invoice value (figure) is not equal to ‘Grand total’ amount

Grand total amount not showing in words

Total invoice value (words) – One Thousand and Zero Paise

Expected results:

Total invoice value (figure) should be equal as shown in ‘Grand total’ amount

Grand total amount should be shown in Words as well

Total invoice value (words) – One Thousand Dollar and Zero Cent

(Note – Should show words with currency as used in Export invoice, if export invoice posted in different currency same currency should be updated)

We had requirement for extensive of cost allocation to generate different types of profitability statements for management reporting. Financial impact for the cost allocation was not required. So we tried to use the Cost Accounting module and across following Gaps -

•Option to perform allocation based on different financial dimensions in the same distribution policy is required e.g. for SKU wise profitability, allocation of cost based on Cost center dimension is required for certain GL whereas for other GL's cost allocation based on SKU dimension is required

•Option to perform allocation across dimensions is required e.g. cost charged to cost center is required to be distributed to SKU dimension in combination with multiple dimensions.

•Option to upload statistical dimension values based on multiple financial dimension combination and to use the same for allocation is required for e.g. quantity uploaded in combination of Cost center and SKU dimension should be used to perform allocation from cost center to Cost Center + SKU dimension based on the quantity uploaded

We are using following dimensions - Segment (SG), cost center (CC), SKU

Example -

Expense 1 booked on Segment and Cost center dimension. Now, to generate SKU wise profitability cost booked in SG+CC dimensions needs to be distributed between SG+CC+SKU dimension based on statistical data.

So, Source value to be picked from SG+CC combination and allocated to SG+CC+SKU dimension combination based on the statistical data at this level.

Also, in a single profitability report there will be requirement to allocate certain cost from SG+CC combination whereas other cost from SG dimension and remaining from SKU dimension.

Business Case:

This kind of complex allocation options are required in multiple industries to generate various profitability statement. Since Dynamics doesn't support this requirement businesses have to either use ISV solution or customization or 3rd party systems.

Customer wise profitability, Segment wise profitability, SKU wise profitability, Profit center wise profitability, etc. are the most common examples of profitability statements in industries. To generate these reports allocations are required to distribute various costs based on different source & metrics.

Ask

Cost accounting module can become a great solution if we can have all these kinds of allocations available in that module, it can increase management experience and reliance on Dynamics system. This will enable key management decisions.

We need to include an option to set an expiration for the carry forward balance. Currently, in the Leave type settings, there is an option to designate a leave type as a carry forward leave type. We need to add an expiry rule so that the carry forward balances are only available for a certain period of time.

Currently, the quality updates package package is available in LCS, and we download a CSV file to review the fixes included in each update.

However, the issue we encounter is that it’s not always clear from the title or problem description where the fix has been applied.

Since Microsoft delivers fixes across a wide range of locations and modules for all customers, many of these may not even be relevant to our specific configurations or regions.

To improve the usability of this list, we would like to suggest introducing an additional category that specifies the module or area where each fix has been implemented.

Alternatively, this information could be incorporated into one of the existing categories.

The reason for this request is that the current approach is both time and resource-consuming, as we need to analyse each fix to determine its applicability.