Tax Filtering

[Former Member]

Hi Friends,

I want to filter tax by Tax types ie,VAT,CST from tax choose from list .How it is possible?

Regars

Sana

[Former Member]

Thanks a lot Binita...

[Former Member]

Sana,

so far as I know, filtering system CFL is not possible. alternatively, you can restrict user from choosing a particular tax code on 'Choose' button click event. or worst, use user defined CFL form.

regards,

Binita

Edited by: Binita Joshi on Jun 6, 2008 11:50 AM

Sana, I would like to add that when I said its not possible, its in system form, about filtering the original system tax code CFL.

I hope you are asking for that only.

[Former Member]

Hi binita,

Thanks for your replay.But i am doing tax filteration in user defined CFL.I don't know what should give in condition(Like TaxType="VAT").I tried some conditions but i can't filter only VAT type TAXes.

Regards

SANA

[Former Member]

Ok Sana.

see if the following example helps :

Private Sub AddChooseFromList()
        Try
            Dim oCFLs As SAPbouiCOM.ChooseFromListCollection
            Dim oCons As SAPbouiCOM.Conditions
            Dim oCon As SAPbouiCOM.Condition
            oform = SBO_Application.Forms.GetForm("139", 1)
            oCFLs = oform.ChooseFromLists

            Dim oCFL As SAPbouiCOM.ChooseFromList
            Dim oCFLCreationParams As SAPbouiCOM.ChooseFromListCreationParams

            oCFLCreationParams = SBO_Application.CreateObject(SAPbouiCOM.BoCreatableObjectType.cot_ChooseFromListCreationParams)

            oCFLCreationParams.MultiSelection = False
            oCFLCreationParams.UniqueID = "MyCFL"
            oCFLCreationParams.ObjectType = "126"

            oCFL = oCFLs.Add(oCFLCreationParams)
            oCons = oCFL.GetConditions()
            oCon = oCons.Add()
            oCon.Alias = "Type"
            oCon.Operation = SAPbouiCOM.BoConditionOperation.co_EQUAL
            oCon.CondVal = "1"

            oCFL.SetConditions(oCons)
            oCFLCreationParams.UniqueID = "CFL2"
            oCFL = oCFLs.Add(oCFLCreationParams)
        Catch
            MsgBox(Err.Description)
        End Try
    End Sub

here, 126 is CFL for table osta table and there you have a column called 'type'. you can set this condition accordingly (look in ostt table for your types filter- Absid field)

HTH

Binita