Line Items: Quantity × Price, Line Discounts & Net Amounts
This lesson is part of the course
In this lesson
You build the line-item block of Brightwater Print & Sign's invoice template: gross amount, discount amount and net amount per line, plus the effective discount of the whole invoice.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Line Items: Quantity × Price, Line Discounts & Net Amounts Locked
- Product Lookup from a Price List: Descriptions, Bulk Prices & Unknown SKUs Locked
- Tax per Line, a Tax Summary per Rate & the Rounding Difference Locked
- Invoice Numbering: Prefix + Year + Padded Counter with TEXT Locked
- Due Dates & Payment Terms: Net Days, WORKDAY and EDATE Locked
- From Quote to Invoice: Validity, Accepted Lines & the Deposit Invoice Locked
- Payment Log & Open Balance per Invoice with SUMIFS (and a Chart) Locked
- Customer Statement & Ageing Summary (with Overdue Highlighting) Locked