Sage 50 Inventory Count Using EZ Scan Software in Excel

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 https://youtu.be/S_LTuxmspn4

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

FacebookTwitterGoogle+Share
Comments are closed.