GST-TAX DETAILS MONTHWISE

Amit Kamdar · Sep 25, 2018

PANKAJ BHONDLE said: ↑

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.
Click to expand...

You copy-pasted my post.......... dot to dot, comma to comma

PANKAJ BHONDLE · Sep 25, 2018

respective amitji, time saving

SUKHWINDER SINGH · Oct 12, 2018

PANKAJ BHONDLE said: ↑

FREE SOURCE CODE
Click to expand...

Dear Sir
unable to see this report

SUKHWINDER SINGH · Oct 12, 2018

still there is no name added

DANIELGORI · May 28, 2019

Missing Basic Amount Some entries in this report

MZMS · May 29, 2019

No Basic Amt column

sandeep76out · Jun 29, 2019

Devaki said: ↑

[#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:FieldEFAULT: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 : ""
Click to expand...

Thank You _()_

Bipin Damania · Jun 29, 2019

Pankajji, Devakiji, Jayji

I have created group GST under Duties & Taxes and if I want only GST group then what to change ?

iexpWEXP : $$IsLedOfGrp:$PartyNameHarryExpWEXP:$$GroupDuties or $$IsLedOfGrp:$PartyNameHarryExpWEXP:$$GroupDeposits

iexpWEXPl : $$IsLedOfGrp:$name:$$GroupDuties or $$IsLedOfGrp:$name:$$GroupDuties

Jay kumar tailor · Jun 30, 2019

try this and revert me
working or not
iexpWEXP : $$IsLedOfGrp:$PartyNameHarryExpWEXP$Name:Group:$GroupName Contains $$LocaleString:"GST")

Bipin Damania · Jun 30, 2019

Jay kumar tailor said: ↑

try this and revert me
working or not
iexpWEXP : $$IsLedOfGrp:$PartyNameHarryExpWEXP$Name:Group:$GroupName Contains $$LocaleString:"GST")
Click to expand...

No.
Not working...

sandeep76out · Jul 3, 2019

PANKAJ BHONDLE said: ↑

FREE SOURCE CODE
Click to expand...

Dear Sir code is not working

PANKAJ BHONDLE · Jul 5, 2019

Dear Sandeep ji above tdl downloaded then small correction (me & devki madam suggestion)

sandeep76out · Jul 6, 2019

Thank you for reply
i was using Devki Ma`dam suggestion code

nasir · Jul 7, 2019

kindly add co

Devaki said: ↑

Good Mr.Jay Kumar Tailor
Click to expand...

Kindly add company name and address plzzzzzzzzzzzzzzzzzzzzzzzzzzz

Log in or Sign up

GST-TAX DETAILS MONTHWISE

FREE CODE

OK

OK

Amit Kamdar Administrator Staff Member

PANKAJ BHONDLE Active Member

SUKHWINDER SINGH New Member

SUKHWINDER SINGH New Member

DANIELGORI New Member

MZMS New Member

sandeep76out New Member

Bipin Damania Active Member

Jay kumar tailor Well-Known Member

Bipin Damania Active Member

sandeep76out New Member

PANKAJ BHONDLE Active Member

sandeep76out New Member

nasir Member

Share This Page

Log in or Sign up

GST-TAX DETAILS MONTHWISE

FREE CODE

OK

OK

Amit Kamdar Administrator Staff Member

PANKAJ BHONDLE Active Member

SUKHWINDER SINGH New Member

SUKHWINDER SINGH New Member

DANIELGORI New Member

MZMS New Member

sandeep76out New Member

Bipin Damania Active Member

Jay kumar tailor Well-Known Member

Bipin Damania Active Member

sandeep76out New Member

PANKAJ BHONDLE Active Member

sandeep76out New Member

nasir Member

Share This Page

Useful Searches