Troubleshooting

Use this section to help solve some common problems that may occur when importing data from FoodChain ID.

Errors

If you cannot solve an error, make a note of it and contact our support team.

Base Unit of Measure must have a value in Item

Cause: This error occurs when importing recipes, and one of the items to be added to the production BOM does not have a value in the Base Unit of Measure field on the Item Card page.

Solution: In Business Central, select a value in the Base Unit of Measure field on the Item Card page for the item listed in the error.

The field Unit of Measure Code of table Production BOM Header contains a value that cannot be found in the related table

Cause: This error occurs when importing recipes, and the unit of measure of the recipe does not exist in Business Central.

Solution: In Business Central, add the missing unit of measure, listed in the error, to the Units of Measure page.

The settings for expiration dates do not match on the item tracking code and the item

Cause: This error occurs when importing ingredients, packaging or finished goods, and the Shelf Life field in FoodChain ID has a value but the Business Central item does not have an item tracking code.

Note

The Shelf Life field in FoodChain ID is a manually added field that maps to the Expiration Calculation field on the Item Card page in Business Central.

Solution:

1. In Business Central, ensure that an item tracking code exists where the Use Expiration Dates toggle is turned on.

2. Ensure that an item template exists where the Item Tracking Code field is populated with an item tracking code where the Use Expiration Dates toggle is turned on.

3. When setting up the item configuration, select the item template that has an item tracking code where the Use Expiration Dates toggle is turned on.

The Unit of Measure Code does not exist

Cause: This error occurs when importing ingredients, packaging or finished goods, and the unit of measure does not exist in Business Central.

Solution: In Business Central, add the missing unit of measure, listed in the error, to the Units of Measure page.

Unit of measure Code cannot be empty for Production BOM Header

Cause: The recipe in FoodChain ID is missing a value in the base unit of measure.

Solution: In FoodChain ID, add the base unit of measure to the recipe listed in the error. The base unit of measure is typically found in Other Information.

Production BOM not fully populated

Recipes and finished good recipes are imported in alphanumerical order, which can sometimes cause a production BOM to be created that contains blank component lines. This occurs because the item or child recipe that makes up a parent recipe has not yet been imported when the parent production BOM was created.

To fix the error, you will need to manually update the blank component lines in Business Central. If you are using FoodChain ID codes as your item numbers in Business Central, displaying the FoodChain ID Code and FoodChain ID Quantity fields allows you to see the information that you need to complete the components.

1. Choose the icon, enter Production BOMs, and then choose the related link.

2. On the Production BOMs page, open the record to which you need to add components.

3. On the Production BOM page, select the Settings icon > Personalize.

4. From the Personalizing menu bar, select + Field.

5. Select a field in the Lines FastTab.

   The fields that can be added to the FastTab are listed in the Add Field to Page list on the right of the page.

6. Drag and drop the following fields to the Lines FastTab

   • FoodChain ID Code
   • FoodChain ID Quantity

7. Select the Done button.

   The FoodChain ID Code and FoodChain ID Quantity are now displayed on the page.

8. For a blank line in the Lines FastTab, populate the following fields:

   Field	Description
   No.	Enter the number listed in the FoodChain ID Code field. This is the number of the ingredient in the FoodChain ID recipe.
   Quantity per	Enter the quantity listed in the FoodChain ID Quantity field. This is the quantity of the ingredient in the FoodChain ID recipe.

9. Repeat for the remaining blank component lines.

System times out while importing records

Business Central has a 5-minute limitation on calls to external systems. If all of the data cannot be imported in 5 minutes, the import will time out.

If this happens, you may need to build a query in FoodChainID that will import fewer records.

1. In FoodChain ID, create an advanced search for a range of records you want to import into Business Central.

2. Select the Code button from the Search screen.

3. Copy the code in the JSON screen.

4. In Business Central, choose the icon, enter FoodChain ID Connector Setup, and then choose the related link.

5. On the FoodChain ID Connector Setup page, select one of the following:

   • Integration > Ingredient
   • Integration > Packaging
   • Integration > Finished Good
   • Integration > Finished Good Recipe
   • Integration > Recipe

6. On the API Configuration Card page, populate the following field:

   Field	Description
   API Body	Paste the code from FoodChain ID.

7. Select the appropriate action to import the FoodChain ID data from the advanced search:

   • Actions > Transfer Data > Get Ingredients
   • Actions > Transfer Data > Get Packaging
   • Actions > Transfer Data > Get Finished Goods
   • Actions > Transfer Data > Get Recipes
   • Actions > Transfer Data > Get Finished Good Recipes

   You can restore the default API body by selecting Load Default API Body.