NumberCruncher's in Paradise

May 20, 2016 at 8:59 AMJoshua Goldberg

Hey everyone. Welcome back to another weekly edition of the NumberCruncher blog! As our weekly readers know, our trainer/support tech, Tom, has been writing our weekly blogs for the past few months. But as summer starts to ramp up and Tom's calendar starts to fill with training appointments, I've been asked to take over. My name is Josh Goldberg, and i'm the marketing supervisor here at NumberCruncher. For the fans and loyal readers of our blog posts, please don't panic! Our blog's will continue to include support answers and how to's, for our product's including All Orders. But it will also include other exciting technology news and new features will be popping up all the time, so make sure you subscribe and follow the NumberCruncher blog, because you never know what will appear! As always, if you are struggling or have any questions about All Order's software, please visit our support page or give us a call at 866-278-6243 so that we can set you and your company up for a training session Today! 

Today's blog post will focus on our product line. Kind of a reintroduction of who we are and what we offer. Before we can dive into our award winning products, we need to start with who we are. NumberCruncher, Inc is a leading provider of inventory and order management software for the QuickBooks community. Founded in 1999, NumberCruncher was the first developer to invest in QuickBooks software development kit from Intuit. Our mission has always been to provide innovative, scalable and cost effective inventory management solutions that solve real world business issues, resulting in total customer satisfaction, increased profitability and competitive advantage. Thousands of manufacturers and wholesale distributors rely on NumberCruncher solutions to manage their everyday business activities across the globe. From inventory control to production management to order processing and fulfillment, these solutions are unmatched in the marketplace, setting the standard for QuickBooks inventory add-ons for the manufacturing and wholesale distribution markets. 

Our flagship product All Orders, is inventory software that bridges the gap between business accounting and business success. All Orders is a comprehensive inventory and order management software application that helps you make better business decisions in purchasing, shipping and receiving, order entry, production and inventory control. All Orders gives the business owner, manager and accountant the tools to be successful faster, easier and more efficiently. The best part about All Orders is the fact the application can be used as a stand-alone inventory software, or users can fully integrate it with QuickBooks, so you never have to enter the same data twice. Besides the integration with QuickBooks, All Orders also supports integration with 3D Cart, Magento, Sales Force, UPS, FedEx & USPS; just to name a few. If you are already an All Orders user, please make sure you have upgraded your software to the latest version 6.2.3, which was released in March. To verify your currently version, please go to Help --> About. The new update was for general maintenance purposes and includes all previous updates and addresses known issues.

 

After the success of All Orders, NumberCruncher got back to the drawing board and realized that in today's society, there's a growing trend of business owners who are constantly on the go and spend very little time, in their main offices. These owners were the inspiration behind our products All Orders Mobile & All Orders Web

All Orders Mobile extends your company's inventory management by bringing it into your warehouse and allows you to take full advantage of the barcode label printing feature within All Orders. The goal of All Orders Mobile is to make your warehouse operations more efficient. After All Orders Mobile is installed on your Windows based device, it connects wirelessly to your All Orders database and download sales orders to be picked, purchase orders to be received and counted. Once a sales order is picked, the picking information will be uploaded in real time back to the All Orders database and automatically creates a Ship Doc. Similarly, once a purchase order is received through All Orders Mobile, the information will be uploaded to All Orders and a receiver will automatically be created. Finally, All Orders Mobile will update your count in All Orders with the new quantities. 

All Orders Web is an e-commerce website that shares a database with your All Orders program. All items, customers, vendors, purchase orders, quotes and orders that are created within All Orders will be instantly available within All Orders Web portal and vice versa. One of the unique features of All Orders Web, is the ability to give role based access to your staff, sales reps, customers and vendors. The role based access feature, will significantly improve customer engagement and quality of service by allowing your customers to view stock availability, create quotes & orders, as well as, check on order statuses. Another beneficial feature of All Orders Web to businesses, is the fact the program is written using ASP.NET, so all the web forms are customizable. You are not only able to customize the look and feel, but you are also able to customize the "business rules" that are specific to your industry. 

