Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Dec 2011
    Posts
    2
    Thanks
    1
    Thanked 0 Times in 0 Posts

    province based tax condition

    I use Word for invoicing - basic sample attached. I would like to set it up so that the displayed and formula tax (GST) rate, which I highlighted in red, changes automatically based on the province entered in the header. How would I go about doing this?
    Attached Files Attached Files

  2. #2
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts
    Welcome to the Lounge!

    There might be a way to do this using Word fields (beyond me, though!), but this would be very easy to do if you create the invoice using Excel, rather than Word. In Excel, you can have a lookup table with each province and its corresponding rate, and then use formulas to automatically bring in the correct rate in the invoice, based on which province is entered at the top.

    Gary

  3. The Following User Says Thank You to Gary Frieder For This Useful Post:

    spiderling (2012-01-03)

  4. #3
    New Lounger
    Join Date
    Dec 2011
    Posts
    2
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks Gary!

    I would prefer Word if this is possible, but I'll try find some time to creating the invoice again in Excel.

  5. #4
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Hi spiderling,

    This can be done easily enough with field coding, using dropdown formfields and formula fields, but this potentially creates problems for your itemised listing. That's because with the document protection required for formfields, you'd need a separate pair of formfields for each potential item and its price - preferably on separate table rows so they'll line up.

    See attached. The sales tax is calculated on the basis of what's chose in the 'Province' dropdown.
    Attached Files Attached Files
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •