Skip to main content
Question

Beginning Balance Field in Custom Inventory Transaction Log Report

  • April 10, 2025
  • 3 replies
  • 126 views
  • Translate All
Freshman I

Working on a modified version of the Inventory Valuation report to act as an inventory transaction log. Trying to get a beginning balance field set up. The goal would be for the report to calculate the total on-hand quantity for the item from BEFORE the date specified in the @TransactionDateFROM parameter. Any ideas?

3 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+14

Hi ​@RyanBostwick 

Please refer to the "Historical Inventory Balance" report to see how to create the Beginning Balance Qty.

 

 

Best Regards,

NNT

Translate
I have devoted a great deal of my time and passion to Acumatica ! 🌐https://www.linkedin.com/in/phambaotruong
    Freshman I

    Hello, ​@nhatnghetinh 

    The issue with that report is that it is grouping by period. As such, it is able to utilize ItemHistCurr, which apparently contains fields that calculate the beginning and end balance for each period. The parameters I’m using in my report are looking at dates, rather than periods.

    Translate
    Chris Hackett
    Community Manager
    Forum|alt.badge.img

    Hi ​@RyanBostwick were you able to find a solution? Thank you!

    Translate
    Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
    Terms & ConditionsAccessibility 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