Get ChoosefromlistUID of AR Invoice Metrix

[Former Member]

Hi,

How can i get chooseFromListUID of AR Invoice Metrix items.Means ChoosefromlistUID's of Itemcode,itemname etc using UI API.Please help

[Former Member]

But still it's showing the same error.I had changed the oCon.Alias = "ItemTyp" as oCon.Alias = "ItemType".Where is the mistake.I herewith attached the screenshot for your reference

Please help

[ANKIT_CHAUHAN]

Hi Rahesh,

Make Sure that the CUID is the correct CFL Id that you want to filter.

Thanks & Regards

Ankit Chauhan

[Former Member]

    Hi Ankit,

             How can i get the correct CFL ID's of Form Item using UI API.Here the CFL in AR invoice Line. ItemCode CFl. Pls help

[Former Member]

Hi,

I need to filter the choose From List of items in AR Invoice Lines.For this  i am using the following code

If pVal.FormType = 133 And pVal.EventType = SAPbouiCOM.BoEventTypes.et_FORM_LOAD Then

            If pVal.Before_Action = False Then

                Dim I As Integer

                Dim oForm As SAPbouiCOM.Form

                Dim omatrix As SAPbouiCOM.Matrix

                oForm = SBO_Application.Forms.Item(pVal.FormUID)

                omatrix = oForm.Items.Item("38").Specific

                Dim oCons As SAPbouiCOM.Conditions

                Dim oCFL As SAPbouiCOM.ChooseFromList

                'Dim oEdit As SAPbouiCOM.EditText = omatrix.Columns.Item("ItemCode").Cells.Item(pVal.Row).Specific

                Dim CUID As Integer = omatrix.Columns.Item("1").ChooseFromListUID '''ItemCode

                oCFL = oForm.ChooseFromLists.Item(CUID)   '''oForm.ChooseFromLists.Item("2")

                oCons = oCFL.GetConditions()

                Dim oCon As SAPbouiCOM.Condition

                oCon = oCons.Add()

                oCon.Alias = "ItemTyp"

                oCon.Operation = SAPbouiCOM.BoConditionOperation.co_EQUAL

                oCon.CondVal = "I"

                oCon.Relationship = BoConditionRelationship.cr_AND

                oCon = oCons.Add()

                oCon.Alias = "ItmsGrpCod"

                oCon.Operation = SAPbouiCOM.BoConditionOperation.co_EQUAL

                oCon.CondVal = "101"

                oCFL.SetConditions(oCons)

            End If

        End If

When I run this code I get an error message like 'Xml 'Conditions' parsing failed  [66000-116].  Invalid alias 'ItemTyp' for table 'OACT'

what is the error

[ANKIT_CHAUHAN]

Hi Rahesh,

The field in the database is ItemType while you have used it as ItemTyp

Please check it. Make it correct. and reply accordingly.

Hope it helps.

Thanks & Regards

Ankit Chauhan

[ANKIT_CHAUHAN]

Hi Rahesh,

What do you mean by A/R Invoice Matrix Item ? Do you want the List of Items in an Invoice ?

The object type of Sales Invoice or A/R Invoice is 13.

While the object type for Item Codes and all is 4.

I don't think there is any ChooseFromListUID for Invoice Details.

Hope it helps.

Thanks & Regards

Ankit Chauhan