Finally, our newest product, ReorderPoint.com, might be the one to impact the industry the most. ReorderPoint.com is a purchasing tool that offers a systematic approach to forecasting inventory needs. ReorderPoint.com is a cloud-based application that integrates with All Orders and QuickBooks. The way it works is, during the initial setup, ReorderPoint.com, will import up to 3 years of historical data from your QuickBooks/All Orders files including sales figures, purchases and component usage. The program then uses statistical methods to determine lead times, trends, seasonality and special orders. Based on the type of trends we identify we apply a model (i.e. a mathematical equation to calculate lead time demand). We then use the lead time demand to calculate the reorder point. The program also regularly imports your current inventory status including on hand, on purchase orders and back order quantities. ReorderPoint.com then compares the inventory status to the reorder point and sends alerts when the status is below of nearing the reorder point. Additionally, ReorderPoint.com provides lists, reports and graphs you can use to analyze your usage and make more informed purchasing decisions. 

Being involved in the software industry means your work is never finished. The minute you take a day off, everything switches up on you. We at NumberCruncher are always participating in new training exercises and growing our knowledge of QuickBooks & technology in general. Woodard is a company that empowers small business advisors through cutting-edge training, networking, coaching & resources. Next week Woodard is hosting their annual Scaling New Heights conference. This year's conference will run May 22nd through May 25th and be located at the Atlantis Resort in Paradise Island, Bahamas. If you will be attending Scaling New Heights, please make sure you stop by the NumberCruncher table at booth #96 and tell our CEO, Ian Benoliel that Josh sent you!

How to Include Employee Costs in BOMs

May 6, 2016 at 3:02 PMThomas Riemann

Hello everyone. Welcome back to the NumberCruncher Blog. As most of you know, My name is Tom and I am the trainer/support tech here at NumberCruncher. If you need to learn how to do something in the All Order's software, I'm your guy! Remember, if you are struggling with something in the All Order's software, please give us a call @ 866-278-6243. We can set up a training session with you and your company remotely. So make sure you build up those questions and give us a call to set up your session today! That's not what brings me to the blog today. What I would like to talk about today is something that customers ask about all the time, "How do I include employee Costs in BOM's." So sit back and enjoy the read!

Our first step is to create an item that we can put into a BOM. We're going to create a new item called "Labor" (or whatever you would like). This item should either be a non-inventory part, service or other charge group. If you are creating this item in QuickBooks, check the "This service is performed by a Sub-contractor, owner or partner." Next, go to the purchasing tab, enter the cost. The cost should estimate the hourly wages and benefits. Of course, we're going to need to select an income account and an expense account. For income, you can select any of them. For the expense account, create a new account Called "Salaries Applies to Finished Goods". Save and close this item.

Now it is time to include this newly created item in the appropriate Bill of Materials. Go to a finished good item and edit the BOM's. Simply add this item to the component lists. Save and close. Now we can start using this finished good on a work order that will include this new Labor Item's cost.

When you finish a production, the labor cost will be deducted from Salaries Applied to Finished Goods expense and included in the cost of your finished product. Now if the salaries account is greater than the Salaries Applied to Finished Goods, this means that a) you have processed payroll but have not yet finished the product or b) the Cost amount on the item is too low. If the Salaries account is less than the Salaries Applied to Finished Goods this means that either a) you have finished product but have not yet processed payroll or b) the "Cost" amount on the item is too high.

Well, I hope this has cleared any confusion you might have with creating Employee Costs in BOM's. If you still have some question's, place a comment below, and I will answer your question directly. You can also send us an email Support. It's Friday! Take some time to yourself this weekend and get ready for Monday! Enjoy!

 

TOM

All Order's Add ons

April 8, 2016 at 3:18 PMThomas Riemann

Welcome back to the NumberCruncher blog! I hope everyone is have a great week! Today I would like to talk about an add on to the All Order's software called All Order Mobile. All Order's mobile extends inventory management into your warehouse. This will allow you to increase your efficiency in the warehouse by decreasing mistakes made. All Orders Mobile by NumberCruncher extends inventory management into your warehouse and lets you take full advantage of barcode label printing within All Orders. To me, this add on really makes our inventory system the best inventory software on the market. Just a little bit of background on myself. I use to manage a warehouse. When I was in that field, we didn't have any bar code scanning or a real time inventory management system like All Orders. Which made my job much more difficult. Adding bar coding to your company will save a lot of headaches going forward. Imagine doing your inventory count's on a hand held device, scanning instead of physically counting. I would of gave anything for this system! Now let's talk about All Orders Mobile.

