3B Monthly Summary

Discussion in 'Free Source Codes' started by Jay kumar tailor, Oct 23, 2018.

    
  1. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Dear Experts,

    I Wants to Design this.
    . Capture.JPG
     
    Last edited: Dec 18, 2018


  2. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Set as :?

    For month
     


  3. hprahul

    hprahul Member


    You must please use the $BSCredit/$BSDebits for the ledger and to get for the month apply filter.

    For eg: for April filter can be $$MonthOfDate:$Date=4
     


  4. drive

    drive Active Member


    Sample GST Monthly With GST Auto Voucher Havala Credit-Debit
     

    Attached Files:



  5. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Good Job.
    Well done.

    dear drive,
    Some Changes Required.

    Replace "HAVALA" With "Adjustment."

    Gst Payment Entry Toggle.

    Show Related Month Turnover (GSTVchAssessableValue) On Top
     


  6. Maulik Patel

    Maulik Patel Active Member


    Good One.
     


  7. Jenny

    Jenny Active Member


    In this report just rectify if in sales part its showing debit note and in your report its showing calculate of total (cgst+sgst+debit note) but actually its minus them from sales and purchase also.same as purchase also.....in total its payable or receivable its showing perfect but in particular "sales & purchase" figure not perfect. Example given below
    sales :
    CGST = 200.00
    SGST = 200.00
    DEBITNOTE = 200.00
    ========================
    TOTAL = 600.00
    purchase :
    CGST = 500.00
    SGST = 500.00
    CREDITNOTE = 100.00
    ========================
    TOTAL = 1100.00
    Its 1100-600 = 500 Receivable

    in your report showing this list but actually showing this type

    sales :
    CGST = 200-50 = 150.00
    SGST = 200-50 = 150.00
    (50+50 =100, Is the credit note)
    ========================
    TOTAL = 300.00
    purchase :
    CGST = 500-100 = 400
    SGST = 500-100 = 400
    (50+50 = 100 Is the debit note)
    ========================
    TOTAL = 800.00
    Its 800-300 = 500 Receivable
     
    Last edited: Oct 26, 2018


  8. Vikash_Dhamecha

    Vikash_Dhamecha New Member


    Good One , but it is tcp file can u share TDL file
     


  9. Devendra_Rawat

    Devendra_Rawat Well-Known Member



    I could not understand what you want.. you need to explain it a little
     


  10. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    3B details monthwise
    For whole year

    Assessable value (outward)and tax details in single sheet

    Which is shown in 3b .
     
    sandeep76out likes this.


  11. drive

    drive Active Member


    It is Filter by TBalDebits & TBalCredits So We can't Justify it is sales or creditnote
     


  12. Jenny

    Jenny Active Member


    just modify it cuz its most important for its
     


  13. Jay kumar tailor

    Jay kumar tailor Well-Known Member


    Can you share txt here ?
     


  14. drive

    drive Active Member


    Sample : GST Monthwise , Daywise Purchase Reg. with GST R2. Ass. Value
     

    Attached Files:



  15. prabin kumar

    prabin kumar New Member


    tdl file for tax register
     


  16. sandeep76out

    sandeep76out New Member


    this is the best way to see GST summary :)
    if you have plz help :) :) Thank you
     


  17. Frz

    Frz Member


    expired
     


  18. drive

    drive Active Member


    It was sample tcp for how to making GST R2 Report.
     
    sandeep76out likes this.


  19. K.THIYAGARAJAN

    K.THIYAGARAJAN New Member


    PLEASE GIVE THIS TDL WITHOUT EXPIRED
     


  20. sivam

    sivam Active Member


    Great Job.. Nice Effort..
     


  21. K.THIYAGARAJAN

    K.THIYAGARAJAN New Member


    THIS TDL EXPIRED PLEASE REMOVE RESTRICATION
     


  22. drive

    drive Active Member


    Dear, K.THIYAGARAJAN it's Sample TCP not full version
     


  23. K.THIYAGARAJAN

    K.THIYAGARAJAN New Member


    OK THANK YOU
     


  24. Happy Kumar Verma

    Happy Kumar Verma New Member


    Dear Sir,
    Please provide a .txt file.
     


  25. hiteshhkj

    hiteshhkj Member


    I HAVE CREATED A TDL FILE WITH 3B ANALYSIS
    [​IMG]



    Screen clipping taken: 29/11/2019, 11:10 PM
     


Share This Page