Back Office Release Notes

• Release date:  Fall 2021
• Software compatibility:  All previous versions can be upgraded
• Corresponding mPower Point of Sale version:  4.0.1.X
• Corresponding mPower Server version:  1.2.1.2214 or higher
• Hardware/Software compatibility: Microsoft .NET 4.8 or higher

Overview

mPower has added many new tools and options to this Back Office release to help customers streamline their operations. The Purchase Request function in New List includes some powerful new features to make purchasing decisions easier and receiving faster. Please see below for details on a few of the many additions that will enhance your store’s day-to-day.

mPower’s cloud customers also have access to a powerful API that publishes data to authorized third parties for web sites, delivery apps, and other data-driven uses. If you have not made the switch to cloud and are interested in taking advantage of this feature, contact our Support team (information below).

Did you know that mPower now has an online Help Center? Create support tickets online, check the status of open tickets, search the knowledgebase for answers to questions, and more. If you missed your invitation or if we don’t have an email for you, let us know so we can get you signed up.

Most of the modules in mPower have been tweaked or updated, so please read on to learn about all the new offerings in Back Office. If you have questions, our Support team is ready to assist at 972-234-5884 x1 or support@mpowerbeverage.com.

Features, Updates, and Patches

Unit Control

Non-Inventory

Upload by VIN

Copy Item

Purchasing and Receiving

Auto-Receive

Updates

Unit Control

• Item: Sizes listed alpha-numerically in drop-down
• Item: Inventory tab on item with no inventory history shows Qty 0
• Item: Alert if item name is too long on new item
• Item: On Inventory tab, can drag the bottom of the window down to see more location data
• Item: Auto Print for documents does not apply to Item Movement History
• Item Search: Quick Add brings up Select Item window if SKUNumber is not found
• Scan Inventory: Scanned item now displays Description and Retail
• Transfer: Alert when Transfer has been shipped or received already
• Transfer: Can change default status

Purchasing and Receiving

• New List: Manual Entry option allows for Qty, Cost updates as items are added
• New List: ‘Approved’ option removed from drop-down
• New List: List Name length extended to 100 characters
• New List: Can filter on Item Name column in Select Item window
• New List – Price Change:
  • Can update Unit List (bottle cost)
  • Can update MinPrice
  • New column Markup %
• New List – Purchase Request: Option to use List Name as Vendor PO
• New List – Purchase Request: User alerted when item with X – Killed status is added
• New List – Purchase Request: Re-enabled ability to sort items in the order added
• New List – Purchase Request: Columns added
  • Sold Next 7 LY
  • Sold Next 14 LY
  • Case Retail
  • Case Markup %
  • Department
  • Category
  • Supplier
  • Item Notes
• New List – Stock Replenishment: Re-enabled
• Purchase Order: Previous Quick Add search string highlighted after item add
• Purchase Order: Can filter on Item on Order Summary tab
• Purchase Order: ‘Show Sales History’ optimized for faster performance
• Purchase Order Maintenance: Sum of ‘Cases Received’ added at top of column
• Return to Vendor: Can Quick Add by SKUNumber
• Return to Vendor: Can Quick Add by VIN

Customer Relations

• Customer: Alert pops if a user tries to create a customer with a duplicate customer number
• Customer: Option to limit history to 100 rows for faster performance

Promotions

• Promotions: ‘Add All’ button removed from Items/Levels tab
• Promotions: Location automatically selected in single-store environments
• Promotions: Can price up on the Promotions tab on an item
• Promotions: Can search by Name/Description in Quick Add

API (available to Cloud customers)

• Can add new customers to a Customer Group
• Can apply points to a sale imported by a 3^rd party for a Rewards customer
• Can insert customer-only records (customer does not have to be attached to an order)
• Changes to API permissions take effect immediately
• Custom Merchandising Levels visible

Other

• Time Clock Edit: Added Total Hours column
• User Security: GM% is hidden if user does not have rights to view cost
• User Security: Ability to restrict price editing to current location
• User Security: Permission to Auto Receive from New List – Purchase Request
• Reports: Error when emailing Customer Statement if another is open

Bug Fixes

Performance Issues

Some users on previous versions experienced an issue where the Back Office program would lock up after a certain number of item records had been opened and closed. This issue has been resolved.

Unit Control

