Consolidate rows in find/browse grid

yanezfi

Member
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

Legendary Poster
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
 
Last edited:
Top