w2vijay
Well Known Member
Hi All,
I have a requirement to include shipment number(SHPN) field in the grid of sales order revisions form(W4210A) of Sales Order Entry application P4210. Then the user will manually enter or change the shipment numer value in the grid. When the OK button is clicked the shipment number entered in the grid should be updated to sales order line table F4211.
VA frm_mnSHPNLineCounter_MATH10 = "1"
Get Max Grid Rows(FC Grid, VA frm_mnSHPNMaxGridRows_MATH10)
While VA frm_mnSHPNLineCounter_MATH10 is less than VA frm_mnSHPNMaxGridRows_MATH10
Get Grid Row(FC Grid, VA frm_mnSHPNLineCounter_MATH10)
F4211.Update
VA frm_mnSHPNLineCounter_MATH10 = [VA frm_mnSHPNLineCounter_MATH10]+1
End While
I have written the above code in the Ok button post button clicked event. But no luck. After reviewing the whole application code and debugging the each event what I observed is all the sales order lines added or updated will be handled by master business functions present and caches to hold the current sales lines and to complete the transactions at the end.
When the debugger is on system funtions 'get max grid rows' and 'Get grid row' are working fine displaying the max rows and grid values. But the problem is at the update statement. It is taking more than 3 mins to complete the statement and not updating the table.
Any ideas how to accomplish this requirement or which event will be appropriate to include the custome code.
*** Zoltan sir any ideas.
I have a requirement to include shipment number(SHPN) field in the grid of sales order revisions form(W4210A) of Sales Order Entry application P4210. Then the user will manually enter or change the shipment numer value in the grid. When the OK button is clicked the shipment number entered in the grid should be updated to sales order line table F4211.
VA frm_mnSHPNLineCounter_MATH10 = "1"
Get Max Grid Rows(FC Grid, VA frm_mnSHPNMaxGridRows_MATH10)
While VA frm_mnSHPNLineCounter_MATH10 is less than VA frm_mnSHPNMaxGridRows_MATH10
Get Grid Row(FC Grid, VA frm_mnSHPNLineCounter_MATH10)
F4211.Update
VA frm_mnSHPNLineCounter_MATH10 = [VA frm_mnSHPNLineCounter_MATH10]+1
End While
I have written the above code in the Ok button post button clicked event. But no luck. After reviewing the whole application code and debugging the each event what I observed is all the sales order lines added or updated will be handled by master business functions present and caches to hold the current sales lines and to complete the transactions at the end.
When the debugger is on system funtions 'get max grid rows' and 'Get grid row' are working fine displaying the max rows and grid values. But the problem is at the update statement. It is taking more than 3 mins to complete the statement and not updating the table.
Any ideas how to accomplish this requirement or which event will be appropriate to include the custome code.
*** Zoltan sir any ideas.