i want opening balance to show in ledger title but while fetching formula its show opening balance of that month only. i want the opening balance of starting of fiscal year of that ledger. The below formula is not showing so please help me $OpeningBalance:Ledger:##LedgerName
That's what I am asking. Just change period by F2 From Date : 1-Apr-20xx And then check what opening balance showing with Ledger Name...
Code: Set As : $$FromValue:@@MybeginDate:$$ToValue:@@MyEndDate:$OpeningBalance:Ledger:##LedgerName Then make a System formula..........specifying the begin and end dates as your Financialyear beginning.
Not Able to Bring Opening of Matched and Unmatched Voucher properly when we change date or select period . Please help
It should change....normally..... but then it depends on how you have set the FROM and TO date in Report level. Cannot comment further --- without looking at the code.
Find any report in Developer............. OR Search for SVFromDate in Developer........... pick the one that has FinYearBegin or something like that............
amit sir i got what i wanted. thank you for your guide. it was like Set As: $$FromValue:"01-04-2020":$OpeningBalance:Ledger:##LedgerName
This is manual........ what will you do for next year ???? So use $$FinYrBegin instead of manual date. Set As: $$FromValue@FinYrBeginDt:$OpeningBalance:Ledger:##LedgerName {System : Formula] FinYrBeginDt : $$FinYearBeg:##SVCurrentDate:$StartingFrom:Company:##SVCurrentCompany Whenever possible.... always make the codes DYNAMIC not Static.