All Orders Mobile by NumberCruncher will make your warehouse operations more efficient! All Orders Mobile is installed on Windows based devices. It can connect wirelessly to your All Orders database and download sales orders to be picked, purchase orders to be received and counts. Once a sales order is picked the picking information will be uploaded in real time back to the All Orders database an automatically create a Ship Doc. Similarly, once a purchase order is received through All Orders Mobile, the information will be uploaded to All Orders and a Reciever will automatically be created. Finally, All Orders Mobile will update your count in All Orders with new quantities.

  • Pick Sales Orders
  • Receive Purchase Orders
  • Perform Inventory Counts
  • Find Location/Bins of Inventory
  • Move Bins
  • Adjust Inventory
  • Transfer inventory.

Check out our Intro video on All Orders Mobile by clicking here. We also have more video tutorial's showing how to perform a Sales Order, Receiving a Purchase Order and performing an inventory count.

Well that is all for today! I hope everyone has a great weekend! Make sure to contact us if you have and Questions. support@numbercruncher.com or call us @ 866-278-6243.

How to return Item's from the Consignment.

February 29, 2016 at 3:36 PMThomas Riemann

Hello, and welcome back to the NumberCruncher Blog! Hope all of you are doing well and you business is thriving! Today I would like to continue to talk about a feature in All Order's called Consignments. I left you guy's hanging last week and only show you how to ship those item's to the customer from the consignment. Today, I am going to tell you how to get some of those item's that didn't sell back in stock from the consignment screen.

So you have sent out those item's now it's time to get some of those back. You will want to create a brand new consignment. Enter the same customer you shipped those item's to. Before I had you enter in the QTY you wanted to ship to the customer in the Ship Doc column. This time you will update the QTY you would like to receive back into All Order's. You can do that by entering the QTY into the Return Column. Once you have entered the necessary qty to be returned, go ahead and go to Activities - Finalize. This will create received doc's for those item's. This process is very similar to what we did last week.

Well, that is all for today. I hope you guy's have a great week! Remember if you have any questions, head over to our website. As always you can always e-mail customer support at support@numbercruncher.com or call us (866) 278-6243.

 

 

What is a Consignment? How do I ship out item's?

February 19, 2016 at 3:50 PMThomas Riemann

Hello, and welcome back to the NumberCruncher Blog! Hope all of you are doing well and you business is thriving! Today I would like to talk about a feature in All Order's called Consignments. You might be asking yourself "What is a Consignment?" Consignment is the act of consigning, the act of giving over to another person or agent's charge, custody or care any material or goods but retaining legal ownership until the material or goods are sold. 

We have a perfect feature in our system for this. To start a new consignment, go to Sales - New Consignment. But lets not get ahead of ourselves. Before we get that started, you will want to make sure you set up the default location for the specific customer. You can do that by going to the customer screen, clicking the Shipping Info tab, and selecting that default location. You will want to make sure you set that location to the location where your quantity is. The reason why you have to set that up before is because only those customers with the default location set will appear in the drop down. Ok, back to the consignment. Once you add a customer and a location, all the items in that location will populate. You can use the filter tab to filter for a specific item on the list. This is where you will be able to pick and choose what item to send and how much QTY to send. You will enter this info under the ship doc column. Once you have selected that information, we can go ahead and go to Activities - Finalize. Now a Ship Doc will be created for that customer for those items. Next week, I will talk about how to get those item's that didn't sell back from that customer. Stay tuned!

Well, that is all for today. I hope you guy's have a great weekend! Remember if you have any questions, head over to our website. As always you can always e-mail customer support at support@numbercruncher.com or call us (866) 278-6243.

How to Perform a Bin Move

December 31, 2015 at 9:04 AMThomas Riemann

 

Hello! I hope you and your family had a great holiday! I know I enjoyed my first Florida Christmas! It was great to go to the beach on Christmas day! Anyway, back to things at hand. Last week we talked the basics about bins. Today, I would like to address how to perform a new "Bin Move". A bin move is a great feature and I find a lot of our clients use this frequently. 

If you need to transfer qty from bin to bin, you can use our newest feature called a Bin move. You can start a new bin move from the Warehouse menu – New Bin Move. This will prompted the bin transfer screen. Enter the location and the date of the transfer. There are 2 ways to move your bin quantities, you can move one item at a time or Move an entire bin. To move one item at a time select select that option. This selection will allow you to move a specific item and quantity. Select the bin from and the bin to and select one item, lot/serial #’s and enter the qty to transfer. One note to make, when you select your from bin, the total quantity in the bin (of all items) is listed.

