1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Repeat Line for description & delete for sq.mt qty & Rate

Discussion in 'Free Source Codes' started by JCTS, Jun 8, 2019.

    
Tags:
Page 2 of 2
  1. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    If you were using this value to calculate Invoice then you would be under-invoicing......... it is better to divide the Sq.Ft by 10.76 ........ i.e. 100/10.76 .... instead of using factorial multiplication.

    In the screenshot above..... adopt the division by 10.76 and check the results. 10.76 is a standard, ignoring the rest of the decimals as is the normative practice followed all over.
     
    Amit Kamdar, Jun 9, 2019
    #26


  2. JCTS

    JCTS Member


    Thank you for suggestion. Actually this conversion factor given by customer. Let me ask customer if he is ok then we shall implement it.

    but we can use it for other sq.mt conversion factor.
     
    JCTS, Jun 9, 2019
    #27


  3. JCTS

    JCTS Member


    Closing balance is calculating correctly but previous balance & current bill amount is not capturing. If i disabled customised invoice tld and attach previous balance tdl then it is working fine. Please guide.

    [Field: prevbald]
    Field : Simple Prompt, Amount Field
    Local : Field : Simple Prompt : Info : "Prev. Balance:"
    Local : Field : Simple Prompt : Width : 14
    Local : Field : Amount Field : Set as : If ($$IsDr:$$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries) +
    then($$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries)-$$abs:#EXPINVTOTAL else +
    ($$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries)+$$abs:#EXPINVTOTAL
    Local : Field : Amount Field : Format : "Symbol,DrCr"

    [Field: Billamtd]
    Field : Simple Prompt, Amount Field
    Local : Field : Simple Prompt : Info :$$LocaleString:"Bill Amount:"
    Local : Field : Simple Prompt : Width : 14
    Local : Field : Amount Field : Set as : #EXPINVTotal
    Local : Field : Amount Field : Format : "Symbol,DrCr"

    [Field: Clobal]
    Field : Simple Prompt, Amount Field
    Local : Field : Simple Prompt : Info : "Net Balance :"
    Local : Field : Simple Prompt : Width : 14
    Local : Field : Amount Field : Set as : $$ToValue:$date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries
    Local : Field : Amount Field : Format : "Symbol,DrCr"
     

    Attached Files:

    JCTS, Jun 9, 2019
    #28


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Problem is...might be there is no value in #EXPINVTOTAL ................

    as a R&D, remove all #EXPINVTOTAL and see....if the other figures come....................
     
    Amit Kamdar, Jun 9, 2019
    #29


  5. JCTS

    JCTS Member


    Yes removed #EXPINVTOTAL and added: $$CollAmtTotal:LedgerEntries:$Amount. after that total value is not coming. only gross amount is coming.
     
    JCTS, Jun 9, 2019
    #30


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    what is ur field name of the Invoice Total???

    I did not ask you to add anything....just remove something......and then see.
     
    Amit Kamdar, Jun 9, 2019
    #31


  7. JCTS

    JCTS Member


    If I removed #EXPINVTOTAL then showing error in Set As:

    Invoice total field is

    [Line:OTS Invoice Amount]
    Field: Name Field, Amount Field
    Local:Field: Name Field: Set as: "INVOICE TOTAL"
    Local:Field: Name Field: Style: Large Bold
    Local:Field: Name Field: Width:22.6
    Local:Field: Name Field: Align: Right
    Local:Field: Amount Field: Set as: $Amount
    Local:Field: Amount Field: Style: Large Bold
    Local:Field: Amount Field: Width: 9
    Local: Field: Amount Field: Align: Right
    Border: Thick Top
    Space Top: 2.5
    Space Bottom: 0.5
     
    JCTS, Jun 9, 2019
    #32


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    study the file from where u copied the SET AS for the mini statement...........

    it is using a "local formula" to compute then referring to that formula in the SET AS........... you use it the same way.
     
    Amit Kamdar, Jun 9, 2019
    #33


  9. JCTS

    JCTS Member


    Amitjee.. #EXPINVTOTAL replaced with $Amount. Code is working fine.

    [Field: prevbald]
    Field : Simple Prompt, Amount Field
    Local : Field : Simple Prompt : Info : "Prev. Balance:"
    Local : Field : Simple Prompt : Width : 14
    Local : Field : Amount Field : Set as : If ($$IsDr:$$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries) +
    then($$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries)-$$abs:$amount else +
    ($$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries)+$$abs:$amount
    Local : Field : Amount Field : Format : "Symbol,DrCr"

    [Field: Billamtd]
    Field : Simple Prompt, Amount Field
    Local : Field : Simple Prompt : Info :$$LocaleString:"Bill Amount:"
    Local : Field : Simple Prompt : Width : 14
    Local : Field : Amount Field : Set as : $amount
    Local : Field : Amount Field : Format : "Symbol,DrCr"

    [Field: Clobal]
    Field : Simple Prompt, Amount Field
    Local : Field : Simple Prompt : Info : "Net Balance :"
    Local : Field : Simple Prompt : Width : 14
    Local : Field : Amount Field : Set as : $$ToValue:$date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries
    Local : Field : Amount Field : Format : "Symbol,DrCr"
     

    Attached Files:

    JCTS, Jun 9, 2019
    #34


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Very good... you are learning fast.....
     
    Amit Kamdar, Jun 9, 2019
    #35
    JCTS likes this.


  11. JCTS

    JCTS Member


    Thanks for guidance Amitjee..
     
    JCTS, Jun 9, 2019
    #36


  12. JCTS

    JCTS Member


    1) I have created class given multiple gst rate & other charges. if my other charges is 0 then it should not show in invoice print.

    [Part: OTS Bottom Part 1 Right]
    Line: OTS Invoice Ledger Entries
    Repeat: OTS Invoice Ledger Entries:LedgerEntries
    Bottom Line: OTS Invoice Amount
    Common Border: Yes
    Border: Thick Left

    [Line: OTS Invoice Ledger Entries]
    Field: Name Field, Amount Field
    Local: Field: Name Field: Set as:if $$Isempty:$LedgerName then "" else $LedgerName
    ; Local: Field: Name Field:Invisible : $$Isempty:$LedgerName
    Local: Field: Name Field: Style: O9
    Local: Field: Name Field: Width:22.6
    Local: Field: Name Field: Align: Right
    Local: Field: Amount Field: Set as:$Amount;$Amount
    Local: Field: Amount Field: Style: O9B
    Local: Field: Amount Field: Border: Thick Left
    Local: Field: Amount Field: Width:9
    Remove if: $LedgerName contains $PartyLedgerName
    Invisible : if $$Isempty:$LedgerName then "" else $LedgerName
    Space Top:0.25


    2) 2) Second query is i have disabled : Enable supplimentary details: No. Then party address & GSTIN is not printing.
     

    Attached Files:

    JCTS, Jun 27, 2019
    #37


  13. JCTS

    JCTS Member


    @amit Kamdarji and all..please guide.
    1) I have created class given multiple gst rate & other charges. if my other charges is 0 then it should not show in invoice print. it is taking too much space.

    [Line: OTS Invoice Ledger Entries]
    Field: Name Field, Amount Field
    Local: Field: Name Field: Set as:if $$Isempty:$Amount then "" else $LedgerName


    2) Second query is i have disabled : Enable supplimentary details: No. Then party address & GSTIN is not printing.
     

    Attached Files:

    JCTS, Jun 28, 2019
    #38


  14. JCTS

    JCTS Member


    1) I have created class given multiple gst rate & other charges. if my other charges is 0 then it should not show in invoice print. it is taking too much space.

    [Line: OTS Invoice Ledger Entries]
    Field: Name Field, Amount Field
    Local: Field: Name Field: Set as:if $$Isempty:$Amount then "" else $LedgerName

    ; Seen default code of accouting details line [Line: EXPINV AccDetails] Taken lot of time to resolve this issue.
    Empty : $$IsEmpty:$Amount AND $RemoveZeroEntries

    Now, this issue has been resolved.
     
    JCTS, Jun 28, 2019
    #39


  15. JCTS

    JCTS Member


    2) Second query is i have disabled : Enable supplimentary details: No. Then party address & GSTIN is not printing.

    This issue also resolved.
     
    JCTS, Jun 30, 2019
    #40


  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    As per your condition specified, you are coding it .... to remove "If empty - ledgername", instead you sud give condition $$IsEmpty:#Amountfield or #Amountfield=0

    As for 2nd query ......you need to force Tally to accept the "enable" in printmode.....check/scan the default code in TDE of Partyaddress and GSTIN and why it is being preventing printing when supplementary details is disabled.
     
    Amit Kamdar, Jul 2, 2019
    #41
    JCTS likes this.


  17. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Good..... self help is best........ :)

     
    Amit Kamdar, Jul 2, 2019
    #42
    JCTS likes this.


  18. JCTS

    JCTS Member


    @amitKamdar jee.. Thank you..
     
    JCTS, Jul 2, 2019
    #43


  19. JCTS

    JCTS Member


    Thank you very much :)
     
    JCTS, Jul 2, 2019
    #44


Page 2 of 2

Share This Page