GST-TAX DETAILS MONTHWISE

Discussion in 'Free Source Codes' started by PANKAJ BHONDLE, Jul 12, 2018.

    
Tags:
?

FREE CODE

Poll closed Jul 19, 2018.
  1. OK

    100.0%
  2. OK

    0 vote(s)
    0.0%
Multiple votes are allowed.
  1. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    FREE SOURCE CODE
     

    Attached Files:



  2. DIGAMBER TOMPE

    DIGAMBER TOMPE New Member


    dear sir where to see this report
     


  3. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    [#Menu:Gateway of tally]
    Item : "9) Month Wise (DUTIES-TAXES) SUMMARY": Display : MonthwiseDutiesTaxesSummary
     



  4. FIGTURE/AMOUNT NOT SHOWING CORRECT PLEASE CHECK
     


  5. sai nanjunda

    sai nanjunda New Member


    not showing ,

    Check code again
     


  6. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Not Working.
     


  7. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    upload_2018-9-11_12-40-2.png
    sea screenshot
     


  8. Jay kumar tailor

    Jay kumar tailor Well-Known Member

    Last edited: Sep 13, 2018


  9. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    add

    Enter to Alter to it
     
    Last edited: Sep 13, 2018


  10. Jay kumar tailor

    Jay kumar tailor Well-Known Member



  11. udaya

    udaya Active Member


    the err is in the code is
    ; [#Menu: Gateway of Tally]
    ; Add : Key Item : "MONTHWISE + DUTIES & TAXES SUMMARY" : R : Display : MonthwiseDutiesTaxesSummary

    in the code remove the ";" in bothe line. it will sho the menu at gateway of tally
     


  12. Devaki

    Devaki Member




    [#Menu: Gateway of Tally]
    Add : Key Item : "Month Wise GST" : G : Display : MonthwiseDutiesTaxesSummary

    [Report:MonthwiseDutiesTaxesSummary]
    Use : DSP Template
    Title : "Month Wise GST Details"
    Variable: SV Print Orientation : String
    Repeat : PartyNameGWLSMSSMS
    Form : MonthwiseDutiesTaxesSummary
    Set : FilterPartyNameGWLSMSSMSSMS : ""
    Set : SVFromDate : $$MonthStart:##SVFromDate
    Set : SVToDate : $$MonthEnd:##SVCurrentDate
    Variable: SVFromDate, SVToDate

    [Form:MonthwiseDutiesTaxesSummary]
    Button : PrintButton, ExportButton
    Button : ExplodeFlag,ChangePeriod,BtnPartyNameGWLSMSSMSFilter
    Bottom Toolbar Buttons : Enter To Edit SMS,BottomToolBarBtn8,BottomToolBarBtn9,BottomToolBarBtn10
    Part : SMSTitle,SMSPeriod,SMSDetails

    Bottom Part : SMSTotals
    Width : 100% Page
    Space Left : 2 mms
    Space Right : 2 mms

    ;Set Always : SV Print Orientation : "Landscape"
    Add : Button :Refresh TDL
    [Key: Enter To Edit SMS]
    Key : Enter
    Title : $$LocaleString:"Explode"
    Type : BottomToolBarBtn2
    Action : Explode

    [Part:SMSTitle]
    Line : SMSTitle
    Horizontal Align : Center

    [Part:SMSPeriod]
    Line : SMSPeriod

    [Line:SMSTitle]
    Field : Simple Field
    Local : Field : Simple Field : Style : Large Bold
    Local : Field : Simple Field : Info : " Month Wise GST Details"
    Local : Field : Simple Field : Border: Thin Bottom
    Local : Field : Simple Field : Align : Center


    [Line:SMSPeriod]
    Right Field : Name Field
    Left Field : Short Prompt,SMSfilterRpt
    Local : Field : Name Field : Info : @@DSPDateStr
    Local : Field : Name Field : Width : 60
    Local : Field : Name Field : Align : Right
    Local : Field : Short Prompt : Set as: "Party Name:"





    [Field:SMSfilterRpt]
    Use : Simple Field
    Style : Normal Bold
    Set as : @SMSPartyNameGWLSMSSMS
    Set Always : Yes
    SMSPartyNameGWLSMSSMS : If $$IsEndOfList:##FilterPartyNameGWLSMSSMSSMS or ##FilterPartyNameGWLSMSSMSSMS="" Then "Show All" Else ##FilterPartyNameGWLSMSSMSSMS




    [Line:SMSHead]
    Use : SMSDetails
    Border : Column Titles
    Local : Field : Default : Type : String
    Local : Field : Default : Align : Center
    Local : Field : Default : Border : Thin Left
    Local : Field : Default : Style : NORMAL BOLD

    Local : Field : SMSSno : Set as : "S.No"
    Local : Field : SMSSno : Border : Thin Left Right
    Local : Field : SMSPartyNameGWLSMSSMS : Set as : "Description"
    Local : Field : SMSPartyNameGWLSMSSMS : Align : Left
    Local : Field : SMSAprQty : Set as : "Apr"
    Local : Field : SMSMayQty : Set as : "May"
    Local : Field : SMSQtyJunSMS : Set as: "Jun"
    Local : Field : SMSJulQty : Set as : "Jul"
    Local : Field : SMSAugQty : Set as : "Aug"
    Local : Field : SMSSepQty : Set as : "Sep"
    Local : Field : SMSOctQty : Set as : "Oct"
    Local : Field : SMSnovQty : Set as : "Nov"
    Local : Field : SMSdecQty : Set as : "Dec"
    Local : Field : SMSjanQty : Set as : "Jan"
    Local : Field : SMSfebQty : Set as : "Feb"
    Local : Field : SMSmarQty : Set as : "Mar"
    Local : Field : SMSTotal : Set as : "TOtal"
    Local : Field : SMSTotal : Border : Thin Left Right
    Space Top : 1.5 mms
    Space Bottom: 1.5 mms


    [Part:SMSDetails]
    Line : SMSHead,SMSDetails
    Repeat : SMSDetails:SMSPartyWise
    Scroll : Vertical
    Total : SMSAprQty,SMSMayQty,SMSQtyJunSMS, SMSJulQty, SMSAugQty, SMSSepQty,SMSOctQty,SMSnovQty,SMSdecQty,SMSjanQty,SMSfebQty,SMSmarQty,SMSTotal
    Common Border : Yes

    [Line:SMSDetails]
    Field : SMSSno,SMSPartyNameGWLSMSSMS
    Right Field : SMSAprQty,SMSMayQty,SMSQtyJunSMS, SMSJulQty, SMSAugQty, SMSSepQty,SMSOctQty,SMSnovQty,SMSdecQty,SMSjanQty,SMSfebQty,SMSmarQty,SMSTotal
    Option : AlterOnEnter : $$IsVoucher
    Space Bottom: 0.5 mms
    Space Top : 0.5 mms
    Border : Thin Top
    Explode : SMSExplode : ($$KeyExplode OR ##ExplodeFlag)

    [Field:SMSDefault]
    Use : Name Field
    Style : Normal Bold

    [Field:SMSSno]
    Use : SMSDefault
    Set as : $$Line
    Width : if $$inprintmode then 3 else 4
    Align : Center
    Border : Thin Left Right
    Style :small


    [Field:SMSPartyNameGWLSMSSMS]
    Use : SMSDefault
    Set as : $PartyNameGWLSMSSMS
    Width : if $$inprintmode then 15 else 20
    Quick Search: Yes
    Style:SMALL


    [Field:SMSAprQty]
    Use:amount field
    ;Use : Qty Field
    Format:"dr/cr"
    ;Type : Number
    Set as : $QtyAprSMS
    Width : if $$inprintmode then 7 else 8
    Border : Thin Left Right
    Style:small
    Color:blue

    [Field:SMSMayQty]
    Use:amount field
    Format:"dr/cr"
    ;Use : Qty Field
    ;Type : Number
    Set as : $QtyMaySMS
    Width : if $$inprintmode then 7 else 8
    Border : Thin Right
    Style:small
    Color:dpink
    [Field: SMSQtyJunSMS]
    Use:amount field
    Format:"dr/cr"
    ;Use : Qty Field
    ;Type : Number
    Set As : $QtyJunSMS
    Border : Thin Right
    Width : if $$inprintmode then 7 else 8
    Style:small
    Color:blue

    [Field: SMSJulQty]
    Use:amount field
    Format:"dr/cr"
    ;Use : Qty Field
    ;Type : Number
    Set As : $QtyJulSMS
    Border : Thin Right
    Width : if $$inprintmode then 7 else 8
    Style:small
    Color:dpink

    [Field: SMSAugQty]
    Use:amount field
    Format:"dr/cr"
    ;Use : Qty Field
    ;Type : Number
    Set As : $QtyAugSMS
    Border : Thin Right
    Width : if $$inprintmode then 7 else 8
    Style:small
    Color:blue

    [Field: SMSSepQty]
    Use:amount field
    Format:"dr/cr"
    ;Use : Qty Field
    ;Type : Number
    Set As : $QtySepSMS
    Border : Thin Right
    Width : if $$inprintmode then 7 else 8
    Style:small
    Color:dpink
    [Field: SMSOctQty]
    Use:amount field
    Format:"dr/cr"
    ;Use : Qty Field
    ;Type : Number
    Set As : $SMSOctQty
    Border : Thin Right
    Width : if $$inprintmode then 7 else 8
    Style:small
    Color:blue

    [Field: SMSnovQty]
    Use:amount field
    Format:"dr/cr"
    ;Use : Qty Field
    ;Type : Number
    Set As : $SMSnovQty
    Border : Thin Right
    Width : if $$inprintmode then 7 else 8
    Style:small
    Color:dpink
    [Field: SMSdecQty]
    Use:amount field
    Format:"dr/cr"
    ;Use : Qty Field
    ;Type : Number
    Set As : $SMSdecQty
    Border : Thin Right
    Width : if $$inprintmode then 7 else 8
    Style:small
    Color:blue

    [Field: SMSjanQty]
    Use:amount field
    Format:"dr/cr"
    ;Use : Qty Field
    ;Type : Number
    Set As : $SMSjanQty
    Border : Thin Right
    Width : if $$inprintmode then 7 else 8
    Style:small
    Color:dpink
    [Field: SMSfebQty]
    Use:amount field
    Format:"dr/cr"
    ;Use : Qty Field
    ;Type : Number
    Set As : $SMSfebQty
    Border : Thin Right
    Width : if $$inprintmode then 7 else 8
    Style:small
    Color:blue

    [Field: SMSmarQty]
    Use:amount field
    Format:"dr/cr"
    ;Use : Qty Field
    ;Type : Number
    Set As : $SMSmarQty
    Border : Thin Right
    Width : if $$inprintmode then 7 else 8
    Style:small
    Color:dpink

    [Field:SMSTotal]
    Use:amount field
    Format:"dr/cr"
    ;Use : Qty Field
    Set as : $TotAmount
    ;Type : Number
    Width : if $$inprintmode then 7 else 8
    Border : Thin Right
    Style:small bold
    Color:dark red


    [Part:SMSTotals]
    Line : SMSTotal


    [Line:SMSTotal]
    Border : Totals
    Use : SMSDetails
    ;Local : Field : Default : Type : String
    Local : Field : Default : Align : Right
    Local : Field : Default : Style : Large Bold
    Local : Field : Default : Border : Thin Left
    Local:Field:DEFAULT:Use:AMOUNT FIELD
    Local : Field : Default:Format:"Dr/Cr"
    Local : Field : SMSSno : Set as : ""
    Local : Field : SMSPartyNameGWLSMSSMS : Set as : "GST Payable/Receivable"
    Local : Field : SMSPartyNameGWLSMSSMS : Align : Left
    Local : Field : SMSAprQty : Set as : $$Total:SMSAprQty
    Local : Field : SMSMayQty : Set as : $$Total:SMSMayQty
    Local : Field : SMSQtyJunSMS: Set as : $$Total:SMSQtyJunSMS
    Local : Field : SMSJulQty : Set as : $$Total:SMSJulQty
    Local : Field : SMSAugQty : Set as : $$Total:SMSAugQty
    Local : Field : SMSSepQty : Set as : $$Total:SMSSepQty
    Local : Field : SMSOctQty : Set as : $$Total:SMSOctQty
    Local : Field : SMSnovQty : Set as : $$Total:SMSnovQty
    Local : Field : SMSdecQty : Set as : $$Total:SMSdecQty
    Local : Field : SMSjanQty : Set as : $$Total:SMSjanQty
    Local : Field : SMSfebQty : Set as : $$Total:SMSfebQty
    Local : Field : SMSmarQty : Set as : $$Total:SMSmarQty
    Local : Field : SMSTotal : Set as : $$Total:SMSTotal
    Local : Field : SMSTotal : Border : Thin Left Right
    Local : Field : SMSTotal : Align : Right

    [Part:SMSExplode]
    Line : SMSExplode
    Repeat : SMSExplode:SMSPartyExplode
    Border : Thin Bottom

    [Line:SMSExplode]
    Use : SMSDetails
    Delete : Border
    Local : Field : SMSSno : Set as : $$Line
    Local : Field : Default : Style : Normal
    Local : Field : Default : Color : red
    Local : Field : Default :Border:THIN BOTTOM
    Local : Field : SMSPartyNameGWLSMSSMS : Set as : $ItemNameGWLW
    Local : Field : SMSPartyNameGWLSMSSMS : Align : Justified
    Local : Field : SMSAprQty : Set as : $itemQtyAprSMS
    Local : Field : SMSMayQty : Set as : $itemQtyMaySMS
    Local : Field : SMSQtyJunSMS: Set as : $ItemQtyJunSMS
    Local : Field : SMSJulQty : Set as : $ItemQtyJulSMS
    Local : Field : SMSAugQty : Set as : $ItemQtyAugSMS
    Local : Field : SMSSepQty : Set as : $ItemQtySepSMS
    Local : Field : SMSOctQty : Set as : $ItemSMSOctQty
    Local : Field : SMSnovQty : Set as : $ItemSMSnovQty
    Local : Field : SMSdecQty : Set as : $ItemSMSdecQty
    Local : Field : SMSjanQty : Set as : $ItemSMSjanQty
    Local : Field : SMSfebQty : Set as : $ItemSMSfebQty
    Local : Field : SMSmarQty : Set as : $ItemSMSmarQty
    Local : Field : SMSTotal : Set as : $itemSMSTotalQty




    [Button:BtnPartyNameGWLSMSSMSFilter]
    Key : F6
    Action : Execute :MonthwiseDutiesTaxesSummaryWise
    Title : Select Party Name

    [Report:MonthwiseDutiesTaxesSummaryWise]
    Form : MonthwiseDutiesTaxesSummaryWise

    [Form:MonthwiseDutiesTaxesSummaryWise]
    Part : MonthwiseDutiesTaxesSummaryWise
    Width : 40% Page
    Height : 10% Page
    Space Left : 2 mms
    Space Right : 2 mms




    [Part:MonthwiseDutiesTaxesSummaryWise]
    Line : MonthwiseDutiesTaxesSummaryWise

    [Line:MonthwiseDutiesTaxesSummaryWise]
    Field : Medium Prompt,MonthwiseDutiesTaxesSummaryWise
    Local : Field : Medium Prompt : Set as : "Select Party Name:"
    Space Bottom : 2 mms

    [Field:MonthwiseDutiesTaxesSummaryWise]
    Table : filterledger5,EndOfList
    ShowTable : Always
    Use : Name Field
    Width : 20
    Border : Thin Box
    Variable : FilterPartyNameGWLSMSSMSSMS
    Modifies : FilterPartyNameGWLSMSSMSSMS


    [Collection: filterledger5]
    Type: Ledger

    BelongsTo: Yes

    [System:Formula]
    SMSFilter : $LedgerName=@@PartyLedgerWiseSMS
    PartyLedgerWiseSMS: If $$IsEndOfList:##FilterPartyNameGWLSMSSMSSMS or ##FilterPartyNameGWLSMSSMSSMS="" Then $LedgerName Else ##FilterPartyNameGWLSMSSMSSMS
    SMSExplodeFilter : $PartyNameGWLSMSSMS=#SMSPartyNameGWLSMSSMS
    SMSExplodeFilterB : $PartyNameGWLSMSSMS=#SMSPartyNameGWLSMSSMS

    [Collection: SMS Voucher]
    Type : Vouchers ;: VoucherType
    ;Child of : $$VchTypePayment
    Belongs to : Yes
    Fetch : date,VoucherTypeName,PartyLedgerName,Amount,PAYHEADNAME,Allledger Entries,Voucher Number,VoucherNumber,Reference,ledgername,amount,allledger Entries
    Filter : NOTIsOptionalVoucher,SMSFilter


    [Collection:SMSPartyWise]
    Source Collection : SMS Voucher
    Walk : ledger Entries
    By : PartyNameGWLSMSSMS : $LedgerName
    Aggr Compute : QtyAprSMS : Sum :If @@SMSmonthFilterapr Then $Amount Else 0
    Aggr Compute : QtyMaySMS : Sum :If @@SMSmonthFiltermay Then $Amount Else 0
    Aggr Compute : QtyJunSMS : Sum :If @@SMSmonthFilterjun Then $Amount Else 0
    Aggr Compute : QtyJulSMS : Sum :If @@SMSmonthFilterjul Then $Amount Else 0
    Aggr Compute : QtyAugSMS : Sum :If @@SMSmonthFilteraug Then $Amount Else 0
    Aggr Compute : QtySepSMS : Sum :If @@VoucherFilterExpSMS and @@SMSmonthFiltersep Then $Amount Else 0
    Aggr Compute : SMSOctQty : Sum :If @@VoucherFilterExpSMS and @@SMSmonthFilteroct Then $Amount Else 0
    Aggr Compute : SMSnovQty : Sum :If @@VoucherFilterExpSMS and @@SMSmonthFilternov Then $Amount Else 0
    Aggr Compute : SMSdecQty : Sum :If @@VoucherFilterExpSMS and @@SMSmonthFilterdec Then $Amount Else 0
    Aggr Compute : SMSjanQty : Sum :If @@VoucherFilterExpSMS and @@SMSmonthFilterjan Then $Amount Else 0
    Aggr Compute : SMSfebQty : Sum :If @@VoucherFilterExpSMS and @@SMSmonthFilterfeb Then $Amount Else 0
    Aggr Compute : SMSmarQty : Sum :If @@VoucherFilterExpSMS and @@SMSmonthFiltermar Then $Amount Else 0
    Aggr Compute : TotAmount : Sum :If @@VoucherFilterExpSMS Then $Amount Else 0
    Sort : Default : $PartyNameGWLSMSSMS
    Filter: iexpSMS

    [Collection:SMSPartyExplode]
    Source Collection : SMS Voucher
    Walk : ledger Entries
    By : PartyNameGWLSMSSMS : $LedgerName
    By : ItemNameGWLW : $vouchernumber
    Aggr Compute : itemQtyAprSMS : Sum : If @@SMSmonthFilterapr Then $Amount Else 0
    Aggr Compute : itemQtyMaySMS : Sum : If @@SMSmonthFiltermay Then $Amount Else 0
    Aggr Compute : itemQtyJunSMS : Sum : If @@SMSmonthFilterjun Then $Amount Else 0
    Aggr Compute : itemQtyJulSMS : Sum : If @@SMSmonthFilterjul Then $Amount Else 0
    Aggr Compute : itemQtyAugSMS : Sum : If @@SMSmonthFilteraug Then $Amount Else 0
    Aggr Compute : itemQtySepSMS : Sum :If @@VoucherFilterExpSMS and @@SMSmonthFiltersep Then $Amount Else 0
    Aggr Compute : itemSMSOctQty : Sum :If @@VoucherFilterExpSMS and @@SMSmonthFilteroct Then $Amount Else 0
    Aggr Compute : itemSMSnovQty : Sum :If @@VoucherFilterExpSMS and @@SMSmonthFilternov Then $Amount Else 0
    Aggr Compute : itemSMSdecQty : Sum :If @@VoucherFilterExpSMS and @@SMSmonthFilterdec Then $Amount Else 0
    Aggr Compute : itemSMSjanQty : Sum :If @@VoucherFilterExpSMS and @@SMSmonthFilterjan Then $Amount Else 0
    Aggr Compute : itemSMSfebQty : Sum :If @@VoucherFilterExpSMS and @@SMSmonthFilterfeb Then $Amount Else 0
    Aggr Compute : itemSMSmarQty : Sum :If @@VoucherFilterExpSMS and @@SMSmonthFiltermar Then $Amount Else 0
    Aggr Compute : itemSMSTotalQty:Sum : If @@VoucherFilterExpSMS Then $Amount Else 0
    Filter : SMSExplodeFilter
    Sort : Default : $ItemNameGWLW





    [System : Formula]
    iexpSMS : $$IsLedOfGrp:$PartyNameGWLSMSSMS:$$GroupDuties or $$IsLedOfGrp:$PartyNameGWLSMSSMS:$$GroupDeposits

    iexpSMSl : $$IsLedOfGrp:$name:$$GroupDuties or $$IsLedOfGrp:$name:$$GroupDuties

    VoucherFilterExpSMS : $$IsJournal:$VoucherTypeName or $$IsSales:$VoucherTypeName or $$IsCreditNote:$VoucherTypeName ;$$IsPayment:$VoucherTypeName or $$IsJournal:$VoucherTypeName or $$IsPurchase:$VoucherTypeName or $$IsSales:$VoucherTypeName or $$IsDebitNote:$VoucherTypeName or $$IsCreditNote:$VoucherTypeName
    SMSmonthFilterapr : $$MonthOfDate:$Date>=4 and $$MonthOfDate:$Date<=4
    SMSmonthFiltermay : $$MonthOfDate:$Date>=5 and $$MonthOfDate:$Date<=5
    SMSmonthFilterjun : $$MonthOfDate:$Date>=6 and $$MonthOfDate:$Date<=6
    SMSmonthFilterjul : $$MonthOfDate:$Date>=7 and $$MonthOfDate:$Date<=7
    SMSmonthFilteraug : $$MonthOfDate:$Date>=8 and $$MonthOfDate:$Date<=8
    SMSmonthFiltersep : $$MonthOfDate:$Date>=9 and $$MonthOfDate:$Date<=9
    SMSmonthFilteroct : $$MonthOfDate:$Date>=10 and $$MonthOfDate:$Date<=10
    SMSmonthFilternov : $$MonthOfDate:$Date>=11 and $$MonthOfDate:$Date<=11
    SMSmonthFilterdec : $$MonthOfDate:$Date>=12 and $$MonthOfDate:$Date<=12
    SMSmonthFilterjan : $$MonthOfDate:$Date>=1 and $$MonthOfDate:$Date<=1
    SMSmonthFilterfeb : $$MonthOfDate:$Date>=2 and $$MonthOfDate:$Date<=2
    SMSmonthFiltermar : $$MonthOfDate:$Date>=3 and $$MonthOfDate:$Date<=3


    [Variable: PartyNameGWLSMSSMS]
    Type : String
    Repeat : ##DSPRepeatCollection

    [Variable:FilterPartyNameGWLSMSSMSSMS]
    Type : String

    [System:Variables]
    FilterPartyNameGWLSMSSMSSMS : ""
     
    sandeep76out and Rajsrisrimal like this.


  13. Devaki

    Devaki Member


    it is working
     


  14. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Good work.

    please add a part in this

    [Part:JK Invoice Company Details]
    Line: JK Company Name, JK Company Address
    Border: Thin Box


    [Line: JK Company Name]
    Field: Name Field
    Local: Field: Name Field: Set as: @@CmpMailName
    Local: Field: Name Field: Style:Large Bold
    Local: Field: Name Field: Align : Center
    Local: Field: Name Field: Full Width: Yes
    Space Top: 0.25

    [Line:JK Company Address]
    Field: Name Field
    Local: Field: Name Field: Set as: $$FullList:CompanyAddress:$Address
    Local: Field: Name Field: Width:100% Page
    Local: Field: Name Field: Style:O9
    Local: Field: Name Field: Align : Center
    Local: Field: Name Field: Line:0
     


  15. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    dear devaki
    please add
    enter to edit
    into it

    check IGST TOTAL
     


  16. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    check now
     


  17. Devaki

    Devaki Member


    Good Mr.Jay Kumar Tailor
     
    nasir likes this.


  18. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    devki madam, i chalange you in my report quiery solve
     


  19. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    [#Menu : Gateway of Tally]
    Add : Item : GST Report1 : Menu : GST Report

    [Menu : GST Report]
    Add : Item : All GST Purchase : Display : GST Purchase
    Add : Item :""


    [Report : GST Purchase]
    Title: GST Purchase
    Variables : SV CurrentCompany

    Form :GST Purchase
    Variable : SVFromDate,SVToDate
    Set : SVFromDate : $$MonthStart:##SVCurrentDate
    Set : SVToDate : $$MonthEnd:##SVCurrentDate
    Set : Is Day Book : Yes

    [Form :GST Purchase]
    Space Right : 1.5
    Space left : 1.5
    ;Space tOP : 1.5
    ;Space Bottom : 1.5

    Part :DSP AccTitles, daybookheadbb2, GST Purchase,daybookbottam2 ;;,daybookhead22 ;;;daybookhead2,
    Buttons : ExplodeFlag,ChangeDybkDate,ChangePeriod
    BottomButton: BlankButton, RelReports, InvReports, AcctReports, Report Operations, FilterButton, ValueButton
    Buttons : PrintButton, ExportButton, UploadButton, MailButton
    Bottom Toolbar Buttons : BottomToolBarBtn1, BottomToolBarBtn2_EditVch, BottomToolBarBtn3, BottomToolBarBtn4, BottomToolBarBtn5, BottomToolBarBtn6, BottomToolBarBtn7, BottomToolBarBtn8, BottomToolBarBtn9, BottomToolBarBtn10, BottomToolBarBtn11, BottomToolBarBtn12
    Background : white

    Page Break : UsCs GI ClPgBrk2 , UsCs GI OpPgBrk2


    [Part: UsCs GI ClPgBrk2]

    Lines : UsCs GI ClPgBrk2

    [Line: UsCs GI ClPgBrk2]

    Fields : Simple Field
    Local : Field : Simple Field : Set As : "Continued..."
    Local : Field : Simple Field : FullWidth : Yes
    Local : Field : Simple Field : Align : Right
    Border : Full Thin Top


    [Part: UsCs GI OpPgBrk2]

    Parts : SD Title2, daybookheadbb2 ;;;;, UsCs GI Inventory Title
    Vertical : Yes





    [Part: SD Title2]
    Line: SD Title2, daybookheadB2

    [Line: SD Title2]

    Fields : Simple Field
    Local : Field : Simple Field : Set As : @@CmpMailName
    Local : Field : Simple Field : Align : Center
    Local : Field : Simple Field : FullWidth : Yes
    Local : Field : Simple Field : WideSpaced: Yes
    SpaceBottom : 1




    [Line :daybookheadB2]
    Field : Simple Field
    Local : Field : Simple Field : Info : "GST Purchase from " + $$String:##SVFromDate +" to " + $$String:##SVToDate


    ;;==================GST Purchase==============================



    [Part : daybookheadbb2]
    Use : GST Purchase
    Delete : Repeat
    Delete : Scroll
    Border : ColumnTitles
    Local : Field : Default : Type : string
    Local : Field : My Voucher Srl2 : Set As : "Sr.No"
    Local : Field : MyVoucherParty2: Set As : "Party Name"
    Local : Field : MyVchTIN2 : Set As : "GST No"
    Local : Field : MyVchNo2 : Set As : "Bill No"
    Local : Field : My Voucher Date2 : Set As : "Bill Date"
    Local : Field : IGST PER:Set as:"%"
    Local : Field : MyVchAmount2x : Set As : "Basic Amount"
    Local : Field : MyVchfNo2 : Set As : "CGST "
    Local : Field : MyVchfNo3 : Set As : "SGST "
    Local : Field : MyVchfNo4 : Set As : "IGST "
    Local : Field : MyVchTotAmount2x : Set As : "Total Amount"

    Local :Field : Default : Style : Normal
    Local: Field: Default: Align: Center


    [Part :GST Purchase]
    Line : GST Purchase
    Repeat :GST Purchase :My Voucher Rep Collection2
    tOTAL : My Voucher Srl2,MyVchAmount2x,MyVchfNo4,MyVchfNo2,MyVchfNo3,MyVchfNo4,MyVchTotAmount2x
    Common Border : Yes
    Scroll : Vertical
    [Line :GST Purchase]
    Field :My Voucher Srl2,MyVoucherParty2,MyVchTIN2,MyVchNo2,My Voucher Date2,IGST PER,MyVchAmount2x,MyVchfNo4,MyVchfNo2,MyVchfNo3,MyVchfNo4,MyVchTotAmount2x
    Option : Alter on enter
    Option : DisplayOnAltEnter
    Explode : My TB Inv Explosion : ##ExplodeFlag or $$KeyExplode
    Option:Colorfull display:$amount>10000
    [!Line:Colorfull Display]
    Local:Field:MyVoucherParty2:Color:DARK red
    Local:Field:MyVchAmount2x:Color:dark red
    [Part: My TB Inv Explosion]
    Lines : My TB Inv Explosion
    Repeat : My TB Inv Explosion : ledger Entries;Inventory Entries
    Scroll : Vertical

    [Line : My TB Inv Explosion]
    Field : My TB Inv ExplosionItem ; here add other fields
    Indent : 5

    [Field: My TB Inv ExplosionItem]
    USe : Name field
    Set as : $LedgerName;$StockItemName



    ;Option : Alter On Enter

    [Field :My Voucher Srl2]
    Use : Number Field
    SET AS:$$LINE
    Width : 4% Screen
    Align: Right
    Border : Thin LEFT Right


    [Field :My Voucher Date2]
    Use : Short Date Field
    Set As : $Date
    Border : Thin Right
    Format:"Short Date"


    [Field : MyVoucherParty2]
    Use : NAme Field
    Set As : $LedgerName ;;;$BASICBUYERNAME
    Width : 35
    Border : Thin Right
    Alter : Voucher
    Display : Ledger Vouchers:$$ISLedger
    Variable: Ledger Name

    [Field : MyVchTIN2]
    Use : Name Field
    Set As :$PartyGSTIN:Ledger:$PartyLedgerName
    Width : 11
    Border : Thin Right


    [Field : MyVchNo2]
    Use : NAme Field
    Set As : $REFERENCE
    Width : 10
    Border : Thin Right
    Align:Center
    [Field:IGST PER]
    Use: Number Field
    Set as:$(Stockitem,$stockitem).GSTIGSTRate
    Format : "NoZero,Percentage"
    Set Always: Yes
    Border : Thin Right
    Align:Center
    Width:4
    [Field : MyVchAmount2x]
    Use : Amount Field

    ;Set as:$$FilterAmtTotal:allLedgerEntries:2:$Amount
    ;Set as : $$NettAmount:$GSTExpTaxableAmt:$GSTIncTaxableAmt
    Set As: $$CollAmtTotal:allinventoryEntries:$Amount ; THIS SEA ALSO LEDGER ENTRY which this field

    Border : Thin Right



    ;***********************
    [Field : MyVchfNo2]
    Use : Amount Forex Field
    Set as:$$FilterAmtTotal:LedgerEntries:CGST1:$Amount; $CGSTAmount is ok
    Border : Thin Right
    Width : 10

    ;***********************
    [Field : MyVchfNo3]
    Use : Amount Forex Field
    Set as : $$FilterAmtTotal:LedgerEntries:SGST1:$Amount;$SGSTAmount
    Border : Thin Right
    Width : 10

    ;***********************
    [Field : MyVchfNo4]
    Use : Amount Forex Field
    Set as : $$FilterAmtTotal:LedgerEntries:IGST1:$Amount;$IGSTAMOUNT ; this problems
    Border : Thin Right
    Width : 10

    ;***********************

    [Field : MyVchTotAmount2x]
    Use : Amount Field
    Set As : $Amount
    Border : Thin Right

    ;***********************


    [System: Formula]
    SGST :$$FilterAmtTotal:LedgerEntries:SGST1:$Amount
    SGST1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"SGST"

    CGST :$$FilterAmtTotal:LedgerEntries:CGST1:$Amount
    CGST1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"CGST"

    IGST :$$FilterAmtTotal:LedgerEntries:IGST1:$Amount
    IGST1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"IGST"




    [Collection : My Voucher Rep Collection2]
    Type : Ledger
    ;Sort : Default : $BASICBUYERNAME
    Type : Vouchers
    Walk : allLedgerEntries
    Filter : IsSalesVT2 ;;;;,CSTFilter2 ;;,Recfiltee2
    Fetch : Date,Amount,VoucherTypeName ,PArtyLedgerName,VoucherNumber,REFERENCE,ReferenceDate, GSTDutyAmount,BASICBUYERNAME,CGSTAmount,SGSTAmount,IGSTAmount

    Fetch : *.*

    Compute:IGSTAmount:$$CollAmtTotal:InventoryEntries:$Amount * $(Stockitem,$stockitem).GSTIGSTRate / 100 ; ledger entries
    Compute:CGSTAmount :$$CollAmtTotal:InventoryEntries:$Amount * $(Stockitem,$stockitem).GSTIGSTRate / 100/2
    Compute:SGSTAmount:$$CollAmtTotal:InventoryEntries:$Amount * $(Stockitem,$stockitem).GSTIGSTRate / 100/2

    [Part: daybookbottam2]

    Lines : daybookTotalLine2

    [Line: daybookTotalLine2]

    Use : GST Purchase
    Local: Field: Default : Style : Small Bold
    ;Local: Field: Default: Type: String
    Local: Field: Default: Align: Right
    Local : Field : My Voucher Srl2 : Set as:$$NumItems:MyVoucherRepCollection2;$$PrevLine:#MyVoucherSrl2
    Local : Field : MyVoucherParty2: Set As : "Total"
    Local : Field : MyVchNo2 : Set As : ""
    Local : Field : MyVchAmount2x : Set As : $$Total:MyVchAmount2x
    LOCAL : FIELD: MyVchfNo2:Set as:$$Total:MyVchfNo2
    LOCAL : FIELD: MyVchfNo3:Set as:$$Total:MyVchfNo3
    LOCAL : FIELD: MyVchfNo4:Set as:$$Total:MyVchfNo4
    LOCAL : FIELD: MyVchTotAmount2x:Set as:$$Total:MyVchTotAmount2x



    Border : Totals

    [System: Formula]

    IsSalesVT2 : $$IsPurchase:$VoucherTypeName


    CSTFilter2 : not ##IsRevChargeAppl
     
    sandeep76out likes this.


  20. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    [Field : MyVchAmount2x]
    Use : Amount Field

    ;Set as:$$FilterAmtTotal:allLedgerEntries:2:$Amount
    ;Set as : $$NettAmount:$GSTExpTaxableAmt:$GSTIncTaxableAmt
    Set As: $$CollAmtTotal:allinventoryEntries:$Amount ; THIS SEA ALSO LEDGER ENTRY which this field

    Border : Thin Right

    quiery is: 1) show only inventory entries,
    2) show in report all ledger entries & all inventory entries
     


  21. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    Do not share code here on forum......share snippets is okay..... majority people are here only to collect codes and sell them, We toil and they spoil. U can post screenshots of finished code here.
     


  22. sekharchana

    sekharchana Member


    perfect thanks sir
     


  23. sathiyaraj

    sathiyaraj Member


    Dear jay,
    Small suggestion Separate input tax & Output Tax...The Final Report is Total Tax amount - Total Input credits(ITC)=Payable Tax Amount...
    This is my suggestion .. Your Code is Good & Perfect...
     
    sandeep76out likes this.


  24. sathiyaraj

    sathiyaraj Member


    Nice...Keep Going...Thanks to share this code..
     


  25. Rajsrisrimal

    Rajsrisrimal Member


    Superb ..... Thanks for sharing
     


Share This Page