Skip to main content
Answer

Creating a Generic Inquiry to Show Back Order Items

  • June 21, 2023
  • 3 replies
  • 161 views
B
Varsity I
Forum|alt.badge.img

Hello, 

I’m trying to create a GI that shows when the quantity of an item ordered is more than available for the item. 

What we currently have set up looks at individual line items and compares the line items to the qty available. 

However, we have noticed that one stock item will be used for a 12 pack and a 6 pack non stock item, for example. 

If someone orders both the 12 pack and the 6 pack, those show up as two separate lines items. We just experienced a situation where the whole order total should have been put on Back order, because there wasn’t enough of the single stock item, but it did not show up on this GI because neither line item by itself was more than the qty available. 

Does anyone have any suggestions on how to get this condition to look at the whole order, but still specific items? 

Thanks!

Best answer by dcomerford

​@bclark I think you will need to use the new feature in a GI where a GI can be used in another GI (release 24R1 ) from memory.

You can then create a GI to work out what is the demand per item so it can do a Group by Items with totals. You can then use this GI in your existing GI to compare the value to the Qty Available to see what you need to order.

Your other choice if you have SQL skills it to create this in a SQL view and then add this as a DAC so it can be used by a GI.

3 replies

J
Freshman I
Forum|alt.badge.img
  • jdabney37
  • Freshman I
  • August 14, 2025

Did you ever figure this out? I am in the same situation. Thanks

 

dcomerford
Captain II
Forum|alt.badge.img+15
  • dcomerford
  • Captain II
  • Answer
  • August 15, 2025

​@bclark I think you will need to use the new feature in a GI where a GI can be used in another GI (release 24R1 ) from memory.

You can then create a GI to work out what is the demand per item so it can do a Group by Items with totals. You can then use this GI in your existing GI to compare the value to the Qty Available to see what you need to order.

Your other choice if you have SQL skills it to create this in a SQL view and then add this as a DAC so it can be used by a GI.

Dermot Comerford
Chris Hackett
B
B
Varsity I
Forum|alt.badge.img
  • bclark
  • Author
  • Varsity I
  • August 15, 2025

​@jdabney37 

I wasn’t able to get this specific GI request figured out, but I do like the suggestion by ​@dcomerford 

Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved