Skip to content
Bitta Apps

Chapter 2 of 4Page 8 of 12

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

  1. On a sales quote, open the Actions menu and choose Open Lines in Sheet. A new workbook opens straight away, named after the document.
  2. 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.
Sales quote opened in a sheet with the header fields above the lines and an empty row for a new line
  • 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:

  1. Choose Review changes. The panel lists every edit, such as a quantity from 6 to 8 or a new line.
  2. Choose Check changes. Business Central validates the changes as the page would, and reports each one as ok or with an error.
  3. Choose Apply to write them to Business Central. The lines refresh: a new line gets its description and price, and the totals update.
Review changes after Check changes on the quote: a changed quantity and a new line, 4 changes, 4 ok
Quote after Apply with the new line described and priced and the totals updated

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

  1. In a workbook, on the Insert tab, choose Purchase document or Sales document. A dialog asks first.
  2. Pick the document type: quote, order, invoice, credit memo, blanket order or return order.
  3. Type the document number, or pick it, and choose the line columns you want.
  4. Choose whether to show header fields above the lines, and whether the sheet may edit, add or delete lines.
  5. Choose Insert. The document lands in the sheet: change a quantity, check, and apply.
Insert purchase document dialog with the document type, document number, line columns, header fields and the options to edit, add and delete lines

More settings opens the Journal and Document Lines Setup, with every option and the order of the columns.

Journal and Document Lines Setup with the lines, document type and number, and the header, editing, adding and deleting options

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.

General journal batch in a sheet with the batch balance and the balance of an unbalanced document above the journal lines

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.

Next step

Ready to try Bitta Sheets?