Square Register POS


POS Products on Amazon


inFlow Review

Overview:

http://www.merchantmaverick.com/reviews/inflow-review/

inFlow is an inventory management software program meant to be used by small and medium-sized businesses to help them track inventory, fill customer orders, reorder stock, generate purchase orders and invoices, and create customized reports. By the standards of the inventory management world this software has been around for a while, and unlike the newer online inventory software, inFlow is something of a self-contained system, a throwback to a time before the ubiquitous “cloud” and all it entails. That is to say, it’s not online software but software you download and install.

Introduced in 2007, inFlow has built up an established customer base and is by all appearances extremely popular with its users. The company claims inFlow is “the world’s most loved and downloaded inventory software.” That’s a hard thing to verify, of course, but I’m inclined to think it may not be too much of an exaggeration.

Currently, more than 720,000 small businesses in more than 120 countries use inFlow. It’s also used in a wide range of businesses and industries, including wholesalers, retailers, manufacturers, health care, e-commerce, and government. The Facebook and Twitter accounts for inFlow are pretty active (especially for a piece of software) and have a healthy number of fans and followers.

In today’s hyper-connected business environment, using inventory software that’s not online may seem a bit limiting – and in some ways it definitely is – but it’s not hard to see why people like inFlow and stick with it. The software handles all the basic inventory management tasks and then some, and it’s not at all intimidating to use, despite everything it can do.

The origin story of inFlow is a familiar one: Archon Systems, the Toronto-based company that created it, started out in 2005 building custom inventory software for other businesses. It didn’t take long for Archon to realize that its customers would have gladly bought pre-packaged software if they had found anything that fit their needs, but the choices at the time were expensive, complicated, or not powerful enough. Thus the impetus for inFlow: why not build something that works for all kinds of businesses and make it available to the public?

To see if inFlow Inventory might be what you’re looking for, read on.

Pricing:

There are three different editions of inFlow software available:

  • Free Edition – Always free
    • Maximum of 100 products and customers, combined
    • 13 reports
    • Multi-user mode: read-only
    • Live chat, phone, email, and forum support
  • Regular Edition – $399 per license
    • Unlimited products and customers
    • 25 reports
    • Multi-user mode: read-write
    • Separate user logins
    • Ability to customize documents
    • Live chat, phone, email, and forum support
  • Premium Edition – $799 per license
    • Unlimited products and customers
    • 30 reports
    • Multi-user mode: read-write
    • Ability to customize documents
    • Live chat, phone, email, and forum support
    • Separate user logins
    • Ability to restrict access rights
    • Bill of materials and work orders
    • Count sheets

The prices are one-time costs, meaning there are no monthly or annual fees and no other charges for using the software once you download it onto a computer.

There are also optional maintenance plans: $99 per year for the Regular Edition, $199 per year for the Premium Edition. These give you unlimited updates and support after the first year (included in the purchase price).

You can install one license on an unlimited number of computers, but licensing is per concurrent use, so only one computer can run the same inFlow license at any one time.

If you want to upgrade, you can do so anytime without needing to re-install anything. There’s also a 45-day money-back guarantee if you decide inFlow isn’t for you.

Note that the Free Edition allows a combined total of 100 products and customers. That’s a decent deal for very small businesses that are just starting out – it’s free, after all. But even if you have only a very limited selection of products you sell, you will probably very quickly reach the 100 mark simply because the number of customers you have is always (hopefully) growing. In other words, while the Free Edition is “free forever,” it’s meant to be a temporary edition; inFlow is counting on your liking the software enough to upgrade (the idea being, of course, that once your business starts growing you’ll be able to shell out a few hundred bucks for it).

Web-Based or Locally Installed:

The inFlow software must be downloaded and installed on your computer.

Hardware and Software Requirements:

You must have a Windows-based computer (or environment), with at least 512 MB of RAM and 700 MB of free hard drive space. The inFlow software does NOT work on Mac or Linux computers.

Ease of Use:

Right off the bat, I had problems installing the software on my computer. This is because inFlow installs Microsoft SQL Server on your computer along with the software. Because I already had a version of SQL on my system (why, I have no idea), this caused some issues. Fortunately, inFlow has clear and detailed instructions on how to fix these kinds of issues if you have trouble. I had to remove files and clean up my system before trying to install inFlow again. I went through this procedure two or three times, with the install ultimately failing each time. Finally I ended up having to install SQL separately through the Microsoft website. All told, it took me more than an hour just to get the software installed properly.

However, once I got past this, getting used to inFlow was a breeze. The layout and design of the software are very simple and straightforward, almost what you might call “retro.” It took me back to the kind of Windows-based software I used in office jobs 5 or 10 years ago, and I’m not saying that in a negative way at all. On the contrary, it was somehow refreshing to see this type of extremely functional, no-frills interface. Don’t get me wrong – it’s not like inFlow is ugly or displeasing to look at; it’s simply that it doesn’t waste much effort on looking like the coolest piece of software you’ve ever seen. Beautiful aesthetics can sometimes be used to mask a poorly designed underlying structure. You need to get things done, and that’s what inFlow is here for, plain and simple.

