Error 20 SO_140MB_SalesJournal_upd.pvc Line 171 occurs when updating a sales order invoice that contains a serial/lot item and Scanco Multi-Bin is installed, activated, prepared, and set up.

Scanco Multi-Bin Hot Fix ID 18867

Sage 100 Version: 2019.4 (6.10.4.0)

Scanco Multi-Bin Version: 6.1041

PROBLEM: Daily Sales Repots/Update: Error 20 SO_140MB_SalesJournal_upd.pvc Line 171 occurs when updating a sales order invoice that contains a serial and/or lot item and Scanco Multi-Bin is installed, activated, prepared, and set up in the current company.

STEPS TO DUPLICATE

1. Access a company that is converted to 2019.4 and has Scanco Multi-Bin activated, prepared, and set up.
2. Create a sales order.
3. Add a serial or lot item to the sales order with a quantity ordered greater than zero.
4. Save and close the sales order.
5. Create an invoice for the sales order.
6. Assign a shipped quantity of 1.
7. Assign a serial/lot number and a bin location in the distribution window.
8. Select the Accept button.
9. Access Daily Sales Reports/Updates.
10. Select the Preview button.
11. An error 20 SO_140MB_SalesJournal_upd.pvc Line 171 occurs.

Note: The error does not occur when serial or lot items are not assigned to the invoice.

EXPECTED BEHAVIOR: Error should not occur when previewing the Sales Journal for a Sales Order invoice that contains shipped serial and/or lot items.

RESOLUTION: This issue is resolved by downloading and installing the program available from Hot Fix ID 18867.