• Build Your Own 6 Pack: Supports multiple pack sizes when adding bottles to BYO SKU
• Inventory Adjustment: Items deleted from adjustment still appear on adjustment documents
• Item: ‘Locations’ column on Promotions tab disappears when adding/deleting a promotion
• Item: ‘Add to Promotion’ on Promotions tab doesn’t always work
• Item: ‘Suggest Unused UPC/SKU’ on Additional UPC window does not work
• Item Select: Search with Status set to ‘Inactive’ includes Active items
• Print Tickets: Printing tickets from Promotion may not populate Promo Price for all items
• Print Tickets: Printing tickets from Confirm Price Change window prints old Case Price
• Print Tickets: Can’t select Promotion from drop-down when item list is uploaded from Excel
• Print Tickets: Print Preview window opens behind Print Tickets when printing from item

Purchasing and Receiving

• New List – Price Change: Margin does not recalculate when item is uploaded from Excel
• New List – Purchase Request: ‘Refresh Data’ link does not work
• Purchase Order: Total cases in ‘PO Total’ zeroes out when Purchase Order is printed

Customer Relations

• Can’t edit or delete Additional Info on Customer

Sales Order

• Sales Order: Print function doesn’t correctly calculate tax
• Sales Order: Can confirm a Sales Order without applying payment
• Sales Order: Shipping Address changes do not save
• Sales Order: Primary Shipping Address on Customer populates Shipping on order by default

• Release date:  11/10/2018
• Software compatibility:  All previous versions can be upgraded
• Corresponding mPower Point of Sale version:  4.0.1.2143
• Corresponding mPower Server version:  1.2.1.XXX
• Hardware/Software compatibility: Microsoft .NET 4.0 or higher

Overview

This Back of Office release adds several new features and corrects a few bugs.

Features, Updates, and Patches

Appearance

• The copy button has been moved to avoid accidental clicks.
  
• Item selection screen will now remember if you have maximized it previously. When opening a new screen, it will now automatically maximize, if that is how you opened it last time.

Functionality

Adjust Weighted Average Cost

• Users can now see the adjustment when changed the WAC. Upon making the change, users will be prompted to confirm the change.
  

Data Upload Tool

• You can now sort the size drop-down by ascending.
• You can now go to the line that errors out due to character length and make appropriate changes.

Customer Maintenance

• You can now search by email address. To do this type an email into the Address field in Customer Maintenance.

Edit Grid Preferences

• There is now a Classic and Extended mode. Users who change items frequently can do so with the ease of Show/Hide Columns.
  • Show/Hide Columns comes back as a separate hing from My GridPrefs, or My GridPrefs streamlines the way it pops up when doing a quick filter.

Inventory Adjustments

• Users can now alphanumerically search for an item. However, it will not bring in an item if there is only one match. Instead, it will give the user the option to select it and add it to the document.
• Users now have the ability to scan additional UPC codes and have it bring in the quantity associated with that UPC.
  
  
• Users can now adjust the BYO 6-Pack adjustment type.

Item Information

• Under the promotion tab on an item, users can now specify a percentage instead of a dollar amount.
• Users can now set a default for Alcohol Content, Tax Code, and Status under item information.
  
  • Choose your selections, and right click to “Set as Default.”
    
• Sales Velocity: Users can now view Quantity Sold of an item as a velocity graph. To access the graph, it is found above “Item Movement History” under the Item screen.
  

Item Quick Search

• This improves speed when searching for items and pulling up the item edit screen.
• The “Quick” checkbox that will only bring in select columns to make the search much faster for specified items. To deactivate just un-check the box and re-open the Item Selection screen.
  
• You can also edit the lookup for the “Quick” search using ItemForEditQuick. > is this for customers or more for us
  
• Quite a few changes were also made to the way the item setup screen opens as well. The most noteworthy change is that the Producer category shows up but the thousands of producers in the dropdown won’t show up unless you click the blue Producer category.
  

Item Select Screen

• You are now able to search for inactive items under the Item Select screen. When searching for an inactive item, simply change the status to inactive on the item screen and search for the item(s).

Price Check and Price Changes

• Users may now use text search to price check an item.
• Use the up and down arrow keys to scroll through the items or use the mouse to directly click on item.
• To increase the price check speed, users can now use their local DB versus HQ.
• On the price change list, mPower will now recognize three decimals in the margin column.
• Price check will now include additional UPC codes.

Print Tickets

