Code: [Part : daybookheadbb] Use : GST Sales Delete : Repeat Delete : Scroll Border : ColumnTitles Local : Field : Default : Type : string Local : Field : My Voucher Srl : Set As : "Sr.No" Local : Field : MyVoucherParty: Set As : "Party Name" Local : Field : MyVchTIN : Set As : "GST No" Local : Field : MyVchNo : Set As : "Bill No" Local : Field : My Voucher Date2: Set As : "Bill Date" Local : Field : IGST PER:Set as:"%" Local : Field : MyVchAmountx : Set As : "Basic Amount" Local : Field : MyVchfNo5 : Set As : "CGST " Local : Field : MyVchfNo6 : Set As : "SGST " Local : Field : MyVchfNo7 : Set As : "IGST " Local : Field : MyVchTotAmountx : Set As : "Total Amount" Local : Field : MyVchfNo8 : Set As : "Debit Note " Local :Field : Default : Style : Normal Local: Field: Default: Align: Center [Part :GST Sales] Line : GST Sales Repeat :GST Sales :My Voucher Rep Collection TOTAL : My Voucher Srl,MyVchAmountx,MyVchfNo7,MyVchfNo5,MyVchfNo6,MyVchfNo7,MyVchTotAmountx,MyVchfNo8 Common Border : Yes Scroll : Vertical [Line :GST Sales] Field :My Voucher Srl,MyVoucherParty,MyVchTIN,MyVchNo,My Voucher Date,IGST PER1,MyVchAmountx,MyVchfNo7,MyVchfNo5,MyVchfNo6,MyVchfNo7,MyVchTotAmountx,MyVchfNo8 Option : Alter on enter Option : DisplayOnAltEnter Explode : My TB Inv Explosion : ##ExplodeFlag or $$KeyExplode Option:Colorfull display1:$amount>10000 [!Line:Colorfull Display1] Local:Field:MyVoucherParty:Color:DARK red Local:Field:MyVchAmountx:Color:dark red [Part: My TB Inv Explosion1] Lines : My TB Inv Explosion1 Repeat : My TB Inv Explosion1 : ledger Entries;Inventory Entries Scroll : Vertical [Line : My TB Inv Explosion1] Field : My TB Inv ExplosionItem1 ; here add other fields Indent : 5 [Field: My TB Inv ExplosionItem1] USe : Name field Set as : $LedgerName;$StockItemName ;Option : Alter On Enter [Field :My Voucher Srl] Use : Number Field SET AS:$$LINE Width : 4% Screen Align: Right Border : Thin LEFT Right [Field :My Voucher Date] Use : Short Date Field Set As : $Date Border : Thin Right Format:"Short Date" [Field : MyVoucherParty] Use : NAme Field Set As : $LedgerName ;;;$BASICBUYERNAME Width : 35 Border : Thin Right Alter : Voucher Display : Ledger Vouchers:$$ISLedger Variable: Ledger Name [Field : MyVchTIN] Use : Name Field Set As :$PartyGSTIN:Ledger:$PartyLedgerName Width : 11 Border : Thin Right [Field : MyVchNo] Use : NAme Field Set As : $REFERENCE Width : 10 Border : Thin Right Align:Center [Field:IGST PER1] Use: Number Field Set as:$(Stockitem,$stockitem).GSTIGSTRate Format : "NoZero,Percentage" Set Always: Yes Border : Thin Right Align:Center Width:4 [Field : MyVchAmountx] 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 : MyVchfNo5] Use : Amount Forex Field Set as:$$FilterAmtTotal:LedgerEntries:CGST1:$Amount; $CGSTAmount is ok Border : Thin Right Width : 10 ;*********************** [Field : MyVchfNo6] Use : Amount Forex Field Set as : $$FilterAmtTotal:LedgerEntries:SGST1:$Amount;$SGSTAmount Border : Thin Right Width : 10 ;*********************** [Field : MyVchfNo7] Use : Amount Forex Field Set as : $$FilterAmtTotal:LedgerEntries:IGST1:$Amount;$IGSTAMOUNT ; this problems Border : Thin Right Width : 10 ;*********************** [Field : MyVchTotAmountx] Use : Amount Field Set As : $Amount Border : Thin Right ;*********************** [Field : MyVchfNo8] Use : Amount Forex Field Set as : "" Border : Thin Right Width : 10 ;*********************** [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" DGST :$$FilterAmtTotal:LedgerEntries:DGST1:$Amount DGST1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"DGST" ;;;;for debitnote [Collection : My Voucher Rep Collection] Type : Ledger ;Sort : Default : $BASICBUYERNAME Type : Vouchers Walk : allLedgerEntries Filter : IsSalesVT ;;;;,CSTFilter ;;,Recfiltee 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 Is ODBCTable: Yes [Part: daybookbottam] Lines : daybookTotalLine [Line: daybookTotalLine] Use : GST Sales Local: Field: Default : Style : Small Bold ;Local: Field: Default: Type: String Local: Field: Default: Align: Right Local : Field : My Voucher Srl : Set as:$$NumItems:MyVoucherRepCollection;$$PrevLine:#MyVoucherSrl Local : Field : MyVoucherParty: Set As : "Total" Local : Field : MyVchNo : Set As : "" Local : Field : MyVchAmountx : Set As : $$Total:MyVchAmountx LOCAL : FIELD: MyVchfNo5:Set as:$$Total:MyVchfNo5 LOCAL : FIELD: MyVchfNo6:Set as:$$Total:MyVchfNo6 LOCAL : FIELD: MyVchfNo7:Set as:$$Total:MyVchfNo7 LOCAL : FIELD: MyVchTotAmountx:Set as:$$Total:MyVchTotAmountx Border : Totals [System: Formula] IsSalesVT : $$IsSales:$VoucherTypeName IsSalesVT1 : $$IsDebitNote:$VoucherTypeName CSTFilter : not ##IsRevChargeAppl
DGST1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"DGST" ;;;;for debitnote Problem coming from here....................
1) You must have ledger name DGST. 2) In collection filter u don't have mention of debit note voucher filter, but in system formula it has. 3) in voucher8 field u must have Set As: like CGST,SGST.IGST otherwise how amount come ?
By the way I cant understand DGST? what is this? If u want to call Tax amount of DN then only filter in collection is sufficient. And U r not so new that U can not do this simple thing. just try bhai. in Ur VCH no. 5,6,7 what u put same u put concern formula in no. 8 this will solve Ur problem. Just try Pl .Let me know.