1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Computing subtotals including shipping, handling and tax

Discussion in 'General' started by plngndz, Nov 30, 2010.

  1. plngndz

    plngndz Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    hello, i am pelin a new user to this oracle forum
    i have a problem i wanna calculate Tax by Subtotal and Shipping and Handling but calculating tax it didn't take account Shipping and Handling
    what can u suggest me?
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Provide table DDL and sample data; your question cannot be answered without that information.
     
  3. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Are you talking about e-business suite? more info please...
     
  4. plngndz

    plngndz Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Yeap,

    We use iStore and i did all the setup as i said the tax doesn’t include shipping and handling cost.

    Is it enough?
     
  5. plngndz

    plngndz Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Well, u r right

    We use iStore and i did all the setup

    For example sub-total = $30.60
    shipping and handling = $3,5
    KDV %18 = $5.51

    The tax doesn’t include shipping and handling cost.
     
  6. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    It shouldn't, if my memory serves me correctly as shipping and handling charges are not taxable entities.
     
  7. plngndz

    plngndz Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    i dont think so david
    i am going to search if i find the reason i write u
    thnxxx
     
  8. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    1. Are delivery and handling charges taxable?
    Delivery charges.
    • You have the property delivered directly to your customer using a common carrier, the U.S. Mail, or an independent contractor
    Tax does not apply to the delivery charges under these conditions if the charges are clearly stated as a separate entry on the invoice or other bill of sale. If the delivery charges are not stated separately, they are taxable.
    Example.
    You sell a refrigerator and have it delivered by an independent contract carrier. On the invoice, you show a $750 charge for the refrigerator plus a separately stated $50 charge for delivery (the amount charged you by the carrier). Since the delivery charge is stated separately, tax applies only to the charge of the refrigerator ($750). If the invoice had shown a single charge of $800, tax would apply to the entire amount.



    You list the shipping and handling separately, therefore they are not taxable.



     
  9. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You list the shipping and handling separately, therefore they may not be taxable depending upon the local regulations. In many cases shipping items between states or countries makes such charges not taxable; however you will need to consult a local tax expert to make the final determination.