When you synchronize data between companies in Business Central, the synchronization can fail if a data template includes fields that don’t exist in the subscriber. This often happens when a field comes from a localization or an app that isn’t present in the receiving company. You fix this by deleting the relevant lines in the data template.
To delete a line, set the data template to Under Development, mark the lines you want to remove, delete them, and then set the template back to Released. After this, the record data only includes the fields you have chosen, and the synchronization runs without errors.
Why you sometimes need to delete fields in a data template
In some situations the data template contains fields that don’t exist in the subscriber company. The reason is usually that the field comes from a localization or from an app that isn’t installed in the company receiving the data.
When that happens, you need to delete those lines in the data template so the synchronization can run smoothly. If you leave fields that the subscriber doesn’t recognise, the synchronization won’t complete as expected.
How to delete lines in a data template in Business Central
The process is straightforward. Open the data template and mark the one you want to edit. Set it to Under Development, which is what lets you delete the lines.
Then mark the lines you want to remove from the data template. In this example, you would mark the Last Modified Date Time field and the related code, because these fields come from a localization that isn’t present in the subscriber.
With the lines marked, choose Manage and delete the lines. When you’re done, set the data template back to Released.
The result after editing the data template
Once the template is released again, the record data only includes the fields you have chosen to keep. The fields that didn’t exist in the subscriber are no longer part of the template, and the synchronization between the companies runs as it should.
Q&A
Why does my data synchronization fail in Business Central?
One common reason is that the data template includes fields that don’t exist in the subscriber company. These are often fields from a localization or an app that isn’t installed in the receiving company. Removing those lines from the data template lets the synchronization run.
How do I delete a line in a data template?
Open the data template and mark the one you want to edit. Set it to Under Development, mark the lines you want to remove, choose Manage and delete the lines, then set the template back to Released.
Why do I need to set the data template to Under Development?
You can only delete lines in the data template when it is set to Under Development. Once you’ve removed the lines, you set it back to Released.
What happens to the synchronized data after I remove fields from the template?
The record data only includes the fields you have chosen to keep. The fields that didn’t exist in the subscriber are excluded, so the synchronization runs without errors.