Quote Line Items
Quote Line Items
I am trying to add a Line Item field to the quote template that lists the products in numerical order as they are added to the quote.
For example if I add 5 different products to the quote the Line Item field should show Items 1 thru 5 on the quote.
What is happening is that when I add a new product it automatically assigns it a line item no as it was entered into the Products Module.
So If I add a 10th product in the Product Module this 10th product entered gets assigned a Line item 10. When I add this product to the quote the Line Item #10 comes in even if its the first item in the quote.
The quote is laid out like:
Line Item Part No Description Qty Unit price TTL
1 123 Peanuts 6 $2 $12
2 456 Straws 3 $1 $3
When I add a new product the next Line item number should be sequential, 1,2,3,4... that is not currently happening. Its taking the Line item number from the product module as it was added and putting this in the Line Item field in the quote.
What field do I need to use in the Quote Module to have it numerically add the next Line item number??