i want to calculate tax amount

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • soahil
    New Member
    • Nov 2006
    • 5
    #1

    i want to calculate tax amount

    Thanks to Pragatiswain

    I have two table with follwing structure

    table no:1 BILL_DETAIl

    Name Null? Type
    ------------------------------- -------- ----
    BILL_ID NOT NULL NUMBER(38)
    S_HEAD_CODE NOT NULL VARCHAR2(12)
    SR_NO NOT NULL NUMBER(38)
    BILL_AMOUNT NUMBER(38)
    DESCRIPTION NOT NULL VARCHAR2(1000)
    CATEGORY_CODE NUMBER(38)
    COMP_ID NUMBER(38)
    TAX_AMOUNT NUMBER(38)
    TAX_ID NUMBER(38)


    Table: No 2. COMPANY

    Name Null? Type
    ------------------------------- -------- ----
    COMP_ID NOT NULL NUMBER(38)
    COMP_NAME NOT NULL VARCHAR2(40)
    CONTACT_PERSON VARCHAR2(25)
    COMP_ADDRESS VARCHAR2(200)
    NTN VARCHAR2(15)
    OWNER_CNIC VARCHAR2(15)
    TOTAL_BUSINESS_ PURCHASE NUMBER(38)
    TOTAL_BUSINESS_ REPAIR NUMBER(38)


    two days back i make a question that whenever i insert valuse in bill_detail table and when i save record then bill_amount should also be inserted in COMPANY table automatically. That problems has been solved with your help.

    Now the problem is when company business in AMOUNT increase from Rs.25000 then that COMPANY will be liable to pay tax at the rate of 6%.
    Also when a tax will be paid by any COMPANY then in future if a BILL of Rs.1 is paid then that amount will be taxable. and remember that when tax has been deducted from any amount then that amount will be not be taxable further.
    if u want to view othe table's structure that is available in
    http://www.thescripts. com/forum/thread567445.ht ml

    Please help me to solve this problem.
    .
    Tags: None
    • pragatiswain
      Recognized Expert New Member
      • Nov 2006
      • 96
      #2
      Originally posted by soahil
      Thanks to Pragatiswain

      I have two table with follwing structure

      table no:1 BILL_DETAIl

      Name Null? Type
      ------------------------------- -------- ----
      BILL_ID NOT NULL NUMBER(38)
      S_HEAD_CODE NOT NULL VARCHAR2(12)
      SR_NO NOT NULL NUMBER(38)
      BILL_AMOUNT NUMBER(38)
      DESCRIPTION NOT NULL VARCHAR2(1000)
      CATEGORY_CODE NUMBER(38)
      COMP_ID NUMBER(38)
      TAX_AMOUNT NUMBER(38)
      TAX_ID NUMBER(38)


      Table: No 2. COMPANY

      Name Null? Type
      ------------------------------- -------- ----
      COMP_ID NOT NULL NUMBER(38)
      COMP_NAME NOT NULL VARCHAR2(40)
      CONTACT_PERSON VARCHAR2(25)
      COMP_ADDRESS VARCHAR2(200)
      NTN VARCHAR2(15)
      OWNER_CNIC VARCHAR2(15)
      TOTAL_BUSINESS_ PURCHASE NUMBER(38)
      TOTAL_BUSINESS_ REPAIR NUMBER(38)


      two days back i make a question that whenever i insert valuse in bill_detail table and when i save record then bill_amount should also be inserted in COMPANY table automatically. That problems has been solved with your help.

      Now the problem is when company business in AMOUNT increase from Rs.25000 then that COMPANY will be liable to pay tax at the rate of 6%.
      Also when a tax will be paid by any COMPANY then in future if a BILL of Rs.1 is paid then that amount will be taxable. and remember that when tax has been deducted from any amount then that amount will be not be taxable further.
      if u want to view othe table's structure that is available in
      http://www.thescripts. com/forum/thread567445.ht ml

      Please help me to solve this problem.
      .
      Hey soahil,

      Please do not open new threads when it is related to the old problem.

      I really don't understand what you are looking for and what you are doing?
      Are you a Business Analyst or User or Software developer?
      If you are a BA, hire someone to do it for you. It may need design change/ development.
      If you are a user of the system, report about the problem to your manager.
      If you are a Software developer do it by yourself. If you need any help, regarding technology, ask specific questions about it. The members of the forum will be glad to help you out.

        Comment

        • soahil
          New Member
          • Nov 2006
          • 5
          #3
          Sorry for that

          Actullay i m developing a database for CONTINGENCY Bills relating to A/C.
          my previous problem has been solved.

          I want now that after a company has made business of some specific limit like Rs. 25,000, then there should be condition of TAX deduction on that particular amount with some specific rate like 6%.

          Table structure is there is the previous thread.

          I will be very thankful to u friend.

          Waitng 4 your +ve response

            Comment

            • pragatiswain
              Recognized Expert New Member
              • Nov 2006
              • 96
              #4
              Originally posted by soahil
              Sorry for that

              Actullay i m developing a database for CONTINGENCY Bills relating to A/C.
              my previous problem has been solved.

              I want now that after a company has made business of some specific limit like Rs. 25,000, then there should be condition of TAX deduction on that particular amount with some specific rate like 6%.

              Table structure is there is the previous thread.

              I will be very thankful to u friend.

              Waitng 4 your +ve response
              What do you mean by 'developing a database for CONTINGENCY'?
              Is it if DB crashes, a secondary DB is already there with data?

                Comment

                • pragatiswain
                  Recognized Expert New Member
                  • Nov 2006
                  • 96
                  #5
                  Calculate and deduct the tax if a company has made business of some specific limit like Rs. 25,000 with some specific rate like 6%. What is the problem?

                    Comment

                    Previous template Next
                    Working...