How to put a RunningTotal in ERP Navision 2009 Report like Customer Transaction Detail Report?

xhirvana
xhirvana Member Posts: 5
in NAV/Navision Classic Client
Hi I am a Beginner here, we have a Customer Transaction Details Report in our ERP Navision 2009, which has Amount & Remaining Amount (LCY) Column. My Boss requested me to put another column for Running Total/Cumulative Sum for the Remaining Amount (LCY). Please, any advice how to put this? Thank you.

Best Answer

  • aripermadi
    aripermadi Member Posts: 9
    Answer ✓
    create a variable to store the cumulative sum and assign the value on OnafterGetRecord of your detail data item .

    example : RemAmoutLCYSUM := RemAmoutLCYSUM + Remaining Amount (LCY)

    use the variable as expression for your new column

Answers

  • aripermadi
    aripermadi Member Posts: 9
    Answer ✓
    create a variable to store the cumulative sum and assign the value on OnafterGetRecord of your detail data item .

    example : RemAmoutLCYSUM := RemAmoutLCYSUM + Remaining Amount (LCY)

    use the variable as expression for your new column
  • xhirvana
    xhirvana Member Posts: 5
    Thank you! We have upgraded now to Business Central🙏

Categories