Back

Calculated fields and totals on the Sales Order Lines

Creating Sales Order
Video 11/26
Play
Close
  • Helpful
  • Not helpful
  • Needs update
  • Technical error
An intermediate video requires some previous experience with Business Central, but it is still easily accessible to most people. Intermediate Watch "the details", if you need detailed knowledge about a specific topic. These videos are only relevant for particular users. The Details

Playlists  Manage

Log in to create a playlist or see your existing playlists.

Open Playlist
Presenter: Christina Fausbøll, Product Manager

What are the calculated fields on a sales order in Business Central?

On the sales order, we have a few calculated fields, along with the totals, which are not editable directly.

Let me show you.

This is what happens in the video

The line amount is automatically calculated based on the quantity and the unit price.

If I change this to a smaller number, the line discount is automatically filled out, both in Percentage and in Amount.

Quantity Shipped and Quantity Invoiced show if documents have already been posted from this sales order, and will show the quantity that has either been shipped or invoiced.

The totals under the sales lines, such as Subtotal Excluding VAT, the Total, the VAT Total and the Total Including VAT, are automatically calculated.

The only fields in the totals that we can change are the invoice discounts.

I can either add an amount or a percentage.

If, on the Customer, you have set up an invoice discount, and on the sales and receivable setup have said that invoice discounts should be automatically calculated, the invoice discount fields here are not editable.

352699360-yZS0pZa8jf8-ENG19072443