Debit note Amount Not showing in my report

Discussion in 'Tally Developer' started by Jenny, Feb 20, 2019.

    
  1. Jenny

    Jenny Active Member


    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
    
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    DGST1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"DGST" ;;;;for debitnote


    Problem coming from here....................
     


  3. Jenny

    Jenny Active Member


    what is the solution for that?
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    that i do not know..............

    let other experts see tot that............
     


  5. Rais Ahmed

    Rais Ahmed Member


    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 ?
     


  6. Jenny

    Jenny Active Member


    Can you correct my code please?...
     


  7. Rais Ahmed

    Rais Ahmed Member


    It is not big work. I M also newbie try as i suggest then inform.
     


  8. Jenny

    Jenny Active Member


    I am not a perfect developer....i am trying but not done...
     


  9. Rais Ahmed

    Rais Ahmed Member


    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.
     


  10. Rais Ahmed

    Rais Ahmed Member


    Jennyji any improvement?
     


  11. Jenny

    Jenny Active Member


    nothing........
     


Share This Page