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.






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

Leases - contains prices




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?