TIN NO IN SALES & PURCHASE VOUCHER ENTRY

Discussion in 'Free Source Codes' started by GAURANG, Apr 3, 2014.

    
  1. GAURANG

    GAURANG New Member


    YOU CAN SHOW PARTY TIN NO IN SALES AND PURCHASE ENTRY
     

    Attached Files:

    divy2281774 likes this.


  2. sachin daga

    sachin daga New Member



  3. Bhavesh

    Bhavesh New Member


    what is use for?!
    No need I suppose, any way ...
     


  4. Bhavesh

    Bhavesh New Member


    what is use for?!
    No need I suppose, any way ...
     


  5. Bhavesh

    Bhavesh New Member


    Oh Sorry Brothers, there problem in my Net Connection
     


  6. Pupesh Arora

    Pupesh Arora Member


    Dear Brother,
    Can you share the code for Payment Voucher1.jpg and Payment Voucher2.jpg
     


  7. mehul2cyahoo

    mehul2cyahoo New Member


    how to get TIN number in "as voucher entry" screen for sales and purchases. (Not as invoice).

    Local : Field : name Field : Set as : $VATTINNumber:Ledger:#EIConsignee+ " " + $SalesTaxNumber:Ledger:#EIConsignee

    can we use any other name to reference Ledger:#EIConsignee
     


  8. priya

    priya Member


    Hi,
    I am prompted to share my thoughts in this forum. If some one does not like a tdl and if they find that it is not useful to them practically, there is no need for them to download it. Instead, please stop posting negative remarks about the tdl. It not only hurts the member who has shared it; but also dampens the enthusiasm of all. Please do not mistake me. I do not aim this criticism against anyone; but find certain harsh remarks in almost all threads, which surprises me. I EXPECT, LEARNED MEMBERS TO ANALISE THE SUBJECT MATTER PRAGMATICALLY AND NOT TO FIND FAULT. BYE
     
    Amina kharadi likes this.


  9. mahaveersomani

    mahaveersomani New Member


    Very Much useful this tdl for me.


    Thanks for share this tdl .

    but i have one query Sir, How to get this tin no. field in sales ledger report? it is not showing there in columner Report.


    Please do needful as earliest.

    Thanks your in advance.
     


  10. divy2281774

    divy2281774 New Member


    Sir,
    Very helpful code we can check tin number at the time of entry.

    this code working in invoice mode but not working with sales voucher/purchase voucher entry mode. Please help me.
     


  11. mujeeb

    mujeeb New Member


    in tanzania, if any tax invoice which does not have the buyer's TIN and VAT number...the buyer cant claim the vat
     


  12. anbhuselvan

    anbhuselvan Member


    Hi Sir,
    Could you please any one help on this Purchase invoice customization. Im unable to fetch the Number of Quantity and Quantity rate in my below mentioned code. Please correct my Code:
    [#Form: Comprehensive Invoice]

    Parts : STDInvoiceTop, EXPINV OpPageBreak, EXPINV Details
    BottomParts : EXPINV Totals , EXPINV SignOff , EXPINV Customer, EXPINV Jurisdiction, EXPINV InvoiceCompGen

    ; Width : @@InvWidth Inch
    ; Height : @@InvHeight Inch
    ; Space Top : @@InvSpace inch
    ; Space Right : 0.5 inch
    ; Space Left : @@InvSpaceLeft inch
    ; Space Bottom: 0.25 inch

    Page Break : EXPINV ClPageBreak, EXPINV OpPageBreak

    Option : Dealer ExcisePurchaseInvoice : (@@IsExciseTraderOn AND (@@IsPurchase OR @@IsDebitNote) AND @@IsTraderInvoice AND ##PUDealerExciseDutyInfo)
    Option : STX Comprehensive Invoice : @@IsIndianServiceTax AND $$STXCanUpdateDutyLed
    Option : Invoice Bank Info Fetch : ##SABankInfo AND NOT $$IsSysName:##SABankName

    ;; When Sales Bill is made in Voucher mode, while printing sales ledger is also getting printed
    Set Always : SVViewName : $$SysName:InvVchView
    Delete :parts : STDInvoiceTop, EXPINV OpPageBreak, EXPINV Details
    Delete :BottomParts : EXPINV Totals , EXPINV SignOff , EXPINV Customer, EXPINV Jurisdiction, EXPINV InvoiceCompGen

    Add: Top Parts : INV;,EXPSMPtitle1

    Height : 100% Page
    Width : 100% Page
    Space Top : 0.25 inch
    Space Right : 0.25 inch
    Space Left : 0.5 inch
    Space Bottom: 0.5 inch

    [part : INV]
    ;Line :RMCmpName,INVS, TRWK,RMCmpAdd, MIComPhone,MIVATTINNumber
    Line :RMCmpName,INVS, TRWK,RMCmpAdd,MIVATTINNumber,CSTN
    Repeat : RMCmpAdd:Company Address
    Line : MI VCHDate,MI PartyName;, MI ColumnTitles
    Add: Line: MIQuantity
    Add: Line: MI rate
    Add: Line: IE Amount , MI AmtInWords
    Add: Line: Global ForCmp1
    Add: Line: INCDetails
    Border: MyBorder
    ;


    [Border: MyBorder]
    Top : Flush, Thin, Full Length
    Bottom : Flush, thin, full length
    Left : Thin
    Right : Flush, Thin, Full Length

    [Border: MyBorder1]
    ;Top : Flush, Thin, Full Length
    Bottom : Flush, thin, full length
    ;Left : Thin
    ;Right : Flush, Thin, Full Length

    [Line :INVS]
    Field: INVS
    [Field: INVS]
    Set as : "BOUGHT NOTE"
    Style : newSTY2
    Align : Center
    FullWidth : Yes

    [Line :TRWK]
    Field: TRWK
    [Field: TRWK]
    Set as : "Trading To Waste Kraft Boxes"
    Style : newSTY2
    Align : Center
    FullWidth : Yes


    [Line: RM CmpName]
    Fields : RMcmpname

    [Field : RMCmpName]
    Set as :mad:@CmpMailName
    Align : Center
    FullWidth : Yes
    Style : newSTY1

    [Line : RMCmpAdd]
    Fields : RMCmpAdd

    [Field : RMCmpAdd]
    Set as : $Address
    Align : Center
    FullWidth : Yes
    Style : newSTY1
    /*
    [Line: MI ComPhone]
    Field : MI ComPhone
    [Field: MI ComPhone]
    Use : Name Field
    Set as : $phonenumber:Company:##SvCurrentCompany
    Indent : 10
    */

    [Line: MI VATTINNumber]
    Left Fields: Short Prompt, MI VATTINNumber
    ;Right Fields: Short Prompt, CSTN
    Local : Field : Short Prompt : Set as : "TIN No:"
    ;Local : Field : Short Prompt : Set as : "GST : "
    [Field : MI VATTINNumber]
    Use : Name Field
    Set as : $VATTINNUMBER:Company:##SvCurrentCompany
    ;FullWidth : yes
    Style : pp6
    Align : Center

    [Line: CSTN]
    Right Fields: Short Prompt, CSTN
    Local : Field : Short Prompt : Set as : "CST.N : "
    [Field : CSTN]
    Use : Name Field
    Set as : $InterstateStnumber:Company:##SvCurrentCompany
    ;FullWidth : yes
    Style : pp6
    Align : Center

    [Line: MI VCHDate]
    Field : Simple Prompt, MI VCHNo
    Right Field : Short Prompt, MI VCHDate
    Local : Field : Short Prompt : Set as : "Voucher Date : "
    Local : Field : Simple Prompt : Set as : " Voucher No : "
    Border: MyBorder1

    [Field: MI VCHDate]
    Use : Short Date Field
    Set as : $Date

    [Field: MI VCHNo]
    Use : Short Name Field
    Set as : $VoucherNumber

    [Line: MI PartyName]
    Space Top: 1
    Field : Short Prompt, MI PartyNAme
    Local : Field : Short Prompt : Set as : "Purchaser: (Name & Vehical No: "

    [Field: MI PartyName]
    Use : Name Field
    Set as : $PartyLedgerName
    ;Set as: $BuyerName


    [Line: MIQuantity]
    Space Top: 1
    Field : Short Prompt, IE Qty
    Local : Field : Short Prompt : Set as : "Quantity: "

    ;[Field: MIQuantity]
    /*Use : Qty Primary Field ;Number Field ;;
    ;Use : Qty Primary Field
    Set as : $BasicQty
    Format : "NoSymbol,Primary"
    */


    [Field : IE Qty]
    Use : Number Field
    Set As : $$Number:$BilledQty
    Format : "NoZero"
    Border : Thin Right
    Width : 10
    Style:Normal

    [Line: MI rate]
    Space Top: 1
    Field : Short Prompt, MI rate
    Local : Field : Short Prompt : Set as : "Unit Price: "

    Explode : Item Desc : $$NumItems:UserDescription > 0


    [Part : Item Desc]
    Line : Item Desc
    Repeat : Item Desc : UserDescription

    [Line : Item Desc]
    Field : Item Desc

    [Field : Item Desc]
    Use : Name Field
    Width : 40
    Indent : 8
    Set as : $UserDescription
    Style : Normal Italic


    [Field : MI rate]
    /*Use : Rate Price Field
    Set as : $Rate
    FullWidth : yes
    */

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


    [Line: IE Amount]
    Space Top: 1
    Field : Short Prompt, IE Amount
    Local : Field : Short Prompt : Set as : "Amount: "

    [Field : IE Amount]
    Use : Amount Field
    Set as : $Amount
    ;Border : Thin Left Right
    Format : "NoComma,NoZero"
    ;FullWidth : yes

    [Line: MI AmtInWords]
    Space Top: 1
    Field : Short Prompt, MI AmtInWords
    Local : Field : Short Prompt : Set as : "Rs: "

    [Field : MI AmtInWords]
    Use : Name Field
    Set as : $$InWords:$Amount
    FullWidth : yes
    Style : Small

    [Line: Global ForCmp1]
    Space Top: 2
    Right Fields: Global ForCmp1
    Space Bottom: 2

    [Field: Global ForCmp1]


    Use : Name Field
    Set as : "For " + @@CMPMailNAme
    Align : Right
    Width : 0

    [Line: INCDetails]
    Space Top: 1
    Field : INCDetails
    ;Local : Field : Short Prompt : Set as : "Purchaser tax Shall be paid bythe Purchaser"

    [Field: INCDetails]
    Style : Normal1
    Set as: "Purchaser tax Shall be paid bythe Purchaser"

    /*[Collection:VCHCollection]
    Type: Stock Item
    */


    [System: Formula]



    LargeSize : 14
    SmallerSize : 6

    ;******************** Cardinal styles ********************;

    [Style: Normal1]

    ;; for linux face name is changed
    Font : if $$SysInfo:IsWindows then "Arial" else "Helvetica"
    Bold: Yes
    Height : @@LargeSize
     


  13. divy2281774

    divy2281774 New Member


    your query answer on this youtube vedio
     


  14. ngvaishnaw

    ngvaishnaw New Member


    sir, in the above it shows only tin number which we saved in account creation but can we give any default tin number when there is no tin number saved in ledger.
    suppose cash sale we want defult tin number
     


  15. tejeet

    tejeet Member



    SIR, PLEASE DEVELOP TDL CODES FOR GST NO TO BE DISPLAY IN SALES & PURCHASE INSTEAD OF VAT TIN NO SINCE GST IS IMPLEMENTED
     


Share This Page