1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Want some help for customize invoice title

Discussion in 'Free Source Codes' started by ONKAR, Jun 24, 2019.

    
  1. ONKAR

    ONKAR Active Member


    @Amit Kamdar sir and other experts, I need your urgent help, I have developed invoice format, now I want to print if I make a bill in cash memo then in print show cash memo, if I make a bill in credit memo then show in print credit memo , so how and where to set this.
     
    ONKAR, Jun 24, 2019
    #1


  2. ONKAR

    ONKAR Active Member


    I have set this but not working, please guide me

    Local: Field: Medium Prompt: Set as: @@IsCreditMemo then "Credit Memo" + @@IscashMemo then "Cash Memo" else "Invoice No." and another problem is i want this format print in cash memo , credit memo voucher also , so i add this but working , please see this code in below post
     
    Last edited: Jun 24, 2019
    ONKAR, Jun 24, 2019
    #2


  3. ONKAR

    ONKAR Active Member


    see this code , when i add this , but working

    see this code below



    [Style:p9]
    Font:Calibri (Body)
    Height:9

    [Style:p9B]
    Use:p9
    Bold: Yes

    ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

    [#Part: VTYP BehaviourMain]
    Option : VTYP BehaveMain KA VchTypeConfirm : @@IsKAVchType

    [!Part : VTYP BehaveMain KAVchTypeConfirm]
    Add : Line : After : VTYP PrintSave :VTYP KA VchTypeConfirm

    [Line : VTYP KA VchTypeConfirm]
    Field : Long Prompt, Logical Field
    Local : Field : Long Prompt : Set as : "Print New Format ?"
    Local : Field : Long Prompt : Width : @@LongWidth
    Local : Field : Logical Field : Storage : KAVchTypeConfirm1

    [System : Formula]
    IsKAVchType : $$IsSales:$Parent
    IsKANewAllow : $KAVchTypeConfirm1:VoucherType:$VoucherTypeName

    [System : UDF]
    KAVchTypeConfirm1 : Logical : 1782

    [#Form : Sales Color]
    Delete : Print
    Add : Print : STC GST INVOICE KA

    [#Form : Credit Memo Color]
    Delete : Print
    Add : Print : STC GST INVOICE KA



    [Report :STC GST INVOICE KA]
    Use : Printed Invoice
    Delete: Form : Printed Invoice
    Form : STC GST INVOICE KA

    [Form:STC GST INVOICE KA]
    Width : 8.3 inch
    Height :
    Space Top : 0.10 Inch
    Space Right : 0.10 inch
    Space Left : 0.40 inch
    Space Bottom: 0.10 inch

    Part: KA Opening Page Break, KA Invoice Body
    Bottom Part: KA Invoice Total, KA Goods Sold

    Page Break : ClKA Page Break, KA Opening Page Break

    [Part:ClKA Page Break]
    Lines : GIKA ClPgBrk

    [Line: GIKA ClPgBrk]
    Fields : Simple Field
    Local: Field: Simple Field : Set As : "Continued..."
    Local: Field: Simple Field : FullWidth : Yes
    Local: Field: Simple Field : Align : Right
    Border : Full Thin Top

    ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
    ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
    [Part: KA Opening Page Break]
    Part: KA CMP Details, KA Leading Details, KA Coloumn Titles
    Vertical: Yes



    [Part:KA CMP Details]
    Part: DMICash CMP Name Details



    [Part:DMICash CMP Name Details]
    Line: KA CMP Name, KA CMP Address

    [Line: KA CMP Name]
    Field: Name Field
    Local: Field: Name Field: Set as: @@CmpMailName
    Local: Field: Name Field: Style:parth CMP Name Cash
    Local: Field: Name Field: Full Width: Yes

    [Style: Parth CMP Name Cash]
    Font: Adobe Garamond Pro Bold
    Height:15
    Bold: Yes

    [Line:KA CMP Address]
    Field: Name Field
    Local: Field: Name Field: Set as: $$FullList:CompanyAddress:$Address
    Local: Field: Name Field: Width:50% Page
    Local: Field: Name Field: Line:0
    Local: Field: Name Field: Style:p9


    [Part:KA Leading Details]
    Left Part: KA Customer Details
    Right Part: KA Invoice Details
    Border: Thin Box

    [Part:KA Customer Details]
    Line:KA Customer Details Title, KA Customer Name, KA Customer Address, KA Customer Contact
    Width: 70% Page

    [Line:KA Customer Details Title]
    Field: Simple Field
    Local: Field: Simple Field : Set as: "Details for Buyer (Billed & Shipped To )"
    Local: Field: Simple Field: Style:p9B
    Local: Field: Simple Field: Full Width: Yes

    [Line:KA Customer Name]
    Field: Simple Field
    Local: Field: Simple Field: Set as:$PartyLedgerName
    Local: Field: Simple Field: Style: P9B
    Local: Field: Simple Field: Full Width: Yes
    Space Top:0.5

    [Line:KA Customer Address]
    Field: Simple Field
    Local: Field: Simple Field: Set as:$BasicBuyerAddress
    Local: Field: Simple Field: Style: P9B
    Local: Field: Simple Field: Full Width: Yes
    Space Top:0.5


    [Line:KA Customer Contact]
    Field: Simple Field
    Local: Field: Simple Field: Set as: "Contact Details :"+" "+ @@VchContactNo
    Local: Field: Simple Field: Style: P9
    Local: Field: Simple Field: Full Width: Yes

    [Part:KA Invoice Details]
    Line: KA Invoice No, KA Invoice Date
    Width: 30% Page
    Border: Thin Left

    [Line:KA Invoice No]
    Field: Medium Prompt,Simple Field
    Local: Field: Medium Prompt: Set as: @@IsCreditMemo then "Credit Memo" and @@IsCashMemo then "Cash Memo" else "invoice No."
    Local: Field: Medium Prompt: Style: P9B
    Local: Field: Medium Prompt: Width: 15
    Local: Field: Simple Field: Set as: $VoucherNumber
    Local: Field: Simple Field: Style: P9
    Local: Field: Simple Field: Full Width: Yes
    Space Top:1

    [Line:KA Invoice Date]
    Field: Medium Prompt, Simple Field
    Local: Field: Medium Prompt: Set as: "Dated"
    Local: Field: Medium Prompt: Style: P9B
    Local: Field: Medium Prompt: Width: 15
    Local: Field: Simple Field: Set as: $Date
    Local: Field: Simple Field: Style: P9
    Local: Field: Simple Field: Full Width: Yes


    ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
    [Part:KA Coloumn Titles]
    Line:KA Invoice Body Title,KA Invoice Body Title1
    Border: Thin Box
    Common Border: Yes

    [Part: KA Invoice Body]
    Part:KA Invoice Body Coloumns
    Vertical: Yes
    Border: Thin Box


    [Part:KA Invoice Body Title]
    Line:KA Invoice Body Title,KA Invoice Body Title1
    Common Border: Yes

    [Line:KA Invoice Body Title]
    Use: KA Invoice Body Coloumns

    Local: Field: Default: Type: String
    Local: Field: Default: Style: P9B
    Local: Field: Default: Align: Center

    Local: Field:KA SrNo: Set as: "Sr "
    Local: Field:KA Item Description: Set as: "Item"
    Local: Field:KA Part No: Set as: "Part"



    Local: Field:KA Billed Qty: Set as: "Billed"
    Local: Field: KA Rate: Set as: "Rate"


    Local: Field:KA Item Total: Set as: "Total"

    Border: Thin Top
    Space Top: 0.25

    [Line:KA Invoice Body Title1]
    Use: KA Invoice Body Coloumns

    Local: Field: Default: Type: String
    Local: Field: Default: Style: P9B
    Local: Field: Default: Align: Center

    Local: Field:KA SrNo: Set as: "No"
    Local: Field:KA Item Description: Set as: "Description"


    Local: Field:KA Billed Qty: Set as: "Qty"
    Local: Field: KA Rate: Set as: ""
    "

    Local: Field:KA Gross Amt: Set as: "Amount"
    Local: Field:KA Item Total: Set as: ""

    Border: Thin Bottom
    Space Bottom: 0.25

    [Part:KA Invoice Body Coloumns]
    Line:KA Invoice Body Coloumns
    Repeat:KA Invoice Body Coloumns:Inventory Entries
    Bottom Line: KA Invoice Body Coloumns Total
    Scroll: Vertical
    Float: No
    Common Border: Yes

    [Line:KA Invoice Body Coloumns]
    Left Field: KA SrNo, KA Item Description
    Right Field: KA Billed Qty, KA Rate,KA Item Total
    Space Top: 0.25

    Local: Field:KA SrNo: Width: 3

    Local: Field:KA Billed Qty: Width: 6
    Local: Field: KA Rate: Width: 6
    Local: Field:KA Item Total: Width: 10
    Local: Field:KA SrNo: Border: Thin Right
    Local: Field:KA Billed Qty: Border: Thin Left
    Local: Field: KA Rate: Border: Thin Left
    Local: Field:KA Item Total: Border: Thin Left


    [Field: KA Sr NO]
    Use: Simple Field
    Set as: $$Line
    Format: "No Zero"
    Style:p9
    Align: Center

    [Field:KA Item Description]
    Use: Simple Field
    Set as: if NOT $$IsSysName:$StockItemName then @@InvItemName else ""
    Style: P9
    Full Width: Yes
    Line:0



    [Field:KA Billed Qty]
    Use: Qty Primary Field
    Set as: $BilledQty
    Style:p9

    [Field:KA Rate]
    Use: Rate Price Field
    Set as: $Rate
    Style:p9


    [Field:KA Item Total]
    Use: Rate Price Field
    Set as: $Rate
    Set Always: Yes
    Style:p9

    [Line:KA Invoice Body Coloumns Total]
    Use: KA Invoice Body Coloumns

    Local: Field: Default: Type: String
    Local: Field: Default: Style: P9B
    Local: Field: Default: Align: Center

    Local: Field:KA SrNo: Set as: ""
    Local: Field:KA Item Description: Set as: "TOTAL"
    Local: Field:KA HSN Code: Set as: ""

    Local: Field: KA Rate: Set as: ""


    Local: Field:KA Gross Amt: Set as: $$CollAmtTotal:InventoryEntries:$Amount

    Local: Field:KA Item Total: Set as: $Amount
    Border: Thin Top Bottom
    Space Bottom: 0.25
    Space Top: 0.25





    [Part:KA Invoice Total]
    Right Part: KA Ledger Entries
    Left Part: KA Invoice Sing Off
    Border: Thin Box

    [Part:KA Ledger Entries]
    Line:KA Ledger Entries
    Repeat:KA Ledger Entries:Ledger Entries

    Float: No
    Common Border: Yes
    Bottom Line: KA Invoice Total

    [Line:KA Invoice Total]
    Field: KA Invoice Total Title, KA Invoice Total Amt

    [Field:KA Invoice Total Title]
    Use: Simple Field
    Set as:"INVOICE TOTAL"
    Style: Large Bold
    Width:20.7
    Align : Center

    [Field:KA Invoice Total Amt]
    Use: Amount Field
    Set as: $Amount
    Style: Large Bold
    Width:13
    Border: Thin Left

    [Line: KA Ledger Entries]
    Remove if : $LedgerName = $PartyLedgerName
    Field: KA Ledger Name, KA Ledger Amount
    Space Top: 0.5
    Border: Thin Bottom

    [Field: KA Ledger Name]
    Use: Simple Field
    Set as: ""
    Style:p9B
    Width: 22
    Border: Thin Left

    [Field:KA Ledger Amount]
    Use: Amount Field
    Set as: $Amount
    Style:p9B
    Width: 11
    Border: Thin Left
    Align: Right

    [Part:KA Invoice Sing Off]
    Part: KA Amount In Word and Declaration, KA Invoice Sing Off Part
    Vertical: Yes

    [Part:KA Amount In Word and Declaration]
    Line: KA Amount In Word, KA Declaration

    [Line:KA Amount In Word]
    Field: Simple Field
    Local: Field: Simple Field: Set as: "TOTAL VALUE (IN WORDS) Rs." +" "+ $$InWords:$Amount
    Local: Field: Simple Field: Full Width: Yes
    Local: Field: Simple Field: Style: P9B
    Local: Field: Simple Field: Line:0
    Border : Thin Bottom

    [Line:KA Declaration]
    Field: Simple Prompt,Simple Field
    Local: Field: Simple Prompt: Set as: "Declaration"
    Local: Field: Simple Prompt: Style: P9
    Local: Field: Simple Field: Set as: "Certified that the Particulars given above are true and correct."
    Local: Field: Simple Field: Line: 0
    Local: Field: Simple Field: Full Width: Yes
    Local: Field: Simple Field: Style: P9
    Border : Thin Bottom
    Space Top: 0.5

    [Part:KA Invoice Sing Off Part]
    Left Part: For KA
    Right Part: For KA Cu

    [Part:For KA]
    Line: For KA, KA Authorised Signatory

    [Line: For KA]
    Field: Simple Field
    Local: Field: Simple Field: Set as: "For" +" "+ @@CmpMailName
    Local: Field: Simple Field: Full Width: Yes
    Local: Field: Simple Field: Style: P9B
    Local: Field: Simple Field: Align: Left
    Space Top: 0.5

    [Line:KA Authorised Signatory]
    Field: Simple Field
    Local: Field: Simple Field: Set as: "Authorised Signatory"
    Local: Field: Simple Field: Full Width: Yes
    Local: Field: Simple Field: Style: P9B
    Local: Field: Simple Field: Align: Left
    Space Top:4

    [Part:For KA Cu]
    Line:For KA Cu

    [Line:For KA Cu]
    Field: Simple Field
    Local:Field: Simple Field: Set as: "Receivers Stamp & Sign."
    Local:Field: Simple Field: Full Width: Yes
    Local: Field: Simple Field: Align: Right
    Local: Field: Simple Field: Style: P9
    Space Top:6


    [Part:KA Goods Sold]
    Line:KA Goods Sold, KA Juridiction

    [Line:KA Goods Sold]
    Field: Simple Field
    Local: Field: Simple Field: Set as: "GOODS ONCE SOLD WILL NOT BE TAKEN BACK"
    Local: Field: Simple Field: Align: Center
    Local: Field: Simple Field: Full Width: Yes
    Local: Field: Simple Field: Style: P9B

    [Line:KA Juridiction]
    Field: Simple Field
    Local: Field: Simple Field: Set as: " SUBJEC TO KOLHAPUR JURISDICTION "
    Local: Field: Simple Field: Align: Center
    Local: Field: Simple Field: Full Width: Yes
    Local: Field: Simple Field: Style: P9B
     
    ONKAR, Jun 24, 2019
    #3


  4. Jenny

    Jenny Active Member


    in which entry form : creditmemo & cashmemo???
     
    Jenny, Jun 24, 2019
    #4


  5. ONKAR

    ONKAR Active Member


    @Jenny mam now problem solved, but one more problem is I want to display the title as if i make cash memo then prints cash memo no. and if I make credit memo then print credit memo no. and if I make normal sales bill then print invoice no. so I add this in my code but not working see this below

    Local: Field: Medium Prompt: Set as: @@IsCreditMemo then "Credit Memo" + @@IscashMemo then "Cash Memo" else "Invoice No."
     
    ONKAR, Jun 24, 2019
    #5


  6. rony

    rony Member


    Dear Onkar,
    Have U tried with "IF"
    Regards
     
    rony, Jun 25, 2019
    #6


  7. ONKAR

    ONKAR Active Member


    @rony sir, how to use this, like this , but not working , tell me exactly how to set this

    Local: Field: Medium Prompt: Set as: @@IFCreditMemo then "Credit Memo" + @@IFcashMemo then "Cash Memo" else "Invoice No."

    But Not Working
     
    ONKAR, Jun 25, 2019
    #7


  8. Jenny

    Jenny Active Member


    First you read tdl after that u do...i think you just copy pest code ...
    Use "IF" Before @@
     
    Jenny, Jun 25, 2019
    #8
    ONKAR likes this.


  9. ONKAR

    ONKAR Active Member


    what is the correct formula sir Ji i am not getting exact result.
     
    ONKAR, Jun 25, 2019
    #9


  10. ONKAR

    ONKAR Active Member


    as per your solution, not working, @Jenny
     
    ONKAR, Jun 25, 2019
    #10


  11. Jenny

    Jenny Active Member


    first u find - CreditMemo... if its available in default form then its work
     
    Jenny, Jun 25, 2019
    #11


  12. Jenny

    Jenny Active Member


    Put like This -

    IF @@IsCreditMemo then "Credit Memo" Else +
    IF @@IsCashMemo then "Cash Memo" Else "invoice No."
     
    Jenny, Jun 25, 2019
    #12


  13. rony

    rony Member


    Have U tried this Local: Field: Medium Prompt: Set as: IF @@ CreditMemo then "Credit Memo" + IF @@cashMemo then "Cash Memo" else "Invoice No."
    Or Miss Jenny suggestion ?
     
    rony, Jun 27, 2019
    #13


  14. ONKAR

    ONKAR Active Member


    I have tried this but not working, showing as bad formula and tally quite
     
    ONKAR, Jun 28, 2019
    #14


  15. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Set as: IF @@ CreditMemo then "Credit Memo" Else IF @@cashMemo then "Cash Memo" else "Invoice No."
     
    Amit Kamdar, Jul 2, 2019
    #15


Share This Page