Hello Everyone In Tally Voucher entry screen if you are doing Sales entry and you see Current Turnover Amount,that gives wrong Amount as Formula set Total of Debit Amount and not Only Sales Amount. If you have any Debit Transaction other then Sales in that particular Party Ledger then that is also consider in Current Turnover. And also not working for Purchase Party i.e. Sundry Creditor. Request you all to check & reply.
I am getting the correct figures......... passed sales for 15k on 15-june passed receipt for 2k when passing another sales on 30-Jun..........it shows correct.......please check your settings...
Tried in ERP9 .........working fine. Try.....unloading one TDL at a time and find the culprit, if any.
Also when trying yours........I was facing a problem in making sales entry.... Dr/Cr mismatch......... so have to find the cause now. I also checked....code for TURNOVER is same in both.
Pass one Payment entry for Cheque Return or Journal entry for Discount Debiting Sales Party (Sundry Debtor) then check you will get Turnover with that Receipt or Journal Amount e.g. Sales 1,00,000/- Payment 10,000/- (As cheque Return) Discount 500/- you will get Turnover (this yr) 1,10,500/- Please check.
For Creditors there is no Separate Formula... Same Formula... So for Creditors we will get Payment Amount or Debit Side Total Amount and not Credit Side...
You will grow OLD and die.....waiting for them ..........make your own way........ TRY THIS......... Code: [#Field: EI CurrentTurnover] Local : Field : Amount Forex Field : Delete : Set As Local : Field : Amount Forex Field : Set as : If $$IsLedOfGrp:#EIConsignee:$$GroupSundryDebtors Then + @@RevisedEITurnoverS Else @@RevisedEITurnoverP [#Object: Ledger] RevCurrTurnoverSale : $$ToValue:##SVCurrentDate:$$FilterAmtTotal:VouchersOfEILedger:IsEISale:$$AsPositive:$Amount RevCurrTurnoverPurc : $$ToValue:##SVCurrentDate:$$FilterAmtTotal:VouchersOfEILedger:IsEIPurc:$$AsPositive:$Amount RevCurrTurnoverDrNt : $$ToValue:##SVCurrentDate:$$FilterAmtTotal:VouchersOfEILedger:IsEIDrNt:$$AsPositive:$Amount RevCurrTurnoverCrNt : $$ToValue:##SVCurrentDate:$$FilterAmtTotal:VouchersOfEILedger:IsEICrNt:$$AsPositive:$Amount [System: Formula] RevisedEITurnoverS : $RevCurrTurnoverSale:Ledger:#EIConsignee - $RevCurrTurnoverCrNt:Ledger:#EIConsignee RevisedEITurnoverP : $RevCurrTurnoverPurc:Ledger:#EIConsignee - $RevCurrTurnoverDrNt:Ledger:#EIConsignee IsEISale : $$IsSales:$VoucherTypeName IsEIPurc : $$IsPurchase:$VoucherTypeName IsEIDrNt : $$IsDebitNote:$VoucherTypeName IsEICrNt : $$IsCreditNote:$VoucherTypeName [Collection : VouchersOfEILedger] Type : Vouchers : Ledger Child Of: #EIConsignee Fetch : Name, Amount
I have netted off -- Sales with CN and Purchase with DN .......... you can adopt / change as per your requirement.