# Cross Company Stock On Hand Report

**URL:** <https://www.epiusers.help/t/cross-company-stock-on-hand-report/104200>\
**Category:** Epicor ERP 10\
**Tags:** baq, dashboard\
**Created:** [June 20, 2023, 10:24am UTC](https://www.epiusers.help/t/cross-company-stock-on-hand-report/104200 "2023-06-20T10:24:56Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mal\_Watterson](https://www.epiusers.help/user_avatar/www.epiusers.help/mal_watterson/32/57110_2.png) [@Mal\_Watterson](https://www.epiusers.help/u/Mal_Watterson)\
**Post date:** [June 20, 2023, 10:24am UTC](https://www.epiusers.help/t/cross-company-stock-on-hand-report/104200/1 "2023-06-20T10:24:56Z")

</div>

Hi, Has anyone here developed a BAQ dashboard that shows On Hand Qty of all parts or even a searched part number across different companies with Epicor.

Our ERP setup has 3 companies, (USA, UK, Canada) our users want to be able to look at a dashbaord and filter or search for a part to see what the other 2 companies have on hand of that part.

This is for our aftermarket, if a customer needs a part and the USA team have 0 on hand the can easily look at this report to see if Canada or UK have the part on Hand.

Thanks in advance  
Mal

---

<div class="post-metadata">

**Author:** ![Dragos](https://www.epiusers.help/letter_avatar_proxy/v4/letter/d/59ef9b/32.png) [@Dragos](https://www.epiusers.help/u/Dragos)\
**Post date:** [June 20, 2023, 1:52pm UTC](https://www.epiusers.help/t/cross-company-stock-on-hand-report/104200/2 "2023-06-20T13:52:06Z")

</div>

A cross-company BAQ would do the trick. See attached an example for PartWhse. You could also use PartBin to show the bins too. Once you have all the fields you need in the BAQ, you can create a dashboard with it.

[WhseOnHand.baq](https://www.epiusers.help/uploads/short-url/3TSaGpP4ynvJ6pMlALkSPqERkw0.baq) (18.5 KB)

LE: forgot to add an important thing - your users will need access to all 3 companies.