pcsoft.us.windevCopyright 2026, PC SOFT20 May 2017 13:12:00 Z18 May 2017 15:23:00 ZHello, This reports got four columns, Date, Particular, Debit Amount, Credit Amount. At the end of each day, totals need to be displayed for Debit Amount & Credit Amount and Balance Amount deducting Debit Amount from Credit Amount, after Date total. Only this balance amount need to be taken for the next day total. And this balance amount could appear either @ Debit Amount column or @ Credit Amount column. Date Particulars Debit Amount Credit Amount 17.08.2017 Paid to Mr.X 10,000.00 0.00 17.08.2017 Billing To Mr. Y, No. 234 0.00 50,000.00 17.08.2017 Purchase from Mr. Z 45,000.00 0.00 ---------------- -------------------- Total 55,000.00 50,000.00 Balance 5,000.00 18.08.2017 Receipt from Mr Y 10,000.00 18.08.2017 Sales to Mr. Q 22,000.00 -------------- ------------------- Total 5,000.00 32,000.00 Balance 27,000.00 19.09.2017 Payment to Mr. E 30,000.00 0.00 -------------- ------------------- Total 30,000.00 27,000.00 Balance 3,000.00 Any idea to arrive totals such as above, is really appreciable. Happiness Always BKR Sivaprakash30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60939-wd21-hfsql21-date-total-arrive-after-taking-balance/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60939-wd21-hfsql21-date-total-arrive-after-taking-balance-60963/read.awp20 May 2017 13:12:00 ZThanks Steven, Got the idea. I'll experiment. Names are self explanatory. Happiness Always BKR Sivaprakashhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60939-wd21-hfsql21-date-total-arrive-after-taking-balance-60963/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60939-wd21-hfsql21-date-total-arrive-after-taking-balance-60963/read.awp[WD21] [HFSQL21] Date total to arrive after taking balance of previous dateguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60939-wd21-hfsql21-date-total-arrive-after-taking-balance-60962/read.awp20 May 2017 12:30:00 ZHi Sivaprakash, You can add whatever code you like, as long as what you get, is what you expect :) But you must understand how…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60939-wd21-hfsql21-date-total-arrive-after-taking-balance-60962/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60939-wd21-hfsql21-date-total-arrive-after-taking-balance-60962/read.awp[WD21] [HFSQL21] Date total to arrive after taking balance of previous dateguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60939-wd21-hfsql21-date-total-arrive-after-taking-balance-60961/read.awp20 May 2017 08:29:00 ZThanks Steven, Here my need to add the Day Balance (DayDebit - DayCredit) to next day's balance. Can I set, If Daydebit > …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60939-wd21-hfsql21-date-total-arrive-after-taking-balance-60961/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60939-wd21-hfsql21-date-total-arrive-after-taking-balance-60961/read.awp[WD21] [HFSQL21] Date total to arrive after taking balance of previous dateguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60939-wd21-hfsql21-date-total-arrive-after-taking-balance-60956/read.awp19 May 2017 18:00:00 ZHi Sivaprakash, 1. Create a report - SORT by Date and also create a BREAK (on the Date field) 2. Declare the following var…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60939-wd21-hfsql21-date-total-arrive-after-taking-balance-60956/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60939-wd21-hfsql21-date-total-arrive-after-taking-balance-60956/read.awp[WD21] [HFSQL21] Date total to arrive after taking balance of previous dateguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60939-wd21-hfsql21-date-total-arrive-after-taking-balance-60947/read.awp19 May 2017 06:52:00 ZThanks José Antonio. But here it's not possible. We need to arrive it every time when a report is requested. Not possible to …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60939-wd21-hfsql21-date-total-arrive-after-taking-balance-60947/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60939-wd21-hfsql21-date-total-arrive-after-taking-balance-60947/read.awp[WD21] [HFSQL21] Date total to arrive after taking balance of previous dateguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60939-wd21-hfsql21-date-total-arrive-after-taking-balance-60944/read.awp18 May 2017 21:33:00 ZHi. In that case I think that is a good practice to store the calculations into the database. For example you can do it once a …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60939-wd21-hfsql21-date-total-arrive-after-taking-balance-60944/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60939-wd21-hfsql21-date-total-arrive-after-taking-balance-60944/read.awp[WD21] [HFSQL21] Date total to arrive after taking balance of previous date