Once you have selected the item, the total quantity for that item in that bin is listed. You can use that to determine the qty that you will transfer. Click add and your entry will be listed below. Repeat the steps for multiple items. The second way is to Move an Entire bin, you can do this by selecting the Move entire bin option. This will move all items and quantities from on bin to another. Select the bin you will transfer from and the bin you will transfer to. The total inventory in that bin will be selected, Click add and it will list all of the items located in that bin.

You can delete the line items that you do not want to transfer by clicking the red X on the line item.

Lastly, you can click Create Transfers and a new Quantity Adjustment screen will open. Remember no quantity is adjusted, you are just moving one bin to another.

In my years of being a Warehouse Supervisor, we had over 200 bins. The inventory warehouse software that we were using at the time did not have a feature like All Orders does. This feature would have made life a lot easier for me. Remember if you have any questions or concern's the NumberCruncher team is here for you. Please give our customer support line a call - (866) 278-6243. You can send us an email also - support@numbercruncher.com. Have a great New Year!! Here's to 2016! Best of luck!




Tom

Performing a Location Transfer

December 18, 2015 at 9:10 AMThomas Riemann

Hello everyone! Welcome back to the blog! Well it's been another great week here in the NumberCruncher office! We hope your company had a great week as well. As you know it's Friday, time for another blog update!  Today I will be talking about how to Perform a Location Transfer.

This feature is used when a business operates from multiple locations. From time to time your company may need to transfer Inventory to and from locations. This is sort of like a Shipping doc only you are the sender and the recipient.

To Create a Location Transfer, select the Warehouse Menu and then select New Location Transfer. Another way of doing this is from your company home screen, Select Location Transfer.

First step is to choose the Location you are shipping from. After that is selected you can now select the location you are shipping to. You can use the “Activate From” and “Activate To” to specify a location for entering Item specific info, such as bins or lot/serial #.

You can now select the items you will be transferring; you must enter in an accurate quantity amount. Only those items in stock will appear in the drop down list. Next, select your shipping method, a ship doc (if applicable), Number of packages, and the total weight.

Just one more step before we can save this location transfer, you must put in the transaction date (if other than today). After those steps are complete, you can now finish by clicking he save button. You can print the transfer log or even email it.

That is how you will typically perform a Location Transfer within the All Orders program. As always, I invite you to check out some of our video tutorials. If you are new to the program, they will give you the jump start needed to begin using All Orders. Make sure you check them out! If you are having some issues or just have question's about anything related to Location Transfers or All Orders in general, please give our customer support line a call - (866) 278-6243. You can send us an email also - support@numbercruncher.com. I hope everyone has a great weekend! Enjoy!


TOM

Creating a New Quantity Adjustment

December 2, 2015 at 11:51 AMThomas Riemann

Hey Guys! Welcome back to the NumberCruncher Blog!!! It's Tom from the NumberCruncher team again! Last Friday we talked about how to "Perform Inventory Counts" within the All Orders program. If you are struggling doing inventory, go check that link out and read our last blog post. Maybe that's not what your looking for, maybe your company doesn't need help doing inventory counts. You might just need to Adjust some Inventory due to a trade show where you gave away some Inventory as prizes. Or your company had a fire and due to that fire some inventory was lost in the process. The perfect tool for this in All Orders is called an "Adjustment".

To start a New Quantity Adjustment, you can do 1 of 2 things, Warehouse – New Qty Adjustment or from the company home screen select Adjustments. After you have selected one of those 2 options you now can select a location for the adjustment.

Once that is selected, you now need to choose an account. Keep in mind the account you choose should NOT be an inventory asset account. If desired, you can also choose a Quickbooks class but this is not a requirement.

Next you will want to start adding items into the form. If your company uses bar code scanners, you can place your cursor in the bar code area and scan your barcode. You could also type the item name in the same box and hit tab. If you are not using the barcode tool, you can choose the item by using the drop down menu. Simply click the first blank line in the Item column of the list. Now, you can adjust the quantity of the Item in the QTY field. Use negative values to indicate lost inventory. If needed, you can adjust the date of the adjustment in the upper right had corner of this form. Check “only adjust” in NumberCruncher if you do not want these adjustments to reflect in Quickbooks.

Well, that pretty much sum's up how to create a Quantity Adjustment. If you are still having trouble, don't forget to check out some of our Tutorial videos. Well guys, that's it for today's post. I will be uploading blog's like this every Friday. If you have any topic's you would like for me to blog about, feel free to contact me directly at tom@numbercruncher.com. I will be sure to listen to all of your suggestions. As always our NumberCruncher support team is always here for any other question's you may have. Please contact us at anytime. Thank you guys for reading!!! I will see you next Friday!!

