Consolidate rows in find/browse grid

[yanezfi]

Hi,

I’m working with JD Edwards EnterpriseOne 9.2 for the first time and I start doing some development (creating forms).

I need to create a Find/Browse form to display Sales Order lines consolidated at an order lines level.
That is, using P4210 (W4210E) “Customer Service Inquiry” I can see all sales order lines.
However, when we have serial numbers we see the lines displayed as 1.000, 1.001, etc.:

Order Number	Or Ty	Line Number	Quantity	UOM	2nd Item Number	Last Status	Next Status	Lot Serial Number
16000001	SO	1	1	EA	FZA2181CN2	560	580	123456896
16000001	SO	1,001	599	EA	FZA2181CN2	900	540	123456896

What I would like to create is a Find/Browse to see the following information:

Order Number	Or Ty	Line Number	Quantity	UOM	2nd Item Number
16000001	SO	1	600	EA	FZA2181CN2

Is this possible? How can I archive this?


I aim of using the Find/Browse is for users to create OneView reports.
But if you have any other suggestion, please let me know.

Thank you for your help.

Yanezfi

 

[johndanter]

Hi

First you need to detect that the Serial LOTN has changed.

So sequence the FB grid by DOCO and LOTN (Sort Order Tab in Grid Properties)

Create a variable called GridLOTN. In the form event Post Dialog Is Initialised set it to 0

In the form event Write Grid Line After set GridLOTN to GC LOTN
Also total the values you want to SUM

You now need to check that the new BC LOTN record is different to GridLOTN (if not 0) in form event Grid Record is Fetched. If so set a flag to Y

Then check in form event Write Grid Line After that flag is Y and is so create your own new grid line using a buffer
Populate the GB variables and then use system function Insert Grid Buffer Row

And reset your SUM