Skip to Content
author's profile photo Former Member
Former Member

Tax Filtering

Hi Friends,

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

Regars

Sana

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 06, 2008 at 09:01 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • author's profile photo Former Member
    Former Member
    Posted on Jun 07, 2008 at 08:58 AM

    Thanks a lot Binita...

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.