Workbooks
Document and journal lines
Edit the lines of Business Central sales and purchase documents and general journals in a sheet: change, add and delete lines, checked like the page.
updated: applies-to: 1.0.0.0
Edit the lines of sales documents, purchase documents and general journals in a sheet. Open the lines from the page, or insert them into any workbook. Change, add or delete lines, then review, check and apply: Business Central validates every value as the page would.
Open the lines from the page
- On a sales quote, open the Actions menu and choose Open Lines in Sheet. A new workbook opens straight away, named after the document.
- The header fields sit on top: the customer, the dates, the external document number, the status and the amounts. The lines sit below, with the page's own columns, and an empty row under them.
- Change a line: type over a value, for example a quantity.
- Add a line: in the empty row, type the type, the number and a quantity.
- Delete a line: select its row and choose Delete Sheet Rows. It stays marked until you apply, and Review changes lists it as a line to delete.
Each edit stays pending until you apply it, and Review changes shows the count. Then:
- Choose Review changes. The panel lists every edit, such as a quantity from 6 to 8 or a new line.
- Choose Check changes. Business Central validates the changes as the page would, and reports each one as ok or with an error.
- Choose Apply to write them to Business Central. The lines refresh: a new line gets its description and price, and the totals update.
Open Lines in Sheet is on sales quotes, orders, invoices, credit memos and return orders, and on purchase quotes, orders, invoices and credit memos.
Insert a document into any workbook
- In a workbook, on the Insert tab, choose Purchase document or Sales document. A dialog asks first.
- Pick the document type: quote, order, invoice, credit memo, blanket order or return order.
- Type the document number, or pick it, and choose the line columns you want.
- Choose whether to show header fields above the lines, and whether the sheet may edit, add or delete lines.
- Choose Insert. The document lands in the sheet: change a quantity, check, and apply.
More settings opens the Journal and Document Lines Setup, with every option and the order of the columns.
General journal batches
On a general journal, Open Lines in Sheet opens the batch straight away. You can also insert journal lines into any workbook from the Insert tab, with the journal template and batch.
The header shows the template, the batch and the batch balance, plus a line for every document that doesn't balance. Fix the amounts in the sheet, check, and apply. When every document balances, the header says so.
It never posts
Bitta Sheets works on documents and general journal batches that already exist, and it never posts. Posting stays on the document or journal page.
When to use it
Use it for quote changes, order updates and month-end journals, with every value checked by Business Central.