May 3, 20196 yr Newbies 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
May 3, 20196 yr Not sure what you're asking. You want to calculate the Opening Stock? Balance + Sold - Purchased
July 1, 20196 yr Author Newbies 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
Create an account or sign in to comment