Advertise here    

QuickBooks Forums      

Go Back   QuickBooks Forums > QuickBooks Software Support > QuickBooks Pro Forum

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 03-06-2007, 01:00 PM
Meganou Meganou is offline
Registered User
 
Join Date: Jan 2007
Posts: 7
custom invoices / adding formulas

I know I can create a custom invoices - so I'd like to have a field show the quantity ordered by the customer, another field with the quantity back ordered if any, and then the total quantity shipped per line item. In my manual invoices on excel, I'm able to do that and key in formulas so that when I type in how many are shipped, it automatically shows the quantity back ordered in that field so the customer knows what's missing in the shipment.

So in QuickBooks I can create the fields the way I want, but is there a way to enter formulas so it calculates the back ordered quantities automatically? It would be nice to reduce chances of errors.

Thanks in advance,
Meganou
Reply With Quote
  #2  
Old 03-06-2007, 02:32 PM
Joe Williams Joe Williams is offline
Registered User
 
Join Date: Jan 2006
Location: Oklahoma
Posts: 8,885
There is no caculateing field that you can add to invocies. You can add rext fields that you can enter invormation in but that is a manual operation on each invoice.
__________________
Joe Williams
joewilliams@wavelinx.net
Piedmont, Ok
Reply With Quote
  #3  
Old 03-06-2007, 05:59 PM
lisa_mn's Avatar
lisa_mn lisa_mn is offline
Moderator
 
Join Date: Nov 2003
Location: Minneapolis
Posts: 3,871
There is a QB add-on called FormCalc that will add calculating columns. Their website is www.goflagship.com

Or, if you're going to be spending money anyway, you might as well upgrade to QB Premier which supports sales orders and back orders without needing anything else.
__________________
Lisa Peterson
Streamline Consulting, Inc.
Making Accounting Work For You
Minneapolis, MN

QuickBooks Advanced Certified ProAdvisor
Sleeter Group Certified QuickBooks Consultant
Peachtree Certified Consultant
Timeslips Certified Consultant
Fishbowl Inventory Authorized Reseller

Ask me about MiSys Manufacturing add-on for Quickbooks and Peachtree
Reply With Quote
Reply

Bookmarks
Bookmark and Share
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

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 Off
HTML code is On

Forum Jump


All times are GMT -5. The time now is 07:38 AM.


 

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
All contents copyright (c) by AccountingUsers Inc.