help needed

Discussion in 'Free Source Codes' started by panam, Oct 24, 2020.

    
  1. Himanshu-2002

    Himanshu-2002 Active Member


    I don't think so that there is any attribute to hide a table....If you don't want table then Just Delete it....But Why are you trying to hide table ?
     
    panam likes this.


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Answer to this is given is POST # 23 above..........
     
    panam likes this.


  3. panam

    panam Member


    dear Himanshu ji, i think u didn't understand my query.
    i dont want to hide the full table, but want to hide(temporary) the quantity of stock items which become zero closing balance in the list of stock items while passing sales voucher.
    The purpose of this code is that we have more than 3000 stock items. while billing sales voucher, we have to keep pressing down arrows for selecting the stock items. it is time consuming and difficult to search or select the stock items. so if we hide the zero closing stock of stock items temporarily, then we can do faster billing.

    note: we cant inactive these stock items with zero closing balance because these items will be purchased every quarter.
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Use Filter in the Collection.............. $ClosingStock <= 0
     
    panam likes this.


  5. panam

    panam Member


    Thank u Amit sir for the instant reply and help...
     


  6. panam

    panam Member


    dear experts,
    i want to set date always 01-04-2020 in stock item for standard selling price not for standard cost.
    this code sets date on standard cost not in standard selling price. please give the field name.

    [#Field:STKitemDate]
    Set As: "01-04-2020"
    Skip on: Yes
     


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    What exactly u want? and where do you want it?

    The field u r editing is from the Master. And I believe you want that standard selling price in some Invoice............
     


  8. panam

    panam Member


    dear sir,
    i want to set date always 01-04-2020 in stock item for standard selling price automatically .
    pls check my screenshot.
     

    Attached Files:



  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Not possible........it is a Aggregate list and common to both Cost and Selling...........

    Any changes you make, will affect both.
     
    panam likes this.


  10. Himanshu-2002

    Himanshu-2002 Active Member


    Try This

    [#Field:STKitemDate]
    Delete: Set as
    Set As: $$Date:"01-04-2020"
     
    panam likes this.


  11. Himanshu-2002

    Himanshu-2002 Active Member


    Amit Sir... What is aggregate list ?
     


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You can use the FromValue function.............
     
    panam likes this.


  13. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    It is a UDF data type........ you use when you need a list of values and then you can pick out from that list as per condition.

    e.g. company can have a list of Motor vehicles numbers, chassis #, make, Mfg Year..........
    e.g. like Closing Stock in Tally......... u specify the date and its corresponding values........

    And you can repeat the LINE with a Aggregate UDF.
     
    panam likes this.


  14. Himanshu-2002

    Himanshu-2002 Active Member


    Oo I thought Aggregate List is different from Aggregate UDF
     


  15. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    My Bad, am not a professional programmer ......... and cannot talk in code language like you guys..............so twists n turns happens.
     
    panam likes this.


  16. Himanshu-2002

    Himanshu-2002 Active Member


    Sir I am Not a professional programmer but I like the complement
     
    panam likes this.


  17. Himanshu-2002

    Himanshu-2002 Active Member


    Complement From a Person Like You gives me something... Which only I can feel
     
    Amit Kamdar and panam like this.


  18. panam

    panam Member


    dear himanshu ji, code not working.
    i have modified your suggested code but the date is being repeating more times.
    check screenshot..

    [#Field:STKitemDate]
    Set As: $$Date:"01-04-2020"
    skip :yes

    [#Field:STKITEMstdcost]
    Set :"0"
    skip on :yes
    Set Always : Yes


    [#Field:STKITEMstdcostper]
    Skip on: Yes
    Set Always : Yes
     

    Attached Files:



  19. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Set As: If $$Line=1 Then $$Date:"01-04-2020" Else ""
     
    panam likes this.


  20. panam

    panam Member


    dear Amit sir,
    You are Genius & master in Tdl sir. The coding is 100% working.

    Thank u very much Amit Sir and Himanshu ji for the reply and help.
    i am very much happy today because of learning of new things in this forum also got the desired results.
     


  21. Himanshu-2002

    Himanshu-2002 Active Member


    Panam Sir..You can call me Himanshu..
     
    panam likes this.


  22. panam

    panam Member


    ok friend.
     


  23. panam

    panam Member


    udf sales leger.jpg dear experts/ members,
    i want EIAccAllocname udf1.jpg to be diplayed in udf.
    please help...



    [#Line: EI COLUMNONE]
    Add:Right Fields:Before:VCH QtyTitle:Ledname
    [Field:Ledname]
    Use:NAME FIELD
    Set as:"LEGER name"
    Width: 20
    Color: BLUE
    Style: NORMAL BOLD
    Align : Right
    Skip : YES
    Set Always: Yes
    Border: thick left right



    [#Line:ei invinfo]
    Add:Right Fields:Before:VCH BilledQty:Ledname1

    [#Line:ci invinfo]
    Add:Right Field:before: VCH BilledQty:Ledname1
    [Field:Ledname1]
    Use : Name Field
    Set as:$EIAccAllocname:vchAccAllocation
    Align : right
    Skip : Yes
    Width:20
    Set Always: Yes
     


  24. Himanshu-2002

    Himanshu-2002 Active Member


    Set as: $$FullList: AccountingAllocation:$EIAccAllocname
     
    panam likes this.


  25. panam

    panam Member


    error.jpg Himanshu bro thank u for the help.
    but getting error
     


Share This Page