• When printing tickets, users can now modify the ticket design when printing promo tickets. Users will be able to pick from a list of promos an item may have on one dropdown menu. On another dropdown menu, users will be able to pick the ticket design. This will allow users to print multiple promotional ticket options on the same piece of paper.
  • An example of varying promotions would be an “Every Day Low Price” and “Monthly Special” tickets.
• Added ABV, BeerType, and BeerStyle to Print Tickets field options.
• Users now have the ability to select the promo pricing that they want to print from the print ticket screen.
• Users can now change the quantity on print tickets to 1. When changing the first item to 1, you will have the option to change them all to 1. This eliminates printing the actual QOH.
• Users now have the ability to load tickets to print in a specified order. To do this, you can sort the columns or load an excel file by looking for SKUNumber & Qty or just SKUNumber. If uploading an excel file, see attached notes.
  • If just a list of SKU numbers is uploaded, “How Many?” will default to QOH (System Qty).
  • If a list of SKUNumber/Qty is uploaded, “How Many?” will populate with the number in the Qty column.

Promotions

• Users can now specify days of the week for promotions (example: Tuesdays).
• Users can now do promotions for a specified Vendor under Item Level.
• All past, present, and future promotions will now show under the promotions tab.

Purchase Requests

• Sales by Month is now visible on the purchase request screen.
• ‘D-Inactive’ status items can now be identified on the Purchase Request screen. This will alert users so users can choose to either edit the item or to add/not add.
• Users now have the ability to purge purchase requests from the database maintenance screen.
  
• Users now have the ability to change the vendor to all by using the cascade changes box. By checking this box, when you change a vendor, it will change the vendor on all items to the same vendor. Checking this box will also change pricing information for a SKU if it is on there multiple times.
  
  
• Quantity on Order (QOO) added to Purchase Request. This column will show you the current number on order for items.
• Quantity on Workorder (QOW) added to Purchase Request. This column will include the number (of items) that are on order/reserve for a customer.
• Quantity Reserved / Case (QOWCase) added to Purchase Request. This column will include the number of cases on reserve.

Remote Support

• You can now download our TeamViewer application directly from the back office software. Simply click on Help -> Remote Support and teamviewer will launch.

Reporting

• The curser will now default to name/description on the SKU lookup in my reports.
• Users can now save files as a zip document. This will allow users to email a report to a customer where they can install it. To do this, users now have “Save as Zip” from the report setup screen. This will export the xml for the report, the xml for the output document and any sql scripts needed for the report.
  
• Additionally, users can also import the zip file by using the load from zip button. It will ask you to select a zip file to import, and then you can give it a name and select which tree it belongs to.
  

Sales Orders

• You now can turn off CSR nag on sales orders.
  

Transfers

• When using the quick add feature, users can now choose if the curser is to go back to the quick add box or to the grid. This feature is interchanging with the “Manual Entry” check box. When the box is checked, the focus goes to the grid after the item is added to update the quantity. When it is unchecked, the focus stays in the quick add box.
  

Web Price

• Users now have the option of seeing the web price under Item Selection -> Vendor/Pricing.
  

Security

Adding a New Customer

• When adding a new customer you can no longer edit points, credit limit, and account balance.

Edit Merchandising Hierarchy

• There are now two options in security for editing Merch Levels, “Levels” and “Hierarchy.” Users can give employees access to Hierarchy so that they do not mess with the over arching levels.

Majority of Menu items are now controlled by security.

• These menu items include document printers and size (no scale) that were previously not controlled before.
  

Masking of Password

• Both old and new passwords are now encrypted.

SKU Number

• SKU Number is no longer accessible except on new items. You may give permission to certain user groups under security settings.
  • To do this, first add it to the menu selection.
    
  • Then, add it to the feature to correct employee.
    

 

Bug Fixes

Account Balance Not Updating

• If users do not update the balance on the customer record, it does not send the balance to be updated.
• If you change the balance on the customer record, and in the meantime a transaction posted or someone else changed the balance, it will ask you if you want to overwrite the recent change with your own.

Clicking Shippers in Setup Files brings up Merch Levels

• When going to Setup Files -> Shipping-> Shippers, it will no longer bring up merchandising levels.

Duplicates

• Tender types are no longer being duplicated upon editing.
• Items that are Price by Location are no longer getting added on the New List twice.

Inventory and Pricing Adjustments

