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.




Why does QuickBooks show Accounts Receivable, when it's on a Cash Basis?

March 1, 2017 at 12:59 PMJoshua Goldberg

The best way to begin this blog topic is to discuss what on earth are we talking about?

Accrual Basis is a bookkeeping method in which you regard income or expenses as occurring at the time you ship a product, render a service or receive a purchase. In Accrual accounting, the time when you enter a transaction and the time when you actually pay or receive cash, may be two separate events. An Accrual-Basis report shows income regardless of whether your customers have paid their invoices and expenses, regardless of whether you have paid all your bills

Cash Basis is a bookkeeper method in which you regard income or expenses as occurring at the time you actually receive a payment of pay a bill. A Cash-Basis report shows income income, only if you have received cash and expenses. If you have not received a payment for an invoice, a Cash-Basis report does not include the income

What's the difference? The Cash accounting method is very straightforward: When cash comes in the door, we record it as revenue & as cash goes out the door, we record it as an expense. The Accrual accounting method is a bit more complicated. With the Accrual method, you need to record revenue when you earn it. For example, you ship a customer on net 30 terms, Using the Accrual method, revenue would be recorded when the product ship, whereas in the Cash method, revenue is recorded when the customer pays after the 30 days.

Likewise, when you purchase an inventory item, your Bill, Check or Credit Card charge will debit the item's Inventory Asset account and credit your Accounts Payable, Bank or Credit Card account. It is not debited to an expense account because (a) it is an asset that you can sell for future benefits & (b) you record the expense to match the income. When you ultimately sell the inventory, QuickBooks will record Revenue and Cost of Good Sold.

So if you are using the Cash Method, you would expect there to be no Accounts Receivable, right? That is not always the case, especially if you have Inventory. Recall that when you create an invoice, QuickBooks records both the Revenue and Cost of Good Sold, but since you are on the Cash Method, Revenue is not shown your Profit & Loss report until you receive the check from your customer. But it would seem right to not record the Revenue, yet still record Cost of Goods Sold, so QuickBooks will temporarily "plug" that amount into your Accounts Receivable. It would make a lot more sense to plug that back into Inventory Asset, but QuickBooks is QuickBooks.

Here are some helpful hints:

The best way to track your Inventory Purchases is to run the Inventory Valuation Summary/Detail reports for all dates:

- Accrual-Basis reports will count Sales as of the Inventory Date & Count Expenses as of the date the goods or services were received

- Cash-Basis reports will provide the reader with a history of cash inflow & outflow

- Under Cash method, Income is reported in the year it is received & expenses are generally deducted in the year they are paid

QuickBooks automatically sets itself to the Accrual Method of accounting because the Generally Accepted Account Principles (GAAP) basis requires the Accrual Method. But since the GAAP is what's generally accepted & not what's required, you are able to customize your QuickBooks to record in the Cash Basis instead.

Although you may have your preferences set to Cash-Basis reporting, some reports will automatically default to an Accrual Basis. Since Accrual Basis is the more common of the two types of accounting method, QuickBooks defaulted the Profit & Loss Report to this method. If you would like to be able to run your Profit & Loss Report without having to customize it each time, you can setup and save a customized report

 The process for customizing your Profit & Loss Reports differs in QuickBooks Desktop & QuickBooks Online

 - In QuickBooks Desktop:

- Click on Reports Tab

- Run the Profit & Loss Report

- At the top left of the Report, click on the Customize Button

- In the pop-up window, set the Account Method to Cash Basis

- Click Run Report

 - In QuickBooks Online:

- Click on Reports to open the Report List page and select the Report you'd like to view

- At the top, click the Customization button

- In the new window that opens, go to the General section and then note which Accounting Method is selected

- Click to select a new Account Method

- Make any other necessary customizations and click Run Report

Your Profit & Loss Report shows the Sales of Product Income accounts and the Cost of Goods Sold (COGS) accounts that are associated with your inventory-enabled Product/Service Item. COGS is an account that reflects the cost of materials and goods held in inventory and then sold. When you sell an item from your inventory, COGS increases by the amount you paid for that item when you purchased it. The difference between the income from the sale & the increase in COGS is the Gross Profit of the sale of that item

Posted in: AllOrder | Features | General | Maintence | News | Sales Order | training

Tags:

Advancing with the Times

June 3, 2016 at 8:55 AMJoshua Goldberg

