Skip to content
Bitta Apps

Bitta Sheets · Part 21 · 2:37 · YouTube

Edit Business Central Journal and Document Lines in a Sheet

What this video covers

Edit the lines of Business Central sales documents, purchase documents and general journals in a sheet, checked like the page.

In this tutorial you open a sales quote's lines in a sheet straight from the page, change a quantity, add a line and delete one, then review, check and apply. You insert a purchase order into a workbook with its own columns, and fix an unbalanced general journal batch. Posting stays on the page.

Transcript

Cedar Ridge wants more chairs. Change their quote in a sheet, and Business Central checks every value. Here's how to edit sales, purchase and journal lines in a Business Central sheet. Open the lines from the page, or insert them into any sheet.

Change, add or delete lines, then review and apply. On the sales quote, Open Lines in Sheet opens a new workbook straight away. The header fields sit on top, and the lines below, with the page's own columns.

Change a quantity: six swivel chairs become eight. In the empty row, type Item, the item number and a quantity, and that's a new line. To delete a line, select its row and choose Delete Sheet Rows.

It stays marked until you apply. Review changes lists every edit. Check changes validates them as the page would, and Apply writes them to Business Central.

The new line gets its description, the whiteboard is gone, and the totals update. Open Lines in Sheet is also on sales orders, invoices, credit memos and return orders,

and on purchase quotes, orders, invoices and credit memos. In any workbook, Insert, then Purchase document, asks first. Pick the document type.

Blanket orders and return orders are in the list too. Type the order number, and choose the line columns you want. Options decide whether the sheet may edit, add or delete lines, and More settings opens the full setup,

with the column order. Insert, and the order lands in the sheet. Change a quantity, check, and apply. On the general journal, Open Lines in Sheet opens the batch straight away.

The header shows the batch balance, and every document that doesn't balance. This one is 50 short. Fix the bank line, check, and apply. Every document balances now.

It works on documents and general journal batches that already exist, and it never posts. Posting stays on the page. Use it for quote changes, order updates and month-end journals,

with every value checked by Business Central. Next, connected tables and SQL. The steps are in the Bitta Sheets guide.

More Bitta Sheets videos

All videos

Next step

See Bitta Sheets on your own data