There’s really no problem in figuring out how inFlow works. Let me put it this way: If you have any experience with Windows and the type of software people use on it, inFlow is going to feel pretty familiar and intuitive to you. The Menu button in the upper left corner is kind of like the Start button in Windows, giving you quick access to everything you need: Sales, Purchasing, Inventory, and Reports, as well as General and Settings functions. The Homepage lets you jump to the most common tasks in each of these areas and also provides shortcuts to things like Dashboard, Reports, and Settings. When you’re working in the system, just hover over a field’s label to see a popup balloon with an explanation of what the field is for. I watched the introductory tutorial video, but I could really almost have skipped it and still had no trouble getting started within a few minutes.

  • Dashboard: While it may not be as slick-looking as some other inventory software, the inFlow dashboard does the job, showing you a timeline graph that you can easily modify via a dropdown menu to show a variety of data. Sales completed, cost of goods sold, and sales profit are the defaults, but you can remove those and/or add in things like sales orders, purchase orders, cash in and cash out, net cash flow, customer and vendor payments due, and cost value of inventory. You can also choose whether to display the data as a line graph, bar graph, or pie chart. The dashboard also shows a “Top 5” table, with a dropdown to change the criteria of what to show there (customers with highest profit, highest sales, etc.; products with highest total profit, highest value sold, highest quantity sold, etc.; sales orders; purchase orders; vendors). You can even change the table to show the “Bottom 5” of any of these things. On the dashboard you can also see the number of outstanding sales orders, purchase orders, products to reorder, and more.
  • Multiple Tabs: You can open multiple tabs, as in a Web browser, so that you can multitask. This is very convenient for completing tasks on the fly while you’re in the middle of something else. For example, if you’re adding a new product and then realize you want to put it in a product category that doesn’t already exist, there’s no need to abandon what you’re doing to go add the category first. Just open a new tab and add it right there. As soon as you’re done, go back to your product tab and the new category is available. Simple!
  • Setup Wizard: The “Get Started” page has a Setup Wizard that guides you through the essential tasks you need to complete to get up and running: thinks like your company info, taxing schemes, and pricing and product settings.
  • Instant Response Time: The fact that inFlow is downloaded software and not online means that there’s essentially no waiting for actions to complete or data to load based on your Internet speed or that moment’s connection to the cloud. You get extremely fast response times to whatever action you’re doing – everything happens right away. Maybe I’ve just become too used to online software these days, but this kind of instant response is really nice to see.
  • Back and Forward Buttons make it easy to navigate within any tab.
  • Simple vs. Advanced: For tasks such as purchase orders and sales orders you have the option to fill out a Simple version of the item, with just the basic information, or an Advanced version, so that you can add info about receiving, payments, returns, packing and shipping, invoices, and even returns.
  • Sticky Notes: While you can attach additional documents to a record, you can also fill out a simple “sticky” note for miscellaneous info that doesn’t fit anywhere else – such as a reminder for yourself or a coworker.

Customer Service and Technical Support:

All editions include access to the following support options:

The online forum is where you can pose and get answers to questions from fellow users and, sometimes, inFlow support staff. The forum looks to be pretty active, with knowledgeable users answering all sorts of questions from others.

The knowledge base is pretty extensive, and you can access and search it from the software interface. Searching for something here will give you a list of both forum posts and support articles related to your topic.

There is also a detailed user manual in PDF form, as well as quite a few tutorial videos on inFlow’s YouTube channel.

Negative Reviews and Complaints:

You’d be hard pressed to find many significant criticisms of inFlow from users. There are, however, certainly some drawbacks and limitations to it:

  • No Integrations: inFlow does not directly integrate with any other software, and no API is available to make your own connections. While you can download and import sales or other data from e-commerce platforms such as Shopify and accounting software like Xero, that still means inFlow’s data does not sync in real time with the data from such programs, as online inventory software such as TradeGecko and Lettuce does. The folks at inFlow are working on including integrations in the future, although exactly how they’ll handle the synchronization between online software and a self-contained program like inFlow remains a question.
  • Windows Only: Right now the software only works on Windows computers. You can’t use it on Macs except by using a program like Bootcamp or Parallels to access a Windows environment. On Linux systems, you have to dual-boot Windows and Linux or use VMWare. On tablets and smartphones, you could use Remote Desktop to access a PC with inFlow on it, but that’s clunky and definitely less than ideal, to say the least.
  • Steep Up-front Price: While you can start out with a free version of inFlow, eventually you’re going to need to pay for it, even if your business starts growing just a little bit. The fact that you can’t just pay a modest monthly fee to stretch out your costs but instead have to plunk down several hundred dollars right away for a full-featured version of the software that will be more useful to you over the long term is something that may make some small business owners think twice. And since the fee is per license, if you need to run the software on more than one computer at a time your costs get even bigger. Granted, over time the fee evens out and actually saves you money over many of the online software offerings with their ongoing monthly fees. But if money is tight as you start out, the cost of inFlow may be prohibitive, or at least more than you feel comfortable paying.

