Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
If you are ever trying to combine sites using out Professional Services Library tool “Inventory Site Combiner” and receiving the following error “You cannot combine the sites as it is the same on a transfer record in the history table.”, this article is for you!
The issue occurs when the two sites that are being combined exist on the same transfer document in the IV history table IV30300. This is working as designed. Let me explain below an provide what you can do to get around it. The Site Combiner tool will update the appropriate historical records and take quantities from one site to the other site. When there has been a transfer between the two sites that are being combined, the tool cannot do it because that would cause the history record to be updated incorrectly and so you receive the error to stop it from happening. If it allowed it, the transaction would show that a transfer was done from a site to that same site which would not make sense. In instances like these, the only option would be to remove history on those types of transactions before combining sites. This is a limitation/error of the tool.
Use the following steps to identify the documents to remove and location of where to go to remove the data.
select * from IV30300 where DOCTYPE = 3
select * from IV30300 where DOCTYPE = 3 and TRXLOCTN = 'SITE A' and TRNSTLOC = 'SITE B'
Once you have your list of document numbers from Step 2, the supported method to address this would be to remove history on the documents by going to Remove Inventory Transaction History (Tools | Utilities | Inventory | Remove Transaction History).
Removing data from SQL is an option by using scripts, but to do it right you would have to write scripts to remove it from the header, lines, distributions tables etc. Using the GP utility removes it from all tables at once so this the recommended solution.
When you test removing history, you can use the following options.
Note: If you STILL get a message after removing the documents from the 1st script above, look at the vice versa scenario to see if those are too causing the error.
select * from IV30300 where DOCTYPE = 3 and TRXLOCTN = 'SITE B' and TRNSTLOC = SITE A'
Hope this is helpful in identifying the records the need to be removed to successfully combine your Sites.
Angela Ebensteiner | SR Technical Advisor | Microsoft Dynamics GP
Business Applications communities