Home   .   Software   .   Books   .   News   .   Articles   .   Forums   . .
    Forums Home   .   Privacy Policy   .   E-mail Us!    
 

Go Back   Flagship Technologies Discussion Forums > Product Discussions & Support > FormCalc SST™ for QuickBooks

Notices

Reply
 
Thread Tools Search this Thread Display Modes
Old 04-15-2014, 03:13 PM   #1
FlagshipTech
Administrator
 
FlagshipTech's Avatar
 
Join Date: Apr 2008
Posts: 374
Default 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.
FlagshipTech is offline   Reply With Quote
Old 04-15-2014, 03:13 PM   #2
FlagshipTech
Administrator
 
FlagshipTech's Avatar
 
Join Date: Apr 2008
Posts: 374
Default 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 step-by-step 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
FlagshipTech is offline   Reply With Quote
Old 04-15-2014, 03:17 PM   #3
FlagshipTech
Administrator
 
FlagshipTech's Avatar
 
Join Date: Apr 2008
Posts: 374
Default 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.
FlagshipTech is offline   Reply With Quote
Old 04-15-2014, 03:19 PM   #4
FlagshipTech
Administrator
 
FlagshipTech's Avatar
 
Join Date: Apr 2008
Posts: 374
Default 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 way--it cannot accept a mixed feet-and-inches 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
FlagshipTech is offline   Reply With Quote
Old 04-15-2014, 03:20 PM   #5
FlagshipTech
Administrator
 
FlagshipTech's Avatar
 
Join Date: Apr 2008
Posts: 374
Default 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
FlagshipTech is offline   Reply With Quote
Old 04-15-2014, 03:20 PM   #6
FlagshipTech
Administrator
 
FlagshipTech's Avatar
 
Join Date: Apr 2008
Posts: 374
Default 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 list--even 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
FlagshipTech is offline   Reply With Quote
Old 04-15-2014, 03:21 PM   #7
FlagshipTech
Administrator
 
FlagshipTech's Avatar
 
Join Date: Apr 2008
Posts: 374
Default 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??
FlagshipTech is offline   Reply With Quote
Old 04-15-2014, 03:22 PM   #8
FlagshipTech
Administrator
 
FlagshipTech's Avatar
 
Join Date: Apr 2008
Posts: 374
Default 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
FlagshipTech is offline   Reply With Quote
Old 04-15-2014, 03:22 PM   #9
FlagshipTech
Administrator
 
FlagshipTech's Avatar
 
Join Date: Apr 2008
Posts: 374
Default 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
FlagshipTech is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -6. The time now is 05:57 PM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © 1995-2012 Flagship Technologies, Inc. All rights reserved.