Pls help me in the syntax

  1. IF I CHOOSE A PARTICULAR [MATERIAL] eg… CEMENT I NEED THE CLOSING BALANCE FOR THAT PATICULAR MATERIAL.
  2. PREVIOUS DAY CLOSING BALANCE SHOULD BE NEXT DAYS OPENING BALANCE FOR THAT PARTICULAR MATERIAL.
    PLS. HELP ME WITH THE SYNTAX .
    THANKS IN ADVANCE, :slight_smile:

Create a VC with MAXROW() expression to establish a reference with the last record and then simply use a de-reference in the initial value.

2 Likes