Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-21-2022, 08:25 AM
BCBoyInOntario BCBoyInOntario is offline Word Document Invoice, and Field codes are doubling fees Windows 11 Word Document Invoice, and Field codes are doubling fees Office 2021
Novice
Word Document Invoice, and Field codes are doubling fees
 
Join Date: Oct 2022
Posts: 2
BCBoyInOntario is on a distinguished road
Cool Word Document Invoice, and Field codes are doubling fees

Good Day, New to this forum anyhow, and can't find anything specific.

Please note, I can only work with what I have so solutions have to be specific
I cannot or won't be inserting a table to do what I need, this needs to happen from
what I currently have.

2 Part Question, hopefully a simple fix.
Word Invoice Doc
I will upload a copy to view



So using Legacy forms portion of the Developer Tab
Placing Boxes for monetary fees
Also additional fees, which for now are working
(Example (Brkers input is a number, and that is multiplied by 200.00 for the total of 400)
Properties is input number times 75.00 for that total (working)
Hourly is input number times 400. for that total (working)

Subtotal is taking the amounts and multiplying them by the input number and adding that extra to the sub total
Example, 2 brokers at 200.00 is 400 but the result is being shown as 1800 not 1400

Need to have Sub total add up the above boxes before calculating tax.

2nd part of Question
GST/HST Tax is a drop down box of 5%, 13%, or 15%, I would like to multiply the chosen tax rate against the Sub Total and placed into Total
Piece of Cake right?

Any assistance would be great, appreciate it.
Attached Files
File Type: docx RedInvoiceNotWorking.docx (38.7 KB, 6 views)
Reply With Quote
  #2  
Old 10-21-2022, 03:46 PM
macropod's Avatar
macropod macropod is offline Word Document Invoice, and Field codes are doubling fees Windows 10 Word Document Invoice, and Field codes are doubling fees Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Your Sub Total uses a calculating formfield to calculate the results of other calculating formfields. You can't use them that way because of a long-term formfield bug. What you can use is a standard formula field coded as:
{=FeeTotal+RushTotal+BrokerTotal+PropertyTotal+Hou rlyTotal \# "$,0.00"}
Other changes necessarily follow from this.

See attached.
Attached Files
File Type: docx RedInvoice.docx (38.8 KB, 3 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-24-2022, 08:59 AM
BCBoyInOntario BCBoyInOntario is offline Word Document Invoice, and Field codes are doubling fees Windows 11 Word Document Invoice, and Field codes are doubling fees Office 2021
Novice
Word Document Invoice, and Field codes are doubling fees
 
Join Date: Oct 2022
Posts: 2
BCBoyInOntario is on a distinguished road
Default

Thanks for the formula, and not quite understanding where this would be placed, or how that would work with multiple chosen numbers under Brokers/Properties/Hourly

I'm not able to edit to be able to view the formulas in the copy you provided...

I am assuming that the Sub Total line would have that formula, then the \# would be the number of one of the Brokers/Properties/Hourly
Not sure how this would work if all three of those boxes were filled with number, because each line is using a different multiplication factor
or is the \# referring to something else?
Thanks, also can we keep the form as editable so I can at least see and place the formulas on the copy that I have?....Thanks
Reply With Quote
  #4  
Old 10-24-2022, 02:39 PM
macropod's Avatar
macropod macropod is offline Word Document Invoice, and Field codes are doubling fees Windows 10 Word Document Invoice, and Field codes are doubling fees Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The required formula is already in the document itself. All you need do with the attachment (which I've updated) is input the values in the relevant Fees, Rush, Brokers, Properties, and Hourly cells.

In order for the formfield calculations to work, Word's 'filling in forms' protection has to be applied. You can apply/remove it via Developer|Restrict Editing.

Naturally, you'll need to unprotect the document so you can add formfields for the Client name, etc., before re-applying the protection.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word Document Invoice, and Field codes are doubling fees Word 2016 cannot hide field codes in document created by work 2013 twinclouds Word 2 03-10-2017 03:15 PM
Word Document Invoice, and Field codes are doubling fees The use of IF field codes in Word 2010 sunaina_ssl@yahoo.com.au Word 3 12-01-2015 08:54 PM
Using DocProperty Field Codes multiple times in the same document trueimage Word 2 09-18-2013 04:44 PM
Word Document Invoice, and Field codes are doubling fees Word Equation field codes mkarthic Word 1 12-02-2011 02:09 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft