Invoice Database

Description

An invoice database with calculations: Invoice Calculations: LineTotal1 "Qty1" * "Price1" LineTotal2 "Qty2" * "Price2" LineTotal3 "Qty3" * "Price3" Subtotal ( "Qty1" * "Price1" ) + ( "Qty2" * "Price2" ) + ( "Qty3" * "Price3" ) + ( "Qty4" * "Price4" ) + ( "Qty5" * "Price5" ) + ( "Qty6" * "Price6" ) + ( "Qty7" * "Price7" ) + ( "Qty8" * "Price8" ) DiscountSave = subtotal x discount% ("Qty1" * "Price1" * "Discount%")+ ( "Qty2" * "Price2" * "Discount%")+ ( "Qty3" * "Price3"* "Discount%") + ( "Qty4" * "Price4" * "Discount%") + ( "Qty5" * "Price5" * "Discount%") + ( "Qty6" * "Price6" * "Discount%") + ( "Qty7" * "Price7" * "Discount%")+ ( "Qty8" * "Price8" * "Discount%") Total = subtotal-discountsaving ( "Qty1" * "Price1" ) - ("Qty1" * "Price1" * "Discount%") + ( "Qty2" * "Price2" ) - ("Qty2" * "Price2" * "Discount%")+ ( "Qty3" * "Price3" ) - ("Qty3" * "Price3" * "Discount%") + ( "Qty4" * "Price4" ) - ("Qty4" * "Price4" * "Discount%") + ( "Qty5" * "Price5" ) - ("Qty5" * "Price5" * "Discount%") + ("Qty6" * "Price6" ) - ("Qty6" * "Price6" * "Discount%")+ ( "Qty7" * "Price7" ) - ("Qty7" * "Price7" * "Discount%") + ( "Qty8" * "Price8" ) - ("Qty8" * "Price8" * "Discount%") Total Due = total+paid ( "Qty1" * "Price1" ) - ("Qty1" * "Price1" * "Discount%") + ( "Qty2" * "Price2" ) - ("Qty2" * "Price2" * "Discount%")+ ( "Qty3" * "Price3" ) - ("Qty3" * "Price3" * "Discount%") + ( "Qty4" * "Price4" ) - ("Qty4" * "Price4" * "Discount%") + ( "Qty5" * "Price5" ) - ("Qty5" * "Price5" * "Discount%") + ("Qty6" * "Price6" ) - ("Qty6" * "Price6" * "Discount%")+ ( "Qty7" * "Price7" ) - ("Qty7" * "Price7" * "Discount%") + ( "Qty8" * "Price8" ) - ("Qty8" * "Price8" * "Discount%") + "Paid"