Views:

Applies to Product – Dynamics 365 Business Central


What’s happening?
Custom fields are not displaying in the report Word layout for a US environment, while they function correctly in the AU environment.


Potential Cause:
This may arise due to several factors, including incorrect report layout configuration, visibility of custom fields in the customer table, language settings, improper field references in the layout, data issues, or customizations affecting the report.


Troubleshooting:
Verify Report Layout Configuration:

  1. Ensure that the Word layout for the report has been configured correctly.
  2. Check if the correct fields have been added to the Word layout.
  3. Navigate to the "Report Layouts" page, find the report, and ensure that the layout type (Word or RDLC) is selected appropriately.
Check Custom Fields in the Customer Table:
  1. Verify that any custom fields added to the customer table are visible in the report layout.
  2. Customize the report layout to pull in these specific fields if necessary.
  3. Ensure the custom fields have been properly mapped using the content controls in the Word layout.
Inspect Language Settings:
  1. Check the Language and Region settings under the General Settings to ensure the USA environment settings are being used correctly.
  2. Ensure the report is set up for the appropriate locale/language, as different languages or locales can affect the data displayed.
Ensure Proper Field References in the Layout:
  1. Confirm that the field references in the Word layout are set up correctly.
  2. If using a custom report layout, ensure the fields are referenced in the correct format (e.g., Customer.Name or Customer.City).
  3. If the report is based on a custom page or query, ensure that the correct fields are included in the data source.
Check for Data Issues:
  1. Verify that the customer data itself is correct and that the records are filled out as expected.
  2. Check for any changes in the schema or the database that may affect the report layout.
Check for Customization Issues:
  1. If there have been any customizations or extensions implemented for the report, ensure that those customizations are functioning correctly and not causing the fields to display incorrectly.
Rebuild the Report Layout:
  1. If the issue persists, try recreating or resetting the Word layout and adding the required fields again. Sometimes, layouts can get corrupted or not refresh properly.
Clear Cache/Refresh:
  1. Clear the cache or refresh the environment to ensure that the latest configuration is being used.
By following these steps, you should be able to identify and resolve why customer fields are unexpectedly not showing in the report Word layout for the USA environment. If the issue persists, further investigation may be required to share the report layout and the specific custom fields that are not functioning as expected.