Line Items in Portal
My file contains an Invoice, Line Items, and Products table. When a new Invoice is created, a script automatically creates 30 Line Items on the Invoice - each one corresponding to the 30 Products we sell.
This is what I would like to happen: when a new Invoice is created, all Products are automatically shown on the Invoice. When I enter in the quantity of Products purchased, then a Line Item for that Product is created. Right now, every Invoice automatically has 30 Line Items created, whether or not a customer buys only one or multiple products.
How can I make this happen?
* My Line Items are shown on my Invoice via a Portal
* Each Line Item has a SKU number associated with it that links it to the Product