This reviewer on Small Business Trends echoes the complaint about integrations:

“Some sort of automatic integration with the dominant financial account software would be great. For now, integration with QuickBooks (or any other software) is manually through exporting inFlow data and inputting into QuickBooks via CSV.”

Given that businesses of all types do an ever-increasing amount of work online, inFlow’s lack of connectedness to the cloud is something that may give you pause. Banking, accounting, shopping – it’s hard to avoid conducting a good deal of your daily business online, and that goes not just for individuals but for companies. While there are still plenty of stand-alone, installed software programs out there that work perfectly well, there’s little doubt that online software, or SaaS (Software as a Service), is the wave of the future, and let’s face it: the future is now.

Positive Reviews and Testimonials:

On the other hand, there is no lack of high praise for inFlow, like in these user reviews on Download.com:

I love the easy to use interface, I did not use any of the tutorials. Btw, awesome quickbook-esque report generation. You can generate reports of the inventory you have with your cost and what it is to be sold at, great for projecting profits and viewing actual profits. I use this inventory system to track sales, to know what types of items sell well and for accounting purposes. I have a low stock (6 or less of each different item), high turnaround (like selling out of items over the weekend) retail business. And yes, I do a lot of data entry, but being able to make copies of inventory items and changing a few things here and there is a time saver!

Tracks everything and is very user friendly. Takes little time to create reports and customize to your liking. Everything is self explanatory and easy for new employees to adapt to. Tracks everything we need, and entering new data is a breeze. Allows you to change field names on just about everything to help match your current personal inventory vocabulary/vernacular, which helps limit mistakes. Allows for transparency with product movement through multiple user mode. Also, you can create new fields so you can add new fields to track if the program doesn’t offer it already. Finally, if you have a problem tech support responds quickly to resolve any issues.

Downloaded this product today and purchased the full edition straight away. If [you’re] looking for a simple straightforward product that does what it says, this is it, look no further. We as a company have tried many different inventory products from ABC inventory to using quickbooks both programmes do not come close to this one. It is an absolute credit to its developers and creators. [Can’t] wait to use more of the facilities [inFlow] has to offer.

For more testimonials from inFlow customers in a variety of fields, check here.

Features:

  • Manage Products and Inventory
    • Organize your products with prices, categories, and images
    • Handle more than 10,000 products on a normal PC with no problem
    • Works with barcode scanners
    • Multiple units of measurement (case, dozen, each, etc.)
    • Multiple locations, including sublocations (bin, aisle, etc.)
    • Inventory movement history
    • Assemble products or packages from raw materials
    • FIFO/LIFO costing
    • Serial numbers (Premium Edition only)
  • Take Orders from Customers
    • Simple workflow lets you enter orders and deduct inventory automatically
    • Advanced workflow tracks more detailed info such as shipping, invoices, picking, and sales returns
    • Create customized, professional-looking invoices to print or email
  • Create Purchase Orders
    • Reorder Stock button automatically creates PO’s for products getting low in stock
    • Keep track of product costs automatically, including moving average
    • Use your own and your vendor’s product codes to ensure accuracy
  • Reports and Analytics
    • See how your business is doing at a glance with graphed timelines
    • Create customized reports on data such as sales, taxes, best-sellers, and inventory prediction
  • Network Computers Together, Set Access Restrictions
    • Multi-user mode lets all of your employees work with the same data in real time by connecting computers via LAN (Local Area Network) or the Internet
    • Decide who has access to see or edit which data elements with different logins and permissions
  • Customizable Fields, Data, Currencies, and More
    • Rename field labels and messages to whatever fits your needs
    • Add extra, custom fields
    • Import and export data between programs like Excel and QuickBooks or even your website via CSV documents
    • Set exchange rates, buy and sell in multiple currencies
    • Software available in multiple languages, including Spanish, French, and Chinese

For a full list of features, click here.

Reports:

What reports you get with inFlow depends on what edition you use.

The Free Edition gives you these reports:

  • Sales
    • Sales by product summary
    • Sales order summary
    • Sales order profit report
    • Customer payment summary
    • Customer payment details
    • Customer order history
    • Product customer report
    • Customer list
  • Inventory
    • Inventory summary
    • Inventory details report
    • Product price list
  • Purchasing
    • Product cost report
    • Vendor list

