How to keep invoices and what was charged for a product from changing when you need to change a product price. These are 3 separate tables that use lookups to reference each other.
Products
0
Name
Current Price
Name
Current Price
1
Hoodie
$65.00
2
Pant
$48.00
3
Beanie
$22.00
There are no rows in this table
Products Price Table
0
Product
Price as of
Price
Product
Price as of
Price
1
Hoodie
1/1/2018
$55.00
2
Hoodie
2/7/2019
$60.00
3
Pant
9/19/2019
$48.00
4
Hoodie
9/18/2019
$65.00
5
Beanie
9/5/2018
$22.00
There are no rows in this table
Invoice Table
0
Invoice Number
Product
Invoice Date
Price per Product
Quantity
Currency
Invoice Number
Product
Invoice Date
Price per Product
Quantity
Currency
1
#1001
Hoodie
8/7/2018
$55.00
3
$165.00
2
#1002
Hoodie
5/10/2019
$60.00
3
$180.00
3
#1003
Hoodie
9/19/2019
$65.00
3
$195.00
There are no rows in this table
Want to print your doc? This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (