Dynamics 365 Finance

Update data entities for Party, Vendor, Customer Postal addresses to include VAT Registration ID and the General section of the Manage Address form.

When using registration ID to maintain VAT numbers, migration of customer/vendor master data becomes extremely cumbersome to have to merge 3 or sometimes even 4 data entities using party ID and location ID to get the information imported.

Currently migrating customer master data with multiple delivery addresses and VAT numbers attached, consist of the following;

1. Customer V3
2. Customer Postal Address
3. Registration Number

These must all be linked by party ID and Location ID.

Currently, it is not possible to recognize multiple Purchase Orders within the same invoice that is read by Invoice capture.

Within a business, it can often happen that suppliers can send one invoice combining multiple Purchase Orders.

Hence, instead of having an automated way to capture the vendor invoices, the business has to manually review the invoices and assign the right PO on each line of the PO invoice before transferring to F&O.

This has a big impact on the purpose of Invoice capture and the automation of the process to facilitate the business processes of the Finance team.

The recognization of multi PO within one invoice would be then very appreciated.

We discovered that some users have been removed from the User Group in Financial Reporting Designer without any changes to the configuration. Therefore, it would be beneficial to have a method or feature to track changes made in Financial Reporting Designer.

Reference :https://fix.lcs.dynamics.com/Issue/Details?bugId=972053&dbType=3&qc=47fdff712904d4b6cebb6830e4b4dac697a696ef4aed5e150e991a9af256f41f.

*** [REPRO STEPS] ***

Tested In “GBSI” Legal entity

1.Go to Accounts Receivable>> Customers >> All customers

A screenshot of a computer Description automatically generated

create 4 customers as Test 01, Test02, Test03, Test04.

A screenshot of a computer Description automatically generated

2.Project management accounting>> Projects >> Project contracts

Create Project contract as Test

A screenshot of a computer Description automatically generated

Funding source as Test01 with GBP currency.

A screenshot of a computer Description automatically generated

In Funding source need to select all created customers

In Funding Rules select Allocation and in Funding rule allocations select

Test01-40 check box selected, Test02-20, Test03-20, Test04-20

3.Go to Project management and accounting>> Projects>>All Projects

Create a Project as Test and customer account as Test01,start date as 1st October.

Select the Project ID and keep the project in process stage.

4.Project management>>Setup>>Timesheets>>All delegates

Click New and select Resource and delegate as Admin start date as 1st oct2024.

5.Project management accounting>>Time sheets >>all Time sheets

Select the line

Need to give for 2hours for 5days total 10hours from 7th oct to 11th oct.

A screenshot of a computer Description automatically generated

submit workflow .

A screenshot of a computer Description automatically generated

6.Accounts receivable >>customers >>All customers

select Test 01

under credit and collections need to drop down and select invoice.

A screenshot of a computer Description automatically generated

7.Project management and accounting>>Projects>> Allprojects

select the project and select Manage and click on Invoice Proposal

select all we can see project transactions as 2hours for 5days.

we can see 3 MIP are created for Test02,Test03,Test04

Open Test02

invoice proposal transaction lines able to see one line with invoice line 140 and In Hour lines we can see only one line with 2 hours and Line amount as 140

Open Test03

we can see invoice proposal transaction we can see only one line with invoice line 140 and In Hour line 2hours with Invoice line amount 140.

Open Test04

Invoice proposal line we can see one line amount as 1820 but in Hours Multiple lines are created with different invoice amount and Hours compared to Test 02 and Test03 customers.

A screenshot of a computer Description automatically generated

Actual Result: We can see for Test04 customer has multiple Hour lines are created when we had given allocation percentage for Test 02-20,Test03-20,Test04-20.

Expected Result: When in allocation Rules had given equal percentage to Test02-20, Test03-20, Test04-20, customers It should show equal hours and Invoice line amount for All customers

K records are somewhat of a new thing when it comes to filing your 1099s. Near the end of the file, K records will be categorized by state code. Currently, D365 doesn't support including this data in the out of the box export file (Accounts payable > Periodic tasks > Tax 1099 > Vendor Settlement for 1099s > Create export file).

I'm proposing that K records be supported when creating an export file within F&O. The system could group values by using the codes configured in the "Combined federal/state filing codes" screen.

Many clients require K records to be included when filing 1099s, so I think this could be a very valuable addition.

There are scenarios where transactions are involved with individuals (local vendors who are not conducting a business) which requires for self-billing as well. It will be NRIC or Passport for such vendors as Business Registration Number. This is a valid scenario which needs to be supported.

The idea is that the Lease expiration/end date on General fast tab in Leases is also applied on both payment schedule lines and executory costs schedule payment lines.

Users should be able to maintain lease start date & lease expiry date in the lease master in MSD, but still should not have a payment line start date with a date beyond lease expiry date. That way the system restricts any payment which has a date plotted after lease expiry date thus acquiring better control in lease accounting & master data.

Hello, the Tax Credit note issue by D365 FFO for UAE (United Arab Emirates) is not compliant with the fiscal regulation of the country.

In accordance with local fiscal requirements, the tax credit note must include details of both the original value of supply and the corrected value of supply for each lines and the totals. This is not possible with the standard solution, as confirmed by you in the support ticket TrackingID#2405290050003222 and also by our local partner.

We suggest to verify the UAE requirement and make the process compliant with the law, by adapting the Invoice data provideer and report Layout accordling.

Thank you

Best Regards

Marcello Cagliani

The view accounting from posted sales tax isn’t being for all source of transactions:

Its source = Sales Order / Voucher / Project we cannot see the view accounting.

DETAILS:

Setup available on sales tax code if you have the marginal base = “Net amount of invoice balance” and origine = “Percentage of net amount” 

But if we try to open view accounting for sales order transactions, information isn’t display.

View accounting is displayed for transaction source = Free text invoice

View accounting isn’t displayed for transaction source = sales order

We would like to access view accounting for all type of source (Sales order/Project -Invoiced on-accounts)

User Impact:

User: The user will pay for the last document saved from the approval journal and this voucher isn’t displayed.

The original document is not available on the posted sales tax form, this makes challenging in Finance part on the Business.

Our client uses an OCR solution coupled with the vendor invoice automation feature in D365 for supplier invoicing. All vendor invoices are sent to the OCR app including prepayment invoice.

The integration utilizes two standard data entities: Vendor Invoice Header and Vendor Invoice Lines (without any customization).

The checkbox “Automatically create invoice lines” isn’t enabled because our client wants to import vendor invoice lines based on OCR reading and apply a three-way matching in D365. In France, the purchase invoice takes precedence and must be recorded even if it is not equal to its purchase order.

Solution proposed is only to enable “Automatically create invoice lines” but there is no solution to import prepayment invoice when this checkbox isn't activated.