Is there any way we can find/search shipments by an inventory ID? Or look at the transaction history (including shipments and purchases) for a certain stock item?
A picking worksheet got lost and we are having a hard time locating the shipment in the system. We process over 400 orders per day.
any tips would be appreciated.
Thank You!
Best answer by darylbowman
Click the + button to create one. Give it a name. Save it.
Add a new record under the ‘Data Sources’ tab (or ‘Tables’ in older versions) with the table name PX.Objects.SO.SOShipLine. Save.
Add a record on the ‘Conditions’ tab where the ‘Data Field’ SOShipLine.InventoryID ‘Equals’ (with ‘From Schema’ checked and then pick your Inventory ID. Save.
Optionally add another condition where SOShipLine.ShipDate is compared to something.
Done.
+15You can build a GI on SOShipLine (Shipment lines) or POLine (PO lines). Then filter by InventoryID / date.
+15Click the + button to create one. Give it a name. Save it.
Add a new record under the ‘Data Sources’ tab (or ‘Tables’ in older versions) with the table name PX.Objects.SO.SOShipLine. Save.
Add a record on the ‘Conditions’ tab where the ‘Data Field’ SOShipLine.InventoryID ‘Equals’ (with ‘From Schema’ checked and then pick your Inventory ID. Save.
Optionally add another condition where SOShipLine.ShipDate is compared to something.
Done.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
