How to Use Navigation in Screen Designed in Screen Printer through SAP b1

[Former Member]

Hi,

I have designed new screen of workorder in which i want to used form navigation such as last,first,prev,next wich is used in sap screens.how can i used it trhough SDK.plz help me.

[Former Member · Accepted solution]

Hi Chaiteshl,

Try This....

'For Enable the Navigation menus
 oform = sbo_application.Forms.Item("ur form id")
 oform.EnableMenu("1288", True)
 oform.EnableMenu("1290", True)
 oform.EnableMenu("1289", True)
 oform.EnableMenu("1291", True)

Thanks

Shafi

[former_member689126]

Hi

set this property

oForm.DataBrowser.BrowseBy = "txtDcEntry"

where txtDcEntry edit text control must be bounded to DocEntry field then next previous menus will automaticaly managed

Regards

Arun

[Former Member]

Thanks Buddy

[Former Member]

Thanks Buddy

[Former Member]

Dear All I want to disply the List of Bill Materials through SDK on the basis of Item code selection wich i given in header on screen of work order.

how can i do it

[former_member689126]

Hi Chaiteshl

Please close this thread and create another thread for your new question so that all members can see .

Regards

Arun

[former_member689126]

Hi

use this to get bom details of a prticular item

Dim oProductTrees As SAPbobsCOM.ProductTrees
Dim oProductTreesLines As SAPbobsCOM.ProductTrees_Lines
Dim oItem As SAPbobsCOM.Items = B1Connections.diCompany.GetBusinessObject(BoObjectTypes.oItems)
oProductTrees = B1Connections.diCompany.GetBusinessObject(BoObjectTypes.oProductTrees)

 If oProductTrees.GetByKey(dbdsEstimation.GetValue(GlobalVariables.MRQ5_ITEMCODE_ALIAS, iEstRow).Trim) Then

  oProductTreesLines = oProductTrees.Items()

  For i = 0 To oProductTreesLines.Count - 1

  oProductTreesLines.SetCurrentLine(i)
                            
         oProductTreesLines.ItemCode
         oProductTreesLines.Quantity
         oProductTreesLines.InventoryUOM

 Next
 End If

Regards

Arun

[Former Member]

Hello Sir,

I have designed work order screen in SAP B1 ,On that screen there is item code Combo box control in header ,i want to disply list of Bill of Materials wich is used to made finished good of the selected item. and that i want to dispaly in grid

kindly tell me how i can do it on combo click.

[Former Member]

Hello Sir,

I have designed work order screen in SAP B1 ,On that screen there is item code Combo box control in header ,i want to disply list of Bill of Materials wich is used to made finished good of the selected item. and that i want to dispaly in grid

kindly tell me how i can do it on combo click.

[Former Member]

Hi,

you have to catch the COMBO_SELECT event, get the combobox.Selected value and then you can do a SQL for the grid. Please note that you have to define a datasource (DataTable) for the grid -> also refer to SDK Help, there are very good samples for grids.

sqlStm = "SELECT Father, Code  FROM ITT1 where Father = 'product1'";
oForm.DataSources.DataTables.Item("dataTable1").ExecuteQuery(sqlStm);
oGrid.DataTable = oForm.DataSources.DataTables.Item("dataTable1");
oGrid.CollapseLevel = 1;

Regards

Sebastian

[Former Member]

i dont know how to do it?

[Former Member]

i dont know how to do it?

[Former Member]

Hi,

please follow the SDK samples, for each point you should get the relevant knowledge.

Try the following, I did not test it...

if (pVal.EventType == SAPbouiCOM.BoEventTypes.et_COMBO_SELECT && pVal.ItemUID == "combo" && pVal.BeforeAction == false)
{
SAPbouiCOM.Item oItem = oForm.Items.Item("combo");
SAPbouiCOM.ComboBox oCmb = (SAPbouiCOM.ComboBox)oItem.Specific;
string itmCode = oCmb.Value;

string sqlStm = "SELECT Father, Code  FROM ITT1 where Father = '" + itmCode + "'";

oForm.DataSources.DataTables.Item("dataTable1").ExecuteQuery(sqlStm);
oGrid.DataTable = oForm.DataSources.DataTables.Item("dataTable1");
oGrid.CollapseLevel = 1;
}

When you create the form, you should add the datatable with:

oForm.DataSources.DataTables.Add("dataTable1");

Alternatively you can assign/create the datatable for the grid with ScreenPainter.

Regards

Sebastian

[Former Member]

Please split this into a new thread as it is a new topic.

it will make it much easier for people when searching for this knowledge in the future!

[Former Member]

Yes Sir,