Item Sales History while Invoicing

Discussion in 'Free Source Codes' started by Nirav Merchant, Jul 11, 2014.

    
  1. ankitda

    ankitda New Member


    Hi,

    Even I am getting the same error. Did it get resolved for you? If yes, how?
     


  2. Hemanth

    Hemanth New Member


    can any one tell in which screen i can use this add by using which short cut.
     


  3. Hemanth

    Hemanth New Member


    Please let me how can i use this. When I am Pressing the F4 key in the sales voucher, the voucher is converting from Sale voucher to Contra voucher
     


  4. Hemanth

    Hemanth New Member


    Got it Nice work sir thank you
     


  5. tejeet

    tejeet Member


    dear sir,
    please develop tdl for sales history for only reference to related party , it should show sales history only of related party instead of all customer & also it should show price, discount
     
    ankitinfo likes this.


  6. vaithy

    vaithy New Member


    HAI, I HAVE ADDED THE PERIOD .... PLZ CHECK
     

    Attached Files:



  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Last 20 transactions of SALES - Item ...irrespective of period.....


    StockItem Diary (Sales-Purchase) 02.PNG
     
    ankitinfo likes this.


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Last 20 transactions of PURCHASES - Item ...irrespective of period.....

    StockItem Diary (Sales-Purchase) 03.PNG
     


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Last 40 transactions of LEDGER entries...irrespective of period.....

    LedgerDiary01.PNG
     
    SANDIP R LATHIYA likes this.


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Right now these are 2 modules.... 1 modules contains both Sales/Purchase history for that item and 2nd module relates to transactions of that Ledger account.

    For your requirement a new module would have to be made.
     


  11. amit

    amit New Member


    post code here
     


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Are you ordering or requesting ??
     


  13. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Here you are..............
    Alt+L on any Ledger Field in voucher.
    Alt+F8 or Alt+F9 on any Stock Item field in voucher.
     

    Attached Files:



  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    here is the revised one.............
     

    Attached Files:



  15. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    here is the revised one.............
     
    ankitinfo likes this.


  16. sivam

    sivam Active Member


    Add Sort in your Collection based on Date.

    Ex:

    Sort : Default : -$Date
     
    vinoth likes this.


  17. sivam

    sivam Active Member


    Add this line in all your collections

    Sort : @@Default : -$Date
     


  18. sivam

    sivam Active Member



    Welcome Keep Learning...
     
    ankitinfo likes this.


  19. sivam

    sivam Active Member



    in your Repeat Line Level("LnSalesHistoryHD" Line) add this

    Empty : $$line >= 50
     


  20. sivam

    sivam Active Member


    Add That code Like Below

    [Line : LnSalesHistoryData]
    Empty : $$line >= 50
     


  21. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Use this in your body line..........
    [Line : yourbody]
    Remove If : $$Line > 50
     


  22. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Also try to generate serial numbers in reverse order...............

    please refer to my code............
     
    ankitinfo likes this.


  23. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Be Logical....you do not have a Serial Number field, then how can it work.........make a serial number field and then apply this in your.........

    [Line : LnSalesHistoryData]
    Remove If : $$Line > 50
     
    ankitinfo likes this.


  24. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Inside [Report : RptSalesHistory] and [Report : RptPurchaseHistory]
    Insert lines ..............
    Variable : HistoryFrom, HistoryTo
    Set : HistoryFrom :
    Set : HistoryTo : $$FinYearEnd:##SVCurrentDate:$StartingFrom:Company:##SVCurrentCompany

    ==================
    Now it is for you to do...................
    A) Define Variable and System variable.............
    B) Make a formula.......
    ----------- Extractyear : wherein you extract the year from $$FinYearBeg:##SVCurrentDate:$StartingFrom:Company:##SVCurrentCompany or whatever other methods available.
    ----------- Historybeginyear : Substract this year by 3 or 5 or 10....depends on how many years you want to go back.............
    ----------- Make a string .... "01/04" + @@Historybeginyear (refer Tally developer, you can do all above easily)

    The value you get now is what you can put in "HistoryFrom" in the report level.

    So in essence, your data company will be from 18-19, whereas inside this report you can call data from whatever year you want to............

    Happy coding............
     
    ankitinfo likes this.


  25. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    that is good.... now stop asking all questions and try on your own.....

    it is basic formula............. make your own..............

    keep asking and you will learn less.... keep doing and you will learn more..........
     
    ankitinfo likes this.


Share This Page