QuickBooks Desktop (Enterprise: Manufacturing and Wholesale 22.0) US edition The issue we are facing today is that when we have a Inventory assembly item, we set the markup to be 100%. The Sales Price adjusts to Markup = 100% and Margin = 50%.Then in Edit --> Preferences --> Items & Inventory --> Company Preferences --> Automatic Cost & Price Updates we set:'when item cost changes' = always update sales price'use auto-update BOM cost as assembly cost' check box on.'When BOM cost changes, update sales price.' check box on.Now when we go back to my item with Markup = 100%, if I go down to the bill of materials section and change the cost or quantity of any item in the Bill of Materials the BOM goes up, and the sales price doesn't change. This is the opposite of what we are after, we always want markup = 100% so when the BOM changes the Sales Price should reflect 100% on the new BOM. The last bullet point I mention 'When BOM cost changes, update sales price' is exactly what we are looking for but in practice it doesn't seem to be working as described.

I appreciate the details you provided about your concern, MarkupAlways100. I got the steps to make sure sales prices are updating now in your QuickBooks Desktop (QBDT). Since the Sales Price is not updating even after setting up the Mark up in QBDT, you'll want to run an update for your software to fix common issues in it. Here's how to manually update your software: Go to the Help menu.Select Update QuickBooks Desktop.Click the Options tab.Select Mark All and then click Save.Go to the Update Now tab.Select the Reset Update checkbox.When you're ready, select Get Updates.To give you more insight and visual guide on how to update QuickBooks Desktop, please check out this article: Update QuickBooks Desktop to the latest release. If the same this happens, I recommend utilizing the Verify Data tool. It identifies known issues within company files and informs users if their Rebuild Data utility needs to be used afterward. Here's how it's used:Click Window, then Close All.In your top menu bar, go to File.Choose Utilities.Select Verify Data.If its results show a "Your data has lost integrity," message, this indicates there's damage in your file. You can use the Rebuild Data utility to fix it. For specific errors, there may already be a resource for them on our support site.All you need to know about tracking inventory assets and the cost of goods sold can be found in this article: Understand inventory assets and tracking cost of goods sold. Check out these articles for more details about how inventory works in QuickBooks:Set up Advanced Inventory.Turn on Advanced Inventory.For the report, you can run a couple of them. Here's an article for the list of reports that will help you review your weekly inventory: Balance Sheet and Inventory/Stock Valuation reports show different amounts for Inventory Asset accou.... Don't hesitate to let me know if there's anything else you need help with managing inventory. I'm here to help anytime.

M

MarkupAlways100

Question

Sales Price not updating with Total Bill of Materials Cost

Forum|Forum|4 years ago
June 21, 2022
1 reply
0 views

QuickBooks Desktop (Enterprise: Manufacturing and Wholesale 22.0) US edition

The issue we are facing today is that when we have a Inventory assembly item, we set the markup to be 100%. The Sales Price adjusts to Markup = 100% and Margin = 50%.

Then in Edit --> Preferences --> Items & Inventory --> Company Preferences --> Automatic Cost & Price Updates we set:

'when item cost changes' = always update sales price
'use auto-update BOM cost as assembly cost' check box on.
'When BOM cost changes, update sales price.' check box on.

Now when we go back to my item with Markup = 100%, if I go down to the bill of materials section and change the cost or quantity of any item in the Bill of Materials the BOM goes up, and the sales price doesn't change.

This is the opposite of what we are after, we always want markup = 100% so when the BOM changes the Sales Price should reflect 100% on the new BOM. The last bullet point I mention 'When BOM cost changes, update sales price' is exactly what we are looking for but in practice it doesn't seem to be working as described.

QuickBooks Desktop

C

Charies_M

I appreciate the details you provided about your concern, MarkupAlways100.

I got the steps to make sure sales prices are updating now in your QuickBooks Desktop (QBDT).

Since the Sales Price is not updating even after setting up the Mark up in QBDT, you'll want to run an update for your software to fix common issues in it.

Here's how to manually update your software:

Go to the Help menu.
Select Update QuickBooks Desktop.
Click the Options tab.
Select Mark All and then click Save.
Go to the Update Now tab.
Select the Reset Update checkbox.
When you're ready, select Get Updates.

To give you more insight and visual guide on how to update QuickBooks Desktop, please check out this article: Update QuickBooks Desktop to the latest release.

If the same this happens, I recommend utilizing the Verify Data tool. It identifies known issues within company files and informs users if their Rebuild Data utility needs to be used afterward.

Here's how it's used:

Click Window, then Close All.
In your top menu bar, go to File.
Choose Utilities.
Select Verify Data.
If its results show a "Your data has lost integrity," message, this indicates there's damage in your file. You can use the Rebuild Data utility to fix it. For specific errors, there may already be a resource for them on our support site.

All you need to know about tracking inventory assets and the cost of goods sold can be found in this article: Understand inventory assets and tracking cost of goods sold.

Check out these articles for more details about how inventory works in QuickBooks:

For the report, you can run a couple of them. Here's an article for the list of reports that will help you review your weekly inventory: Balance Sheet and Inventory/Stock Valuation reports show different amounts for Inventory Asset accou....

Don't hesitate to let me know if there's anything else you need help with managing inventory. I'm here to help anytime.

M

MarkupAlways100Author

Forgive me if I am misunderstanding, but I am testing the functionality in a sample company. Becasue the issue is persistent in our company and the test company I do not believe this to be an error within the company file, rather an issue within the functionality of QuickBooks. I am trying to see if others can get their markup percent to stay at 100% after adjusting their BOM inside an inventory assembly item. If you (or anyone) can replicate my Test inventory assembly item and produce different results, that is what we are after. Attached are screenshots where you can see the markup drop after changing the BOM, even with the proper box checked.

M

mv32

Thanks for letting us know the result, @talk2khurram,

If the system is still unable to update the sales price after trying out the solutions listed by my peer, I highly recommend getting in touch with our Support Team.

Our representatives can help diagnose the company file and check what's causing this odd behavior. To get our support, follow the steps below:

On your QuickBooks company file, click the Help menu.
Select Contact Us, then Contact Us.
Type your concern in the What can we help you with? box.
Hit Continue, then scroll down to get your contact options.

I'm also adding this article about our contact options and support availability for your reference: Contact QuickBooks Desktop support.

A quick reference about the Build Assembly transaction can be found here: Combine your inventory items to build finished goods.

Kindly update me with the outcome after contacting support. I want to make sure this is resolved so you can work with the program without any issues.

Sign up

Login with SSO

Login to the community

Login with SSO