Very beautifully done Pankaj..... A few suggestions...... a. In your Border definitions....use "FULL" so that the horizontal lines are flush with vertical ones. b. Use --- Color : If $$IsDr:#OpBalance Then "Blue" Else "Red" to visually identify DR n CR Amts. c. Add one column for OTHERS which will contain Journals n Payments (adjustments entries if any). d. Remove GROUP column and try to put that above the Column title,so you get more space in Data Report area. e. You can also put Invisible formula to hide columns if there are none data to display. If you are stuck, let me know.
Respective Amit Kamdarji, please help, negative Quantity field no symbol (-) then color & background highlighted
Please use appropriate forum....so that other members can follow the line.............. you have already made a POST on this topic...so kindly use the same.......
can u plz set formulas net sale = opening balance+sale amount and total (Rec-Dis)= Net sale-receipt -discount and ClosingBalance=net sale-total receipt
Respective Amitji, Above screenshot problems solve, but my problem is not contra voucher debit & credit amount seprataly
If your problem is not contra voucher debit & credit amount seprataly .... then what is the real problem??? didn't get you..
Filter out the debits n credits...... However the TOTALS would be same....but one debit and other credit
pease send filter formula Aggr Compute:ContraDebitExtract :Sum:if $$IsContra:$VoucherTypeName THEN $Amount ELSE ""