Greetings,

The BIE Views for Inventory do not have a data source for the Sales Order table(s). You are not going to be able to do this without contacting a Sage 100 Development Partner to modify the BIE View source and add a Sales Order Data Source to the BIE view(s) where you want to display the Sales Order information.  Likewise, the Sales Order Views don;t have a data source for the Inventory Items.

Instead of BIE, consider creating a custom Crystal report where you can link the tables together that you need to create the report.

Thanks,

Kent

Greetings,

The BIE Views for Inventory do not have a data source for the Sales Order table(s). You are not going to be able to do this without contacting a Sage 100 Development Partner to modify the BIE View source and add a Sales Order Data Source to the BIE view(s) where you want to display the Sales Order information.  Likewise, the Sales Order Views don;t have a data source for the Inventory Items.

Instead of BIE, consider creating a custom Crystal report where you can link the tables together that you need to create the report.

Thanks,

Kent

Another option is to use Sage Intelligence Reporting to create your own unique report.  You can find Sage Intelligence Reporting and Crystal classes on Sage U.

Hi - I've had help from our representative and now have a solution! It is possible, just hard to navigate.

While in the BIE Item View by Warehouse Module, clicking on a single item, then closing its filter lets you add several more columns in the Edit Column tab (for some reason). We were able to add Qty on SO and many others to the report.