Blog
Insight Works blog
How-to articles and answers about running warehouses, shipping, planning, production, and quality in Microsoft Dynamics 365 Business Central, plus the questions attendees ask in our webinars.
242 articles answering webinar questions
- Why does my Import Export PowerTool export file lose its line endings when saved in Excel?If your export file will not import after you edit it in Excel, missing line endings are a likely cause. This article explains why line terminators can disappear, how to…
- Does the Import Export PowerTool provide logging for imports and exports in Business Central?Need an audit trail for your data loads? This article explains the logging available with the Import Export PowerTool in Business Central, why the change log is the main record…
- Can I automate imports in the Import Export PowerTool using AL code or Power Automate?Looking to run data loads without manual steps? This article explains how the Import Export PowerTool supports automation in Business Central through published events and a programmatic AL interface, and…
- Does the Import Export PowerTool fail an entire import batch or only the affected line?What happens when one row in your import is bad? This article explains the Import Export PowerTool error handling in Business Central, why a failure rolls back the entire table…
- How does the Import Export PowerTool Remove Quotes option treat inch marks in a description?Will a description like Tape, 12 inch survive an import? This article explains how the Import Export PowerTool Remove Quotes option treats inch marks and embedded quotation characters, why Excel…
- Can the Import Export PowerTool change a configuration package table processing order in Business Central?Hoping to rearrange a configuration package quickly? This article explains what the Import Export PowerTool does and does not change about configuration packages in Business Central, why it leaves package…
- How do I delete items in Business Central using the Import Export PowerTool?Need to remove items in bulk? This article walks through deleting items in Business Central with the Import Export PowerTool, how to filter and preview the records first, the confirmation…
- How do I import a new customer list into Business Central with the Import Export PowerTool?Bringing customers into Business Central? This article explains how to import a new customer list with the Import Export PowerTool, how to build the file, which fields to validate, and…
- How long does it take to import hundreds of thousands of records with the Import Export PowerTool?Planning a very large data load? This article explains how long the Import Export PowerTool takes to import hundreds of thousands of records in Business Central, why timing scales roughly…
- Can the Import Export PowerTool export or import file attachments in Business Central?Trying to migrate file attachments? This article explains why the Import Export PowerTool does not export or import attachments in Business Central, what it does handle such as record links…
- Can you restrict delete permissions to specific users in the Import Export PowerTool?Wondering whether you can stop specific users from deleting data with the Import Export PowerTool? This article explains how delete access is governed by global tool settings and each user’s…
- Can you customize the inventory count sheets in Business Central, including adding your own fields to them?Count teams often need their own fields and layout on a count sheet, such as an extra reference column. This article explains how count sheets in Advanced Inventory Count can…
- Can one inventory count include both lot numbered items and items that have no lot or serial tracking?Most warehouses hold a mix of lot numbered, serialized, and untracked items. This article explains how Advanced Inventory Count lets you count all of them together on a single count…
- How do you bring only lot tracked items into a count using the calculate inventory function in Business Central?Sometimes you need a count that includes lot numbered items and nothing else. This article shows how to use the item tracking code filter so only lot tracked items are…
- Can you count inventory in Business Central without recording lot or serial numbers, even when items carry lot numbers?Not every warehouse needs to count lot and serial detail. This article explains how lot specific and serial specific tracking determine whether you must record that detail during a count,…
- When moving to Advanced Inventory Count, when do you use update next count period and how does it work?Teams adopting cycle counting need to know how the next counting period advances. This article explains when to use update next count period in Advanced Inventory Count and how it…
- How does Advanced Inventory Count handle directed put away and pick locations, including lot tracked items?Advanced warehousing adds a second journal to every count. This article explains how Advanced Inventory Count handles directed put away and pick locations in Business Central, including lot tracking, by…
- Can you confirm empty bins during a count in Business Central, and how do scanners help?Confirming that a bin is genuinely empty is part of a thorough count. This article explains the limits of the physical inventory journal for empty bins and how scanner based…
- What historical records does Business Central keep for inventory counts, and can you report on count adherence?The basic physical inventory journal posts adjustments but keeps little history. This article explains how Advanced Inventory Count retains count sheet detail, archived counts, and physical inventory ledger entries so…
- Does Advanced Inventory Count generate accuracy reports in Business Central, or do you export to Excel?Teams want accuracy statistics by item without living in Excel. This article explains the built in difference and discrepancy reporting in Advanced Inventory Count, the statistics it captures, and where…