We are scheduling to go live in September with D365. We are migrating for AP open transactions (open AP and unallocated payments). Has anyone any suggestions how we can ensure we do not re-process invoices that have already been processed in the legacy system. The normal control is to disallow duplicate invoice numbers but because this is a new system the duplicate number check will not work.
Thanks for any advice
Hello Simon,
I don't think that there is a standard solution in D365 available that would mitigate your risk.
What you can possible do as an additional safeguard is exporting all invoices that are going to be paid from your payment journal into Excel. Once you have that information available there you have to get all the old invoices from your prior system in there are well.
This then allows you running a check whether you have some duplicates.
Best regards,
Ludwig
Hi Simon,
For go-live, the cut off date will be decided on which data migration will happen. This data migration process usually over weekend and for 1 or 2 days. Once the data is migrated and D 365 is up and runnning. AP will do all transcations in D365.
For these 1-2 days customers usually do not accespt any supplier Invoice or if accepted, process it only in D365 after go-live. Ofcourse they can always check the legacy system while doing so.
There is no other automated or system check is in place.
Does that answer your question?
Hi Ludwig,
No the question I ask is how do we mitigate the risk of a supplier sending an invoice in that was paid before data migration and AP process it again for payment incorrectly. (or a simple clerical processing error) . D365 will check for a duplicate invoice number but because this invoice is not open and has not therefore been migrated it will not be registered. The only means I could think of was for AP to refer to legacy system as well as a manual process.
Cheers
Can you elaborate?
I would expect that you post your open invoices once again in D365.
If they are paid then you don't have to migrate them but if they are not then you need to post them once again to create the open position that can be paid later in from D365.
1. Do you have option to take only open invoices?
2. Generally we should take all the open invoices and the total should match with Trial balance , then only you should take for consideration
3. One check is which you have talked about duplicate check
4. This should be taken care while preparing the data for migration that we do not consider any invoice which has been already paid in legacy system
Ideal way would be to perform the check before migration when you export the data. The other way would be to customize the duplicate check to perform on unposted journal lines as well besides the standard validation.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sohaib Cheema 844 User Group Leader
André Arnaud de Cal... 752 Super User 2025 Season 2
CA Neeraj Kumar 553
