Sage 50 Barcode

Sage 50 Barcode

Understand using barcodes for Sage 50

Sage 50 Barcode

Sage 50 Barcode

“EzScanIt” has fully integrated barcode scanners for Sage 50. The functions include receiving Purchase orders, Shipping Sales orders, Physical Inventory counts and the ability to print barcode labels for any inventory item found in Sage 50. Learn More

What is a Sage 50 Barcode?

Typically printed on a label to identify a Sage 50 inventory item. A barcode is a method of representing part numbers / SKU data in a visual, machine-readable form. Barcodes represent characters of data by varying the widths and spacings of parallel lines. These barcodes, now commonly referred to as linear or one-dimensional, can be scanned by special optical scanners, called barcode readers.

What are barcode readers?

A barcode reader (or barcode scanner) is an optical scanner that can read printed barcodes, decode the data contained in the barcode. These can be directly attached to a hardware device, a rugged handheld scanning device and today smart phones.

What are UPC codes?

UPC codes are also knows as bar codes, but are issued by a central authority for a fee, and are thus unique in all the world.  If you’re not selling through a retail chain, you don’t need them.

Why is a barcode different from a POS software?

This is where you get into the POS software:  UPC codes must be ‘mapped’ to an internal or external stock number.  The UPC code may be similar, completely different, or nonexistent, for any given SKU.

There’s no mapping system built into Sage 50.  There’s an internal item ID, a 52-character part code, and a description.  The part code is search-able, but only from the beginning of the code.  The description is searchable on any character.  There a 5, 100 character ‘user’ fields in which you can put any data you like, but you can’t access any of that data from any invoice data entry screen.

Some Sage 50 inventory item numbers may be set up with the UPC, like “123456789 Scooby Doo Lunch Box”, or may have descriptions that contain the UPC, like “Scooby Doo Lunch Box 123456789”.   Once that’s all set up, you can program your bar code reader for the appropriate number of [TAB] entries to get it to the right place on screen.

Barcode Scanners

If you use a directly attached scanner you can plug it in to your hardware and scan a few bar codes in the item maintenance window, while adding lines to a sales order or purchase order. Most Barcode “Wedge” scanners do not have to be configured.  They have computer chip in them that decodes just about any barcode they come across.  Some are programmable, so that when you pull the trigger and they pick up a valid bar code, they will send (for example) [enter] [tab] <the ascii text in the barcode> [tab] [tab] to the program being used.

There are many different formats of bar code.  One of the easiest ways to print barcodes, is to use a “3 of 9” font in Windows.  (sometimes called Code 39).  There’s no checksum to calculate and print, all you need to do is put an asterisk (*) character at the beginning and end of the text that you want to encode.  (Obviously, you can’t use the asterisk as part of any barcodes). Requires an asterisk at the beginning and end of the ASCII text.   It’s start / stop codes are easy to add (i.e. in Excel)

Most barcodes have a start / stop code, and / or a Checksum.  The start / stop code is how the bar code reader knows it just saw the whole barcode.  The Checksum is how the reader knows it saw it correctly. Code 39 uses only a start / stop code.   Code 128 uses both.

What is Sage 50 Barcode Code 39?

Code 39 is a variable length, discrete barcode symbology. Code 39 uses characters that are displayed in this example it’s “=Concatenate(“*”,A1,”*”).  The Code 39 specification defines 43 characters, consisting of uppercase letters, numeric digits and a number of special characters. An additional character is used for both start and stop delimiters.

