Calling Form using zoom functionality in R12

CALLING FORM USING ZOOM FUNCTIONALITY

Login to ERP and select inventory responsibility and click change organization.

Select your organization and navigate to miscellaneous transaction form.

Click on Help > Diagnostics > Custom code > Personalization

A password window will appear asking for password for apps.

Personalization form will be displayed.

Add a record to create a menu, insert values from

Seq no = 10

Description = Create a menu

Level = Function

Enabled = Yes

On condition tab select

Trigger Event = WHEN-NEW-FORM-INSTANCE

This will set a trigger to fire every time we enters into form.

On actions tab insert the values as

Seq no = 10

Type = Menu

Description = Creating a menu

Language = All

Enabled = Yes

Menu entry = Menu 1

Menu label = OnHand Quantity

This will create a menu named OnHand Quantity.

Close both forms and invoke miscellaneous transaction form again.

Click on Tools

Check that it shows the menu OnHand Quantity.

Check the item field in the table.

To check this click in item field and then click on Help > Diagnostics > Examine

Copy the block name and field name.

Now invoke the personalization form.

Create a new record.

Seq = 20

Description = Copy values and Call onhand quantity

Level = Function

Enabled = Yes

On condition tab select

Trigger event = MENU1

Remain will left default

On Actions tab select

Seq = 1

Type = Property

Description = Copy value for item

Language = All

Enabled = All

Object Type = Global variable

Target object = ITEM

Property name = Value

Value = =:MTL_TRX_LINE.ITEM

Seq = 10

Type = Buitlin

Description = Call Form

Language = All

Enabled = All

Builtin type = Launch Function

Function code = INV_INVMATWB

Function name = Material Workbench

Note:- when you select Function code the Function name will automatically be detected.

The trigger type as menu1 specifies that this trigger will be fired when click on the menu1 which is

Onhand Quantity.

The record on seq 1 will create a global variable and the item selected on the form will be copied to this global variable which we will pass to the form will be called by this menu.

The record on the seq 10 will call a form because builtin launch function is used to do so in this case the function name INV_INVMATWB calls the onhand quantity form.

If you want to know the form name navigate to that form call personalization form and see the function name for that form.

Close both the forms

Recall the miscellaneous transaction form select any item and click to Tools > Onhand Quantity

It will display the onhand quantity form.

Once the form is called its half done you have called form and you have done half of the zooming functionality.

Click on the item / revision field to check the table field in the item diction.

Click Help > Diagnostics > Examine

Copy values for block and field.

Now navigate to Help > Diagnostics > Custom Code > Personalization.

This will call the personalization form for Onhand Quantity form.

Create a record

Seq =10

Description = Moving values from global variable

Level = Function

Enabled = Yes

On conditions tab

Trigger event = WHEN-NEW-FORM-INSTANCE

Leave remaining as default.

Move to actions tab

Insert values as

Seq = 10

Type = Property

Description = Transferring values from global variable

Language = All

Enabled = Yes

Object type = item

Target object = MATERIAL_QF.ITEM

Property name = Value

Value = =:global.item

Create a new record as

Seq = 11

Type = Builtin

Description = Move to next block

Language = All

Enabled = Yes

Builtin type = DO_KEY

Argument = Next_Block

Seq = 12

Type = Builtin

Description = Move to next fielf

Language = All

Enabled = Yes

Builtin type = DO_KEY

Argument = Next_Item

In Seq 10 the value from Global variable is copied to the Item filed in the Onhand Quantity Form. It only copies the value to item field and moves to cursor to first field. When we click on find button it will display all the items. Now this is because the item is only copied to the field but not actually validated, this thing is handled in Seq11 and Seq 12. As cursor is on the first field of this form and the item is the first field of the second block Seq 11 moves the navigation to the first field on the second block and Seq 12 moves the navigation to the second field of the second block, as the cursor first came in the item field when it navigates out of the item field it gets validated. Now if we find the records it displays only particular records.

Save and close all the forms.

Invoke Miscellaneous transaction form select any item and then select Onhand Quantity from the tools menu it will display the Onhand Quantity form and copies the value and also validates it. Enter further criteria’s if you have to and click on find button it will display the item specific records.

For any queries contact mzeeshan.shaikh@hotmail.com