AnsweredAssumed Answered

How to populate invoice line-items?

Question asked by TekGlobe on Jun 22, 2018
Latest reply on Jun 25, 2018 by philmodjunk


So, numbskull that I am, I assume that there is a simple method to my issue.

 

In my solution, I will be creating a new invoice every month based on manually entered prices contained in a lease.

How do I generate an invoice, which pulls the correct information from the Lease???....

 

A lease can contain up to 6-10 products/services with a specific price.

 

Tables:

Contacts

Invoice

Invoice_Lines

Products/Services - List of Products - No prices per product

Leases - contains prices

 

Contacts--<<Invoices>>---[Invoice_Lines]---<<Products---<<Leases

 

instead of scripting a find for the price, and then setting the field price in the Invoice_Lines table. Is theres a better way of creating a relationship that will allow some type of look up for the price?

Outcomes