Opening Balance (Accounts/Stock)

[Shaikh Atta Ur Rahman]

Hi, I want to have an opening balance of my product stock or any customer account but i cannot get the idea of what calculation can be used. I am using a list view of the products where the balances are coming from the transaction table.

 

Required E.g

For Products Stock (The opening calculation idea is required.

Product	Opening Stock (Required)	Purchased	Sold	Balance
APPLES	10	08	02	16
ORANGES	50	90	30	110

[Fitch]

Not sure what you're asking. You want to calculate the Opening Stock?

Balance + Sold - Purchased

[Shaikh Atta Ur Rahman]

Hello, I want to have the closing balance (of previous day) in the current day Opening Stock field and this will be the formula for the current day Opening Stock+Purchased-Sold=Balance