SALES INVOICE

Discussion in 'Tally Developer' started by GOURAV JAIN, Oct 1, 2012.

    
  1. GOURAV JAIN

    GOURAV JAIN Member


    I want to make an invoice in which quantity is in pcs. and amount as per pcs. but i want an another field for 2nd unit of measure like in kgs. but this unis have no link with rate. It's just only for show the weight of an item in invoice print and at voucher entry level. And it also shows in stock summary. If i want to see how much quantity in kgs. is sold how it is possible.
    It's not working when i use alternate unit. B'coz at any any time variance in weight.
    some time 1 pcs. is = 5 kg. or sometime 1 pcs = 6kg.

    Pls help me.

    Thanx in advance
     


  2. Kamal Sharma

    Kamal Sharma New Member


    if you are a user of Tally then you can buy a addOn from TallyShop "Alternate Quantity for Stock Item 1.2" for the same.

    If you are a developer then you can add a udf on voucher entry and add the same in print and report.
    sample as given below : -
    This will teach you how to add udf on entry level and print on invoice.

    [#Line: EI ColumnOne] ;; Invoice Column Headings1 without class
    Option : Global EI ColumnOne : @@IsSales
    ;; "Global" prefix is added for better readability of the code
    [!Line: Global EI ColumnOne]
    Add : Right Fields : At Beginning : Global VCH Marks, Global VCH NumPack
    ;;Need to mention Right Fields, since just Field means Left Field
    ;;and we need “NumPack” Column to the right of the screen at beginning
    Local : Field : Default : Align : Center
    Local : Field : Global VCH Marks : Info : "Marks"
    Local : Field : Global VCH NumPack : Info : "No. of Packages"

    [#Line: EI ColumnTwo] ;; Invoice Column Headings1 without class
    Option : Global EI ColumnTwo : @@IsSales
    [!Line: Global EI ColumnTwo]
    Add : Right Fields : At Beginning : Global VCH Marks, Global VCH NumPack
    Local : Field : Default : Align : Center
    Local : Field : Global VCH Marks : Info : ""
    Local : Field : Global VCH NumPack : Info : ""

    [#Line: EI InvDetails]
    Option : Global EI InvDetails : @@IsSales

    [!Line: Global EI InvDetails]
    Delete : Lines : EI Marks, EI NumPackages
    [#Line: CI InvDetails]
    Option : Global CI InvDetails : @@IsSales

    [!Line: Global CI InvDetails]
    Delete : Lines : CI MarksPackages
    [#Line: EI InvInfo] ;; Invoice Inventory Entries without Class
    Option : Global EI InvInfo : @@IsSales

    [#Line: CI InvInfo] ;; Invoice Inventory Entries with Class
    Option : Global EI InvInfo : @@IsSales

    [!Line: Global EI InvInfo]
    Add : Right Fields : At Beginning : Global VCH Marks, Global VCH NumPack
    Local : Field : Global VCH Marks : Storage : BasicPackageMarks
    Local : Field : Global VCH NumPack : Storage : BasicNumPackages

    [Field: Global VCH Marks]
    Use : Short Name Field
    Width : 8
    Align : Right
    Border : Thin Left Right
    Invisible : NOT ##VrVarC1
    Skip on : $$IsEnd:$StockItemName
    ;; Inactive : $$IsEnd:$StockItemName

    [Field: Global VCH NumPack]
    Use : Short Name Field
    Width : 12
    Align : Right
    Border : Thin Left Right
    Invisible : NOT ##VrVarC1
    Skip on : $$IsEnd:$StockItemName
    ;; Inactive : $$IsEnd:$StockItemName

    [#Form: Export Invoice]
    Option : Global Export Invoice NP : @@IsSales

    [!Form : Global Export Invoice NP]
    Local : Line : VCH NarrPrompt: Add : Right Fields : At Beginning : Global Total Marks, Global Total NumPack
    [Field: Global Total Marks]

    Use : Global VCH Marks
    Border : Totals
    Set as : $$String:mad:@NumPackMarksTotal
    Set always : Yes
    Skip : Yes

    [Field: Global Total NumPack]

    Use : Global VCH NumPack
    Border : Totals
    Set as : $$String:mad:@NumNumPackTotal
    Skip : Yes
    Set always : Yes

    [System: Formula]
    NumNumPack : $$Number:$BasicNumPackages
    NumNumPackTotal : $$CollNumTotal:InventoryEntries:mad:@NumNumPack

    NumPackMarks : $$Number:$BasicPackageMarks
    NumPackMarksTotal : $$CollNumTotal:InventoryEntries:mad:@NumPackMarks

    ;; End-of-File
     


  3. fannu

    fannu Member



  4. fannu

    fannu Member


    dear sir i hav to addres book tdl plz send me addras book multi coding
     


  5. Nur Mohammed

    Nur Mohammed Member


    total is not coming
     


  6. Kamal Sharma

    Kamal Sharma New Member


    you need to add totals on part level
     


Share This Page