Calculating totals of multiple units in Stock Summary Report

Discussion in 'Tally.ERP 9' started by Dev P, Aug 17, 2015.

         
  1. Dev P

    Dev P New Member


    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
     


  2. NAGARAJKMAR SUBRAMANIAN

    NAGARAJKMAR SUBRAMANIAN Active Member


    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.
     



  3. Dear Sir
    Will you please tell me the formula to convert stockitems as Number.
    Thank you
     


  4. NAGARAJKMAR SUBRAMANIAN

    NAGARAJKMAR SUBRAMANIAN Active Member


    use $$Number:$BilledQty
     



  5. Dear NAGARAJKMAR SUBRAMANIAN

    Its done...
    Thanks a lot, your suggestion helps me a lot. Finally i had achieved my goal. Thank you so much.
     



  6. can u share
     



  7. can u share
     



  8. 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
     

    Attached Files:



Share This Page