Skip to main content
Question

How to Get Most Recent Pending Price From Price Worksheets?

  • December 18, 2025
  • 1 reply
  • 10 views
S
Varsity I
Forum|alt.badge.img

Building a GI where I need to get the most recent “Effective Date” for all inventory items that are a “STAFF” price code. The ways I’ve seen to get the most recent record in GI’s won’t work here because the effective date only lives on the ARPriceWorksheet table and not on the ARPriceWorksheetDetails table where the inventory item, price code, and pending price are. 

Thanks for the help!

      1 reply

      nickcerri32
      Varsity I
      Forum|alt.badge.img+2
      • nickcerri32
      • Varsity I
      • December 19, 2025

      ​@SBaldwin - I’d switch the tables around and make the detail sheet the parent table.

       

      Then you can group by the Price Code and Inventory (I used nventoryCD, but you could just as easily use the ID field.)  This should return the most recent effective date.

       

      Nick - If we helped give us a Like. If we answered your question, select the Best Answer option.
      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