Invoice Database

Tags: Business Documents Templates

last edited: 2022-03-15

An invoice database

invoice database aef0dc8d d182 4502 affd e4b468ada8ce

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"

Release List

Release: 1.0 – An invoice database

Compatibility: 4.2
Operating Systems:
License:

Feedback

Post your review

You cannot post reviews until you have logged in. Login Here.

Reviews

No one has commented on this page yet.

RSS feed for reviews on this page | RSS feed for all reviews