• Using embedded views in Sales DBfor sales items?

    By Johann-Michael Weiler 2 decades ago

    The current version of the Sales DB uses list fields to hold the sales items columns.

    Wouldn't it be handier to use sales item documents (as responses?) and manage all editing/deleting via an embedded view? I know, embedded views have their deficiencies, but in most of the applications I've written, they do such things like summarizing values very well.

    When it comes to printing an order, almost in every case, I did an extra "output" action, that generates a complete separately layed out document with one Rich Text field holding the output data. This comes in handy, if you want to edit the generated output and save several output versions.

    • SalesDB response docs

      By Dave Leigh 2 decades ago

      I'm thinking on it. It would make scripting a bit easier on that page. The Sales db wasn't intended to be an AR package, though it's sort of started to lean that way with calculation/display of sales tax and the ability to convert to an invoice and print. Maybe I need to rethink that.