Bitta Sheets · Part 2 · 3:08 · YouTube
Business Central Bulk Update Without Export and Import
What this video covers
Update many Business Central records at once with one spreadsheet formula, and write them back safely.
In this tutorial a supplier raises chair costs: you put the chairs in a Bitta Sheets data table, fill one price formula down every row, see Business Central refuse a change it won't accept, and apply the rest. A colleague's edit is caught, not overwritten, and every change lands in the audit log.
Transcript
Your chair supplier is raising costs six percent on Monday, and every chair price has to follow. Here's how to change many records at once with one formula, and write them back safely.
Bring the records into a sheet. Write one formula and fill it down. Business Central checks every record, and only the good changes are written. In a workbook, insert a data table on the Item table,
with the number, description, unit cost, unit price and profit percent. Filter on Vendor No. 40000, so only this supplier's chairs come in, and pick a table style.
Then allow write-back. Nothing is written until you review it. Ten chairs, live from Business Central. The header menu filters by value or with Business Central syntax,
and sorts them. Your first idea might be to type the new cost. Try it on the Paris chair. Review changes lists it.
Check changes runs Business Central's own rules, then rolls everything back. And Business Central refuses it. The item already has ledger entries, so its unit cost can't be typed over.
Undo this change, and the cost is back. Change the price instead. On the Formulas tab, the Function Library has every function by category. From Math and Trig, pick ROUND.
The new price is the unit cost, plus six percent, times the markup, rounded to cents. Select the column and fill it down with Control D. Ten pending changes, and nothing written yet.
If a formula gives an error, like a division by zero, that one change is refused on its own. Check again. All ten pass, and each one shows what else changes,
like the profit percent. Meanwhile, a colleague changes the Sydney chair's price on its item card. Apply. Nine records are written, but not Sydney:
someone changed it after you loaded the table, so their price stays. Each record is written on its own. If one fails, its other changes are skipped,
and a deleted record is reported too. To drop what's left, use Discard. From the title bar's menu, refresh this live data. The nine new prices come straight from Business Central.
Sydney's change stays pending, highlighted, until you decide what to do with it. And the Studio Audit Log keeps every field change, with the old and the new value.
Use it when one rule changes many records: a supplier's price rise, a new markup, or one field corrected across a range. Next, budgets, written back live. The steps are in the Bitta Sheets guide.
More Bitta Sheets videos
All videos
1:18OverviewEdit Business Central Tables Live in a Spreadsheet
2:08Part 1Edit Business Central Data in an Excel-Style Sheet
2:50Part 3Business Central Budget in a Spreadsheet, Written Back Live
2:35Part 4Business Central Budget Entry by Department
2:56Part 5Business Central Consolidation: Companies and Account Mapping
2:29Part 6Business Central Consolidation: Ownership, Rates and Minority Interest