How do Update Units Committed runs in VisionCore

There are unexpected times that the Units Committed would show wrong values. Causes of this issue may include wrong data during an import process.

To fix this, you can run the Update Units Committed tool. This tool would search each items that are placed in the outstanding sales orders, back orders and sales invoices. In other words, when an item belongs to an open sales order or back order and an unposted invoice, the sum of the qty ordered in those transactions will be gathered and updated as the correct Committed qty.

Open sales orders are orders that are not completed or processed to a sales invoice. Unposted invoices are sales invoice that are yet to be posted.

This tool will use the data found on these table:

1.tblOESales

2.tblOESalesDetail

3.tblARInvoice

4.tblARInvoiceDetail

This tool will update the this table:

1.        tblICInventoryStockTotal – the affected column is dblUnitsCommitted