Playlists Manage
Log in to create a playlist or see your existing playlists.
Log in
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.