Advertise here    

QuickBooks Forums      

Go Back   QuickBooks Forums > QuickBooks Software Support > Premier Manufacturing and Wholesale Edition Forum

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 07-13-2017, 05:28 PM
JoeMcFadden JoeMcFadden is offline
Registered User
 
Join Date: Jul 2017
Posts: 4
How to show price and promo price on invoice.

We are using QB Enterprise Desktop 17 Manufacturing and Wholesale.

We are a distributor and we have customers who get different pricing.
We also have sales (promos) that run for a specific period of time.

We have the price levels working and the promo pricing working.

What we need to do is show the price before the promo (but with the price level applied) in 1 column, and then show the promo price in another column so that the customer knows they are getting the promo pricing. (This is actually in our contract to provide this. We are switching from MAS90, and we are able to provide it with that software.)
(And, ideally - show the difference.)

If you click the little icon in the price column, it shows the price level and discount info... how do I show that on the invoice?

I haven't been able to figure out how to accomplish this with QB and could use a little help.

Last edited by JoeMcFadden; 07-16-2017 at 07:23 PM.
Reply With Quote
  #2  
Old 07-14-2017, 05:36 AM
Rustler Rustler is offline
Registered User
 
Join Date: Feb 2008
Location: Texas - The Republic
Posts: 2,329
What you need to do is first create a custom field for an inventory item call it MSRP or something.

then fill in the custom field for all items with the MSRP amount per item

use customize data layout for an invoice, on the column tab check mark the custom MSRP field to show in print and or on screen, and set the order (lowest number is the leftmost column)

This third party utility may help too
http://www.q2q.us/ucfOverview.htm
I am not affiliated

Then when you select the item the sales price, or the price level list price will show in the rate block, and the standard MSRP price will show in the MSRP block
Reply With Quote
  #3  
Old 07-14-2017, 07:08 AM
JoeMcFadden JoeMcFadden is offline
Registered User
 
Join Date: Jul 2017
Posts: 4
Thank you very much for the reply!

Will the price level rules update the MSRP column like it does the sales price column?

We need to show the sales price (adjusted per customer by price rules) and also show a column with promo pricing if it applies for that item.

So, if the sales price is $24.99 and the price level for Customer A is $22.99 and a promo for that item for that customer is $2 off, we need to show in one column the $22.99 and then the next column under the heading Promo Price $20.99, and in a perfect world, a Discount column that shows the difference, in this case: $2.00

Under this same scenario, Customer B may have $23.49 as their price, and may have $1.50 as their promo discount. So their columns would be $23.49 for Price and $21.99 for Promo and $1.50 for Discount.

We need a way to show the customer (per line) their discount to prove they are getting the promotional pricing.

The promo rules are exclusive, so how can I possibly show the A price or the B price if the promo price overrules it?
Reply With Quote
  #4  
Old 07-15-2017, 03:55 AM
Rustler Rustler is offline
Registered User
 
Join Date: Feb 2008
Location: Texas - The Republic
Posts: 2,329
Sorry I misunderstood what you were wanting, I thought you wanted standard price, price level price

You say price rules, are you using enterprise? Sorry I don't have enterprise and do not know how price rules work. I saw that you said you use QB Desktop 17 Manufacturing and Wholesale, I thought that was premier since you didn't say enterprise
Reply With Quote
  #5  
Old 07-16-2017, 04:03 PM
JoeMcFadden JoeMcFadden is offline
Registered User
 
Join Date: Jul 2017
Posts: 4
Yes, it's Enterprise.
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 Off

Forum Jump


All times are GMT -5. The time now is 06:50 AM.


 

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