changing the name of default fields of Sales Invoice

Discussion in 'Requests' started by nrj, Sep 10, 2017.

    
  1. nrj

    nrj New Member


    hello sir,
    by the following code I can change the name of "voucher no." and " Date "
    but how to change the name of other fields.
    [#Part : EXPINV Number]

    Local : Field : EXPINV SubTitle : Set as : "Bill No."

    [#Part : EXPINV Date]

    Local : Field : EXPINV SubTitle : Info : $$LocaleString:"Date of BIll"
     
    nasir likes this.


  2. Amit1256

    Amit1256 New Member


    Explain your problem briefly...
     


  3. Ejajkhan

    Ejajkhan New Member


    [#Part: EXPINV Number]

    Lines : EXPINV SubTitle
    BottomLines : EXPINV Number
    Local : Field : EXPINV SubTitle : Set as : "Bill No."
    Local : Field : EXPINV SubTitle : Width : 25% Page
    Local : Field : EXPINV SubTitle : Cells : ($$Quotient:mad:@ExcelCellColumn:4)
    Border : Full Thin Bottom
    Height : 9 mms
     


  4. nrj

    nrj New Member


    I want to change name of other fields of invoice like supplier's Ref,Buyer's Order No.,Despatch Document No.,Despatch Document No. etc fields
     
    nasir likes this.


  5. nrj

    nrj New Member


    dear experts, any solution ??
     


  6. mpal2311

    mpal2311 Active Member



  7. Amit1256

    Amit1256 New Member


    ok please give me ur mail id will be sending the codes ASAP
     


  8. Rakesh Kumar

    Rakesh Kumar Member



  9. shubham sancheti

    shubham sancheti New Member



  10. Rajsrisrimal

    Rajsrisrimal Member



  11. Systecg

    Systecg Member



  12. Systecg

    Systecg Member


    sir,
    If possible mail me too at systech.ahd@gmail.com

    I want to change name of other fields of invoice like supplier's Ref,Buyer's Order No.,Despatch Document No.,Despatch Document No. etc fields
     


  13. info.ap

    info.ap New Member



  14. info.ap

    info.ap New Member


    Amit Sir...now learning basic, mail me too - amitpandya.dxb@gmail.com, so can start practice...Regards
     


  15. info.ap

    info.ap New Member


    Amit Sir...now learning basic, mail me too - amitpandya.dxb@gmail.com, so can start practice...Regards
     


  16. Amit1256

    Amit1256 New Member


    Sorry Guys was not able to respond you.... this is the example of customization please follow this and GOOD LUCK, please share your codes too...






    ;; Sri Ganeshji : Sri Balaji : Sri Pitreshwarji : Sri Durgaji : Sri Venkateshwara


    [#Form: Sales Color]

    Option : Global Sales Color : ##InvVarC2 AND @@IsSales

    [!Form: Global Sales Color]

    Add : Print : Global Invoice

    [Report: Global Invoice]

    Use : Printed Invoice
    Delete : Form
    Add : Form : Global Invoice1

    [Form: Global Invoice1]

    Use : STD Invoice Dimensions
    Space Left : @@InvSpaceLeft inch
    Space Right : 0
    Space Bottom: 0
    Parts : STD Invoice Top, GI OpPgBrk, Global Invoice Body
    Bottom Parts: Global Invoice Bottom

    Page Break : GI ClPgBrk, GI OpPgBrk

    [Part: GI ClPgBrk]

    Lines : GI ClPgBrk

    [Line: GI 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: GI OpPgBrk]

    Parts : Global Invoice Top, Global Invoice Add, GI Inventory Title
    Vertical : Yes

    [Part: Global Invoice Top]

    Lines : GI Cmp Name, GI Title
    Space Bottom : 1
    Border : Thin Cover

    [Line: GI Cmp Name]

    Fields : Simple Field
    Local: Field: Simple Field : Set As : @@CmpMailName
    Local: Field: Simple Field : Align : Center
    Local: Field: Simple Field : FullWidth : Yes
    Local: Field: Simple Field : WideSpaced: Yes
    Local: Field: Simple Field : Style : Cmp Style

    [Line: GI Title]

    Use : GI Cmp Name
    Space Top : 1
    Local: Field: Simple Field : Set As : "INVOICE"
    Local: Field: Simple Field : Style : Normal Bold

    [Part: Global Invoice Add]

    Parts : Global Invoice BillAdd, Global Invoice ShipAdd
    Right Parts : Global Invoice InvDet
    Space Top : 1
    Border : Thin Left Right Bottom
    Height : 12% Page

    [Part: Global Invoice BillAdd]

    Lines : Global Invoice BillAddTitle, Global Invoice BillName, Global Invoice BillAdd
    Repeat : Global Invoice BillAdd : Address
    Width : 28% Page

    [Line: Global Invoice BillAddTitle]

    Fields : Name Field
    Local: Field: Name Field : Set as : "Billing Name & Address"
    Local: Field: Name Field : Align : Center

    [Line: Global Invoice BillName]

    Fields : Name Field
    Local: Field: Name Field : Set as : $PartyLedgerName

    [Line: Global Invoice BillAdd]

    Fields : Name Field
    Local: Field: Name Field : Set as : $Address
    Local: Field: Name Field : Style : Normal

    [Part: Global Invoice ShipAdd]

    Use : Global Invoice BillAdd
    Repeat : Global Invoice BillAdd : BasicBuyerAddress
    Delete : Line : Global Invoice BillName
    Local : Line : Global Invoice BillAddTitle :Local : Field : NameField : Set As : "Shipping Address"
    Local : Line : Global Invoice BillAdd : Local : Field : Name Field: Set As : $BasicBuyerAddress

    [Part: Global Invoice InvDet]

    Lines : Global Invoice InvNo, Global Invoice InvDt, Global Invoice InvTerms, Global Invoice DueDt, +
    Global Invoice ShipDt, Global Invoice ShipVia

    [Line: Global Invoice InvNo]

    Fields : Medium Prompt, Name Field
    Local : Field : Medium Prompt : Set as : "Inv No"
    Local : Field : Name Field : Set as : $VoucherNumber

    [Line: Global Invoice InvDt]

    Use : Global Invoice InvNo
    Local : Field : Medium Prompt : Set as : "Inv Dt"
    Local : Field : Name Field : Set as : $Date

    [Line: Global Invoice InvTerms]

    Use : Global Invoice InvNo
    Local : Field : Medium Prompt : Set as : "Terms of Delivery"
    Local : Field : Name Field : Set as : $BasicOrderTerms

    [Line: Global Invoice DueDt]

    Use : Global Invoice InvNo
    Local : Field : Medium Prompt : Set as : "Due Dt"
    Local : Field : Name Field : Set as : $$String:mad:@DueDtCalc

    [Line: Global Invoice ShipDt]

    Use : Global Invoice InvNo
    Local : Field : Medium Prompt : Set as : "Shipped Dt"
    Local : Field : Name Field : Set as : $BasicShippingDate

    [Line: Global Invoice ShipVia]

    Use : Global Invoice InvNo
    Local : Field : Medium Prompt : Set as : "Ship Via"
    Local : Field : Name Field : Set as : $BasicShippedBy

    [Part: GI Inventory Title]

    Lines : GI Inventory Title
    Border : Thin Left Right

    [Line: GI Inventory Title]

    Use : GI Inventory Details

    Local : Field : Default : Type : String
    Local : Field : Default : Style : Normal Bold

    Local : Field : GI SI No : Set as: "SI. No."
    Local : Field : GI Item Name : Set as: "Item Name"
    Local : Field : GI Qty : Set as: "Quantity"
    Local : Field : GI Rate : Set as: "Rate"
    Local : Field : GI Amount : Set as: "Amount"

    Border : Thick Bottom
    SpaceTop: 0

    [Part: Global Invoice Body]

    Lines : GI Inventory Details
    Repeat : GI Inventory Details : Inventory Entries
    Scroll : Vertical
    Border : Thin Left Right Bottom
    Common Borders : Yes

    [Line: GI Inventory Details]

    Fields : GI SI No, GI Item Name
    Right Fields: GI Qty, GI Rate, GI Amount

    Space Top : if $$Line = 1 then 1 else 0

    [Field: GI SI No]

    Use : Number Field
    Set as : $$Line
    Border : Thin Right

    [Field: GI Item Name]

    Use : Name Field
    Set as : if NOT $$IsSysName:$StockItemName then @@InvItemName else ""
    FullWidth : Yes

    [Field: GI Qty]

    Use : Qty Primary Field
    Set as : $BilledQty
    Border : Thin Left

    [Field: GI Rate]

    Use : Rate Field
    Border : Thin Left
    Set as : $Rate

    [Field: GI Amount]

    Use : Amount Forex Field
    Border : Thin Left
    Set as : $Amount

    [Part: Global Invoice Bottom]

    Parts : GI Acc Det, GI Net Amt, GI Invoice Bottom
    Vertical: Yes
    Border : Thin Left Right Bottom

    [Part: GI Acc Det]

    Lines : GI Inventory Total, GI Acc Det
    Repeat : GI Acc Det : Ledger Entries
    Height : 10% Page
    Common Borders : Yes

    [Line: GI Inventory Total]

    Right Fields: GI Rate, GI Amount
    Local : Field : GI Rate : Type : String
    Local : Field : GI Rate : Delete: Border
    Local : Field : GI Rate : Width : 20
    Local : Field : GI Rate : Set as: "Sub Total"
    Local : Field : GI Amount : Set as: $$CollAmtTotal:InventoryEntries:$Amount
    Local : Field : GI Amount : Style : Normal Bold
    Local : Field : GI Amount : Border: Thin Left

    [Line: GI Acc Det]

    Use : GI Inventory Total
    Right Fields: GI Rate, GI Amount
    Local : Field : GI Rate : Set as: $LedgerName
    Local : Field : GI Amount : Set as: $Amount
    Local : Field : GI Amount : Style : Normal
    Local : Field : GI Amount : Border: Thin Left

    [Part: GI Net Amt]

    Lines : GI Inventory Total
    Local : Line : GI Inventory Total : Local : Field : GI Rate : Set as: "Net Amount"
    Local : Line : GI Inventory Total : Local : Field : GI Amount : Set as: $Amount
    Border : Thin Bottom


    [Part: GI Invoice Bottom]

    Parts : GI Address, GI Other Details, GI Signatory


    [Part: GI Address]

    Lines : GI Address Title, GI Address
    Repeat : GI Address : Company Address

    [Line: GI Address Title]
    Use : GI Address
    Local : Field : Name Field : Style : Normal Bold
    Local : Field : Name Field : Set as : "Address"
    Indent : 1

    [Line: GI Address]

    Fields : Name Field
    Local : Field : Name Field : Style : Normal
    Local : Field : Name Field : Set as : $Address

    [Part: GI Other Details]

    Lines : GI Phone, GI Fax, GI Email


    [Line: GI Phone]

    Fields : Medium Prompt, Simple Field
    Local : Field : Medium Prompt : Set as : "Phone"
    Local : Field : Simple Field : Set as : $PhoneNumber:Company:##SVCurrentCompany

    [Line: GI Fax]

    Fields : Medium Prompt, Simple Field
    Local : Field : Medium Prompt : Set as : "Fax"
    Local : Field : Simple Field : Set as : $Fax:Company:##SVCurrentCompany

    [Line: GI Email]

    Fields : Medium Prompt, Simple Field
    Local : Field : Medium Prompt : Set as : "Email"
    Local : Field : Simple Field : Set as : $Email:Company:##SVCurrentCompany

    [Part: GI Signatory]

    Bottom Line : GI Signatory
    Border : Thin Left

    [Line: GI Signatory]

    Field : Name Field
    Local : Field : Name Field : Set as : "for " + @@CmpMailName
    Local : Field : Name Field : Full width: Yes


    ;; Style Definition

    [Style: Cmp Style]

    Font Name : "Arial"
    Height : 15

    [System: Formula]

    DueDtCalc : $Date + $$Number:$BasicDueDateofPymt

    ;; End-of-File
     


  17. Systecg

    Systecg Member


    there are no result found in print.. how to use plz guide ..

     


  18. Systecg

    Systecg Member


    there are no result found in print.. how to use plz guide ..

     


  19. Systecg

    Systecg Member


    there are no result found in print.. how to use plz guide ..

     


Share This Page