Happy Friday to our weekly readers! I hope everyone's week is wrapping up nicely after the extended Memorial Day weekend! I know i'm ready for the weekend after this short but busy work week. With the second half of the year fast approaching, companies are searching for ways to help manage their inventory and keep their stock full for the rest of the year. What better way to find the solutions you need, then with a FREE trial? NumberCruncher provides FREE FULL trials of our software for all new users. All Orders provides you with a 30 day trial, while ReorderPoint.com gives you 14 days to see the benefits of our software. Just like always, if you need any help or have any questions about All Orders or ReorderPoint.com, 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! Since a lot of our followers do renew their service with us around the midpoint of the year, I just wanted to remind everyone again that every year when you renew your All Orders plan, your included training hours reset, this allows us to ensure that our clients always stay up-to-date on the latest and greatest features NumberCruncher is bringing you. If you have recently renewed, please give us a call to set up your training refresher TODAY!

Since day 1, NumberCruncher's main goal was to provide an industry changing product with exceptional customer service. We have been fortunate enough to have success on both ends. NumberCruncher was the first company to invest in the Quickbooks SDK from Intuit and is an award  winning gold developer for Quickbooks. NumberCruncher.com is a Better Business Bureau accredited business and has received an A+ rating from them, continually since 2010. But with all our accolades and success, there is always room for improvement and advancement. Over the next quarter, NumberCruncher will be implementing some new features and procedures that is going to make it even easier for us to answer any questions you may have and assist you with any issues that may arise while using any of our products. We also will be incorporating some new technology to help us get into contact with our clients easier and more efficiently.

At the bottom of this post there's a signup for our Blog Blast. Our Blog Blast will be sent out every Friday with the latest NumberCruncher Blog post, some announcements from the NumberCruncher team, the latest technology/accounting news, Client Spotlights and the occasional contest or giveaway.  

If there are any features you would like to see or topics you would like to read about in our Blog or Blog Blast, feel free to leave a comment or send me an email at jgoldberg@numbercruncher.com.

Also please send me an email if you are interested in having your company featured in our "Client Spotlight" feature. 

Finally, I would just like to bring the latest technology hack to the attention of our readers. This week it came out that hackers are using Teamviewer software to hijack PCs and drain PayPal accounts. NumberCruncher utilizes the Teamviewer software as part of our customer service experience, and this threat seems serious enough that our readers should read the article and educate themselves about the hack and ways to protect yourself from becoming a victim.

Hope everyone has a great weekend!  

NumberCruncher Blog Blast Signup

* indicates required

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 Orders!

January 22, 2016 at 10:44 AMThomas Riemann

Welcome back! Hope everyone had a great week! I know some of you guy's that live up north are getting hammered with some pretty intense snow. I feel your pain, I was born and raised is South New Jersey so I know how a snow storm's can destroy a mood. I guess since you guy's will be snowed in all weekend, you might want some good reading material. Well, recently in the past 2 weeks, All Orders has been featured on http://www.intuitiveaccountant.com. They have written a great article about the All Orders program that I would love for you guy's to check out.

That isn't all, All Orders is now on appcenter.intuit.com. Click the link to see an over view of the All Orders program and how it works with Quickbooks. Take a look at our pricing, as you can see we offer training hours based off how many user's. We also include unlimited technical support and software upgrades. To find out more about our program please visit us, NumberCruncher.

Well that is all for today's blog. Make sure you check out those links so you can read up on all our key features! Next week, I will be back talking about some of our smaller features within the All Orders software. Get ready to learn about Lot/Serial #'s on Next weeks Blog! Everyone, if you are getting hit with snowy weather, please be safe out there!. Till Next week! Farewell!

 

The All Orders Approach to Sales Orders

May 20, 2015 at 11:33 AMRachel

It is widely understood that having a proper and concise system for creating and filling sales orders is crucial for proper allocation of resources to complete a sale. Need more reasons on why you need to get a handle on your sales orders? Check out our post about why you need a sales order here.  Now, the question is how can NumberCruncher change the way you approach your sales orders?

With All Orders, the sales order process is dynamic and seamlessly integrated with QuickBooks. All Orders allows the user to create sales orders with multiple shipping and release dates, thus eliminating the need for multiple sales orders. A single sales order can support multiple ship-to addresses as well as items considered to be inventory and non-inventory. Features like this allow the user to create a single sales order that meets a variety of needs.

Is an item running low or out of stock? The sales order screen includes information about the availability of items in the order. If stocks need to be refilled, purchase orders can be created in seconds. This new purchase order is linked to the sales order and items are held for matched the sales order as they are received by the warehouse.  Once the purchase order is received, the underlying sales order can be satisfied automatically. No need to check back and forth on an purchase order to know when to update the SO. Upon filling a sales order, All Orders creates a ‘shipper’, from here an invoice is created in QuickBooks with the click of button.

If a user is transitioning to All Orders after using QuickBooks for their sales orders, the transition is simple. Existing sales orders can be imported directly into All Orders from QuickBooks. The linked sales, work, and purchase orders as well as the integrated pick lists and ship docs are designed to reduce errors and improve efficiency.

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.

Posted in: Sales Order

Tags: , , , , ,