Replace Ledger and Stock Item in Voucher Entries

Discussion in 'Tally Integration' started by Devendra_Rawat, May 22, 2018.

    
  1. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    Dear Friends with this TDL you can replace an accounting ledger and/or stock item from entries on the screen in Ledger Report or stock item report or Daybook

    Menu-Display Daybook,
    Menu-DisplayLedger,
    Menu-DisplayStock Item .

    Version 1.4 Menu
    moved to Utilities Menu


    This tool is handy when you have lot of entries in which you have entered a wrong ledger or stock item and now want to replace it .

    This tool will search for ledger and stock item in selected vouchers and modify them with new ledger and stock item.



    . look for button RBCRPLC ledger or RBCRPLC Item on right side button panel.


    24/05/2018
    File Modified and bug fixed for purchase entries

    Regards


    03/11/2018
    Version 1.2 capable of replacing one bank account with another bank Account.


    06/11/2018
    Version 1.3 Selected Voucher alternation available now

    Only selected lines/or vouchers/ledger will be altered .

    use select all button to replace all vouchers at one go..


    04th May 2019

    Version 1.4 comes with separate Menu under Utilities Menu

    Original Tally reports not modified .. new reports are used to perform operations

    Original Tally Day book from display menu -- export issue solved



    Regards
     
    Last edited: May 4, 2019


  2. mpal2311

    mpal2311 Active Member


    Nice Code. Great.
    Thanks for sharing.
     


  3. Umashankar

    Umashankar Member


    Well done Garima. Thanks for sharing your code.
     


  4. Devendra_Rawat

    Devendra_Rawat Well-Known Member



    Welcome
     
    panam likes this.


  5. Devendra_Rawat

    Devendra_Rawat Well-Known Member



    Welcome sir
     
    panam likes this.


  6. Rajsrisrimal

    Rajsrisrimal Member


    Great Help to all, Superb and Nice work Garima Ji
     


  7. Devendra_Rawat

    Devendra_Rawat Well-Known Member



    Welcome sir

    Thank You Sir
     


  8. Sanjeev S

    Sanjeev S Active Member


    Nice concept. Will have a real application in getting rid of duplicate Ledgers and Items created accidentally.

    One small issue, though I couldn't find time to rectify or go deep into it, its not working on Purchase entries showing some error of dr cr not matching. When ever I get time I will find out the issue either at my end or the code.

    But, as I said great code :)
     


  9. Devendra_Rawat

    Devendra_Rawat Well-Known Member



    You are right... but I forgot to check it even though I had noticed it earlier with purchase entries.. This may be due to reason that in sales entries stock is entered as negative while in purchase entries as positive.. the error lies in inventory allocation and batch allocation..

    I will look into it.
     
    panam likes this.


  10. Devendra_Rawat

    Devendra_Rawat Well-Known Member



    You are right... but I forgot to check it even though I had noticed it earlier with purchase entries.. This may be due to reason that in sales entries stock is entered as negative while in purchase entries as positive.. the error lies in inventory allocation and batch allocation..

    I will look into it.


    Purchase entry issue fixed now... at least I hope so .
     
    panam likes this.


  11. Sanjeev S

    Sanjeev S Active Member


    Nice concept. Will have a real application in getting rid of duplicate Ledgers and Items created accidentally.

    One small issue, though I couldn't find time to rectify or go deep into it, its not working on Purchase entries showing some error of dr cr not matching. When ever I get time I will find out the issue either at my end or the code.

    But, as I said great code :)
    Yes. It's working now.

    Thanks a lot
     


  12. Sridharan S

    Sridharan S Member



  13. Devendra_Rawat

    Devendra_Rawat Well-Known Member



    Great... both posted it around the same time.. I on 24th you on 28th May.. Only difference is yours is Exe file mine is TDL.

    We have using this tool in our office since last two years..and its for learning purpose
     
    panam likes this.


  14. Sridharan S

    Sridharan S Member


    So obviously yours is well tested. I appreciate your work.
     


  15. dudhebhate

    dudhebhate New Member


    Thanks for providing. Though purchase entry is fixed what about stock journals?
     


  16. Devendra_Rawat

    Devendra_Rawat Well-Known Member



    Great... both posted it around the same time.. I on 24th you on 28th May.. Only difference is yours is Exe file mine is TDL.

    We have using this tool in our office since last two years..and its for learning purpose
    Through Daybook, if stock journals are displayed in Day Book, then it can do it.. check Day Book, there is button to do it.. it will try to modify all type of vouchers which are there on screen, even after you apply range /filters.

    check it..
     
    panam likes this.


  17. Devendra_Rawat

    Devendra_Rawat Well-Known Member



    Great... both posted it around the same time.. I on 24th you on 28th May.. Only difference is yours is Exe file mine is TDL.

    We have using this tool in our office since last two years..and its for learning purpose
    Through Daybook, if stock journals are displayed in Day Book, then it can do it.. check Day Book, there is button to do it.. it will try to modify all type of vouchers which are there on screen, even after you apply range /filters.

    check it..
     


  18. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Good job.....very useful
     


  19. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Good job.....very useful
     


  20. dudhebhate

    dudhebhate New Member


    nope its not working
     


  21. dudhebhate

    dudhebhate New Member


     


  22. dudhebhate

    dudhebhate New Member


    nope its not working
     


  23. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    I need tdl, particular item rate change to new rate
     


  24. Devendra_Rawat

    Devendra_Rawat Well-Known Member


    Describe your requirement in details.. as there are different rates for different items.. how would you want to go with it .. process ?
     
    panam likes this.


  25. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    Single item name input new rate
     


Share This Page