Home Forums Import Export PowerTool Importing Items Data


Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • prathmesh gujarprathmesh gujar
      Post count: 1


      I am trying to import my item data using import export power tool into by business central. Although, much of the data is imported not all data is getting imported. Data such as Last Direct Cost, Unit Price, Tax Group Code is not getting imported.


      Terri Vaive
        Post count: 154
        Hello Prathmesh,
        There could be numerous reasons why those fields are not being set as you expect. It could be the data file you are importing, the settings you are using in the Import Export PowerTool for the Import operation, and even extensions you have installed.
        Assuming your data is correct and no other extensions are impacting it, here are some settings you may want to consider:
        • Do you have Validate Field Data enabled? It could be you are validating other fields causing those fields to result in different values than expected. You can try disabling the validation or move those fields to the end of the data file so they are imported last and are set after other fields are validated.
        • Do you have Allow Record Updates enabled? If the record already exists such as from running import before or manually creating the record, if you run the import again without the update enabled it will skip it during the import.
        You can also verify your import settings using the following Knowledge Base article, https://kb.dmsiworks.com/knowledge-base/import-export-powertool-import-data/.
        Thank you,
      Viewing 2 posts - 1 through 2 (of 2 total)
      • You must be logged in to reply to this topic.