More detailed reports are only available with the Regular and Premium editions. These include:

  • Sales by product details
  • Sales order operational report
  • Sales tax report
  • Back order report
  • Vendor product list
  • Purchasing tax report
  • Purchase order details
  • Inventory by location
  • Inventory movement summary
  • Estimated inventory duration
  • Stock reordering report

Reports are clear and professional-looking and can be printed or exported as PDFs.

Integrations and Add-Ons:

As I mentioned earlier, inFlow currently offers no direct integrations with any other software, and there is no API (Application Programming Interface) available. But integrations are in the works, so it will be interesting to see what other software you’ll be able to use with inFlow in the future.

However, inFlow has a variety of extra resources that you can import into the program to make it more useful, including:

  • Custom document templates
  • Accessories like barcode scanners, barcode printers, and barcode printing software to generate barcodes, since inFlow doesn’t generate them itself
  • Language files for Hebrew and Portuguese. You can also import other languages if you like.

Check out inFlow’s Resources page for a more detailed look.

Security:

Because inFlow is stand-alone software you download and install on your individual computer(s), it doesn’t entail the same worries about security as you might have with online inventory software. Since it’s not stored in the cloud, your inFlow data is pretty much as safe as your internal computer network is.

Final Verdict:

Overall, inFlow Inventory software is pretty darn good at what it does: that is, help you manage and track your products, customers, and purchasing, while also giving you useful reporting and analytics to help you monitor how your business is doing. The interface couldn’t be much clearer or simpler to use. You’ll find that it’s very intuitive and straightforward, so you’ll rarely have to think about what a certain feature does. In those rare instances where you’re momentarily stumped, the online forum and knowledge base will likely be all you need to find the answer to your question or solve an issue.

The software’s main limitation is that it’s not online and thus cannot automatically sync with the data in any online sales channels or accounting software you may use. You can import and export this type of data, so this does mean that inFlow involves a bit more manual data entry. For this reason, the software is probably best suited to manufacturers, wholesalers, and other businesses that may not have an extensive online presence but still need to save time and get a better handle on managing their inventory, suppliers, and customers.

While the up-front price for a single license may be a bit steep for small companies and having multiple instances of it running at the same time will definitely ratchet up the cost, this is a one-time fee, and as your business grows you could see significant savings over the monthly fees you would pay for online, SaaS software.

That said, I suspect that if inFlow is to stay relevant and competitive into the future, it will need to include some integrations with other software, online or otherwise, and the folks at Archon Systems seem to be aware of this. As it stands now, inFlow is one of the most downloaded inventory software programs for a reason. It’s hard to argue with hundreds of thousands of satisfied users. Give it a spin to see if you might end up being one of them.

Ted Porter

Ted Porter

Ted is a writer and editor with a background in television and online media who is our reviewer of inventory management software. Based in the San Francisco Bay Area, he loves to travel whenever he gets the chance and most recently spent a year living in China. In his spare time he can be found reading, writing, and spouting random lines from old movies and TV shows (rarely a day goes by without an obscure “Seinfeld” quote). Ted is currently working on two long-unfinished novels, which he hopes to wrap up before he hits retirement age.
Ted Porter
Ted Porter
Leave a comment

2 Comments

Ted Porter

Hi Matt,

Thanks for the response and explaining further about inFlow. Good to know about the support availability for all inFlow customers. I’m sure our readers will appreciate the extra information so they’re better able to evaluate the software for their business needs.

– Ted

Rating Not Rated
Matt @ inFlow Inventory

Hey Ted

Thank you so much for taking the time to review inFlow! It’s much appreciated! Just wanted to clarify and add some points to your review if I may.

We built inFlow specifically for those that have item based businesses. You can use inFlow everyday to run your business from purchasing to sales.

When you need to do accounting, inFlow can generate all the reports you need to make your accountant happy. Or, of course, you can enter your information into your Quickbooks too.

As you mentioned, we don’t have direct integration or an API just yet but it would be nice to give our customers that option.

Although we say there’s only forum support for free users, everyone is welcomed to get in touch with us via support@inflowinventory.com. We also have live chat and phone support available here: http://www.inflowinventory.com/software-contact-info.aspx

We definitely don’t turn anyone down for support :)

Licensing works per concurrent user. So, to have two people using inFlow at the same time, you would need two licenses. You can also install one license on two different computers (say a laptop and desktop) – you just would only be able to access one at a time.

You can also have inFlow installed on every single computer in your office and give everyone unlimited READ only access. No one will ask “is it in stock?” again since everyone can check!

If you’re curious to find out if inFlow is a good fit for your business, feel free to get in touch with me direct via matt@inflowinventory.com or call 1·866·923·4974 x 711.

Thanks again for taking the time to do the review!

-Matt