• The error of not being able to enter a – before the number during inventory adjustment has been resolved.
• When taking payment on a sales order, it will now calculate the deposits (if applicable) in the payment amount correctly.
• When uploading a price change from Excel, it will recalculate the price on the Invoice list.
• When changing retail in price change for an item with CasePk > 1 makes Old Margin and Old Case margin incorrect. Prior to the fix, old margin would go into the negative. This is no longer true.
• When items were committed in inventory, they were not showing. This has been resolved, and if items are placed on hold, they will show committed in inventory tab in back office.
• The bug when a deleted item with the UPC matching another item’s SKU is not deleted, mPower would give you an option to choose between items and/or freeze, has been resolved.

Lists & Reporting Errors

• When creating a Need to Order DSOH report, create purchase request by vendor, it previously was only pulling in history if all vendors were on one list. This bug has been fixed to pull history whether it is one or multiple vendors.
• When scanning in inventory while using the QuickAdd feature, it was previously pulling in deleted items. Deleted items are now correctly ignored and will only pull in the item if it is active.
• Clear button on reports is now working correctly.
• The bug, when adding a Gift Card to a Sales Order and erroring out, is now resolved.
• The bug, when uploading price changes and ignoring list and discount fields, is now resolved. Both List and Discount fields are now recognized.
• Now, when you create a new list, the default cancel date is set for 1 day after start date on confirmed purchase order instead of 1 month.
• Filters will now continue to hold when sorting through and deleting items under Item Select screen. Previously, you would filter the wine items by 2014 Vintage (example), alphabetize the departments, highlight an item and delete said item. The list would resort back to all products that were brought in originally.

New List Errors

• When creating a new list and save it and/or tag someone else on it, the history is pulling correctly. The bug, of when adding a new item to the list and the history not showing for the item, has now been resolved.
• When creating a new list, inventory that has history was pulling Quantity on Hand correctly while those without history were not pulling QOH. This has been resolved and all inventory will pull in QOH.
• Additionally, when creating a new list you will no longer receive, “the system has encountered an error” message. This error occurred when hitting the ADD button to add an employee and then ultimately deciding to not add an employee to the list.
• The error when uploading a new list from Excel or CSV has been resolved. This includes the ability of uploading an Excel document with a 0 as a placeholder. However, it will still not view a negative number as being valid.

Printing

• Printing will now print directly to the printer both with 64 bit support on and with 64 bit support off.
• When printing purchase orders, the number of copies are no longer squared. The previous bug would print 4 copies instead of 2. Now resolved, it will only print the selected amount of copies, no longer squaring the amount.
• When printing tickets from the print tickets button, you will now only be asked once if you wish to change all quantities to one.
  • When changing quantity on the first item, if you click:
    • Yes: it will change all quantities to 1.
    • No: it will only change the first items quantity to 1 and you can edit the others as needed.
• When creating a new list to print tickets, if you were to delete a row, you would receive the error, “deleted row information cannot be access through the row.” You will no longer receive this error as this bug has been fixed.

Promotions

• If an item is on a promotion twice, it will no longer require the user to add discountamount1 (dollar amount) when changing just the price.
• When creating a new merchandise level promotion, it will no longer change to an item level promotion upon saving.

Search by Vendor Not Pulling Up Items

• The bug, when selecting a vendor in the Select Item screen, mPower showed the vendor selected, but pulled up an error as if a vendor has not been selected, has been resolved.

Transfers

• The bug, where the location for transfer is grayed out, has been resolved.
• The bug, where transfers were not saving, has been resolved.
• The error message, “document control,” when saving a transfer report has been resolved.

Miscellaneous

• Clicking save twice before it is complete will no longer timeout and error.
• Clicking on the promo in Item Selection screen will no longer time out. Now, when you click on the promo it Item Select screen it will bring up a report view.
• The bug when generating a return authorization from a sales order creates a new SO instead of an RA, has been resolved.

Server

• mPower will no longer attempt to send reports with no data. If there is no data to report, users will receive an email with no attachment and “No Data to Report on” added to the body of the email.
• Cloud Server Hosting Option
  • Users can now opt in to use our cloud server hosting option versus a local server. Learn more by clicking here.

Synch

• Promotions now update as part of the five minutes synch routine.
• Users will no longer be informed about communication issues or time outs. Synch will instead pause and automatically retry the action instead.
• The reindex and truncate will run every night at 2 a.m.
• Customer edits done on the POS will be synched to HQ.
  • Additionally, account balances will be synched correctly.
