Message Boards

How to combine lines in a browse?

thumbnail
Joseph Betts, modified 3 Years ago.

How to combine lines in a browse?

Post Date: 10/29/18 (Bronze, 20 Posts) Recent Posts

Hi All,

I am new to the browse world and I am trying to create a browse which shows shipped quantity and price from sod_det table.

The problem that I have is that there are multiple lines of the same Item Number which I am not expecting to see. In the screenshotted example there are four lines of shipped quantity for the same item number. I am only expecting to see one line which shows the total shipped quantity and price. The browse is only using the sod_det table and no other tables are required. How do I combine these into one line and show the total shipped quantity?

Screenshot: https://ibb.co/n9i7Nf

Thanks in advance!

 

 

browse combine tables
thumbnail
Phill Norrey, modified 7 Years ago.

Re: How to combine lines in a browse?

Post Date: 10/30/18 (Yoda, 1010 Posts) Recent Posts
The sod_det hold sthe data for each individul line.&nbsp; I would add a column onto your browse to show the sod_line and then in the column for the sod_qty_ship I would set that to only display if the qty &gt; 0<br />
<br />
I personally would always leave it at this detail.&nbsp; It is very easy to summerize when running the browse or to export to excel to do the summary
thumbnail
Joseph Betts, modified 7 Years ago.

Re: How to combine lines in a browse?

Post Date: 11/4/18 (Bronze, 20 Posts) Recent Posts

Thanks for the reply Phill.

I think you are correct here. It is easy to summarize this when running the browse and don't think it's necessary.

Kindest Regards, Joseph.

thumbnail
Phill Norrey, modified 7 Years ago.

Re: How to combine lines in a browse?

Post Date: 11/5/18 (Yoda, 1010 Posts) Recent Posts
Your welcome.&nbsp; BTW what is the reason for creating the browse from the sod_det table rather than invoice history?

Message place holder