Skip to main content
Solved

Trial Balance End Point

  • March 22, 2026
  • 7 replies
  • 59 views
mohammadnawaz51
Jr Varsity II
Forum|alt.badge.img+6

Hi Team,

I hope you are doing well.

I am currently looking for Trial Balance or Account Details endpoints in Acumatica ERP.

We are able to successfully retrieve data for the Account Details inquiry screen. However, when attempting to filter using From Period and To Period, we are not receiving any results.

Could you please assist us in understanding:

  • If there are any specific parameters or formatting required for the period filters
  • Or if there are any limitations or additional configurations needed for this scenario

Any guidance or suggestions would be greatly appreciated.

Thank you in advance for your support.

Best answer by Manikanta Dhulipudi

​@mohammadnawaz51 I dont think end points is available for reports.

https://www.acumatica.com/acumatica-marketplace/global-payex-ap-accounts-payable-automation-solution/

    7 replies

    nhatnghetinh
    Captain II
    Forum|alt.badge.img+13
    • nhatnghetinh
    • Captain II
    • March 23, 2026

    Hi ​@mohammadnawaz51 

    What is your Acumatica version? From version 2024 I see the Trial Balance report has "From Period" & "To Period".

     

     

    Account Details: This report correctly displays data according to "From Period" - "To Period". This report even allows filtering by "From Date" - "To Date"

     

    Best Regards,

    NNT

    I have devoted a great deal of my time and passion to Acumatica ! 🌐https://www.linkedin.com/in/phambaotruong
      mohammadnawaz51
      Jr Varsity II
      Forum|alt.badge.img+6

      ​@nhatnghetinh ​@mohammadnawaz51 I am looking for webservice end point to pull the data.

      https://www.acumatica.com/acumatica-marketplace/global-payex-ap-accounts-payable-automation-solution/
        mohammadnawaz51
        Jr Varsity II
        Forum|alt.badge.img+6

        ​@darylbowman Any Help here?

        https://www.acumatica.com/acumatica-marketplace/global-payex-ap-accounts-payable-automation-solution/
          Manikanta Dhulipudi
          Captain II
          Forum|alt.badge.img+16

          ​@mohammadnawaz51 I dont think end points is available for reports.

          Acumatica Functional Consultant & Customer Experience Supervisor
            meganfriesen37
            Captain II
            Forum|alt.badge.img+13

            For Reporting, I usually use the following DAC’s to get the information I need

            • GL History - this has the ending balances for any period with transactions
            • GL History by Period - this will help fill in the gaps for any periods without transactions
            Megan Friesen, Contego Software Solutions, Canada
              mohammadnawaz51
              Jr Varsity II
              Forum|alt.badge.img+6

              ​@meganfriesen37 I am trying to pull the data using the From date and TO date with API but data returning zero.

               

              • FromPeriod
              • ToPeriod
              https://www.acumatica.com/acumatica-marketplace/global-payex-ap-accounts-payable-automation-solution/
              meganfriesen37
              Captain II
              Forum|alt.badge.img+13

              ​@mohammadnawaz51 The history tables only have the balances on a period basis and not on a date specific basis.  For that, I think you’d need to look at something custom or some type of calculation that you’d have to program into your report.  The opening/closing balances calculated on the Account Details tab are not available to pull onto reports.

              Megan Friesen, Contego Software Solutions, Canada
                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