Adding discounts into QBE when receiving inventory

Mark_Vitamart_dotca · ‎October 06, 2023

We are an online retail store that uses QBE to generate purchase orders and then use the app to receive inventory into the system. The system then asks us to create an item receipt. Once we approve the item receipt the inventory goes into our system.

The problem we are facing is when we create a purchase order (typically 100-500 different items) the price we actually pay for the inventory is not the wholesale price, it is a discounted price such as 10% off all items. Currently when we receive the inventory into the system we are receiving it all at full wholesale price, but we aren't actually paying full wholesale price as we often get % discounts off wholesale.

We know we can change every price on the Item Receipt page one at a time to the price on the invoice from our supplier before we upload the new inventory, however this is painful as we often have hundreds of items we are receiving and changing the inventory one at a time doesn't make sense.

Is there a way for us to assign a discount at any step in the PO or receiving inventory process where we can have all the associated items have their price discounted in bulk and entered into QBE in bulk?

Alex M · ‎October 06, 2023

Hi there Mark_Vitamart_dotca,

It's important that all your transactions have the correct products and services so that you're billing the correct rates to your customers. QuickBooks Enterprise is a great tool able to help you keep track of sales and expenses so you can see the profit of your business. I can point you in the right direction for assistance with discounts.

For assistance with simplifying your process for entering discounts for purchases, I recommend reaching out to the QuickBooks Desktop support team outside of the Community. They'll be able to view the current way you're applying your discounts with you in a secure setting in order to see if there is a more effective way of entering these discounts on purchases made in bulk. You can reach them using the methods outlined in QuickBooks Desktop software support policies.

If you have any other questions, feel free to reach out here.

Mark_Vitamart_dotca · ‎October 07, 2023

Thanks Alex. I have spoken to level 1 and level 2 support. Both said they are stumped as to how to add discounts when receiving inventory.

It must be possible as purchasing product and having the supplier give discounts is a very common thing. How do we apply those discounts to the item receipt when we receive the inventory into our system?

Trish_T · ‎October 10, 2023

Hi Mark_Vitamart_dotca,

Thanks for getting back to us here. In QuickBooks Desktop, discounts are entered as line items, so you'll need to add them to your list. Here's how;

1. Go to the Lists menu and select Item List

2. Click Item, then New

3. In the drop-down menu for Type, select Discount

4. Give it a Name and enter the required fields

5. Hit OK when done.

You can create as many discount items as necessary, then apply them to your forms.

Please don't hesitate to submit a suggestion to our Development Team , if you would like to see other options for entering vendor discounts. Recommendations are greatly appreciated in assisting with future updates and feature improvements, to improve your overall customer experience with QuickBooks.

If you have any other questions, let us know. We're here for you!

Topics

Training

Community

Resources

Adding discounts into QBE when receiving inventory