GST PURCHASE LEDGER EXTRACT WITH GST AMOUNT

Discussion in 'Requests' started by PANKAJ BHONDLE, Feb 22, 2019.

    
  1. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member



  2. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    Untitled.png
     

    Attached Files:

    Vashisth likes this.


  3. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member



  4. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    upload_2019-2-22_3-8-8.png


    FINALY DONE FOR GST WORKING IN USE GSTR-3B
     
    Vashisth likes this.


  5. Johar

    Johar Member


    Pankaj, My GST Report created
     

    Attached Files:

    sandeep76out and Vashisth like this.


  6. Jenny

    Jenny Active Member


    Can u send me this code please?
     


  7. Rakesh Kumar

    Rakesh Kumar Member



  8. Pradeep Kothari

    Pradeep Kothari New Member


    Sir we will be highly obliged if you can share the tdl here or on my email id : p.mahavira@gmail.com
     


  9. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    GST PURCHASE REGISTER.png GST PURCHASE LEDGER.png GST LEDGER WISE PURCHASE.png

    1) GST PURCHASE REGISTER
    2) GST PURCHASE LEDGER
    3) GST PARTY WISE PURCHASE
     
    Rohit Khedar likes this.


  10. Rohit Khedar

    Rohit Khedar Member



  11. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    Thank You, Rohit Ji
     


  12. Rakesh Kumar

    Rakesh Kumar Member



  13. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    upload_2019-2-26_1-1-26.png

    1) PENDING FOR DEBIT NOTE & CREDIT NOTE
     


  14. vnrajugst

    vnrajugst New Member



  15. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member



  16. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    ABOVE GST WORKING IS FINAL, BUT MY QUIERY NOT SOLVE
    1) In Gst Working :- Total amount is blank (Debit note Or Purchase amount is empty condition)
    2) In Gst Working:- Total amount is blank ( Credit Note Or Sales Amount is empty condition)

    3) In Gst Working & Other report :- (Double bill field) not solve (in case purchase Register entry by mistake double voucher entry)
    4) In Purchase Register & Sales Register : Basic Amount value consider ledger Entries first , second entry in tax ledger, but second entry addition ledger not picup
    5) in Purchase & Sales Register: Pic up Basic Amount - first Purchase Ledger (i.e.Purchase State 5%) , Second Purchase Ledger (i.e.Purchase State 12%) not picup

    please help me, all genius tdl experts
     


  17. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    1) & 2) quiry solve
     


  18. Rajiv Prabhakar

    Rajiv Prabhakar New Member



  19. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    thanks, rajiv prabhakar
    no share code, but i am own practice in hard work 15 days & 15 night
     
    kishan369 and Amit Kamdar like this.


  20. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    thanks, Amit Kamdarji, for like this post
     


  21. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    For 4 and 5............

    $TotalLedDrVchAmt - IGSTAmt - CGSTAmt - SGSTAmt ( The GST Amount u have already computed separately. So deduct that from $TotalLedDrVchAmt.)
     
    PANKAJ BHONDLE likes this.


  22. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    Thanks Dear Amitji,
     


  23. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member



  24. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    1) One Issue Not Solve :no pic up single bill (mix bill entry) (i.e.Purchase State 5% & Purchase state 12%) in Purchase & Sales Entry
    2) Only Pic up First Purchase Ledger (i.e.Purchase State 5%)
     


  25. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Try this....

    $Amount - (@@CGSTTaxAmt + @@SGSTTaxAmt + @@IGSTTaxAmt)
     


Share This Page