Form Designer - Creating Multiple Sage Data Tables

SOLVED

I am modifying a Sales Order form and trying to create two data tables that reference the Sage sales order data. It looks like a go within designer, but only one table will actually print content. So for example, if I create one table that shows qty and item ID's from each line item and create a second table that shows unit price and total from each line item, only the qty and item IDs will show data when the form is printed. The second table will show headers with no content.

I normally would not use multiple tables, but need certain fields to have font customization and Sage is set up so that only one font can be used per table.

Anybody know a workaround??

Thanks,

Phil

  • 0
    verified answer
    You can only put one table on a form. But you can produce the same result by individually placing fields on your form. Look at one of the multipurpose check formats as an example of how to lay it out. It's just a matter of getting your field order set correctly and inserting "Read next line item record" commands after each set of fields.

    If you can't figure it out, a certified consultant can either show you how or create the form for you. Let me know if you would like a quote.
  • 0 in reply to StephenC

    Thanks for the reply, Steve! Haven't been able to make progress on this. I am interested in a quote to work with a consultant, if you feel what I am trying to do is definitely possible.

    To elaborate a little:
    The form I am using already has a columnar data table broken up into 5 objects which use next line read commands so that there is data from one line per object. If there are more than 5 lines per sales order, it just prints as multiple pages, reading each next line until all are depleted. There are numerous individual fields and some text fields on the page as well.
    My goal is to add more columnar data fields in a different font. The data fields must work in the same manner as described above, where there will be 5 new objects that draw line item data in sequence and extend page-over-page until there is no data left. So, both the existing table objects and the new objects must be able to draw from the same lines.
    My attempts to do this through the method I think you're suggesting above cause the existing table to read lines 1 thru 5, and the new objects to read lines 6 thru 10, rather than ALSO reading lines 1 thru 5.
    Buy capturing data from the same lines in different fonts, I believe can use a barcode font for my UPC field to print line descriptions and a scannable barcode per line item.

    Again, if you think what I have described above is possible, I would love to learn how to do it and would be eager for a quote, but I don't want to end up in a situation where I'm paying for time only to run into a dead end in the form designer.

    Thanks
    Phil Ryan
    [email protected]
    774-773-7961

  • 0 in reply to Phil Ryan
    edit: "Again, **if you think** what I have described above is possible, I would love to learn how to do it and would be eager for a quote, but I don't want to end up in a situation where I'm paying for time only to run into a dead end in the form designer."
  • 0 in reply to Phil Ryan
    I would probably dump the table and place all of the fields individually. I'll email you to get more details.