Skip to main content
Answer

INLocationStatus LocationID for all past locations

  • October 9, 2025
  • 1 reply
  • 26 views
V
Jr Varsity III
Forum|alt.badge.img

In a GI, when I join InventoryItem to INLocationStatus and output the InventoryItem.InventoryID and INLocationStatus.LocationID, I get a list of every location that that Item has ever had inventory in, even if that location no longer has inventory in it.

Is there a way to clean these up or filter old locations out for a given item without simply excluding QTY zero?

Best answer by bwhite49

Yes, you can filter through the join or as a condition in the GI itself.

 

Join example. The inner join is important in this case
GI condition

 

    1 reply

    bwhite49
    Captain II
    Forum|alt.badge.img+11
    • bwhite49
    • Captain II
    • Answer
    • October 10, 2025

    Yes, you can filter through the join or as a condition in the GI itself.

     

    Join example. The inner join is important in this case
    GI condition

     

    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