Sage 100

Just converted a company from 3.74 sql to 5.1 premium. In 3.74 they enter a PO as type Drop Ship. Then, enter the Receipt of Invoice, and the Quantity Invoiced AND the Quantity Received fields are updated on the PO. Does anyone know how this could happen in a generic version of MAS, or is this a script or trigger doing the Quantity Received update? Is there any way the Quantity Received field on the PO should be getting updated on a Drop Ship PO?

Not sure if it is a bug or not but in 5.2.3 the qty received field is set to zero when entering a Receipt of Invoice and it is disabled so there is no way to enter a qty through the interface. If you go to the \mas90\cm\scripts folder is their a file there called PO_ReceiptofInvoiceDetail_Bus.vbs. That would tell you if a user-defined script is attached to an event involving the receipt of invoice.

I also tested in v5.2.3 and the PO was completed, but no value in Qty rec.

Yes. I was ""almost"" certain that a drop ship PO never gets a quantity received. Something custom is going on. Digging deeper.

Premium... check for SQL triggers.

Found the trigger on AP_InvoiceHistoryDetail. Thanks everyone!