Posted in:

Tags: , , , , , , ,

Performing an Inventory Count

November 27, 2015 at 2:04 PMThomas Riemann

 

Hello, Welcome to the NumberCruncher blog! My name is Tom and I am the newest member of NumberCruncher. I have worked in a warehouse before as the Inventory Control Supervisor, so I know the pains of doing Inventory. For most of you, it’s that time of year to get those inventory counts in. I know this is a very time consuming process and it could be in the middle of the busy holiday season. Please do not get discouraged, the NumberCruncher team is here. Today let’s focus on how to perform an inventory count.

When your company is performing a new inventory count, the tool to use in All Orders is called a Count. To start a new count click Warehouse - New Qty Count. You can also go to the company home screen and Click on the Count icon. Once you are on the Count screen, you can now select the location. After selecting the Location, the quantities for all the items within that location as of the count date will appear.

Some points to keep in mind while doing this count are:

-Counts are location specific, if you have more than one location you will need to create a count for each

-Only one count per location can be opened at a time.

-You cannot change the location or the count date once the count has been saved.

-If you leave a New Qty blank that means the item has not been counted

-There is one row for each item, bin, lot/serial #

-The current qty is qty on hand NOT the quantity available

Once you have added the location and count date, you can now enter the correct counted qty for each item. For each row you can either enter the new qty or the difference. When you have finished the count click Activities – Finalize. That will create an adjustment for all items having quantity differences. If an item, bin, lot/serial # is not on the count, Click Activities – Add item. Once the item is added it will appear on the bottom of the list. If you are you using at bar code scanner, you can scan in the items, bin or lot/serial#. By default All Orders expects the first scan to be the Item, you can change this by toggling the `scan by’ options. Lastly, you can use the filter tab to allow you to shorten the number of items shown on the grid.

I hope this has helped your company breath a little easier performing an Inventory count. Thank you so much for reading! If you have any questions regarding inventory counts or anything regarding the All Orders software, please do not hesitate to contact us. The NumberCruncher support team is always here to help! As always, have a great week!

E-mail: support@numbercruncher.com

Phone: (866) 278-6243

Posted in:

Tags: , , , , , ,

What Don't We Track?

May 27, 2015 at 4:07 PMRachel

It is no surprise that if you know what your inventory is; when it is coming in and where it is going; you will be better able to serve your customers. Last week, we talked about our Sales Orders module and the ability to connect to purchase orders and automatically fill linked sales orders. Now, let’s think about the capability to track the minutiae of production. There are items to order and receive. There are orders to pack and ship. There are parts that break and need to be replaced and what if an entire batch needs to be recalled? Those are a lot of moving parts to track (pun intended).

Lot and Serial number tracking is available for items that have been purchased, received, used in production and shipped to customers.This function also allows for tracking “items within items.” This makes it easy to find the exact component within a finished product. You also have the functionality to assign serial numbers to items on work orders and shipments to customers. Any serial number with All Orders is easily tracked from warehouse to customer. And if you are looking for all the transactions in which a particular serial number is involved, the All Orders “Find” function is particularly valuable. With the functions of All Orders, you can track the transactional and locational history of anything with an attached serial number.

Wait. You’re saying that you have inventory in multiple warehouses or you want to know how the inventory is moving to a contractor or just track it from your warehouse to a vendor? Don’t you worry, locations are specified on each packing slip and work order that is generated. Paired with the tracking feature for serial and lot numbers, you will always know exactly which warehouse is holding your supplies and shipments. If you want to get even more specific, you can use All Orders’ bin feature. This allows you to label specific storage locations such as shelves, rooms, area, or virtual location for easy retrieval and organization. Much like our serial and lot number tracking of items within items, we have this same feature for storing inventory at a location within a location. Do you outsource any production? All Orders can track that too.

Remember when we talked about generating lot and serial numbers? Well, if you prefer your serial numbers to be in barcode form, All Orders can do that for you. Now, when a shipment comes in or goes out, a simple scan will update your system and keep you on top of the locations and destinations of all products. This is handy for shipping and receiving, since our system allows items to be scanned into the system and updated on the receiving list. It’s a quick way to reduce human error. But if you prefer to enter numbers by hand, and run the risk of a costly input error, that is also an option, just use the listed numbers from the receiving form. But IDK, do you.

All Orders  by NumberCruncher provides solutions for your inventory and order management needs. For more information or to request a free trial, visit our website.