[#Menu:GATEWAY OF TALLY] Add:Item:MYREPORTisplay:CUSTOMERSALEREPORT [Report:CUSTOMERSALEREPORT] UseSP TEMPLATE Form:CASHSALEREPORTNIK Set : SVFromDate: ##SVCurrentDate Set : SVToDate : ##SVCurrentDate Set : FilterPartyNameGWLWCUSTOMER : "" [Form:CASHSALEREPORTNIK] UseSP TEMPLATE Height:100% SCREEN Width:100% SCREEN Part:CASHSALEREPORTtitleNIK,CASHSALEREPORTbodyNIK,CSBOTTOMTITLENIK Button:EXPLODEFLAG,BtnPartyNameGWLWFilterCUSTOMER [Part:CASHSALEREPORTtitleNIK] Line:CASHSALEREPORTtitleNIK,KCUSTOMER Background:YELLOW [Line:kCUSTOMER] Right Field : Name Field Left Field : Short Prompt,SMSfilterRptCUSTOMER 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:SMSfilterRptCUSTOMER] Use : Simple Field Style : Normal Set as : @CSITEMNAMENIK Set Always : Yes CSITEMNAMENIK : If $$IsEndOfList:##FilterPartyNameGWLWCUSTOMER or ##FilterPartyNameGWLWCUSTOMER="" Then "" Else ##FilterPartyNameGWLWCUSTOMER [Button:BtnPartyNameGWLWFilterCUSTOMER] Key : F5 Action : Execute : Dispatch DetailsWiseCUSTOMER Title : PARTY NAME [Reportispatch DetailsWiseCUSTOMER] Form : Dispatch DetailsWiseCUSTOMER [Formispatch DetailsWiseCUSTOMER] Part : Dispatch DetailsWiseCUSTOMER Space Left : 2 mms Space Right : 2 mms [Partispatch DetailsWiseCUSTOMER] Line : Dispatch DetailsWiseCUSTOMER [Lineispatch DetailsWiseCUSTOMER] Field : Medium Prompt,Dispatch DetailsWiseCUSTOMER Local : Field : Medium Prompt : Set as : "Select Party Name:" Space Bottom : 2 mms [Fieldispatch DetailsWiseCUSTOMER] Table : filterledgerCUSTOMER,EndOfList ShowTable : Always Use : Name Field Width : 20 Border : Thin Box Variable : FilterPartyNameGWLWCUSTOMER Modifies : FilterPartyNameGWLWCUSTOMER [Collection: filterledgerCUSTOMER] Type: Ledger ChildOf: $$GroupSundryDebtors BelongsTo: Yes [System:Formula] SMSFilterCUSTOMER : $Name=@@PartyLedgerWise PartyLedgerWise : If $$IsEndOfList:##FilterPartyNameGWLWCUSTOMER or ##FilterPartyNameGWLWCUSTOMER="" Then $Name Else ##FilterPartyNameGWLWCUSTOMER [Variable: PartyNameGWLWCUSTOMER] Type : String Repeat : ##DSPRepeatCollection [Variable:FilterPartyNameGWLWCUSTOMER] Type : String [System:Variables] FilterPartyNameGWLWCUSTOMER : "" [Line:CASHSALEREPORTtitleNIK] Field:CASHSALEREPORTtitleNIK Right Field: uni date field;; Space Bottom:.5 Local:Field:uni date field:Set as:##SVCURRENTDATE;;DATE FIELD2 Local:Field:uni date field:Width:10;;;DATE FIELD3 [Field:CASHSALEREPORTtitleNIK] Use:name field Indent:6 Set as:"CUSTOMER WISE SALE REPORT" Full Width:Yes Style:HEADER TITLE Align:Center Color:red Border:THICK BOTTOM Wide Space:Yes; Line:1.5;;;0 [#Style:HEADER TITLE] Height:grow 20% [Part:CASHSALEREPORTbodyNIK] Line:CASHSALETITLELINENIK,CASHSALEDETAILLINENIK Repeat:CASHSALEDETAILLINENIK:CASHSALECOLLNIK Scroll:Vertical Common Border:Yes Total:CSPARTYSALENIK Total:CSTOTALBILLAMTNIK Background:GREEN [Collection:CASHSALECOLLNIK] Type:VOUCHER:LEDGERS Child Of:$$GroupSundryDebtors Belongs To:Yes COMPUTE:$$CollAmtTotal:InventoryEntries:$Amount Fetch:Credit Totals,debit Totals Filter : NOTIsOptionalVoucher,SMSFilterCUSTOMER [Line:CASHSALETITLELINENIK] Field:CS SNONIK, CS PARTYNAMENIK,CS PARTYSALENIK,CS TOTALBILLAMTNIK Local:Field:CS SNONIK:Info:"Sr NO" Local:Field:CS PARTYNAMENIK:Set as:"CUSTOMER NAME" Local:Field:CS PARTYSALENIK:Info:"SALE VALUE" Local:Field:CS TOTALBILLAMTNIK:Info:"BILL AMOUNT" Border:Flush Column Titles Local:FieldEFAULT:Color:BLUE [Line:CASHSALEDETAILLINENIK] Field:CS SNONIK, CS PARTYNAMENIK,CSPARTYSALENIK,CS TOTALBILLAMTNIK [Field:CS SNONIK] Use:NUMBER FIELD Set as:$$Line Border:THIN LEFT [Field:CS PARTYNAMENIK] Use:NAME FIELD Set as:$Name Display:Voucher Border:THIN LEFT Width:45 [Field:CS PARTYSALENIK] Use:Amount FIELD Set as: $$CollAmtTotal:InventoryEntries:$Amount Width:20 Format:"DrCr,Nozero," Border:THIN LEFT [Field:CS TOTALBILLAMTNIK] Use:AMOUNT FIELD Set as:$debitTotals Format:"DrCr,Nozero," Border:THIN LEFT Width:15 [PART:CSBOTTOMTITLENIK] Bottom Line:cashsalebottomlineNIK Background:YELLOW Height:5% SCREEN [Line:cashsalebottomlineNIK] Field:cstotalTITLEflNIK Right Field:CSPARTYSALETOTNIK,cstotalVALUEflNIK Border: THIN TOP BOTTOM [Field:cstotalTITLEflNIK] Set as:"TOTAL" Style:LARGE BOLD Color:BLUE Align:Center Width:23 Border:THIN LEFT [Field:CSPARTYSALETOTNIK] Use:Amount Field Set as:$$Total:CSPARTYSALENIK Style:LARGE BOLD Space Right:1.25 Space Left:2.20 Width:21 Format:"CrDr" Color:BLUE Border:THIN LEFT [Field:cstotalVALUEflNIK] Use:Amount Field Set as:$$Total:CSTOTALBILLAMTNIK Style:LARGE BOLD Space Right:1.25 Space Left:6.20 Color:BLUE Format:"CrDr" Width:23 Border:THIN LEFT
[#Menu:GATEWAY OF TALLY] Add:Item:MYREPORTisplay:CUSTOMERSALEREPORT [Report:CUSTOMERSALEREPORT] UseSP TEMPLATE Form:CASHSALEREPORTNIK Set : SVFromDate: ##SVCurrentDate Set : SVToDate : ##SVCurrentDate Set : FilterPartyNameGWLWCUSTOMER : "" [Form:CASHSALEREPORTNIK] UseSP TEMPLATE Height:100% SCREEN Width:100% SCREEN Part:CASHSALEREPORTtitleNIK,CASHSALEREPORTbodyNIK Button:EXPLODEFLAG,BtnPartyNameGWLWFilterCUSTOMER [Part:CASHSALEREPORTtitleNIK] Line:CASHSALEREPORTtitleNIK,KCUSTOMER Background:YELLOW [Line:kCUSTOMER] Right Field : Name Field Left Field : Short Prompt,SMSfilterRptCUSTOMER 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:SMSfilterRptCUSTOMER] Use : Simple Field Style : Normal Set as : @CSITEMNAMENIK Set Always : Yes CSITEMNAMENIK : If $$IsEndOfList:##FilterPartyNameGWLWCUSTOMER or ##FilterPartyNameGWLWCUSTOMER="" Then "" Else ##FilterPartyNameGWLWCUSTOMER [Button:BtnPartyNameGWLWFilterCUSTOMER] Key : F5 Action : Execute : Dispatch DetailsWiseCUSTOMER Title : PARTY NAME [Reportispatch DetailsWiseCUSTOMER] Form : Dispatch DetailsWiseCUSTOMER [Formispatch DetailsWiseCUSTOMER] Part : Dispatch DetailsWiseCUSTOMER Space Left : 2 mms Space Right : 2 mms [Partispatch DetailsWiseCUSTOMER] Line : Dispatch DetailsWiseCUSTOMER [Lineispatch DetailsWiseCUSTOMER] Field : Medium Prompt,Dispatch DetailsWiseCUSTOMER Local : Field : Medium Prompt : Set as : "Select Party Name:" Space Bottom : 2 mms [Fieldispatch DetailsWiseCUSTOMER] Table : filterledgerCUSTOMER,EndOfList ShowTable : Always Use : Name Field Width : 20 Border : Thin Box Variable : FilterPartyNameGWLWCUSTOMER Modifies : FilterPartyNameGWLWCUSTOMER [Collection: filterledgerCUSTOMER] Type : Ledger ChildOf : $$GroupSundryDebtors BelongsTo : Yes [System:Formula] SMSFilterCUSTOMER : $Name=@@PartyLedgerWise PartyLedgerWise : If $$IsEndOfList:##FilterPartyNameGWLWCUSTOMER or ##FilterPartyNameGWLWCUSTOMER="" Then $Name Else ##FilterPartyNameGWLWCUSTOMER [Variable: PartyNameGWLWCUSTOMER] Type : String Repeat : ##DSPRepeatCollection [Variable:FilterPartyNameGWLWCUSTOMER] Type : String [System:Variables] FilterPartyNameGWLWCUSTOMER : "" [Line:CASHSALEREPORTtitleNIK] Field:CASHSALEREPORTtitleNIK Right Field: uni date field;; Space Bottom:.5 Local:Field:uni date field:Set as:##SVCURRENTDATE;;DATE FIELD2 Local:Field:uni date field:Width:10;;;DATE FIELD3 [Field:CASHSALEREPORTtitleNIK] Use:name field Indent:6 Set as:"CUSTOMER WISE SALE REPORT" Full Width:Yes Style:HEADER TITLE Align:Center Color:red Border:THICK BOTTOM Wide Space:Yes; Line:1.5;;;0 [#Style:HEADER TITLE] Height:grow 20% [Part:CASHSALEREPORTbodyNIK] Line:CASHSALETITLELINENIK,CASHSALEDETAILLINENIK Bottom Line : CASHSALEDETAILLINENIKTota Repeat:CASHSALEDETAILLINENIK:SalesPartyWiseColletion Scroll:Vertical Common Border:Yes Total:CSPARTYSALENIK Total:CSTOTALBILLAMTNIK Background:GREEN [Collection:CASHSALECOLLNIK] Type : VOUCHERS : VoucherType Child Of : $$VchTypeSales Belongs To : Yes [Collection : SalesPartyWiseColletion] Source Collection : CASHSALECOLLNIK Walk : InventoryEntries By : ParttLedgername : $PartyLedgerName Aggr Compute: Amount : Sum : $$AsAmount:$Amount Format : $ParttLedgername, 10 [#Field : Vchnarration] Table : SalesPartyWiseColletion ;Filter : NOTIsOptionalVoucher,SMSFilterCUSTOMER [Line:CASHSALETITLELINENIK] Field :CS SNONIK, CS PARTYNAMENIK, Right Field : CS PARTYSALENIK,CS TOTALBILLAMTNIK Local:Field:CS SNONIK:Info:"Sr NO" Local:Field:CS PARTYNAMENIK:Set as:"CUSTOMER NAME" Local:Field:CS PARTYSALENIK:Info:"SALE VALUE" Local:Field:CS TOTALBILLAMTNIK:Info:"BILL AMOUNT" Border:Flush Column Titles Local:FieldEFAULT:Color:BLUE [Line:CASHSALEDETAILLINENIK] Field:CS SNONIK, CS PARTYNAMENIK, Right Field : CSPARTYSALENIK,CS TOTALBILLAMTNIK [Field:CS SNONIK] Use : NUMBER FIELD Set as : $$Line Border : HIN LEFT [Field:CS PARTYNAMENIK] Use : NAME FIELD Set as : $ParttLedgername Display : Voucher Border : THIN LEFT Width : 45 [Field:CS PARTYSALENIK] Use :Amount FIELD Set as : $Amount Width :20 ;Format :"DrCr,Nozero," Border:THIN LEFT [Field:CS TOTALBILLAMTNIK] Use:AMOUNT FIELD Set as:$debitTotals Format:"DrCr,Nozero," Border:THIN LEFT Width:15 [Part : CASHSALEDETAILLINENIKTota] Line : CASHSALEDETAILLINENIKTota [Line : CASHSALEDETAILLINENIKTota] Field :CS SNONIK, CS PARTYNAMENIK, Right Field : CS PARTYSALENIK,CS TOTALBILLAMTNIK Local: Field : CS SNONIK : Info : "" Local: Field : CS PARTYNAMENIK : Info : "Total" Local:Field:CS PARTYNAMENIK :Set as : $$Total:CSPARTYNAMENIK Local:Field:CS PARTYSALENIK :Set as : $$Total:CSPARTYSALENIK Border : THin Top Bottom
[#Menu:GATEWAY OF TALLY] Add:Item:MYREPORTisplay:CUSTOMERSALEREPORT [Report:CUSTOMERSALEREPORT] UseSP TEMPLATE Form:CASHSALEREPORTNIK Set : SVFromDate: ##SVCurrentDate Set : SVToDate : ##SVCurrentDate Set : FilterPartyNameGWLWCUSTOMER : "" [Form:CASHSALEREPORTNIK] UseSP TEMPLATE Height:100% SCREEN Width:100% SCREEN Part:CASHSALEREPORTtitleNIK,CASHSALEREPORTbodyNIK Button:EXPLODEFLAG,BtnPartyNameGWLWFilterCUSTOMER [Part:CASHSALEREPORTtitleNIK] Line:CASHSALEREPORTtitleNIK,KCUSTOMER Background:YELLOW [Line:kCUSTOMER] Right Field : Name Field Left Field : Short Prompt,SMSfilterRptCUSTOMER 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:SMSfilterRptCUSTOMER] Use : Simple Field Style : Normal Set as : @CSITEMNAMENIK Set Always : Yes CSITEMNAMENIK : If $$IsEndOfList:##FilterPartyNameGWLWCUSTOMER or ##FilterPartyNameGWLWCUSTOMER="" Then "" Else ##FilterPartyNameGWLWCUSTOMER [Button:BtnPartyNameGWLWFilterCUSTOMER] Key : F5 Action : Execute : Dispatch DetailsWiseCUSTOMER Title : PARTY NAME [Reportispatch DetailsWiseCUSTOMER] Form : Dispatch DetailsWiseCUSTOMER [Formispatch DetailsWiseCUSTOMER] Part : Dispatch DetailsWiseCUSTOMER Space Left : 2 mms Space Right : 2 mms [Partispatch DetailsWiseCUSTOMER] Line : Dispatch DetailsWiseCUSTOMER [Lineispatch DetailsWiseCUSTOMER] Field : Medium Prompt,Dispatch DetailsWiseCUSTOMER Local : Field : Medium Prompt : Set as : "Select Party Name:" Space Bottom : 2 mms [Fieldispatch DetailsWiseCUSTOMER] Table : filterledgerCUSTOMER,EndOfList ShowTable : Always Use : Name Field Width : 20 Border : Thin Box Variable : FilterPartyNameGWLWCUSTOMER Modifies : FilterPartyNameGWLWCUSTOMER [Collection: filterledgerCUSTOMER] Type : Ledger ChildOf : $$GroupSundryDebtors BelongsTo : Yes [System:Formula] SMSFilterCUSTOMER : $Name=@@PartyLedgerWise PartyLedgerWise : If $$IsEndOfList:##FilterPartyNameGWLWCUSTOMER or ##FilterPartyNameGWLWCUSTOMER="" Then $Name Else ##FilterPartyNameGWLWCUSTOMER [Variable: PartyNameGWLWCUSTOMER] Type : String Repeat : ##DSPRepeatCollection [Variable:FilterPartyNameGWLWCUSTOMER] Type : String [System:Variables] FilterPartyNameGWLWCUSTOMER : "" [Line:CASHSALEREPORTtitleNIK] Field:CASHSALEREPORTtitleNIK Right Field: uni date field;; Space Bottom:.5 Local:Field:uni date field:Set as:##SVCURRENTDATE;;DATE FIELD2 Local:Field:uni date field:Width:10;;;DATE FIELD3 [Field:CASHSALEREPORTtitleNIK] Use:name field Indent:6 Set as:"CUSTOMER WISE SALE REPORT" Full Width:Yes Style:HEADER TITLE Align:Center Color:red Border:THICK BOTTOM Wide Space:Yes; Line:1.5;;;0 [#Style:HEADER TITLE] Height:grow 20% [Part:CASHSALEREPORTbodyNIK] Line:CASHSALETITLELINENIK,CASHSALEDETAILLINENIK Bottom Line : CASHSALEDETAILLINENIKTota Repeat:CASHSALEDETAILLINENIK:SalesPartyWiseColletion Scroll:Vertical Common Border:Yes Total: CS PARTYSALENIK, CS TOTALBILLAMTNIK Background:GREEN [Collection:CASHSALECOLLNIK] Type : VOUCHERS : VoucherType Child Of : $$VchTypeSales Belongs To : Yes Fetch : Amount [Collection : SalesPartyWiseColletion] Source Collection : CASHSALECOLLNIK By : ParttLedgername : $PartyLedgerName Aggr Compute: SalesAmount : Sum : $$CollAmtTotal:InventoryEntries:$AMount Aggr Compute: NetAmount : Sum : $$AsAmount:$Amount [#Field : Vchnarration] Table : SalesPartyWiseColletion ;Filter : NOTIsOptionalVoucher,SMSFilterCUSTOMER [Line:CASHSALETITLELINENIK] Field :CS SNONIK, CS PARTYNAMENIK, Right Field : CS PARTYSALENIK,CS TOTALBILLAMTNIK Local:Field:CS SNONIK:Info:"Sr NO" Local:Field:CS PARTYNAMENIK:Set as:"CUSTOMER NAME" Local:Field:CS PARTYSALENIK:Info:"SALE VALUE" Local:Field:CS TOTALBILLAMTNIK:Info:"BILL AMOUNT" Border:Flush Column Titles Local:FieldEFAULT:Color:BLUE [Line:CASHSALEDETAILLINENIK] Field:CS SNONIK, CS PARTYNAMENIK, Right Field : CSPARTYSALENIK,CS TOTALBILLAMTNIK [Field:CS SNONIK] Use : NUMBER FIELD Set as : $$Line Border : HIN LEFT [Field:CS PARTYNAMENIK] Use : NAME FIELD Set as : $ParttLedgername Display : Voucher Border : THIN LEFT Width : 45 [Field:CS PARTYSALENIK] Use :Amount FIELD Set as : $SalesAmount Width :20 ;Format :"DrCr,Nozero," Border:THIN LEFT [Field :CS TOTALBILLAMTNIK] Use :AMOUNT FIELD Set as :$NetAmount Border :THIN LEFT Width :15 [Part : CASHSALEDETAILLINENIKTota] Line : CASHSALEDETAILLINENIKTota [Line : CASHSALEDETAILLINENIKTota] Field :CS SNONIK, CS PARTYNAMENIK, Right Field : CS PARTYSALENIK,CS TOTALBILLAMTNIK Local: Field : CS SNONIK : Info : "" Local: Field : CS PARTYNAMENIK : Info : "Total" Local:Field:CS PARTYSALENIK :Set as : $$Total:CSPARTYSALENIK Local:Field:CS TOTALBILLAMTNIK :Set as : $$Total:CSTOTALBILLAMTNIK Border : THin Top Bottom
Sir,thankyou report is working but the the new transaction of voucher not created they cant save bill..please solve it sir