Sage 100

Ok I'm ""lost"". Recently upgraded a client from SAGE 100 Standard version 4.4 PU10 to 2013 PU5. In version 4.4 had a Custom Crystal Report in Sales Order that included the QuantityShipped field from the SO_ShippingQtyByItem table. In version 2013 I cannot find that field or the table that field might be located in. Any help will be appreciated.

See the various key-options in the SO_InvoiceDetail file. Includes keys: KITEM and KITEMWHSE that include the item in the key.

No longer ""lost"" I found the field I was looking for in the QuantityShipped in the SO_InvoiceDetail table. What I'm trying to do is list all the records in the SO_DailyShipment file. For each Sales Order listed I want to display the detail lines that have a Quantity Shipped > 0.00 (that field is stored in the SO_InvoiceDetail table until the invoice records are posted). How do I link (inner join, left outer join, Enforced, Not Enforced) the following tables in my Crystal Report - SO_DailyShipment, SO_InvoiceDetail, SO_InvoiceHeader, and SO_SalesOrderDetail files? Right now I'm getting the lines printing four times for each record in the SO_DailyShipment file. I have excluded non inventory lines like comment lines.

Do you really need to have the invoice header and so detail file? I would think you could get the data you needed with just linking the invoice detail file to the daily shipment wrk file.

Thanks @KellySappington Removing the SO_SalesOrderDetail file did the trick! I found all the ""details"" I needed in the SO_InvoiceDetail and SO_InvoiceHeader files.