Method:Classic General Q&A

Re: Sales Order Form only generating first line item

Method_Audisho — Tue, 30 Jun 2015 15:33:52 GMT

No problem, glad I could help

Audisho

Re: Sales Order Form only generating first line item

cdrryan — Tue, 30 Jun 2015 15:15:18 GMT

That did the trick! I didn't realize that I used the fields from the wrong table.

Thank you again for all your help,

Conner

Re: Sales Order Form only generating first line item

Method_Audisho — Tue, 30 Jun 2015 13:33:49 GMT

Hi Conner,

The Detail Report section of your estimate template lists “Estimate.EstimateLine.Estimate”, but the Detail Report on your sales order template does not list anything here. It also looks like you may have dragged the incorrect line item fields onto the sales order template. You need to drag in the fields from the SalesOrderLine table that is nested in the SalesOrder table. Not the stand-alone SalesOrderLine table.

Let me know if this helps.

Audisho

Sales Order Form only generating first line item

cdrryan — Mon, 29 Jun 2015 22:16:03 GMT

A few weeks ago I finished customizing the print templates in the report designer. Today I was testing a few out by clicking 'print preview' and I noticed that while my estimate report generated all of the line items, my sales order template only shows the first line item and nothing else. I have attached 2 images of what my design looks like in report designer, although they basically look the same.

Estimate

http://i.imgur.com/052HtOC.jpg

Sales Order

http://i.imgur.com/7aDnxRl.jpg

Any idea as to what would be causing this?

Thanks,

Conner