I have "KGS" and "Pieces" as two separate units for my stock line items. There is no link between the two units. That is to say, this is not a case where a certain number of "PCS" = 1 KGS . In my existing stock summary report, for Fabric A for example, I have both units listed in separate line items. However, in the closing balance column, Tally is not adding up the quantities separately. The default configuration appears to be to add up only when there is a single type of unit for that stock item. This sounds like something which would be pretty common for many businesses. Can you please advise if there is some configuration within Tally, which can help activate this? Thank you. Dev P
In Tally , Qty field is stored with Unit, So Stock Items which is having Diff. Units cannot adding the qty's, no sum will come, By Default tally cannot do this Stil if u want sum stockitems having Diff. Units u can do through customisation, convert the Both stockitems as Number then u can add n arrive total qty value.
Dear NAGARAJKMAR SUBRAMANIAN Its done... Thanks a lot, your suggestion helps me a lot. Finally i had achieved my goal. Thank you so much.
Dear NAGARAJKMAR SUBRAMANIAN I had already got some useful help from you. Thank you for the entire help. Right now i am working on a report by modifying Tally solutions sample txt file. at final moment i got hang up. Can you please tell the issue to get ride of there. Please see attached files. Issues: Forecast column will report memo voucher total ledger wise, And Sales column will show Party Sales voucher total. Please check and revert i am at zakirhossain.edu@gmail.com Thank You [#Menu : Gateway Of tally] Key Item: My STM TB : M : Display : AutoCol Trial Balance ;;: My Trial Balance [Report: AutoCol Trial Balance] ;; Title : $$LocaleString:"Trial Balance" Form : AutoCol Trial Balance Set : GroupName : "Sundry Debtors" Repeat : SVCurrentCompany, SVFromDate, SVToDate ColumnReport: MyMultiColumns1 Variable : AutoCol TB Group, IsLedgerWise, SVPeriodicity PrintSet : Report Title : $$LocaleString:"Trial Balancesss" Set : IsLedgerWise : No [Form: AutoCol Trial Balance] Button : ExplodeFlag, F2ChangePeriod, ChangeCompany, LedgerWiseButton Keys : ChangePeriod BottomButton: MyAutoButton, BlankButton, InvReports, AcctReports, ReportOperations, FilterButton, ValueButton Buttons : PrintButton, ExportButton, UploadButton, MailButton Parts : AutoCol TB Title, AutoCol TB Details Page Break : DSP ClPageBreak, AutoCol TB OpPgPart Height : 100% Page Width : 100% Page Space Top : 0 Space Left : 0 Background : Released Pale Yellow Option : Prn AutoCol TB : $$InPrintMode [!Form: Prn AutoCol TB] Add : Parts : At Beginning : DSP CompanyName, DSP CompanyAddress, DSP ReportTitle Space Left : 0.25 inch [Part: AutoCol TB OpPgPart] Parts : DSP CompanyName, DSP CompanyAddress, DSP ReportTitle, AutoCol TB Title Vertical : Yes [Part: AutoCol TB Title] Lines : AutoCol TB Title1, AutoCol TB Title2, AutoCol TB Title3, AutoCol TB STitle Border : Thin Top [Line: AutoCol TB Title1] Use : AutoCol TB Title3 Local : Field : Name Field : Set as : "" Local : Field : AutoCol TB DrAmt Field : Set as : @@CmpMailName Local : Field : AutoCol TB DrAmt Field : Lines : 0 Local : Field : AutoCol TB DrAmt Field : Border : Thin Left Invisible : $$IsCommon:SVCurrentCompany AND $$InPrintMode [Line: AutoCol TB Title2] Use : AutoCol TB Title3 Local : Field : Default : Style : Normal Local : Field : Name Field : Set as : $$LocaleString:"Particulars" Local : Field : Name Field : Style : Normal Bold Local : Field : Name Field : WideSpaced : Yes Local : Field : AutoCol TB DrAmt Field : Set as : @@DSPDateStr Local : Field : AutoCol TB DrAmt Field : Border : Left Full Thin Bottom [Line: AutoCol TB Title3] Fields : Name Field, AutoCol TB DrAmt Field Local : Field : Default : Type : String Local : Field : Name Field : Set as : "" Local : Field : Name Field : Align : Center Local : Field : AutoCol TB DrAmt Field : Align : Centre Local : Field : AutoCol TB DrAmt Field : Border : Left Full Thin Bottom Local : Field : AutoCol TB DrAmt Field : Set as : $$LocaleString:"Variance Report" Repeat : AutoCol TB DrAmt Field [Line: AutoCol TB STitle] Fields : Name Field, AutoCol TB Amount Field Local : Field : Default : Style : Normal Local : Field : Default : Align : Centre Local : Field : Default : Type : String Local : Field : Name Field : Set as : "" Local : Field : AutoCol TB Forecastamt Field : Set as : $$LocaleString:"Forecast" Local : Field : AutoCol TB Forecastamt Field : Border: Thin Right Local : Field : AutoCol TB DrAmt Field : Set as : $$LocaleString:"Sales" Local : Field : AutoCol TB Variance Field : Set as : $$LocaleString:"Variance" Local : Field : AutoCol TB Variance2 Field : Set as : $$LocaleString:"Variance2" Local : Field : AutoCol TB CrAmt Field : Set as : $$LocaleString:"Collection" Local : Field : AutoCol TB CrAmt Field : Border : Thin Left Repeat : AutoCol TB Amount Field Border : Thin Bottom [Part: AutoCol TB Details] Lines : AutoCol TB Details BottomLines : AutoCol TB Total Repeat : AutoCol TB Details : AutoCol TB GroupLed Total : AutoCol TB DrAmt Field, AutoCol TB CrAmt Field Scroll : Vertical CommonBorder: Yes Float : Yes Page Break : AutoCol TB ClPgLine, AutoCol TB OpPgLine Option : AutoCol TB Details Led : ##IsLedgerWise ;; Part Level Page Breaks is introduced to have Page Totals ;; at the beginning (except first page) and end (except last page) ;; of every page ;; The optional part is selected when Ledgerwise is selected by the user. [!Part: AutoCol TB Details Led] Repeat : AutoCol TB Details : AutoCol TB Led Local : Collection: AutoCol TB Led : BelongsTo : Yes [Line: AutoCol TB ClPgLine] ;; Line for Closing Page Totals Use : AutoCol TB Details Delete : Fields : AutoCol TB Amount Field Add : Fields : AutoCol TB AmountSTField Delete : Repeat : AutoCol TB AmountSTField Add : Repeat : AutoCol TB AmountSTField Local : Field : Default : Style : Normal Bold Local : Field : AutoCol TB Name Field : Set as : "Carried Over" Local : Field : AutoCol TB Name Field : WideSpaced : Yes Local : Field : AutoCol TB ForecastAmtSTField: Set as : $$Total:AutoColTBForecastAmtField Local : Field : AutoCol TB DrAmtSTField: Set as : $$Total:AutoColTBDrAmtField Local : Field : AutoCol TB DrAmtSTField: Border : Totals Local : Field : AutoCol TB VarianceSTField: Set as : $$Total:AutoColTBVarianceField Local : Field : AutoCol TB Variance2STField: Set as : $$Total:AutoColTBVariance2Field Local : Field : AutoCol TB CrAmtSTField: Set as : $$Total:AutoColTBCrAmtField Local : Field : AutoCol TB CrAmtSTField: Border : Totals Space Top : 1 [Line: AutoCol TB OpPgLine] ;; Line for Opening Page Totals Use : AutoCol TB ClPgLine Local : Field : AutoCol TB ForecastAmtSTField: Delete : Border Local : Field : AutoCol TB DrAmtSTField: Delete : Border Local : Field : AutoCol TB VarianceSTField: Delete : Border Local : Field : AutoCol TB Variance2STField: Delete : Border Local : Field : AutoCol TB CrAmtSTField: Delete : Border Local : Field : AutoCol TB Name Field : Set as : "Brought Foward" Space Top : 0 Space Bottom: 1 [Field: AutoCol TB AmountSTField] ;; New Field Definition for the Page Totals Fields : AutoCol TB ForecastAmt STField, AutoCol TB DrAmt STField, AutoCol TB Variance STField, AutoCol TB Variance2 STField, AutoCol TB CrAmt STField Border : Thin Left [Field: AutoCol TB ForecastSTField] Use : AutoCol TB Forecast Field [Field: AutoCol TB Variance STField] Use : AutoCol TB Variance Field [Field: AutoCol TB Variance2 STField] Use : AutoCol TB Variance2 Field [Field: AutoCol TB DrAmtSTField] Use : AutoCol TB DrAmt Field [Field: AutoCol TB CrAmtSTField] Use : AutoCol TB CrAmt Field [Line: AutoCol TB Details] Fields : AutoCol TB Name Field, AutoCol TB Amount Field Local : Field : AutoCol TB Name Field : Set as : $$Name ;;$$Name Local : Field : AutoCol TB ForecastAmt Field : Set as : $DebitTotals ;;Local : Field : AutoCol TB ForecastAmt Field : mysrchkey : $mDate + $LName Local : Field : AutoCol TB DrAmt Field : Set as : $DebitTotals ;;$DebitTotals ;;if $$IsDr:$ClosingBalance then $ClosingBalance else 0 Local : Field : AutoCol TB Variance Field : Set as : $CreditTotals-$DebitTotals ;;if $$IsDr:$ClosingBalance then $ClosingBalance else 0 Local : Field : AutoCol TB Variance2 Field : Set as : $$String:$VarrianceRate + "%";;(($DebitTotals / $CreditTotals) * 100) + "%";;if $$IsDr:$ClosingBalance then $ClosingBalance else 0 Local : Field : AutoCol TB Variance2 Field : Alignment : Right Local : Field : AutoCol TB CrAmt Field : Set as : $CreditTotals ;;if $$IsDr:$ClosingBalance then 0 else $ClosingBalance Repeat : AutoCol TB Amount Field Explode : DD TB Group Explosion1 : ##ExplodeFlag or $$KeyExplode [System: Formula] VarrianceRate : (($DebitTotals / $CreditTotals) * 100) ;;explode part [Part: DD TB Group Explosion1] Lines: DD TB Group Explosion1 Repeat: DD TB Group Explosion1 : DD TB GroupsLedgers ;;AutoCol TB Led ;;Local : Collection: Autocol TB Led : BelongsTo : Yes [Line: DD TB Group Explosion1] Fields: AutoCol TB Name Field, AutoCol TB Amount Field Explode: DD TB Group Explosion1 : $$IsGroup And ($$Keyexplode Or ##ExplodeFlag) Indent: 2 * $$ExplodeLevel Local: Field: Default: Delete: Border Repeat : AutoCol TB Amount Field ;;Explode part end [Field: AutoCol TB Name Field] Use : Name Field Variable : AutoCol TB Group Display : AutoCol Trial Balance : $$IsGroup Option : AutoCol TB LedName Field Led : $$IsLedger Option : Autocol TB LedName Field Grp : $$IsGroup [!Field: AutoCol TB LedName Field Led] Variable : LedgerName Display : Ledger Monthly Summary Style : Normal Italic [!Field: AutoCol TB LedName Field Grp] Variable : DDGroupName1 ;;LedgerName Display : DD Trail Balance ;;Style : Normal Italic [Field: AutoCol TB Amount Field] Fields : Autocol TB Forecastamt Field, AutoCol TB DrAmt Field, Autocol TB Variance Field, Autocol TB Variance2 Field, AutoCol TB CrAmt Field Border : Thin Left Display : AutoCol Trial Balance : $$IsGroup Display : Ledger Monthly Summary : $$IsLedger [Field: AutoCol TB Forecastamt Field] Use : Amount Field Style : Normal [Field: Autocol TB Variance Field] Use : Amount Field Style : Normal [Field: Autocol TB Variance2 Field] Use : Name Field Style : Normal [Field: AutoCol TB DrAmt Field] Use : Amount Field Style : Normal [Field: AutoCol TB CrAmt Field] Use : Amount Field Style : Normal [Collection: AutoCol TB GroupLed] Collection : AutoCol TB Group, AutoCol TB Led [Collection: AutoCol TB Group] Type : Group Child Of : ##AutoColTBGroup Filter : NoProfit Fetch : Name, ClosingBalance [Collection: AutoCol TB Led] Type : Ledger Child Of : ##AutoColTBGroup Filter : NoProfit [Variable: AutoCol TB Group] Type : String Default : "Sundry Debtors" Volatile : Yes ;; [System: Formula] ;; NoProfit : NOT $$IsLedgerProfit AND $ClosingBalance > 0 [Line: AutoCol TB Total] Use : AutoCol TB Details Local : Field : Default : Style : Normal Bold Local : Field : AutoCol TB Name Field : Set as : "GRAND TOTAL" Local : Field : AutoCol TB Name Field : WideSpaced : Yes Local : Field : AutoCol TB Name Field : Align : Centre Local : Field : AutoCol TB Forecastamt FIeld : Set as : $$Total:AutoColTBForecastamtField Local : Field : AutoCol TB DrAmt Field : Set as : $$Total:AutoColTBDrAmtField Local : Field : AutoCol TB Variance Field : Set as : $$Total:AutoColTBVarianceField Local : Field : AutoCol TB CrAmt Field : Set as : $$Total:AutoColTBCrAmtField Border : Flush Totals Fixed : No Space Top : 1 [Report: MyMultiColumns1] Title : $$LocaleString:"Column Details" [Form: MyMultiColumns1] No Confirm : Yes Full Width : No Space Right : 0.25 Background : @@SV_UNBLUE Parts : My MultiColumns1 Option : Small Size Form [Part: My MultiColumns1] Lines : Form SubTitle, My MultiCompany, My MultiFromDate, My MultiToDate Local : Field : Form SubTitle : Info : $$LocaleString:"Column Details" [Button: MyAutoButton] Key : Alt+N Action : Auto Columns : MyAutoColumns1 Title : $$LocaleString:"Auto Column" Inactive : $$NumItems:MyAutoColumns1 < 1 [Collection: MyAuto Columns1] Title : $$LocaleString:"Column Details" Object : MyCurrentCompany, MyQuarterly, MyMonthly, MyYearly, MyHalfYearly Filter : Belongs Format : $$Name, 15 Client Only : Yes [Object: MyCurrentCompany] Name : $$LocaleString:"Company" VarName : "SVCurrentCompany" CollName : "List of Primary Companies" BelongsIf : $$NumItems:ListOfPrimaryCompanies > 1 IsAgeWise : No Periodicity : "" [Object: MyQuarterly] Name : $$LocaleString:"Quarterly" VarName : "SVFromDate, SVToDate" CollName : "Period Collection" BelongsIf : "Yes" IsAgeWise : No Periodicity : "3 Month" [Object: MyHalfYearly] Name : $$LocaleString:"Half-Yearly" VarName : "SVFromDate, SVToDate" CollName : "Period Collection" BelongsIf : "Yes" IsAgeWise : No Periodicity : "6 Month" [Object: MyMonthly] Name : $$LocaleString:"Monthly" VarName : "SVFromDate, SVToDate" CollName : "Period Collection" BelongsIf : "Yes" IsAgeWise : No Periodicity : "Month" [Object: MyYearly] Name : $$LocaleString:"Yearly" VarName : "SVFromDate, SVToDate" CollName : "Period Collection" BelongsIf : "Yes" IsAgeWise : No Periodicity : "Year" [Report: MyAutoColumns1] Auto : Yes Title : $$LocaleString:"Auto Repeat Columns" [Form: MyAutoColumns1] No Confirm : Yes Full Width : No Space Top : 1 Space Bottom: 1 Space Left : 1 Space Right : 1 Background : @@SV_UNYELLOW Parts : My AutoColumns Output : My AutoColumns Option : Small Size Form [Part: My AutoColumns] Lines : Form SubTitle, My AutoColumns Local : Field : Form SubTitle : Info : $$LocaleString:"Auto Repeat Columns" [Line: My AutoColumns] Fields : Medium Prompt, My SelectAuto, My AutoColumns, My CollName, My StartPeriod, My EndPeriod, My SetPeriodicity Local : Field : Medium Prompt : Info : $$LocaleString:"Repeat Using :" SpaceBottom : 0.25 [Field: My SelectAuto] Use : Short Name Field Table : MyAutoColumns1 Show Table : Always [Field: My AutoColumns] Use : Short Name Field Invisible : Yes Set as : $$Table:MySelectAuto:$VarName Set always : Yes Skip : Yes [Field: My CollName] Use : Short Name Field Invisible : Yes Set as : $$Table:MySelectAuto:$CollName Modifies : DSPRepeatCollection Set always : Yes Skip : Yes [Field: My StartPeriod] Use : Short Date Field Invisible : Yes Set as : if $$IsEmpty:$$Table:MySelectAuto:$Periodicity then ##SVFromDate else + if $$Table:MySelectAuto:$Periodicity = "Day" then ##SVFromDate else + $$LowValue:SVFromDate Set always : Yes Modifies : SVFromDate Skip : Yes [Field: My EndPeriod] Use : Short Date Field Invisible : Yes Set as : if $$IsEmpty:$$Table:MySelectAuto:$Periodicity then ##SVToDate else + if $$Table:MySelectAuto:$Periodicity = "Day" then $$MonthEnd:#DSPStartPeriod else $$HighValue:SVToDate Set always : Yes Modifies : SVToDate Skip : Yes [Field: My SetPeriodicity] Use : Short Name Field Invisible : Yes Set as : if NOT $$IsEmpty:$$Table:MySelectAuto:$Periodicity then $$Table:MySelectAuto:$Periodicity else "Month" Set always : Yes Modifies : SVPeriodicity ;; End-of-File [Collection: DD TB GroupsLedgers] Collection : DD TB Groups, DD TB Ledgers [Collection: DD TB Groups] Type : Group Child Of : #DDGroupName1 Filter : Zero Filter Fetch : Name, ClosingBalance [Collection: DD TB Ledgers] Type : Ledger Child Of : #DDGroupName1 Filter : Zero Filter Fetch : Name, ClosingBalance [Variable: DDGroupName1] Type : String Default : "" [System: Formula] Zero Filter : NOT $ClosingBalance < 0 ;;=====ledger wise forecasting calculation ;; End-of-Code