Yes you can do that, which tables were you planning on using?

For the current inventory information -I am using the IM1_InventoryMasterfile and IM2_InventoryItemWhseDetl (value is greater than 0) for the current Inventory information.

For the units sold by sku within a specific time frame -I am using the IM5_InventoryTransactionDetail with the criteria of "SO" as transaction type and transaction date range is 10/1/2012 - 3/31/2014.

I either get the inventory value to agree with my current day value but units sold is incorrect, or my units sold is correct but the inventory value is less than actual as some skus did not have sales in that date range and were not included in the report.

For the current inventory information -I am using the IM1_InventoryMasterfile and IM2_InventoryItemWhseDetl (value is greater than 0) for the current Inventory information.

For the units sold by sku within a specific time frame -I am using the IM5_InventoryTransactionDetail with the criteria of "SO" as transaction type and transaction date range is 10/1/2012 - 3/31/2014.

I either get the inventory value to agree with my current day value but units sold is incorrect, or my units sold is correct but the inventory value is less than actual as some skus did not have sales in that date range and were not included in the report.

How do you have the tables linked?

Yes... the key is Item number

IM5_InventoryTransactionDetail should probably be a left out join in case you did not have a transaction for an inventory item.  If you have an equal join, only records with transactions will be pulled in.  Also, if you have multiple warehouses, do you have the IM5 linked to the Master or the Warehouse?  What version of Mas are you running?