• Editing customers on POS will now since properly and update on time.
• Messages will synch synchronously from POS to Back Office.
• Reserve Quantities (keg & work orders) will be shared across locations.
• When creating a new customer in POS, you will see a new suffix at the end of the customer number: “-POS.” When creating a customer in back office, you will not see the new suffix. This is because back office generates a different type of number than register so there are no conflicts.

• Release date:  8/22/2016
• Software compatibility:  All previous versions can be upgraded
• Corresponding mPower Point of Sale version:  3.6.0.16X
• Corresponding mPower Server version:  1.2.1.297
• Hardware/Software compatibility: Microsoft .NET 4.0 or higher

Overview

This release of Back Office contains quite a few enhancements to ordering, reporting, and inventory adjustments, as well as various other new features and fixes. Please read through the notes below to make sure you don’t miss out on anything!

The new release also updates the forms that mPower uses for printing tickets and other documents such as receiving, purchase orders, and reports. Because of that, you may find changes in tickets getting printed as well as to the printouts for those documents. If you find that to be the case, please give us a call and we will be happy to assist: 972-234-5884, opt. 1.

Features, Updates, and Patches

 Ordering Enhancements

• Purchase Request Upload Speed: We changed the way items are brought in to the purchase request screen. It pulls in the items, then calculates the fields making the process much faster. You will see the screen below while mPower is calculating the various fields such as Sold30 and DSOH.

• Purchase Request Button Placement: The ‘Reject’ and ‘Approve’ buttons were moved further away from the ‘Save’ button to avoid inadvertent clicks

• Purchase Request Arrow Key for Modifying Qty Column: You can now use the down arrow on a keyboard to go from the Qty column of one item to the next without clicking.
• Purchase Request:  GM% and MU% are now available columns on new lists
• On Purchase Requests, mPower now contrasts every other row to make it easier to track a row

• Min Case Order Qty: You can now choose a MinCaseQty on the Item setup / Inventory tab. If you add an item to an order, the Case Qty will automatically populate with the MinCaseQty

• On Purchase Orders, you can now search for items in the ‘Quick Add’ using alphabetical characters

• On Purchase Orders, the vendor printout was cleaned up by including a carriage return after VendorName and before Contact
• On Purchase Orders, we added Sold 60 and Sold 90 to the Sales History section

Receiving Enhancements

• Added an Invoice column to the receiving screen that is editable (if user has security rights). GM% and MU% are also now available columns.
• Added total units, cases, and receiving cost to the top of the receiving screen to show what is being received vs ordered. Click on the screenshot below for example:

Reporting Enhancements

• Comparison Options: On some comparison reports you will now have the option to compare different time periods. On these comparison reports, you can choose to compare either the exact dates from this year to last year or the same period. If you compare by period, it compares based on the week from this year to last. In the example below, it is comparing Last Year (P) which makes the “From” dates match the same week as this year. You can also choose Last Year (D) which will make it compare by the identical calendar dates.

• We have three standard comparison reports that can be added to your database at your request:
  • Sales by Department Comparison
  • Sales by Category Comparison
  • Item Sales Comparison

Copy/Paste SKU Numbers

• Copy/Paste SKU Numbers: In the filters in the My Reports screen, you can now copy and paste a group of SKU Numbers into the SKU Number window to limit the reporting to those items. See screenshot below.

Promotion Enhancements

• When saving an item level promotion, it now updates item by item so that the registers aren’t affected while a large promotion is being saved.
• There is no longer an option to delete Promotion Type (and accidentally remove Simple Discount, for example)

Other Updates and Patches

• Scan Inventory Tool:  Option to choose between multiple products with the same UPC (seasonal items)
• Scan Inventory Tool:  Added CaseQty to the screen
• Select Item:  Added CasePrice as column on Promotions tab
• Select Item:  When you copy an item mPower no longer brings in the last cost from the copied item
• User Security:  If a user does not have rights to Edit Promotions, the Add/Delete options on the Promotions tab on each item are now grayed out
• Transfer:  When creating a new transfer, the ‘From’ location will now default to the location from which mPower is currently set

