Skip to main content
Solved

Breakout the sum of different "Doc. Types" on invoice

mike2665
Jr Varsity III
Forum|alt.badge.img

We are trying to get the Applications Lines to print on our invoice. (See below, 1,2,3,4) Then at the bottom will be the sum of Prepayments and Credits. Struggling to create a SWITCH formula or by Sorting and Grouping. Or should I create a subreport to handle this? Has anyone successfully created this in a report?

 

 

 

Best answer by meganfriesen37

On the Main Report, on the Subreport:
 

  • Does your Report Name match the name of the subreport file as you’ve saved it in your Acumatica environment?
  • Have you populated your subreport parameters correctly on the main report?
    • I have also seen some weird things when you use the stock “print” option from the AR Invoice screen and if you use @DocType or @RefNbr those fields don’t always flow through correctly.  You should use ARInoivce.DocType and ARInvoice.RefNbr to feed through to the subaccount (it will work if you go to the main report page and do it, but not from the stock “print” button).
View original
    robk20
    1 person likes this
    • robk20
      robk20
    Did this topic help you find an answer to your question?

    3 replies

    meganfriesen37
    Captain II
    Forum|alt.badge.img+12

    Try a sub report and then have a variable in your subreport that totals the amount paid that you can reference back in your main invoice

    Megan Friesen, Contego Software Solutions, Canada
    Chris Hackett
    mike2665
    2 people like this
    • Chris Hackett
      Chris Hackett
    • mike2665
      mike2665
    mike2665
    Jr Varsity III
    Forum|alt.badge.img
    • mike2665
    • Author
    • Jr Varsity III
    • 19 replies
    • April 25, 2023

    I have created my subreport but my data form the Reference Number column is not populating when I run the report. Here are my schema settings, can someone take a look to see what I am missing?

     

    meganfriesen37
    Captain II
    Forum|alt.badge.img+12

    On the Main Report, on the Subreport:
     

    • Does your Report Name match the name of the subreport file as you’ve saved it in your Acumatica environment?
    • Have you populated your subreport parameters correctly on the main report?
      • I have also seen some weird things when you use the stock “print” option from the AR Invoice screen and if you use @DocType or @RefNbr those fields don’t always flow through correctly.  You should use ARInoivce.DocType and ARInvoice.RefNbr to feed through to the subaccount (it will work if you go to the main report page and do it, but not from the stock “print” button).
    Megan Friesen, Contego Software Solutions, Canada
    Chris Hackett
    mike2665
    2 people like this
    • Chris Hackett
      Chris Hackett
    • mike2665
      mike2665

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    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