»invoices

»line items

<aside> <img src="/icons/database_gray.svg" alt="/icons/database_gray.svg" width="40px" />

Database Structure

↗️ Relation to another Database,  🔎 Rollup from a Relation, () not used in this example

<aside> <img src="/icons/official-document_gray.svg" alt="/icons/official-document_gray.svg" width="40px" />

Invoices

Invoice Name

Invoice Number

Customer (↗️)

Customer Address (🔎)

Contact Person (↗️)

Line Items ↗️

Sum of line items 🔎

</aside>

<aside> <img src="/icons/reorder_gray.svg" alt="/icons/reorder_gray.svg" width="40px" />

Line Items

Item Name

Price per Item

Number of Items

Total Price of Item

Invoice ↗️

</aside>

Additional Databases for a more elaborate setup

<aside> <img src="/icons/factory_gray.svg" alt="/icons/factory_gray.svg" width="40px" />

Customer

Legal Name

Billing Address

Invoices (↗️)

</aside>

<aside> <img src="/icons/user-circle_gray.svg" alt="/icons/user-circle_gray.svg" width="40px" />

Contact Person

Name

E-Mail

Company (↗️)

</aside>

<aside> <img src="/icons/barcode_gray.svg" alt="/icons/barcode_gray.svg" width="40px" />

Product List

Product Name

Price

Line items (↗️)

Invoices (🔎)

Customers (🔎)

</aside>

</aside>

Make Link

https://eu1.make.com/378025/scenarios/3177737/edit