New Release - All Orders Data Import/Export Optimization

June 6, 2017 at 4:00 PMChad Moulder


RELEASE NOTES
 

All Orders 6.2.16

DOWNLOAD 64bit 32bit

 

What's New

Starting with release 6.2.16, All Orders has added features that will enable users to easily export/import and edit bulk information within the software.

This is was one of the most requested features from our users and was voted on at the "Creative Feature Session" at this year's CRUNCHTREAT.

In addition we have enhanced our tools for update BOMs in bulk, added multi line custom fields and more. Read on for the details!  

 

Export/Import

You will notice on various lists and entity editing screens throughout the system a new Excel Export button. Some of the more popular ares it is available in include the item, customer, vendor and price level lists. This button can be used to export the data you need into the same format as our standard Excel import templates. By doing this we eliminate the need for exporting data from reports and then copying and pasting into our standard import template. Now you can export, make the changes you need and then import all without having to copy and paste a thing!

 

Bulk Updating BOMs

We've added a new and enhanced screen that will allow users to bulk edit bill of materials (BOMs). Simply go to the Production menu and click on the Bulk Update BOMs button.From here users can easily add new components in bulk, remove components in bulk or replace existing components in bulk. Select the components and the assemblies and click Process to quickly and efficiently get all your BOMs in order!


Multi Line Custom Fields

Ever wanted to add a new custom field to have notes, comments, or store any other type of data that needs to have multiple lines? Now you can! When managing custom fields and adding or modifying a Text type of field a Lines box will appear where a number of lines can be entered for how many lines should be visible for that custom field. Once a number larger than 1 is entered it automatically turns the custom field into a multi line that can store as many lines as needed and the number entered will be how many lines are immediately visible on the custom field entry screen before the user needs to scroll down.


Customer/Vendor Notes

Now users can view notes and comments for customers and/or vendors while saving order documents.


Edit Custom Fields on read only Ship Docs

Now users can create and edit custom fields on shipping documents even after the document has been marked as shipped or invoiced which would have rendered the fields as read only in the past.


Additional Features

  • Importing sales order from QB picks up custom fields as well.
  • Setting for showing customer/vendor notes when saving order documents.
  • Cost fields on the BOM screen made wider.
  • Download button on the attachments screen for downloading web based attachments locally.
  • New setting to leave inactive items off new order being created by duplicating existing orders.
 
 

We're always working to improve All Orders. If there is a feature you would like to see in a future release, please take a look at feature release page (link) to vote on other user-submitted suggestions or to submit your own.

For more information about this release, please email contact@numbercruncher.com. For details about CRUNCHTREAT 2018, including registration, programming and sponsorship opportunities, please contact chad@numbercruncher.com.




Falling into Autumn

October 31, 2016 at 8:58 AMJoshua Goldberg

Hey Crunchers, hope everyone had a successful October and is ready for the Holiday season! So our readers know, our blogs until the end of the year will be more condensed, as we finish development on our newest product, Order Time.

Although we are focused on finishing & releasing Order Time, one thing we are committed too is not letting our support or development on All Orders slip. This is evident by our upcoming release of All Orders version 6.2.7. The newest release adds 15 new features & fixes some common issues (i.e. Duplicate item error when trying to reconcile QuickBooks to All Orders.) Please visit our known issues section of our support page to view the full list of Added & Fixed Features of 6.2.7.

One new feature area I would like to highlight briefly has to do with Packages. With All Orders, you can now create Packages & Boxes and can specify what items go into each Package/Box. In order to use this new feature, you need to manually turn it on by going to Preferences --> Shipping --> Company Preferences --> Package. After turning the preference on, you now have the ability to:

  • Create (either Automatically or Manually generated) & Print UCC's (Uniform Commercial Codes)
  • After inserting Items on your Ship Doc, you can click on the Package Button & Create Packages for Shipment
    • You can create Default Weight Properties for Package Types & Create Tracking Numbers
  • Once the Packages are created, you can create & view a Package Manifest that shows the breakdown of quantities
  • Integrate your shipping with FedEx & UPS

Just a quick reminder that TODAY is the final day to get discounted registration for the Numbercruncher Client Retreat! Use code NC17 to save at checkout until 11:59pm TONIGHT (10/31)! The Client Retreat will be held February 6th through 9th in Dania Beach, Florida and will cover topics on All Orders, All Orders Web, All Orders Mobile, Integration Options, Business Cycles, Inventory Primer, Reports & More! The Retreat is the perfect opportunity to learn everything you ever wanted to know about current & future Numbercruncher products, as well as, the perfect opportunity to escape the harsh winters of up north!

The end of the year is fast approaching, make sure your All Orders software is setup and working properly before the holiday rush hits! Don't hesitate in contacting us, if you have any questions or need to setup training

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!

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.

New feature - Custom Messages

March 18, 2016 at 3:05 PMThomas Riemann

          Good afternoon! Happy Friday everyone! As you guy's already may know, we recently released a new version of the All Orders software, Version 6.2.3. I recommend everyone download this update. We believe that All Order's is the # 1 Inventory System on the web today! We strive to come out with these updates as frequent as possible to improve our Inventory System and add key features that you may have requested. Speaking of requesting features, have you seen our feature request on NumberCruncher.com? Now our software has many many features but let's face it, as smart as we are, we can't think of everything. So if there is anything that is not in the All Order's software currently, submit a feature request! Not every feature will be able to make it in but if it gets enough user votes, you may see it in the next update!

          Ok, let's get to the point of this post. Let's talk about a feature that many of you have requested, Custom E-mail templates. To get to this new feature in the newest update, go to List - Profile Lists - Sales - Custom Messages. This feature will allow you to add a custom message when you are e-mailing the invoice to a customer. When creating a new custom message, you now have the ability to select which report you would like this custom message to be associated with. For instance, let's say you are e-mailing a Sales Order report to a customer, you can create a custom message to appear every time you e-mail that Sales Order report to the customer. Every time we e-mail this to a customer we want it to say Thanks for your business! Have a great day. We would simply put that in as a new note and simply select which report its tied too below. Additionally, we can add selected information to be displayed in the custom message. Similar to our reporting system, we can add fields to this custom message. Lets say we want all the item's on this sales order to appear in the e-mail as well. We would simply add this field like this: [ITEM]. Since we have multiple line item's on the sales order, were going to tell the system to bring all those item's into the e-mail. We would set this up like this:  [LINE][ITEM][/LINE]. What that will do is list all the item's on the report. I have created an example of a complete custom message:

