Follow

04.08.a RECONCILIATION CSV UPLOAD TOOL

The RECONCILIATION CSV UPLOAD TOOL allows an administrator or manager to upload multiple CSV files containing product counts, providing a cumulative upload of all included product SKUS and the respective summary levels.

 

Since this task can make large changes to your GramTracker database, we recommend that you make certain that only the proper users are allowed access.

 

A StoreAdmin or Manager user can locate the Reconciliation Task by navigating to:

Inventory > Reconcile

 

 You can begin a reconciliation by clicking "Start a Reconciliation".

 kb_StartRec.png

 

This will create a reconciliation which can be saved and continued at any point.

The reconciliation screen will allow you to filter down to any product level you'd like, or you can view all products at once.

 

Show items with no inventory: By selecting "no", this filter will allow you to show only inventory that currently has stock.

 

Type:  This filter allows you to determine which inventory type you'd like to see, Bulk, Simple, or Price by Weight Simple.

 

Vendors: You may select specific vendors to show on the reconciliation. To select more than one vendor at a time, simply hold Ctrl or Shift while clicking on vendor names.

 

 

 

You may optionally give a name to this reconciliation for clarification.

 

As you count the inventory in your location, you record the amounts on the CSV template attached to this KB.  All that is required is the product SKU if non-batch tracked or non-medicated, and the package ID for any batch tracked medicated items.

 

If your system is batch tracked, the package ID of the items would be the point of reference for the upload.  This means that one would either scan the packages one by one into a spreadsheet, or scan one package and enter the count of units in that package.

 

A suggested workflow would be to filter the reconciliation by product category, and work on one at a time for your cycle counts.  However, if you don't have the need to separate your categories, you can easily upload multiple files with all of your counts, and the system will automatically create an additive count for each time the SKU or package ID appears (we recommend a 1 is entered for any manually scanned packageIDs or SKUs so the system will recognize a unit is present for each scan).

 

The following graphic is an example of what your CSV file should look like prior to upload.  Multiple files can be included in a single reconciliation, providing you the ability to have several employees submitting counts from individual departments or inventory locations. The first column represents the SKU and/or Package ID of the item, and the second column is the number of units of that item...keep in mind that if you are scanning individual packages, the mobile version of the reconciliation does have an additive scanning capability as well.

 

 

When you have the CSV files populated and saved locally or to your network, you are able to upload the CSV files to aggregate and cumulatively add the units for each SKU or PackageID included within the uploaded files.

 

 

As you upload files, the reconciliation will continue to add any new values for the SKUs and/or Package IDs represented within the files.

 

Once the files have been uploaded, the aggregate levels and adjustments to be made can be saved whenever you like by clicking "Save for Later", and the reconciliation can then be re-opened at a later time.

 

 kb_SaveRec.png

 

Once all files have been uploaded, you can save and view the changes you would like to apply by clicking "Save and View All Changes". If you are satisfied with your changes, you may apply those changes by selecting an inventory adjustment reason, and clicking "Save and Make These Adjustments"

 

Note: A reconciliation will only adjust the items that are included in the adjustments review. Be sure these are accurate before proceeding to apply the adjustments.

 

Once these adjustments have been applied, you can not reverse the changes. As such, it is vital that you verify that the changes you are about to make are accurate.

 

kb_MakeRec.png

 

Once applied, you can see the results of your changes by navigating to the transaction history of your inventory.

 

kb_AfterRec.png

 

An additional feature included with the CSV upload tool is the ability to zero out any products that are not included in the Zero Out Category selected for the reconciliation.  Using this tool will essentially create a filter on the reconciliation, limiting it to the products for the selected Zero out category.  This is a sensitive function as it does allow for inventory to be zeroed out if not included in the CSV uploaded files, and is part of the category selected to Zero out.

 

 

***This feature is recommended only when you are reconciling one product category at a time***

 

Should you have any additional questions or concerns, please contact support at 888.932.6537 ext1 or at support@mjfreeway.com. 

Was this article helpful?
0 out of 1 found this helpful
Have more questions? Submit a request

Comments