Code 39 is a bit more prone to misreads, since there is no checksum.  (but still less prone to error than manually entering these item ID’s. If you are looking at using Code 39 AND picking up UPC-A codes then the part number will need to be the UPC number unless your scanner can interpret both.

More about Code 39 can be found:   http://en.wikipedia.org/wiki/Code_39. Sage 50 scanner

What is Sage 50 Barcode Code 128?

Code 128 is a high-density linear barcode symbology defined in ISO/IEC 15417:2007. It is used for alphanumeric or numeric-only barcodes. It can encode all 128 characters of ASCII and, by use of an extension symbol, the Latin-1 characters defined in ISO/IEC 8859-1.

Code 128 Requires a ‘Check Digit’ calculation included in the barcode. Also uses encoded start / stop codes that aren’t the same as each other. It is possible to have a scanner use UPC-A codes as long as the inventory item numbers are the UPC-A numbers unless your scanner can interpret both.

More about Code 128 can be found: http://en.wikipedia.org/wiki/Code_128 . scanner sage 50

Where do I get more information on fully integrated Sage 50 Barcode Scanners?

EzScanIt can receiving your Sage 50 Purchase orders, Shipp your Sage 50 Sales orders, complete a  Physical Inventory count for all Sage 50 inventory items and can print barcode labels for any inventory item in your Sage 50 company. Learn More

 For more information about scanning Barcode Scanners for Sage 50 scanning visit www.jcscomputer.com Or give us a call for a free Sage 50 barcode demo 800.475.1047. Put our 30 years of Sage 50 experience to work for you. Sage Timeslips Training

Barcode Sage 50

Barcode Sage 50

EzScanIT Barcode for Sage 50 includes barcode labels. Easily print barcode labels for inventory items and more.

Barcode Sage 50 is the EzScanIt and has Shipping capabilities for Sage 50 Sales Orders, receiving for Sage 50 purchase orders, Along with physical inventory including variances and the ability to print Sage 50 inventory item labels and you can print Sage 50 inventory labels for one, multiple or all of your inventory items.

Search Faster, Better & Smarter using the add on for Sage 50 that includes a Barcode Scanner. Once you add your Sage 50 inventory items, customers and vendors you are ready to rock and roll. If you are a Sage 50 user this is a familiar process. As soon as you add sales orders and purchase orders they will transfer to the Motorola handheld device.

After a purchase is received the waiting on a bill purchase is sent to Sage 50 and after a sales order is shipped an UN-printed sales invoices is sent to Sage 50. These transactions will wait for you in Sage 50 until you are ready to convert them to a parables invoice or print your customer sales invoice.

The EzScanIt barcode label printing module can print most barcode label sizes. You can print multiple labels for a single item, print multiple item labels or you can print barcode labels for all your inventory items. Most of the time these can be customized to work with your existing labels using our specified Zebra printer.

We hope this helps you understand the Barcode EzScanIt Sage 50 label print program. For more information give us a call Accounting Business Solutions 800.475.1047 or visit www.jcscomputer.com. We look forward to speaking with you soon.

View a brief demo using the add on for Sage 50

 

Sage Timeslips Support

Sage 50 Scanner

Sage 50 Scanner

Sage 50 Scanner is easy to start & easy to use. Time-Saving Sage 50 Barcode Scanning Solution For Small Businesses. Spend Less Time Capturing, Managing, & correcting your inventory data so you can get back to work. Give us a call for a Free discovery and demo.

Do you need Sage 50 Barcode labels? EzscanIT for Sage 50 can help you easily print barcode labels for inventory items and more.

EzScanIt includes:

The ability to ship existing Sage 50 sales orders and automatically record them as unprinted customer sales invoices.

You can receive Sage 50 purchase orders and have them recorded as Vendor ‘waiting on a bill’ purchases

During the physical inventory count take some or all of your items to a handheld device to easily automate your count process. Once the variance report is generated and reviewed inventory adjustments are sent to Sage 50. As a result, the Sage 50 quantity on hand will agree with the actual physical count.

Print Sage 50 barcode labels for one, multiple or all of your inventory items

If you are a Sage 50 user this is a familiar window showing the inventory item list. You simply launch a barcode label generator and define which items you want to print barcode labels for.

The EzScanIt barcode label printing module can print most barcode label sizes. You can print multiple labels for a single item, print multiple item labels or you can print barcode labels for all your inventory items.

We hope this helps you understand the EzScanIt Sage 50 barcode label print program. For more information give us a call Accounting Business Solutions 800.475.1047 or visit www.jcscomputer.com. We look forward to speaking with you soon.

 

View the Sage 50 Scanning Solution

 

Sage Timeslips Support

Sage 50 Physical Inventory Count

Sage 50 Physical Inventory count

EZScanIt is the Sage 50 Barcode Add-ons for Sage 50 Quantum by Sage Software

Maximize your performance With EZScanIt Inventory Management Software. This software is designed, fully integrated and made just for Sage 50cloud. This application works with all your Sage 50Cloud information. It reads inventory items, sales orders, purchase orders and comes with the ability to print barcode labels. Using this software you can get work completed quickly and manage your Sage 50 inventory in a snap. Visit Sage 50 Support to view additional information on support and training and Sage 50 barcode scanning.

This is the only barcode scanning software on the market that uses your Sage 50 data. Yes, the same data you have already set up in your Sage 50cloud software package. This Sage 50 Barcode Inventory System is an affordable inventory management software. It will help you reduce costs. You can increase efficiencies, minimize your time and efforts using sage 50cloud physical inventory count

EzScanIt Demo

This video revels how to use EZScanIt Sage 50 Barcode add-on for Sage 50. You can ship, receive, print labels and perform physical Counts. Other names for this software include:

  • 2020 Sage 50 cloud
  • 2019 Sage 50C
  • Sage 50
  • Peachtree Accounting
  • Sage 50 Bar Code Scanner
  • Bar Code Scanning Software
  • Sage 50 Inventory Management

Sage 50 BarCode add ons for Sage 50. Ship, receive, print barcode labels and perform physical inventory counts for Sage 50 software using your data from your Sage 50 company data files. No need to set up a second software application and maintain two sets of data files.

Advantages:

Most businesses write the counts on paper and then calculate the differences. They they manually enter the adjustments. A barcode scanner allows you to more quickly take a physical inventory count, update the inventory adjustments into Sage 50 and print a physical inventory variance report. If you want to easily finish your work you can use these features to help you get it done.

Accounting Business Solutions by JCS provides support, training and consulting for Sage 50 all versions. Put our 30 years of experience to work for you and we can share with you best practices for using Sage 50 Accounting software. For more information visit www.jcscomputer.com or call 800.475.1047

 

Sage Timeslips Training

sage 50 barcode scanner, sage 50 barcode scanning, barcode scanning sotware, sage 50 add ons, sage 50 barcode, sage 50 inventory management

Sage 50 Barcode Add Ons

#sage50barcodescanner, #sage50barcodescanning, #barcodescanningsotware, #sage50addons, #sage50barcode, #sage50inventorymanagement

Sage 50 Accounting – Receiving a Purchase Order flowing through Shipping and Completing a Sales Order – 800.475.1047 – Support – Training – Consultant – Reseller

Sage 50 Accounting Bar Code Software and Bar Code Labels

Sage 50 Accounting – Receiving a Purchase Order flowing through Shipping and Completing a Sales Order – 800.475.1047 – Support – Training – Consultant – Reseller

Wondering how Bar Code Software works?  Can your business benefit from using it?  Do you have serialized items you need to keep track of?  We’ve got the details for you.

The following will explain how Bar Code Software works with a handheld device incorporating purchase orders, receiving in purchase orders, applying purchase orders to a sales order and assigning serial numbers to items that include them.

1

For this demonstration we are using EZ Scan Software with Motorola MC75A handheld

Starting with purchase orders, logged into your company on a handheld device you’ll be prompted to choose a vendor you wish to receive a purchase order in from or the option to choose the purchase you wish to receive in either using the drop down arrow or manually key in the purchase order number with the keypad on the handheld device.  The handheld is programmed to only see open purchase orders.  So if the order has been fully received in, it will not show up as an option on your handheld.  If the purchase order was partially received, the handheld will only give you the options to receive in what is still open.  After choosing the vendor and purchase order number, the system will prompt the date in which you received it or entered it in.  Also on the screen of handheld device is a ‘Receiver #’ space to add the packing ticket or referenced received number in if you choose to reflect on receipt.

12

After choosing the vendor and purchase order you wish to receive in, the handheld will display the purchase order just as it is reflected in Sage 50.  You can view the quantities to receive, what is open on the purchase order, how many of that item was ordered, unit of measure for that item, the item description, serialized item or not, and the line number in which the item is listed on the purchase order. You have the option to ‘receive all’ or an option for ‘items’ which allows you to select a certain line item and adjust the quantity received if it does not match the original quantity of the purchase order. There is also an option for ‘notes’ which would be for example “The box was damaged.”  For serialized items that you receive in, select the ‘items’ option, then enter the quantity you wish to receive, then at the top of the screen you’ll see an option for ‘SER.’ Once selected it will open a new window where you can actually scan the barcode of the item and it will add the serial number associated with that item in the field. If you wish to assign your own serial number, you’ll click the box that says ‘ADD’ and blank consecutive serial numbers.

Sage 50 currently does not yet have the ability to direct right into your Sage 50 software, however, there is a utility that runs on your server that transfers the data back and forth between your Sage 50 data and the handheld device. Sage 50 and your handheld device will sync every 5-7 minutes to transfer data back and forth.

The handheld will also give you the option to view sales. Once selected, a new screen will pop up as ‘ship order.’ Select the customer from the drop down menu or key in the customer.  Choose the Sales Order you wish to view with the drop down option or if you know the Sales Order number you wish to view you can key it in.  If there is a Customer Purchase Order number you wish to include on the shipping information you can enter it (from the Sales Order created). There is an option for ‘Ship Via’ to select a shipping method, enter the ‘Ship Date’ and finally you have the option to enter a freight amount.  There is an option to review the bill/ship to information for customers that have more than one location or multiple addresses. There is an option to add notes either on the Statement, a Customer Note, or an Internal Note you can add those as well. Click save and it will bring you back to the Ship Item window.

12

Now we are ready to ship the item. By selecting items the new window will come up for ‘Ship Item’s Detail’ which gives the option to enter in the quantity you wish to ship and assign serial numbers for those items being shipped. Select SER box and that will bring up all the available serial numbers you have available to choose from or select the serial numbers that were scanned in upon receipt of the purchase order. There is an option for ‘Audit’ which you can select to view any open or pending items that have not yet been received/shipped/included on that transaction. Once complete, click save.

3

Back in Sage 50, you can view the open purchase orders to see what’s been received and completed. Same goes for Sales Orders. When the Sales Order is complete and ready to be invoiced, you’ll see on the Sales Order screen a button to view ‘Serial.’ By selecting that, you’ll be able to view the serial numbers of the items for that customer that were packed and/or shipped.

To view this demonstration via webcast, visit

For more information on Sage 50 give one of our professional consultants a call 800.475.1047 www.jcscomputer.com

With over 25 years of accounting and business knowledge as well as proficient technical background you get the training and support your business needs and deserves working with a proficient expert consultant.   You can work with the same consultant to help you master your Sage Software and for those occasional questions you need help with so you can understand best practices and how to manage your company information and books.

Put our 25 years of experience to work for you!

“Your Success is Our Goal”

www.jcscomputer.com          800.475.1047          solutions@jcscomputer.com

Like us on Facebook  and follow us on Twitter

Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming

Physical Inventory Count on Handheld with Bar Codes – 800.475.1047 – Support – Training – Consultant – Reseller

Physical Inventory Count on Handheld with Bar Codes – 800.475.1047 – Support – Training – Consultant – Reseller

What are the Physical Inventory Steps taken and what do they mean?

Physical Inventory is the process where a business physically counts its entire inventory. A physical inventory count may be mandated by financial accounting rules or the tax regulations to place an accurate value on inventory, or the business may need to count inventory so component parts or raw materials can be restocked. Sage 50 Physical Inventory Count provides automation to quickly count inventory and minimize down time for the business.

Inventory Control System Software can speed the physical inventory count process.

Perpetual Inventory system tracks the receipt and the use of inventory then calculates the quantity on hand.

Cycle Counting is an alternative to physical inventory which can result in actual down time for a business.

The following is how to perform a Physical Inventory Count using a Handheld Device (Motorola MC75A and EZ Scan Software) with Inventory Items having Bar Codes.

1

Starting in your Sage 50 software, from the Inventory & Services Screen select Inventory Items and View and Edit Inventory Items. This will populate a new window with your entire inventory.

Next we want to export our inventory items list to our handheld device. Logging into the EZ Scan Software, select Export Inventory from the menu bar. Select Inventory you wish to export. You can export the entire inventory list or a range of items. Once selected a new window will populate with the items you wish to include then you need to Copy Inventory to PDA.

2

You will receive a confirmation of successful completion once the data has been transferred to your handheld device.

Now that your handheld device has the transferred data it is time to view and take action. Select your Inventory Control Module on your device. A warning will notify you that you are about to begin the inventory count process. Click ok and a new window will populate shown below.

34

In the Item ID field choose the item you wish to count. In this example we’ve only chosen a range of items to be physically counted. You will enter in the Physical Count in the PhyCount field.

5

Once completed entering in your Physical Count, click ok on the handheld device. Now the data needs to be transferred back to your Sage 50 data.

From the menu option select Upload from Handled under the Inventory Count Module. Confirmation of the export will prompt you that it was successful. Review the data that you’ve entered by selecting the Physical Inventory Review (Hand Held) from the Inventory Count Module menu. If everything matches up we can import the data back to Sage 50.

From the Inventory Control Module menu, select Import Inventory Adjustment Hand Held.

6

A warning will populate to confirm your selection

Click Yes

Select Import from the menu option

7

Back in your Sage 50 Software, Select Inventory & Services, Perform Inventory Adjustment. Select List from the menu and a new window opens. Select Open on the menu bar and you will now see the transactions that have transferred over from the handheld to Sage 50. Review your adjustments if you’d like to confirm the transfer.

To view this demonstration via webcast visit

For more information on Sage 50 give one of our professional consultants a call 800.475.1047 www.jcscomputer.com

With over 25 years of accounting and business knowledge as well as proficient technical background you get the training and support your business needs and deserves working with a proficient expert consultant.   You can work with the same consultant to help you master your Sage Software and for those occasional questions you need help with so you can understand best practices and how to manage your company information and books.

Put our 25 years of experience to work for you!

“Your Success is Our Goal”

www.jcscomputer.com          800.475.1047          solutions@jcscomputer.com

Like us on Facebook  and follow us on Twitter

Alabam

Sage 50 Inventory Count Using EZ Scan Software in Excel – 800.475.1047 – Training – Support – Consultant – Reseller

Sage 50 Inventory Count Using EZ Scan Software in Excel – 800.475.1047 – Training – Support – Consultant – Reseller

Physical Inventory is the process where a business physically counts its entire inventory. A physical inventory count may be mandated by financial accounting rules or the tax regulations to place an accurate value on inventory, or the business may need to count inventory so component parts or raw materials can be restocked. Sage 50 Physical Inventory Count provides automation to quickly count inventory and minimize down time for the business.

Inventory Control System Software can speed the physical inventory count process.

Perpetual Inventory system tracks the receipt and the use of inventory then calculates the quantity on hand.

Cycle Counting is an alternative to physical inventory which can result in actual down time for a business.

For this demonstration we are using EZ Scan Software and Motorola MC75A handheld device

1

To start the process, log into your EZ Scan software and from the main menu click Inventory Count Module then select Physical Inventory Count. A warning window pops up to let you know you are about to begin the process. Select Yes. This should populate an Export window. Select Options.

2

Next, in the Export Current Items Stock window, make the selection of the items you wish to perform a count on. Can be all of your items, a range of items, or a series of other options.  Once items are selected, click ok and a new window will populate Export Current Stock for Sage with your selections listed.

3

Upon confirmation of your selection, click Move to SQL and Excel from the menu bar.  This will open a new excel window that prompts you to save the file – we recommend a unique name that includes the date and timestamp.  Once your file is saved it will bring you back to the EZ Scan window and let you know if the process was completed successfully.

Open excel, chose the file you just named and exported.  This is the new inventory sheet for a physical count to be recorded on.

4

Enter the new counts and save.

This should take you back to your EZ Scanner Software. Select Upload Excel from the Inventory Count Module.

5

Select the file you just completed and saved with your current physical inventory count.

This will close the window.

In the Inventory Count Module, Select Physical Inventory Review Excel.

6

Verify your excel spreadsheet from the physical count matches what EZ Scan now shows.  If there are changes to be made you can select delete record or if everything matches select close from the menu.

Next you want to Import the changes by selecting Import Inventory Adjustment Excel from the Inventory Count Module Menu.

7

Review the Warning message and once confirmed click yes to proceed.

A final review will open with the option to Import changes.
Open Sage 50, go to Inventory & Services. There you should see the new counts reflected on quantities on hand for the items you adjusted quantities for.

To view this demonstration via webcast visit

With over 25 years of accounting and business knowledge as well as proficient technical background you get the training and support your business needs and deserves working with a proficient expert consultant.   You can work with the same consultant to help you master your Sage Software and for those occasional questions you need help with so you can understand best practices and how to manage your company information and books.

Put our 25 years of experience to work for you!

“Your Success is Our Goal”

www.jcscomputer.com          800.475.1047          solutions@jcscomputer.com

Like us on Facebook  and follow us on Twitter

Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming

X