POSmen King IP Submask

    – King Server: 169.254.183.215 (255.255.0.0)
    – My Server: 169.254.25.154

    – Membership Webcam Computer: 169.254.153.91 (255.255.0.0)

    – Foot Massage Computer: 169.254.92.70 (255.255.0.0)

    Gateway: 0.0.0.0

    Dell T110 II, E3-1220 v2@310GH, 3.90 GHZ
    Windows 2003 SP2

IP Subnet Mask

Netmask Netmask (binary) CIDR Notes
_____________________________________________________________________________
255.255.255.255 11111111.11111111.11111111.11111111 /32 Host (single addr)
255.255.255.254 11111111.11111111.11111111.11111110 /31 Unuseable
255.255.255.252 11111111.11111111.11111111.11111100 /30 2 useable
255.255.255.248 11111111.11111111.11111111.11111000 /29 6 useable
255.255.255.240 11111111.11111111.11111111.11110000 /28 14 useable
255.255.255.224 11111111.11111111.11111111.11100000 /27 30 useable
255.255.255.192 11111111.11111111.11111111.11000000 /26 62 useable
255.255.255.128 11111111.11111111.11111111.10000000 /25 126 useable
255.255.255.0 11111111.11111111.11111111.00000000 /24 “Class C” 254 useable

255.255.254.0 11111111.11111111.11111110.00000000 /23 2 Class C’s
255.255.252.0 11111111.11111111.11111100.00000000 /22 4 Class C’s
255.255.248.0 11111111.11111111.11111000.00000000 /21 8 Class C’s
255.255.240.0 11111111.11111111.11110000.00000000 /20 16 Class C’s
255.255.224.0 11111111.11111111.11100000.00000000 /19 32 Class C’s
255.255.192.0 11111111.11111111.11000000.00000000 /18 64 Class C’s
255.255.128.0 11111111.11111111.10000000.00000000 /17 128 Class C’s
255.255.0.0 11111111.11111111.00000000.00000000 /16 “Class B”

255.254.0.0 11111111.11111110.00000000.00000000 /15 2 Class B’s
255.252.0.0 11111111.11111100.00000000.00000000 /14 4 Class B’s
255.248.0.0 11111111.11111000.00000000.00000000 /13 8 Class B’s
255.240.0.0 11111111.11110000.00000000.00000000 /12 16 Class B’s
255.224.0.0 11111111.11100000.00000000.00000000 /11 32 Class B’s
255.192.0.0 11111111.11000000.00000000.00000000 /10 64 Class B’s
255.128.0.0 11111111.10000000.00000000.00000000 /9 128 Class B’s
255.0.0.0 11111111.00000000.00000000.00000000 /8 “Class A”

254.0.0.0 11111110.00000000.00000000.00000000 /7
252.0.0.0 11111100.00000000.00000000.00000000 /6
248.0.0.0 11111000.00000000.00000000.00000000 /5
240.0.0.0 11110000.00000000.00000000.00000000 /4
224.0.0.0 11100000.00000000.00000000.00000000 /3
192.0.0.0 11000000.00000000.00000000.00000000 /2
128.0.0.0 10000000.00000000.00000000.00000000 /1
0.0.0.0 00000000.00000000.00000000.00000000 /0 IP space

