Back to GI Library

Do you have an idea for a Generic Inquiry that you’d like to see here in the GI Library?

Feel free to leave a comment below with your idea.

Comments

  1. Brent Leis says

    I would like to see a GI that looks at aged buckets and creates a business event that would note if customer is pat due. This GI should group invoices by customer # and then give you the total past due and the ability to drill down into what is making up that sum total of past due.

  2. Amanda Biggart says

    Would love to see a twisted version of your historical inventory valuation report. Our company uses the lot/serial and expiration date functionality and we have had a hell of a time trying to get someone to design an accurate historical valuation report for us (we have spent thousands and still don’t have a functioning report). The total value always ties to our GL, but the lot serial and expiration dates that pull are not correct and we need to be able to sort and filter out inventory by exp date for our bank (at month end).

  3. Kevin Latimer says

    We have tried however not had much success in recreating the historical inventory balance totals in a GI instead of using the canned report.

    The calculation that would give us a month end total including inventory including bins that did not change in the period evades us. We built a GI using the PX.Objects.IN.INItemSiteHist table but the totals do not include parts that have no movement.

  4. Lorne Weinstein says

    I would love to develop a GI that shows me dead stock. We use average valuation method for valuing inventory. Any thoughts on how to develop that?

Leave a Reply

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2026 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.