Your opinion about storing invoice line items as a list rather than records

Das Goravani das at
Fri Jan 19 19:58:11 EST 2018

What’s your opinion about

Line items of an invoice

store them as a complete list in the invoice header, store a list with each invoice

or store them as small records, each line item is a record

only advantage I can see for line item records is that you can search up what invoices a certain product appeared on real fast, but that’s not that common of a search request

seems to me you can safely store the invoice line items in one list in the invoice header

das goravani

More information about the omnisdev-en mailing list