Skip to main content
Answer

Running Balance Quota vs Sales

  • October 3, 2022
  • 2 replies
  • 123 views
J
Freshman II

Hi All,

 

I am trying to create a report that can show what is our running balances on sales to meet our quota, i use invoices and memos as my references for the report, and group it by doc type, and on the formula for the running balances is =IIf([ARInvoice.DocType]='CRM', 10000000+SUM([ARInvoice.CuryLineTotal]), IIf([ARInvoice.DocType]='INV', ((10000000-SUM([ARInvoice.CuryLineTotal]))*(-1)), IIf([ARInvoice.DocType]='DRM', ((10000000-SUM([ARInvoice.CuryLineTotal]))*(-1)), 0)))

how can i end up on the correct report for this 

 

Best answer by lauraj46

Hi @Jov29 ,

I don’t think it’s possible to calculate a running total in a Generic Inquiry.  You could do this in the Report Designer by using variables.  

Laura

    2 replies

    lauraj46
    Captain II
    Forum|alt.badge.img+8
    • lauraj46
    • Captain II
    • Answer
    • October 3, 2022

    Hi @Jov29 ,

    I don’t think it’s possible to calculate a running total in a Generic Inquiry.  You could do this in the Report Designer by using variables.  

    Laura

    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*.
    Laura03
    Chris Hackett
    J
    J
    Freshman II
    • Jov29
    • Author
    • Freshman II
    • October 3, 2022

    Hi @Jov29 ,

    I don’t think it’s possible to calculate a running total in a Generic Inquiry.  You could do this in the Report Designer by using variables.  

    Laura

    Hi Laura, 

     

    Thanks for responding, i will try to use report designer for the running total. 

    Chris Hackett
    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