• Transfer:  When status is changed to ‘Cancelled,’ there is now a prompt to verify that the document should be cancelled
• Emailed Reports/Receipts:  Added option to define port used for SMTP traffic
• Print Tickets:  Print Preview restored on newest versions of Windows
• Print Tickets:  Cursor now goes back to the Quick Add box after an item is scanned, allowing you to keep scanning without clicking
• Print Tickets:  You can now search by VIN in the Quick Add box
• Price Change: Case Pack Qty no longer disappearing from the screen
• Adjust in Stock: Container added as a field on the screen
• Edit Item:  On the Vendor/Pricing tab, you can now set a “Max Promo %” that will calculate the MinPrice for you:

• Edit Item:  Added ability to use letters in CaseUPC field
• Edit Item:  Added ability to edit MU% and GM% in Additional UPC to update Retail price
• Update Size Tool: Added Description column
• Purchase Request:  Fixed duplication issue with Price By Location items
• Purchase Order Emailing:  Fixed issue that was adding vendor’s email addresses multiple times when multiple orders were attached
• Price Check:  You can now search for items in addition to scanning them. Click on the screenshot below for an example.

• Receiving:  Added ability to edit receiving screen if an item is accidentally over-received
• Item Movement History:  Added date options for searching history. Click on the screen shot below for an example:

 

• Various other small changes were made as well to the product improving speed and quality in the background

mPower Implementation Guide

• Release date:  4/15/2015
• Software compatibility:  All previous versions can be upgraded
• Corresponding mPower Point of Sale version:  3.6.0.61
• Corresponding mPower Server version:  1.2.1.282
• Hardware/Software compatibility: Microsoft .NET 4.0 or higher

Overview

The latest version of mPower Back Office introduces some changes in regard to user security and privileges.  In order to meet PCI compliance standards, mPower must require strong passwords and force logouts after a certain period of inactivity. Under this version, users will be logged out after a maximum of 15 minutes of inactivity and will need to log back into Office with a strong password, as defined by the PCI compliance board. See ‘User Security’ (below) for additional information in regards to user security.

Version 2.5.0.1056 of Back Office also includes some exciting new enhancements, including a size update tool and an inventory count module. Information on both of these new tools, as well as instructions for use, is included in the pages that follow.

Last, several time-saving modifications have been built into this release.  See below for detail on these and the other items listed above.  If you have questions, our support team is ready to assist:  972-234-5884, opt. 1.

Features, Updates, and Patches

User Security

User accounts for any payment application must meet a minimum security standard as set forth in the PCI Payment Application Data Security Standard, published by the PCI Security Standards Council.  Requirements include:

• Unique user IDs
• User account locked out after no more than six invalid login attempts
• Set user account lockout to no less than 30 minutes, and/or allow administrator unlock
• Require user to re-authenticate after more than 15 minutes of inactivity
• Passwords must be at least seven (7) characters and include letters and numbers
• Passwords must be changed every ninety (90) days
• New password cannot be the same as any of the user’s last four (4) passwords

mPower Back Office version 2.5.0.1056 meets all of these requirements.

Update Size Tool

Version 2.5.0.1056 of Back Office introduces a function called ‘Update Size’ that allows employees with access to change the size associated with a product or products.  At the top of the window is a Search box. Users can search by either SKU Number or product name.

The current size of the product or products is listed in the ‘Size’ column.  To change the size, click in the cell next to the product under the ‘New Size’ column and choose the appropriate size from the drop-down box.  Once the new size has been selected in the ‘New Size’ column, click the Update button at the top right of the window to apply the change.

Inventory Adjustment Merge Tool

The Inventory Adjustment Merge Tool is a new feature in mPower that allows store employees to create a master count of all items on the shelves and in the warehouse.  With this tool, mPower customers can create their own inventory documents without the help of outside parties.  Several people can scan inventory at once, each creating their own inventory count document that will be merged with all other documents to create a final count.  The merge will create an Inventory Adjustment that can then be uploaded to mPower to correct inventory counts several times a year.

Step 1:  Create a Document and Sub-Documents

• From the Navigation Bar, click on Unit Control.
• Click on Inventory Adjustment Merge.
• Click on the ‘Create Blank Adjustment Documents’ tab:

• Choose the proper Location from the drop-down box.
• Enter the appropriate Reason Code.
• Enter the Base Document Number, such as InvCount-Q1-4.15.15.  This is the master Inventory Adjustment document to which all others will be merged for a final count.