Shipping Notification

[SHIPDATE]

Number Cruncher Inc.

123456 Street Road

Hollywood, FL 12345

Phone (000) 000-0000 Fax (000) 000-0000

Billing:

[BILLADDR1]
[BILLADDR2]
[BILLCITY], [BILLSTATE]  [BILLZIP]
[BILLPHONE], [BILLEMAIL]

 

Shipping:

[SHIPADDR1]
[SHIPADDR2]
[SHIPCITY],[SHIPSTATE] [SHIPZIP]
[SHIPPHONE] [SHIPEMAIL]

Dear [CUSTOMER]

Your order [DOCNO] shipped [SHIPDATE].

Here is your tracking#: [SHIPDOCREF]

Item: [LINE][ITEM][/LINE]

          Stay tuned for next week's blog post! I will be going over why our software is the best inventory software out on the web. I will be going over some of the features All Order's has that many other inventory software might not include. Well, I hope you guy's have a great weekend! Talk to you Soon!

Update: Version 6.2.3

March 4, 2016 at 3:42 PMThomas Riemann

Hello everyone! Welcome back to the NumberCruncher Blog! I hope you got a chance to check out our previous post about the Consignment's Feature within the All Orders software. If your company does consignment's and you would like to learn more about this feature, please check out last week's post below. Today, I would like to go over a new update, Version 6.2.3

Added - Create Custom Messages for emailing forms and include place holders for data to be populated upon emailing.
Added - Preference to have lot/serial #s scan mode auto on for all documents.
Added - Images can now be added to labels in the same way they are added to other reports.
Fixed - Click Save & New after creating a new lead would jump into the screen to create a new customer instead of a lead.
Fixed - Generating documents that required custom fields from repair orders causing errors.

In Next week's blog post, I will go over our new feature that came with this update. Custom Messages for emailing forms. 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.

Posted in:

Tags:

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.

Lot/Serial Numbers

January 29, 2016 at 9:20 AMThomas Riemann

Hello, and welcome back to the NumberCruncher Blog! I hope you guy's enjoyed some of those articles about our fantastic program, All Orders. If you haven't checked those out yet and are still on the fence about making the switch to All Orders, make sure you scroll to the previous blog post!

For today's post, I will be addressing Lot/Serial #'s. Tracking Lot and Serial #'s allows you to specifically track the movement of a particular item within your inventory. A lot of companies in the food industry and electronics will use Lot and Serial #'s. Normally, you wouldn't be able to differentiate between an item that was purchased a year ago and an identical item that was purchased 2 days ago. That's why its important to assign your items with a Lot or Serial number, so you can effectively track that item's movement. Another great thing about Lot/Serial #'s is that it will allow you to also track expiration dates.

In order to enable Lot/Serial #'s in All Orders, proceed to the Item Editor and select the "other" tab. You will see a check box "This item has lots or serial numbers. Make sure that is checked to assign a lot number to it. If you already have some Lot or serial numbers for items, but they are not in All Orders, you can use our LotSerialNumber.xls import sheet to get them into the system. You can find all our import sheets by following this patch in your machine: C:\Program Files\NumberCruncher\All Orders\Import. These are some of the very basic's of the Lot/Serial # feature in All Orders. In future blog post's I will be diving deeper into some of the basic features in All Order's.

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

Bins

December 24, 2015 at 8:48 AMThomas Riemann

 

Hey guy's! Welcome to the NumberCruncher Blog, Thursday Edition! Firstly, Happy Holidays from NumberCruncher team! We hope you and your employees have a great holiday weekend and spend some quality time with your families! Now, in my past 2 blogs we focused on Locations. Now we are going to focus on features within the locations, Bins.

Within the all orders program, we have a unique feature called Bins. This allows you to create a location within locations, allowing you to easily pinpoint the location of the item. If you have a huge warehouse with multiple aisles of product, this would be a key feature for you. A bin does not have to be a physical bin. A bin can be any place of storage, from an actual bin to a shelf or a crate.

For each item that is a Part or an Assembly you can specify a default bin.

When you add items to inventory (Receiving Purchase orders, completing a Work Order) the qty will automatically go into the designated bin. If you leave this area blank, it will go into the default bin. You can change which bin an item is either added to or pulled from on any transaction. You can also split qty between multiple bins in the same location. From the line item of a transaction, click details icon then click bins. Click in any column to enter in the desired bin, and then enter the quantity.

On a transaction where the qty is being decreased aka ship doc and you are not sure which bin the product is on you can click “get available” that will bring up a dialog box.

The bin feature is very useful for your warehouse staff, so make sure you take advantage of the easy to use feature within All Orders. Well, I hope you have learned something from this blog post and again I hope your company can run a little bit smoother. As I always mention, make sure you check out all our support tutorials. Remember if you have any questions or concern's the NumberCruncher 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. Hope everyone has a safe and wonderful holiday!