Net Host Total
Net Addr Addr Addr Number
Class Range NetMask Bits Bits of hosts
———————————————————-
A 0-127 255.0.0.0 8 24 16777216 (i.e. 114.0.0.0)
B 128-191 255.255.0.0 16 16 65536 (i.e. 150.0.0.0)
C 192-254 255.255.255.0 24 8 256 (i.e. 199.0.0.0)
D 224-239 (multicast)
E 240-255 (reserved)
F 208-215 255.255.255.240 28 4 16
G 216/8 ARIN – North America
G 217/8 RIPE NCC – Europe
G 218-219/8 APNIC
H 220-221 255.255.255.248 29 3 8 (reserved)
K 222-223 255.255.255.254 31 1 2 (reserved)
(ref: RFC1375 & http://www.iana.org/assignments/ipv4-address-space )
( http://www.iana.org/numbers.htm )
———————————————————-

The current list of special use prefixes:
0.0.0.0/8
127.0.0.0/8
192.0.2.0/24
10.0.0.0/8
172.16.0.0/12
192.168.0.0/16
169.254.0.0/16
all D/E space
(ref: RFC1918 http://www.rfc-editor.org/rfc/rfc1918.txt )
( or ftp://ftp.isi.edu/in-notes/rfc1918.txt )
(rfc search: http://www.rfc-editor.org/rfcsearch.html )
( http://www.ietf.org/ietf/1id-abstracts.txt )
( http://www.ietf.org/shadow.html )

Martians: (updates at: www.iana.org/assignments/ipv4-address-space )
no ip source-route
access-list 100 deny ip host 0.0.0.0 any
deny ip 0.0.0.0 0.255.255.255 any log ! antispoof
deny ip 0.0.0.0 0.255.255.255 0.0.0.0 255.255.255.255 ! antispoof
deny ip any 255.255.255.128 0.0.0.127 ! antispoof
deny ip host 0.0.0.0 any log ! antispoof
deny ip host [router intf] [router intf] ! antispoof
deny ip xxx.xxx.xxx.0 0.0.0.255 any log ! lan area
deny ip 0/8 0.255.255.255 any log ! IANA – Reserved
deny ip 1/8 0.255.255.255 any log ! IANA – Reserved
deny ip 2/8 0.255.255.255 any log ! IANA – Reserved
deny ip 5/8 0.255.255.255 any log ! IANA – Reserved
deny ip 7/8 0.255.255.255 any log ! IANA – Reserved
deny ip 10.0.0.0 0.255.255.255 any log ! IANA – Private Use
deny ip 23/8 0.255.255.255 any log ! IANA – Reserved
deny ip 27/8 0.255.255.255 any log ! IANA – Reserved
deny ip 31/8 0.255.255.255 any log ! IANA – Reserved
deny ip 36-37/8 0.255.255.255 any log ! IANA – Reserved
deny ip 39/8 0.255.255.255 any log ! IANA – Reserved
deny ip 41-42/8 0.255.255.255 any log ! IANA – Reserved
deny ip 50/8 0.255.255.255 any log ! IANA – Reserved
deny ip 58-60/8 0.255.255.255 any log ! IANA – Reserved
deny ip 69-79/8 0.255.255.255 any log ! IANA – Reserved
deny ip 82-95/8 0.255.255.255 any log ! IANA – Reserved
deny ip 96-126/8 0.255.255.255 any log ! IANA – Reserved
deny ip 127/8 0.255.255.255 any log ! IANA – Reserved
deny ip 169.254.0.0 0.0.255.255 any log ! link-local network
deny ip 172.16.0.0 0.15.255.255 any log ! reserved
deny ip 192.168.0.0 0.0.255.255 any log ! reserved
deny ip 192.0.2.0 0.0.0.255 any log ! test network
deny ip 197/8 0.255.255.255 any log ! IANA – Reserved
deny ip 220/8 0.255.255.255 any log ! IANA – Reserved
deny ip 222-223/8 0.255.255.255 any log ! IANA – Reserved
deny ip 224.0.0.0 31.255.255.255 any log ! multicast
deny ip 224.0.0.0 15.255.255.255 any log ! unless MBGP-learned routes
deny ip 224-239/8 0.255.255.255 any log ! IANA – Multicast
deny ip 240-255/8 0.255.255.255 any log ! IANA – Reserved

filtered source addresses
0/8 ! broadcast
10/8 ! RFC 1918 private
127/8 ! loopback
169.254.0/16 ! link local
172.16.0.0/12 ! RFC 1918 private
192.0.2.0/24 ! TEST-NET
192.168.0/16 ! RFC 1918 private
224.0.0.0/4 ! class D multicast
240.0.0.0/5 ! class E reserved
248.0.0.0/5 ! reserved
255.255.255.255/32 ! broadcast

ARIN administrated blocks: (http://www.arin.net/regserv/IPStats.html)
24.0.0.0/8 (portions of)
63.0.0.0/8
64.0.0.0/8
65.0.0.0/8
66.0.0.0/8
196.0.0.0/8
198.0.0.0/8
199.0.0.0/8
200.0.0.0/8
204.0.0.0/8
205.0.0.0/8
206.0.0.0/8
207.0.0.0/8
208.0.0.0/8
209.0.0.0/8
216.0.0.0/8
———————————————————-

well known ports: (rfc1700.txt)
www.iana.org/assignments/port-numbers

protocol numbers:
www.iana.org/assignments/protocol-numbers
www.iana.org/numbers.htm

ICMP(Types/Codes)
Testing Destination Reachability & Status
(0/0) Echo-Reply
(8/0) Echo
Unreachable Destinations
(3/0) Network Unreachable
(3/1) Host Unreachable
(3/2) Protocol Unreachable
(3/3) Port Unreachable
(3/4) Fragmentaion Needed and DF set (Pkt too big)
(3/5) Source Route Failed
(3/6) Network Unknown
(3/7) Host Unknown
(3/9) DOD Net Prohibited
(3/10) DOD Host Prohibited
(3/11) Net TOS Unreachable
(3/12) Host TOS Unreachable
(3/13) Administratively Prohibited
(3/14) Host Precedence Unreachable
(3/15) Precedence Unreachable
Flow Control
(4/0) Source-Quench [RFC 1016]
Route Change Requests from Gateways
(5/0) Redirect Datagrams for the Net
(5/1) Redirect Datagrams for the Host
(5/2) Redirect Datagrams for the TOS and Net
(5/3) Redirect Datagrams for the TOS and Host
Router
(6/-) Alternate-Address
(9/0) Router-Advertisement
(10/0) Router-Solicitation
Detecting Circular or Excessively Long Routes
(11/0) Time to Live Count Exceeded
(11/1) Fragment Reassembly Time Exceeded
Reporting Incorrect Datagram Headers
(12/0) Parameter-Problem
(12/1) Option Missing
(12/2) No Room for Option
Clock Synchronization and Transit Time Estimation
(13/0) Timestamp-Request
(14/0) Timestamp-Reply
Obtaining a Network Address (RARP Alternative)
(15/0) Information-Request
(16/0) Information-Reply
Obtaining a Subnet Mask [RFC 950]
(17/0) Address Mask-Request
(18/0) Address Mask-Reply
Other
(30/0) Traceroute
(31/0) Conversion-Error
(32/0) Mobile-Redirect

Ref: [RFC 792] [RFC 896] [RFC 950] [RFC 1016]
www.cisco.com/univercd/cc/td/doc/product/lan/cat6000/sw_5_3/cofigide/qos.htm#19774

Decimal system Prefix’s
Factor Exponent Prefix
—————————————————
1 000 000 000 000 000 000 000 000…10^24….yotta
1 000 000 000 000 000 000 000…10^21….zetta
1 000 000 000 000 000 000…10^18….exa
1 000 000 000 000 000…10^15….peta
1 000 000 000 000…10^12….tera
1 000 000 000…10^9…..giga
1 000 000…10^6…..mega
1 000…10^3…..kilo
100…10^2…..hecto
10…10^1…..deka
0.1…10^-1….deci
0.01…10^-2….centi
0.001…10^-3….milli
0.000 001…10^-6….micro
0.000 000 001…10^-9….nano
0.000 000 000 001…10^-12…pico
0.000 000 000 000 001…10^-15…femto
0.000 000 000 000 000 001…10^-18…atto
0.000 000 000 000 000 000 001…10^-21…zepto
0.000 000 000 000 000 000 000 001…10^-24…yocto
—————————————————

Convert Fahrenheit <> Celsius:
Celsius = (Fahrenheit – 32) / 1.8
Fahrenheit = (Celsius * 1.8) + 32

last updated: 4jul02

GetMyTable

Public Sub GetMyTable(MyTableID)
‘Public Function ReadServerName(FileFullPath As String) As String

‘ Get pMyTableID from pMyAltTable – pMyTable
‘ Get Final TableID
‘ A1 will be finally I1 – pMyAltTable
‘ pMyTable >> pMyAltTable >> pMyTable

Dim cnn As ADODB.Connection
Dim cmd As ADODB.Command
Dim Parameter1, Parameter2 As ADODB.Parameter

Set cnn = New ADODB.Connection
Set cmd = New ADODB.Command

cnn.ConnectionString = “driver={SQL Server};” & “server=” & pMyServer & “;” & “uid=;pwd=;database=” & pMyDB & “”
cnn.Open

Set Parameter1 = cmd.CreateParameter(“@MyTable”, adVarChar, adParamInput, 10, pMyTable)
Set Parameter2 = cmd.CreateParameter(“@MyAltTable”, adVarChar, adParamOutput, 10)

Parameter1.Value = pMyTable

cmd.Parameters.Append Parameter1
cmd.Parameters.Append Parameter2

cmd.ActiveConnection = cnn
cmd.CommandType = adCmdStoredProc

cmd.CommandText = “sp_GetMyTable”
cmd.Execute

pMyAltTable = Parameter2.Value
pMyTable = pMyAltTable

Set Parameter1 = Nothing
Set Parameter2 = Nothing

Set cmd = Nothing
cnn.Close
End Sub

64-Bit Pole Display Setup

USB Logic Controls Pole Displays – Win 7

These instructions cover the process for installing a Logic Controls USB pole display under Windows 7. However, for other brands of pole display the process is very similar. A COM Port Emulation Driver from the manufacturer must always be installed for USB pole displays to interface with LiquorPOS or MerchantPOS.

Before you begin the install process you will need to download and unzip the driver files for the pole display. Click on the link below to download the files. Unzipping the files directly under the c: drive of your PC is recommended.

Download the 32- bit Logic Controls USB Driver

Download the 64-bit Logic Controls USB Driver

Procedure Outline

  1. Connect the Pole Display & Install the Driver
  2. Create the Batch File
  3. Add the Batch File to the Startup Folder
  4. Configure the Pole in the POS Software

 

Step 1 – Connect the Pole Display & Install the Driver

  1. Connect the pole display to power and then plug the USB cable for the display into the computer. Logic Controls displays will almost always have TWOcables, one for power and one for the PC.
  2. Access Devices & Printers in Windows. Go toStart>Devices and Printers.

USB Pole - Win 7 Start Menu

  1. In the “Devices and Printers” window you should see and Unknown Device. Right-click on this device and left-click onProperties.

USB Pole Win 7 01

  1. Go to the Hardware Taband click onProperties. On theGeneral Tab click onUpdate Driver.

USB Pole Win 7 02

  1. Choose the option to Browse my computer for driver software.

USB Pole Win 7 04

  1. You will now be given the option to browse for the driver files. Click on the Browsebutton and locate the folder where you placed the unzipped Logic Controls USB Driver. When you have locate that folder clickOK.

USB Pole Win 7 05

  1. Windows will likely pop up with a warning at this point. Select the option to Install this driver software anyway.

USB Pole Win 7 06

  1. The pole display will now finish installing and you will see a screen like the one below. Note the COM Port Numberthe pole display has been installed to. You will need this information in the next step. You can also see the COM port in the icon for the device in the “Devices and Printers” window after it has been installed.

USB Pole Win 7 07

 

Step 2 – Create the Batch File

  1. Please note:  This step will not always be necessary under Windows 7, most of the time the pole display will function well once the driver has been installed and the pole display has been configured in LiquorPOS or MerchantPOS.  However, if necessary, click on the Start icon, go to Run, type ‘cmd’, and hit Enter to bring up a command prompt.

Access Command Prompt - Win 7

  1. At the command prompt you may need to type cd\ to get to a straight c:\> prompt. At the c:\> prompt type edit poleset.bat and hit <enter>.

Poleset Win 7 01

  1. You will now be in the edit batch file window. You will type three lines into the batch file. (The ‘#’ in ‘com#’ refers to the number of the COM/Serial port the pole is attached to or, if you are using a USB pole, the number assigned to the pole in the Virtual Com Port Driver)
    • 1st Line: @echo off <enter>
    • 2nd Line: mode com# 9600,n,8,1 <enter>
    • 3rd Line: mode com# 9600,n,8,1

Poleset Win 7 02

  1. To save the poleset batch file hit <Alt+F> and <S> to save and <Alt+F) and <X> to Exit.

Poleset Win 7 03

  1. You should be back at a command prompt at this point. Type ‘exit’ and hit <enter> to exit DOS.

Poleset Win 7 04

 

Step 3 – Add the batch file to the Startup Folder

  1. Go to Start>All Programs, right-click onStartupand left-click onExplore all users.

Startup Folder Win 7

  1. Scroll down the list of files under ‘Programs’ and double-click on ‘Startup’. Right-click in any blank space to the right, left-click on new and select ‘Shortcut’.

Poleset Shortcut - Win 7 01

  1. In the ‘Create Shortcut’ window type ‘c:\poleset.bat’ in the ‘Type the location of the item:’ field. Click Next. (If you placed the poleset file somewhere other than directly under the c: drive you will need to click on Browse and locate the file to create the shortcut.)

Poleset Shortcut - Win 7 02

  1. Leave the name as ‘poleset’ in the ‘Type a name for this shortcut:’ field and click Finish.

Poleset Shortcut - Win 7 03

  1. You should now see a shortcut to ‘poleset’ in the ‘Startup’ folder. Launch poleset by double clicking on the shortcut icon. You will see a window flash and then disappear. Close the window.

Poleset Shortcut - Win 7 04

 

Step 4 – Configure the Pole in the POS Software

  1. Access Customize

Launch the POS Backoffice software. Go to the Edit menu, click on ‘Customize’, and select ‘Hardware’. You can also click on the ‘Customize’ icon, , and then select ‘Hardware’.

  1. Configure Pole Display Settings

Check the box next to ‘Enable pole display’, select the correct brand of your pole display from the ‘Display type:’ pull down menu, and enter your default message. Most importantly, select the port your pole display is attached to. This needs to match the port you specified in the batch file created in the first part of the installation process. Click and .

Enable Pole Display - 5.2

  1. Step 3 – Finish

The pole display is now installed. You may need to exit out of the POS software and go back in before the pole will begin displaying properly.

Widnows Server Secondary Plex

I would assume that you have a Software RAID using your Windows Server, that’s why you have two booting options, note that this is generally a very bad idea to do on production servers, I would highly recommend you to use a Hardware RAID.

Make sure that your RAID is dead before you remove and edit the boot entries, you can do that by visiting the Disk Management console of your Windows server, here’s a good explanation on what to look for when you go there, if the RAID is up and running, then leave it as is, your delayed boot problem might be caused by something else.

If one of the RAID disks is dead, you will need to use the BCDEdit tool to remove the faulty reference to the Secondary Plex as follow:

  • BCDEdit /enum (to show all the GUIDs of your disks)
  • BCDEdit /delete “GUID”