Skip to main content
Solved

Generic Inquiry that shows on hand qty for any configured item?

  • Mar 25, 2025 1:53 PM UTC
  • 2 replies
  • 117 views
  • Translate All

Forum|alt.badge.img

I know more than the basics in Acumatica but this one I’m wondering if a) is this possible? and/or b) should it even be attempted?

I need to create a generic inquiry that would show on hand qty for all configured items, with their configurations listed.

Help?

Best answer by bwhite49

You can show qty based on open sales orders where the production order qty completed is greater than 0. See the attached GI. 

This will give you the qty on hand for config items. Unfortunately, there is no inventory status table for configured items.

View original

2 replies

bwhite49
Captain II
Forum|alt.badge.img+12
  • Captain II
  • Answer
  • Mar 25, 2025 2:40 PM UTC

You can show qty based on open sales orders where the production order qty completed is greater than 0. See the attached GI. 

This will give you the qty on hand for config items. Unfortunately, there is no inventory status table for configured items.

Translate

Forum|alt.badge.img
  • Author
  • Freshman I
  • Mar 25, 2025 2:47 PM UTC

Thank you. I will to work from this. I appreciate your help.

Translate