User Profile

Collapse

Profile Sidebar

Collapse
SheikhAltaf
SheikhAltaf
Last Activity: Oct 19 '21, 05:47 AM
Joined: Oct 17 '21
Location: Pakistan
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • SheikhAltaf
    replied to How to Calculate opening balance in all ledger accounts
    in Access
    Thanks for response.
    Dr means Receipts and Cr means Payments i.e,

    [B]1-Capital - Ledger Account|[B]
    Opening balance Rs10000
    01-01-2021 DR Receipt 1000 Total balance Rs.11,000
    20-01-2021 CR Payments 2000 Total balance Rs.9,000

    2-Assets - Ledger Account
    Opening balance Rs-15,000
    01-01-2021 CR Payments -1000 Rs.-16,000
    20-01-2021 DR Receopts 2000 Rs.-14,000

    ...
    See more | Go to post

      Leave a comment:

    • SheikhAltaf
      started a topic How to Calculate opening balance in all ledger accounts
      in Access

      How to Calculate opening balance in all ledger accounts

      Dear all,
      I am unable to calculate running Dsum of opening balance of ledger accounts (above 200 ledgers)
      =Nz(DSum("[Debit]-[Credit]","qry_OpeningB alance"),0)
      this works very well only for single ledger account, but not working for all ledger accounts in report, for example, i want to see ledgers of 2 accounts i.e Capital and Assets

      1-Capital
      Opening balance Rs10000
      01-01-2021...
      See more | Go to post
      No activity results to display
      Show More
      Working...