'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Use Edit in Excel for Business Central Physical Inventory Journals
Question details
Understand the editing limitations and requirements when using the Edit in Excel feature for warehouse physical inventory journals in Microsoft Dynamics 365 Business Central.
- Product
- Microsoft Dynamics 365 Business Central
- Device & OS
- not provided
- Scenario
- Updating physical inventory counts by exporting the journal to Excel and publishing the changes back to Business Central.
- Observed behavior
- Users need to know which fields can be edited and which actions (like adding formulas or lines) cause publishing errors.
Ensure you have the Microsoft Dynamics Office Add-in installed in your spreadsheet application and are authenticated with your Business Central account.
Safely Edit Physical Inventory Journals in Excel
Follow these strict guidelines when modifying exported physical inventory journals to ensure a successful data publish back to Business Central.
The Edit in Excel functionality for warehouse physical inventory journals is designed strictly for updating inventory counts. Modifying the structure of the document or unsupported fields will break the synchronization.
In Dynamics 365 Business Central, navigate to your warehouse physical inventory journal and click the 'Edit in Excel' icon to generate and open the spreadsheet.
Locate the 'Warehouse Physical Quantity' column in the worksheet. This is the only field you are permitted to edit during this process.
Enter exact numeric values only. Do not insert new rows, delete existing lines, or use spreadsheet formulas, as these actions will trigger publishing errors.
Once your physical quantities are updated, use the Dynamics Excel Add-in pane on the right side of your screen to click 'Publish' and sync the data back to Business Central.
Manage Exported Business Data Seamlessly with WPS Office
If you frequently export ERP or business data to spreadsheets and need a reliable, cost-effective tool to review and manage your files, WPS Office is an excellent choice. It offers powerful spreadsheet capabilities without the heavy subscription fees.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite on your device.
- 2. Open Exported Files: Launch WPS Spreadsheets and open the .xlsx file you exported from your business management system.
- 3. Edit and Save: Review your data, utilize powerful sorting and filtering tools, and save your work flawlessly in the original Excel format.
Frequently Asked Questions
Why do I get a publishing error when sending inventory data back to Business Central?
Publishing errors typically occur if you have added new lines, deleted existing rows, or entered formulas into the Excel sheet. The Dynamics add-in requires strict adherence to the original exported structure.
Can I edit the item description or location code in the exported Excel file?
No. When editing a warehouse physical inventory journal via Excel, only the warehouse physical quantity field can be modified. All other fields, including item descriptions and location codes, are strictly read-only.
What happens if I use Excel formulas to calculate my physical inventory?
Using formulas in the exported Excel file is not supported and will cause publishing errors. You must enter raw numeric values for the physical quantities before attempting to publish the data back to Business Central.
