Part Restock not showing in Inventory

Part Restock not showing in Inventory

๐Ÿ› ๏ธ How to Add a Missing Part to Inventory and Update Related Tables

This article outlines the steps to resolve issues when a part in a vendor invoice appears blank or has a zero Parts ID. This typically requires manually adding the part and updating the SQL database.

๐Ÿ”— Step 1: Connect to the Client Server

  • Ensure you are connected to the clientโ€™s server environment before proceeding.

๐Ÿงพ Step 2: Check Vendor Invoice

  1. Navigate to Parts > Vendor Invoices.

  2. View Closed and Posted invoices.

  3. Locate the relevant invoice by entering the vendor invoice number.

  4. Right-click on the invoice and select Edit.

๐Ÿ” Step 3: View the Part Master Record

  1. Within the invoice, right-click on the part line item and choose View Part Master Record.

  2. If the part information is blank and shows a 0 in the lower-left corner, this indicates a missing or unlinked Parts Master ID.

๐Ÿ›’ Step 4: Add the Part to Inventory

  1. Go to Parts > Parts List.

  2. Create a new part record in the inventory.

  3. Make note of the Parts Master ID in the lower-left corner of the part entry screen.

  4. Save and close the new record.

๐Ÿงฎ Step 5: Update the Database via SQL Server

โš ๏ธ Note: Ensure you have appropriate permissions and a backup before making any SQL changes.

  1. Launch SQL Server Management Studio (SSMS) and connect to the database.

  2. Open the table dbo.RestockDet.

    • Locate the relevant row for the invoice/part.

    • Enter the new Parts ID in the ItemID column.

    • Set the ItemType column to 1.

  3. Then open the table dbo.Parts.

    • Search for the newly created part by part number.

    • Update the OnHand quantity to 1 (or adjust based on customer input).

โœ… Final Check

  • Verify that the part is now correctly listed in the invoice and inventory.

  • Double-check all quantities and make any additional changes if requested by the customer.

  • Notes
    Always confirm with the customer before adjusting quantities.


    • Related Articles

    • Repair Order and Part Invoices Setup

      Repair Order and Part Invoices Setups are a bit lengthy but will help the users to see the various features in MaxxTraxx and help decide what they want to program to do. Have them navigate to the Setup Menu and click on Repair Order and Part ...

    • Manufacturing Parts: How to move the individual part pieces out of inventory and then put the finished part into inventory

      Option 1: Vendor Invoice Place all the individual items on the invoice as credit items by using the “Receive Credit for Returned Part” From the “Add Line Item” menu, you will then add the completed product to the invoice to be restocked Make sure ...

    • How to Find How Many Part Numbers in Inventory Have a Positive Quantity

      Open the Report: Go to Reports from the main menu. Select Company Reports. In the left pane, click on Inventory. Select the Report Type: Choose General Inventory Summary. Run the Report: Click Run Report. In the “By Quantity in Stock” section, set ...

    • Parts Inventory Pricing Update

      There will be times a shop needs to update parts pricing on multiple part numbers. MaxxTraxx has a tool to perform inventory pricing updates without going to each part and adjusting them manually. You should always do a backup PRIOR to running the ...

    • How To Set Up Part Price Matrices

      MaxxTraxx has the capability to create several Matrices for your part price calculations and can have differently Matrices assigned to your Online Vendors.  Creating a Parts Matrix: Click on 'Parts Mgr' on the tool bar at the top Choose 'Part Price ...