AnsweredAssumed Answered

Invoice line items: Repeating field vs. line item table

Question asked by GaryBenzon on Oct 24, 2014
Latest reply on Oct 27, 2014 by GaryBenzon

Title

Invoice line items: Repeating field vs. line item table

Post

I developed an invoicing system for my business 25 years ago when FM was only on the Mac and was not relational. It uses a repeating field of 10 lines for invoice line items. Occasionally I need more than that and have to make separate invoices.

I noticed that nowadays, samples of invoice databases from FM and others use a separate table for line items with a portal on the invoice layout. Other than the ability to have unlimited line items, what are the advantages of doing it this way?

Thanks in advance for any advice.

GB

Outcomes