Stock vs. Bin Location Messages

Stock vs. Bin Location Messages

Introduction

This procedure is only required for companies who are using the Warehouse and/or Locations feature in JAS.

 

Setup

Sometimes stock units are adjusted incorrectly through system transactions or user adjustments.  Either way if the total units by style (sum of all sizes in one color) in the Master File does not match the summed stock units of all individual locations (for the same style / color), users will receive the following message when they attempt to adjust stock. Only a user with a Master Password is allowed to continue.

Locations: 113, Master: 110 Match Locations to Master

The discrepancy is caused by a JAS process that updated the Master Stock value without updating the Bin Location Stock value (or vice versa). This problem can be caused by any number of processes that update stock levels in JAS: Cutting Ticket Receipts, Purchase Order Receipts, Invoicing, Manual Adjustments, Credit Memo's, etc. This makes it very difficult to find the actual cause of each individual instance.

To find the problem, users will have to run a Style History Journal for the style/color in question and forward it to jonar@jonar.com for analysis. That report will allow Jonar to retrace the processes performed on that item in the recent past; allowing Jonar to find out which program caused the discrepancy and then adjust the program and/or data accordingly.

To ensure that the problem is dealt with quickly, users should run the Stock vs. Bin Report once a week to see if any styles contain discrepancies. If a style is found to have this problem, the Style History Journal and the Stock vs. Bin Report should be run daily (for that item) and sent to Jonar each time until the issue is resolved.

The Style Cut and Sold screen by style/color shows the stock values in the master file. The total stock should be the sum of stock units in all warehouse bin locations.


 

Style Stock Adjustments

Then inventory of the total master stock must match the combined location inventory. In order to correct the inventory so that the total stock matches the total of the inventory from each location combined there are 2 steps to be done.  This section will explain each step.

Please note that the adjustment must be done by a user who has master access to JAS.

 In JAS go to:

  • Styles
  • Processing
  • Adjust Stock
  • Style Inventory System




    • Click on "Inventory Quantity Adjustments".

 

You will receive the message informing you that the master does not match the locations.

Click on "Ok".



Make the necessary adjustments and click on "Proceed".



 

Note: If the stock entered does not match the locations, a message will be received.

 

Report Procedures

Style History Journal


 
In the JAS main menu, go to:


  • "Styles";
  • "Reports";
  • "General And Summary Reports";
  • "Style History Journal".


Users should enter a small date range (1 week is good to start with) and they should select only the style(s) that have stock discrepancies. 
This report should then be sent to Jonar for analysis.



A report will be generated, similar to the following.

Stock vs. Bin Report

 From the JAS main menu, go to:

  • "Utilities";
  • "Stock vs. Bin Loc".


This report does not allow user selections for dates or styles.  It will simply list any and all styles that have a discrepancy in the stock values.  Requesting Size Details is necessary for proper analysis.
A report will be generated

    • Related Articles

    • Generating a Stock on Hand Report by Style/Color

      Introduction The following document explains how to view all units available for particular stock, either by style, or by style & color. Setup In the main JAS menu, go to: Styles Reports General And Summary Reports Stock on Hand On the first screen, ...

    • Style Master List - Customs Report

      Introduction This wiki will explain how to generate a report to view the customs information that was entered in the style customs screen.   Report Selections In JAS go to: Styles Reports General and Summary Reports Master List Select the specific ...

    • Comparing original and current inventory after a count

      Introduction This wiki will show the user how to access a report that compares original and current inventory after the inventory has been frozen, and a count has been completed. Steps Go to Styles Physical Inventory Choose "Style inventory report of ...

    • Style Cut & Sold Calculations

      Introduction The Style Cut and Sold Screen is a very efficient tool allowing users to view the current status of any Style / Color at a glance.   Setup Access the Cut & Sold calculation for Styles on the main JAS menu under "Styles"; "Inquiry";  ...

    • Reset Inventory Amounts For Make Styles

      Introduction The inventory on manufactured styles are not being tracked at this time. In order to be able to invoice styles without being blocked when there is insufficient inventory, the inventory values by size and color will need to be updated ...