I found this song because my daughter plays violin so we have spent some time checking out various electric and other non standard violin videos on YouTube.
After having our application to the Amazon Associates program rejected twice because our blog had not been updated in almost 3 years I decided to start posting updates on our blog again to see if that would be enough for a new application to be approved (see First blog post in a while…) and as of today it has been a month since that first new post.
I wanted to get everything done before scheduling this post so I rejoined the associates program again on 2/06/2018 and for now we have a active associates account with links on our products using our new associates id. However it may be several weeks before the application is actually approved or rejected and I will post a update when the account is officially approved or rejected.
When you have worked with QuickBooks for as many years as I have, 16 years, you are bound to run into some of QuickBooks quirks and have to figure out how to troubleshoot and resolve them. One of the quirks I have run into is that you can have inventory with zero quantity on hand but that still has a inventory value that is not zero.
From my experience this type of issue happens when making a inventory adjustment that moves inventory from one inventory item to another (for example when moving a single unit item into a multipack item). If you do not make inventory adjustments that move inventory from one inventory item to another you probably will not have this issue, however if you do the procedure below will allow you to find any problem inventory items.
To find inventory items affected by this issue you will want to open QuckBooks and go to Inventory -> Reports -> Inventory Valuation Summary and run the report. Below is a screenshot of two of our inventory items that have zero quantity on hand but have a inventory value.
QuickBooks inventory valuation report showing two items that have a quantity on hand of zero and a inventory value that is not zero.
You could scroll through the inventory valuation report trying to spot each these problem inventory items, however unless have only handful of inventory items it would get tedious and you would almost certainly miss one or two of the problem inventory items.
The easiest option to ensure you find all your problem inventory items is to export the report to Excel, since you can filter the inventory items to show only the ones you are looking for. If you have a large number of inventory items you may want to export the report to a CSV file and then open the CSV file in Excel (It took about 13 minutes to export our 4,000 inventory items to Excel).
Export QuickBooks inventory valuation report to Excel.
Once you have the report in Excel you can filter the On Hand column to show items that have zero quantity on hand and then filter the Asset Value column to show only items that have a non zero inventory value.
QuickBooks inventory valuation report in Excel and filtered to show inventory that has 0 quantity on hand and a valuation that is not 0.
One way to fix the issue would be to drill into the inventory valuation detail and find the inventory adjustment that caused the issue. In the screenshot below I can see there was a adjustment that made the inventory negative on 5/04/2017 and clicking into that adjustment shows me that we moved 10 non existent units out of the inventory item and into another inventory item. To resolve the issue I could edit the inventory adjustment and change it to move inventory from the correct item.
QuickBooks inventory valuation detail showing the non zero inventory value.
The other way to correct the issue would be to enter a inventory value adjustment to rest the inventory value to zero. Fixing the original adjustment would be the preferred method, however in this case since I found the issue almost 8 months later I chose to use inventory value adjustment.
QuickBooks inventory adjustment to reset the value to zero.
This will fix issues that can be found using the inventory valuation report, however it will not catch them all thanks to another QuickBooks quirk where inactive inventory items are not included in the inventory valuation report. This issue can lead the total inventory value reported on your inventory valuation report to be different from the value reported on your balance sheet and I will cover how to troubleshoot that issue in a future post.
In the name of creating regular posts where I don’t have to do much writing (and schedule several in advance) I will be regularly posting music videos that I find interesting and refreshing and that provide a break from the music I generally listen to at work.
Editors Note: My wife originally wrote this article in October 2013 and it was not edited / published at the time.
So let’s get real. If you have kids, a Prius is not at the top of the list for kid-friendly vehicles. Space is the biggest issue here. Kids need space to put their toys, books and sippy cups.
When my husband and I went looking for a new set of wheels, a Prius wasn’t even on our radar- too expensive for starters. But then I saw a shiny, black 2010 Prius on the lot and I liked the look instantly. The salesman was so smart, spouting off all of these things we wanted to hear- “best-selling car in Northern California” and “black is elegant.”
When I calculated all the miles we drive up and down Skyway- the main road that connects Paradise to Chico- I was sold. 50 miles per gallon? Like, really? Really? Between visiting family all over California and trekking to and from my husband’s half-marathons, this was a smart choice.
Honestly, we bought the car knowing it would be a tight fit. In retrospect, I did not calculate our baby-at-the-time would grow. She would soon become a toddler, then a young adult and so on and so forth. My emotions drove the purchase and a portion of my practicality went out the window. Now I get why most Mom’s drive minivans.
There were several conversations had with regards to how to drive far in a small car with a small child. The goal was to not be exhausted on arrival to our destination. We contemplated getting an iPad. We budgeted for one, but then decided to upgrade our phones instead as we were late to get on the “Smart Phone Train.”
Our baby is now 2 ½ years old and she loves technology, specifically Daddy’s phone. More specifically, YouTube and Netflix. I cannot imagine a road trip without these tools to help keep our toddler entertained.
My husband has a HTC Evo V and I have a Samsung Galaxy Victory. Neither comes equipped with the cables that you need to keep a young person happy on a long road trip. The issue is that the child wants to hold the phone but it needs to be plugged in to get juice or to play from the speakers.
Here are two cables from YourCableStore.com that never leave our car:
1) 6’ or 12’ Headphone Extension Cable- H3MM6-B or H3MM12-B. If you plug your phone into the 3.5mm auxiliary jack, your child can hold the phone and it can be heard through the car’s speaker system.
2) 6′ or 10’ USB Extension Cable- USB 2 AM- AF 6 or USB 2 AM-AF 10, plug into the charging cord and have it charge while the child holds/ uses the phone or tablet. (Editors note in 2013 we sold single units of these items but due to the rising costs of selling on Amazon we now only sell 5 packs).
Now our daughter can watch Daft Punk’s new video on YouTube on repeat to her heart’s content. She likes to get funky.
