SAP
      Back to home
      1. Richardson Knowledge Base
      2. IT
      3. SAP

      Fixing Multiple or Missing Barcodes in SAP Business One

      This article provides a step-by-step guide to identifying and resolving multiple or missing barcodes on a single item in SAP Business One.

      1. Identifying Items with Barcode Issues

      To determine which items have multiple or missing barcodes:

      1. Open the following file on SSMS:
        \Richardson Sports\IT Internal - Documents\SAP\Queries\Barcode Lookup
      2. Run the Barcode Lookup query (With last condition OITM.QryGroup34 = "Y").
      3. Review the item codes to check for missing or duplicate barcodes.
      4. The last AND condition in the query can be used to filter for only currently stocked items.
        • These need to be addressed immediately.

      2. Fixing Barcode Issues in SAP Business One

      Once you have identified an item number that needs fixing:

      1. Open SAP Business One.
      2. Navigate to Inventory → Item Master Data.
      3. Open B1 Validation (Ensure you are an authorized user with OK/Update permissions).
      4. Modify Barcode Settings:
        • Right-click the Barcode text box.
        • Select B1 Usability Package → Edit B1 Validation Configurations.
      5. Search for the specific Item Number.
      6. Open the Bar Codes window (using the button on the right).
      7. Delete all existing barcode rows:
        • Right-click all rows and select Delete Row.
      8. Click Update → OK on barcodes window NOT ITEM MASTER WINDOW.

      3. Finalizing the Fix in B1 Validations

      1. Go to the B1 Validations tab (opened earlier).
      2. Activate the OK/Update tool.
      3. Click Update.
      4. DO NOT UPDATE TWICE – Doing so will create duplicate barcodes.
      5. Deactivate the OK/Update tool in the B1 Validations tab.
      6. Perform a final update in the Item Master Data tab.
      7. Search for the next Item Number that requires fixing and repeat the process.

      Final Notes

      • Always ensure that only one barcode exists per item to prevent future processing issues.
      • If you mistakenly update twice, repeat the process to remove duplicates.
      • Items that are currently stocked should be prioritized.

      By following these steps, you can eliminate barcode errors in SAP Business One, ensuring data accuracy and inventory integrity.