• In the ‘How Many’ blank, enter the number of sub-documents you would like to create (typically the number of tablets or scanners you are using to count product).
• To create the documents, click the Create Blank Adjustment Documents bar.
• Once clicked, you will see all of the sub-documents listed in the gray box at the bottom of the window.

Step 2:  Scan Inventory

• From the Navigation Bar, click on Unit Control.
• Click on Scan Inventory.

The following screen will appear:

The sub-documents that were created in the previous step will appear in the drop-down box next to ‘Document.’

IMPORTANT!  Each counter should use a separate document number for counting.

• Choose the appropriate sub-document in the drop-down box.
• Place the cursor in the ‘Scan’ field and scan the first item to be counted as shown below:

Notice that the item description is displayed in the yellow bar at the bottom of the screen. mPower will enter a quantity of 1 in the ‘Bottle Qty’ field.

• If there is more than 1 item on the shelf, adjust the number in the field by clicking the + sign or by scanning the item again.

• To add these items to the total count for the store, click Add.
• To cancel, click Cancel.

Note the ‘Previously Counted’ total in the yellow Description field at the bottom of the screen.  After a counter scans the item, he or she can see if the item has already been counted, and if so, how many times.  This is a safeguard against including the item on the document multiple times by mistake.

To see the total counts at any time, go to Unit Control -> Document Control.

• Under ‘Type,’ select ‘Inventory Adjustment.’
• Under ‘Owner,’ select the name of the counter.
• Click Search.
• To view the Inventory Adjustment, highlight the appropriate row and click Edit/View.

Note that this method of counting enters the Total in the ‘Actual Qty’ column, so that the adjustment corrects to the number of items actually in the store.  In other words, as a counter creates his/her sheet, the counts entered will translate to ‘Actual Qty.’

Step 3:  Merge Documents

Once each counter has completed his or her counts, the documents can be merged.

• From the Navigation Bar, click on Unit Control.
• Click on Inventory Adjustment Merge.
• Click on the ‘Merge Documents’ tab.

(NOTE:  If only one document has been edited, no merge options will show on this screen.)

• To create a new ‘Merged Document Number,’ enter whatever number you prefer in that blank.
• Choose the documents to merge by clicking the check box to the left of each document.
• To delete the original counting documents, click the box next to ‘Cancel Documents on Merge.’
• Finally, click on Merge Documents.

Step 4:  Upload Adjustment to mPower

• To view the merged document and make any final adjustments, go to Unit Control -> Document Control.
• If you created a new document number, enter it in the ‘Document #’ field.
• Under ‘Type,’ select ‘Inventory Adjustment.’
• Under ‘Owner,’ select the name of the person that merged the documents together.
• Click Search.
• To view the Inventory Adjustment, highlight the appropriate row and click Edit/View.

• Make any final tweaks to the Adjustment document, so that all counts are correct.
• When satisfied, change the Status from ‘Unconfirmed’ to ‘Confirmed.’
• Then click Save.

mPower will then make the inventory adjustments to your database.

Additional Notes

• To zero out an item in inventory, scan the barcode and click the – sign, so that ‘Bottle Qty’ reads ‘0.’ This will adjust the Actual Qty to 0 in the adjustment document.
• Renaming the final adjustment document (Merged Document Number) is NOT a required step. If a new name is not chosen, the adjustment document will retain the original Base Document Number.

Updates and Patches

• Print Tickets:  Restored ability to print tickets from receiving screen
• Inventory Setup:  Merchandising tree now refreshing when items are deleted
• Edit Item:  Item Movement History now including sales processed at 00:00:00
• Edit Item:  Removed pop-up warning when entering Case Pk Qty for new item
• Edit Item:  Resolved issue where Case Retail was updating based off of initial updates to Case Pk Qty and not re-adjusting based on saved edits until Retail was edited
• Edit Item:  Resolved issue where Unit MU% was requiring a decimal place for percentages
• Promotions:  Added the ability to upload attachments
• Purchase Order:  Resolved issue where VINs would disappear after editing VIN and closing PO window
• My Reports:   Restored Vendor check-box tool
• Purchase Order:  Added alert that will pop up if the same Vendor PO is entered on a new PO
• Purchase Order:  Now displays total cases on order
• Purchase Order:  Where Negative POs are used and items are scanned into a list, the last item of a multiple item entry does not come out of inventory, even though Item Detail shows that it does
• Customer Maintenance:  Added Vintage to Purchase History

mPower Implementation Guide