Skip to main content
Solved

Create a Journal Voucher Report

  • Mar 19, 2026 8:35 AM UTC
  • 7 replies
  • 95 views
  • Translate All
sabrinarzk
Freshman I

Hi,
I am trying to create a Journal Voucher report from the Journal Voucher (GL304000) screen.

Inside the report, I wanted to see the GL Transaction, pulling it out from Journal Voucher > GL Transaction

 


 


My report details missing.
 

 

Best answer by lauraj46

Hi ​@sabrinarzk ,

That's odd.  I tested the report that I attached with demo data and it printed the detail.  Have you tried using a GI to validate the report designer schema?  You can also use the Source Data option in the DAC Schema Browser to open GLDocBatch, GLTranDoc and GLTran and explore the data.   Choose a BatchNbr and walk it through to validate.  Note that the RefNbr on the GLDocBatch is not the same RefNbr on the GLTran itself.  That is we you need to link through GLTranDoc.

Hope this helps!

Laura 

View original
SR

    7 replies

    lauraj46
    Captain II
    Forum|alt.badge.img+9
    • lauraj46
    • Captain II
    • Mar 19, 2026 11:01 AM UTC

    Hi ​@sabrinarzk ,

    Can you please attach the rpx file for your report?

    Translate
    Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
      sabrinarzk
      Freshman I
      • sabrinarzk
      • Author
      • Freshman I
      • Mar 26, 2026 2:42 AM UTC

      Hi Laura,
      Attached the rpx file.

      Translate
      SR
      lauraj46
      Captain II
      Forum|alt.badge.img+9
      • lauraj46
      • Captain II
      • Mar 26, 2026 1:09 PM UTC

      Hi ​@sabrinarzk ,

      Thanks for sharing your report.  The BatchNbr field on the GLDocBatch field does not correspond to the BatchNbr on the transaction itself.  You need to use the GLTranDoc table as an intermediary table to get the correct linkages.  The revised version of the report is attached.  Hope this helps!

      Laura

      Translate
      Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
        sabrinarzk
        Freshman I
        • sabrinarzk
        • Author
        • Freshman I
        • Mar 31, 2026 3:50 AM UTC

        Hi Laura,
        I amend the report using your revised version, but the line details still do not appear on the report.

        Translate
        SR
        lauraj46
        Captain II
        Forum|alt.badge.img+9
        • lauraj46
        • Captain II
        • Mar 31, 2026 11:27 AM UTC

        Hi ​@sabrinarzk ,

        Do the joins match exactly, or have you tested using the version that I uploaded?  On my demo data, the report did show details.  You could also test in a GI, using only the three tables GLDocBarch, GLTranDoc and GLTran.  Give that a try and let me know how it goes.

        Laura 

        Translate
        Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
          sabrinarzk
          Freshman I
          • sabrinarzk
          • Author
          • Freshman I
          • Apr 7, 2026 9:42 AM UTC

          Hi Laura,
          I tested using the three tables GLDocBatch, GLTranDoc, and GLTran, but it failed.

          The GLTran details fails to load in the form.

          Translate
          SR
          lauraj46
          Captain II
          Forum|alt.badge.img+9
          • lauraj46
          • Captain II
          • Answer
          • Apr 7, 2026 11:25 AM UTC

          Hi ​@sabrinarzk ,

          That's odd.  I tested the report that I attached with demo data and it printed the detail.  Have you tried using a GI to validate the report designer schema?  You can also use the Source Data option in the DAC Schema Browser to open GLDocBatch, GLTranDoc and GLTran and explore the data.   Choose a BatchNbr and walk it through to validate.  Note that the RefNbr on the GLDocBatch is not the same RefNbr on the GLTran itself.  That is we you need to link through GLTranDoc.

          Hope this helps!

          Laura 

          Translate
          Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If 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