Filter VendPackingSlipTrans by Warhouse (InventLocationID) in Electronic Reporting

(1) Share

Report

Posted on by Mark Loren Manuel

We are creating a Vendor Packing Slip Report that can be filtered by Delivery Date and Warehouse. The problem is that the VendPackingSlipTrans table does not have a field for the warehouse. Instead, we are filtering the InventDim table since it has a warehouse field, and then using VALUEIN because there is an InventDimId in VendPackingSlipTrans. However, there are a huge number of InventDimIds, and the report is throwing an error suggesting that we either update the list in VALUEIN or use the WHERE function to filter the table. The WHERE function, however, takes a very long time to execute.