1. To correct a mismatch in the quantity column in a stock report in Sage X3, you can follow these steps:
2. Identify the mismatch: Review the stock report and identify the specific items or transactions where the quantity column shows a discrepancy.
3. Verify data integrity: Double-check the data integrity by comparing the stock report with other relevant sources such as purchase orders, sales orders, receipts, or any other relevant documents. Ensure that there are no errors or missing entries in the data.
4. Trace the transactions: Trace the transactions related to the mismatched items. Identify the documents or transactions that caused the incorrect quantity in the stock report. This could include purchase receipts, sales orders, transfers, adjustments, or any other relevant documents.
   1. Purchase Orders: If the mismatch is due to incorrect quantities in purchase orders, locate the relevant purchase orders and adjust the quantities accordingly. This may involve modifying the existing purchase order or creating a new corrective purchase order.
   2. Sales Orders: If the mismatch is related to sales orders, review the sales orders and verify if the quantities are correct. If not, modify the sales orders accordingly to reflect the accurate quantities.
   3. Stock Adjustments: If the discrepancy is due to stock adjustments, such as write-offs, transfers, or manual corrections, review the adjustment entries and make the necessary adjustments to rectify the quantities.
   4. Inventory Receipts: If there are discrepancies in inventory receipts, verify the receipt transactions and ensure that the quantities entered are accurate. If required, adjust the receipts accordingly.
5. Make corrections: Depending on the identified transactions, you can take the following corrective actions:
6. Reconcile the stock: After making the necessary corrections, reconcile the stock by updating the inventory records. This may involve adjusting the stock quantities, updating stock locations, or performing any other relevant actions to reflect the corrected quantities accurately.
7. Generate a new stock report: Once the corrections and reconciliations are completed, generate a new stock report to verify that the quantity column accurately reflects the corrected data.

Remember to perform these corrective actions cautiously, taking into consideration the impact on other related transactions and ensuring that all changes are properly documented. It's always recommended to consult with your system administrator or Sage X3 expert for specific guidance based on your organization's setup and requirements.