
04152014, 03:13 PM  #1 
Administrator
Join Date: Apr 2008
Posts: 382

Multiply feet & inches like 10' 4" ?
[Duplicated from email support]
We are a metal building component manufacturer. Problem 1; We use Manufacturing and wholesale 14 version of Quickbooks. On the sales order, we use two “text columns” for quantity and length (foot and inches, ex: 10’ 4”) Needless to say Quickbooks will NOT calculate the total which in turn is multiplied by the price for the total dollars. Can we set up your product to make this calculation for us? Problem 2; The weight per item is set up in each item. We need to be able to get a total weight on each sales order and be able to print it on the Packing Slip when we ship a load. Can your software help with these two issues?? Thank you. Amy S. 
04152014, 03:13 PM  #2 
Administrator
Join Date: Apr 2008
Posts: 382

Re: Multiply feet & inches like 10' 4" ?
Amy,
> On the sales order, we use two “text columns” for quantity and length (foot and inches, ex: 10’ 4”) Needless to say Quickbooks will NOT calculate the total which in turn is multiplied by the price for the total dollars. To clarify: you enter feet in the 1st column and inches in the 2nd, and you need to calculate the Quantity based on them, correct? For instance 10' 4" needs to result in a Quantity of 10.25 (feet)? If so then yes, FormCalc SST (http://www.goflagship.com/products/sst.htm) can handle that calculation easily. > The weight per item is set up in each item. We need to be able to get a total weight on each sales order and be able to print it on the Packing Slip when we ship a load. This is also very doable. You customize the form (Sales Order) to include the Item custom field holding the weight. Also add another custom field to hold the Extended Weight. FormCalc SST then multiplies Quantity * Item weight and puts the result in Extended Weight on each line. Finally, it totals the Extended Weight column. To see stepbystep details or a video of doing something similar, please go to our Problem Solved page ( http://www.goflagship.com/products/sstprobsolv.htm ), and view the "Shipping weight calculations on an Invoice" topics. Mark Wilsdorf Flagship Technologies, Inc. http://www.goflagship.com 
04152014, 03:17 PM  #3 
Administrator
Join Date: Apr 2008
Posts: 382

Re: Multiply feet & inches like 10' 4" ?
Hi, Mark!
On the 1st question, the columns are set up as follows; [Description] [# of Pieces] [Length (foot AND inches)] [Total] [U/M] [Rate] [Amount] # of Pieces (whole #’s EX: 1, 15, 540…) X Length (foot AND inches EX: 10’ 2”) = Total (10.17) Amy S. 
04152014, 03:19 PM  #4 
Administrator
Join Date: Apr 2008
Posts: 382

Re: Multiply feet & inches like 10' 4" ?
Amy,
FormCalc SST can show decimal results as feet and inches (i.e., 5.25 shown as 5' 1/4") but cannot go the other wayit cannot accept a mixed feetandinches value as data for calculations. Here's an alternative to consider, depending on what you need to show on Sales Orders and Packing Slips... Description # of Pieces LengthFT LengthINCH LengthTOTAL Total U/M Rate Amount Column descriptions: LengthFT is the "feet" part of the length. LengthINCH is the "inches" part of the length (entered separately from LengthFT). LengthTOTAL is optinal: it's the decimal result of FormCalc SST's calculation of a decimal value for LengthFT + LengthINCH. (It's really only useful for showing the result of this calculation...it wouldn't need to be displayed, for FormCalc SST to calculate the Total column.) Your original "Length (foot AND inches)" column could still be used if you want. FormCalc SST would take the values from LengthFT and LengthINCH and show the results in mixed feet and inches. (You might only want to use this column if necessary to show on printed forms....otherwise, it's really not needed.) Mark Wilsdorf Flagship Technologies, Inc. http://www.goflagship.com 
04152014, 03:20 PM  #5 
Administrator
Join Date: Apr 2008
Posts: 382

Re: Multiply feet & inches like 10' 4" ?
We can certainly state our “foot” and “Inches” in separate columns. BUT, I don’t think I have any additional columns available in Quickbooks. Can we add additional columns somehow??
Amy S 
04152014, 03:20 PM  #6 
Administrator
Join Date: Apr 2008
Posts: 382

Re: Multiply feet & inches like 10' 4" ?
Amy,
Do you have all of your available Item list custom fields in use? Most people don't, and if you don't, you can define a couple custom fields in the Item listeven though you won't be using them to hold data for each item. Once defined there in the Items list, custom fields will be available to use in your QuickBooks form customization as blank columns. Mark Wilsdorf Flagship Technologies, Inc. http://www.goflagship.com 
04152014, 03:21 PM  #7 
Administrator
Join Date: Apr 2008
Posts: 382

Re: Multiply feet & inches like 10' 4" ?
Oh my, I’m feeling pretty optimistic! I was able to create an additional column by going thru the item list.
So we will be able to enter the inches in the inches column like this? 4 15/16” (whole # and a fraction) and it still calculate?? 
04152014, 03:22 PM  #8 
Administrator
Join Date: Apr 2008
Posts: 382

Re: Multiply feet & inches like 10' 4" ?
> So we will be able to enter the inches in the inches column like this? 4 15/16” (whole # and a fraction) and it still calculate??
No. Recall from one of my prior replies, that FormCalc SST can only use decimal numbers as sources for calculations. Mark Wilsdorf Flagship Technologies, Inc. http://www.goflagship.com 
04152014, 03:22 PM  #9 
Administrator
Join Date: Apr 2008
Posts: 382

Re: Multiply feet & inches like 10' 4" ?
Thanks for your help. I think we are going to try it for the 30 days on one computer and go from there. Excited to give it a try!
Again, thanks for the coaching! Amy S 
Thread Tools  Search this Thread 
Display Modes  

