This review was originally written in June 2013 by Michael our operations Manager but never published and I am posting pretty much as it was written with a few minor edits for clarity / readability.

This past weekend the band I play with had some out of town gigs for which we had to stay overnight. This means self imposed hotel room confinement to ward off pre-gig exhaustion … so … it’s either read, watch 50 episode of “Friends” on TBS, or get creative…. this last trip I did the latter. I decided to bring my Line 6 POD and Guild SG100 guitar with me and do some practicing and idea cultivation. My favorite headphones have an 1/8″ plug, so I asked my boss if I could borrow one of the 3.5mm female to 1/4 inch adapters we sell (Part number: HA 3F6M1-B) for the weekend because my POD has a 1/4″ jack for headphones.

After I got settled into my room I started getting out my notebook and pen, setting up the POD, and making my connections. I took the HA3F6M1B out of it’s bag and the first thing I noticed was it’s attractive all metal design and it’s weight and sturdiness. When I plugged the 1/8″ of my phones into the HA3F6M1B the fit was snug and smooth, a good sign. I was also pleased that the grip on the base made it easier to apply the pressure necessary to make the connection. When I went to plug the phones into the POD jack the fit was, again, snug and smooth and the textured grip on the base was again a nice feature with practical application and aesthetic value in spades. I played for a total of 8 hours in my room over the weekend without a snap of crackle from a bad or intermittent signal, just sparkling-clear stereo signal for hours. The all metal design is not a bit flimsy, so connecting or disconnecting can be done quickly and without worry, i.e. you don’t have to worry about apply a little pressure to this product, it’s not going to fall apart on you.

Lastly, on a shallow note, this little adapter looks GREAT and somehow is more satisfying to plug in than one of it’s plasticized cousins, given that what makes it attractive, metal, is the same thing that makes it sturdy, easy to use, and reliable… I really doubt I will be returning this little sucker to the warehouse. This little adapter is going to make it easier for me to get some practice hours in and to actually improve my playing in the process, so it’s usefulness is paying instant dividends, sometimes the littlest part of the puzzle is what helps us progress. Check out some of the other all metal offerings on the website, you won’t be disappointed.

YCS Basics 3.5mm female to 1/4 inch adapter

YCS Basics All Metal 1/8 Inch (3.5mm) Female To 1/4 Inch Male Stereo Headphone Adapter

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.