Need help in customize invoice page break...

Discussion in 'Tally Developer' started by garvan14, Nov 24, 2014.

    
  1. garvan14

    garvan14 New Member


    in this code when i compile show no error but when execute shows Memory access coilation


    Please help



    Code:
    [#Form: Comprehensive Invoice]
        Add : Option : My Invoice : @@IsSales
    
    [#Form: Simple Printed Invoice]
        Add : Option : My Invoice : @@IsSales
    
    [!Form : My Invoice]
        Delete : Parts
        Delete : Bottom Parts
        Delete : PageBreak
    
        Height    : 6.0 inches
        Width    : 8.0 inches
    
        Space Top : 0
        Space Bottom: 0
        Space Left : 0.1
        Space Right : 0
    
        Add : Parts : OPGBrk, My Invoice Body Part
        Add : Bottom Part: My Invoice Bottom Part
     
        Add : Pagebreak : CLPGBrk, OPGBrk
    
    [Part: OPGBrk]
        Parts:MI CmpName,MI PartyDet,MI ColumnTitles
        Right Part:MI InvDet
        Border: Thin Bottom
     
        ;;Line : MI CmpName,MI InvDet,MI PartyAdd1, MI ColumnTitles
        ;;Repeat: MI PartyAdd1:PartyAddress
    
    [Part: MI CmpName]
        Line: My CmpName
     
    [Line: My CmpName] 
        Field : MI CmpName
    
    [Field: MI CmpName]
        Use : Name Field
        Set as : @@CMPMailNAme
        FullWidth : yes
        Align : Centre
    
    ;------------------------------------------------------------------
    
    [Part:MI PartyDet]
        Line: MI PartyName,MI PartyAdd
        Repeat:MI PartyAdd:PartyAddress
    
    [Line:MI PartyName]
        Fields:Name Field
        Local:Field:Name Field:Set as: "Party : " + $PartyLedgerName
         Local:Field:Name Field:Align: Left
        Local:Field:Name Field:Style: Normal
    
    [Line: MI PartyAdd]
        Use:MI PartyName
        Local:Field:Name Field:Set as: $Address
        Local:Field:Name Field:Style: Normal
        Indent:5
    
    ;------------------------------------------------------------------
    
    [Part:MI InvDet]
        Line:MI InvNo, MI InvDt
     
    [Line: MI InvNo]
        Fields    : Short Prompt, Name Field
        Local    : Field    : Short Prompt    : Set as : "No. : "
        Local    : Field    : Name Field    : Set as : $VoucherNumber  
     
    [Line: MI InvDt]
         Use    : MI InvNo
         Local    : Field    : Short Prompt    : Set as : "Dt. : "
         Local    : Field    : Name Field    : Set as : $Date
    
    ;------------------------------------------------------------------
    
    [Part: MI Column Titles]
        Line:MI Column Titles
     
    [Line: MI Column Titles]
        Use : IE Details
        Local : Field : Default : Lines : 2
        Local : Field : Default : Type : String
        Local : Field : Default : Style : Normal Bold
        Local : Field : Ie SRNo : Set as : "S.N."
        Local : Field : IE SiName : Set as : "Items"
        Local : Field : IE Qty : Set as : "Qty"
        Local : Field : IE Rate : Set as : "Price"
        Local : Field : IE Amount : Set as : "Amount"
        Border: Column Titles
    
    ;---------- Body Part ----------
    
    [Part : My Invoice Body Part]
        Part : IE Details, LE Details
        Vertical : Yes
        Scroll : Vertical
        Common Border : yes
    
    [Part : IE Details]
        Line :IE Details
        Repeat : IE Details : Inventory Entries
        Total : IE Qty, IE Amount
    
    [Line : IE Details]
        Field : IE SrNo, IE SiName
        Right Field : IE Qty, IE Rate, IE Amount
        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 : IE SrNo]
        Use : Short Name Field
        Set as : $$Line
        Border : Thin Left
        Width : 4
    
    [Field : IE SIName]
        Use : Name Field
        Set as : $StockItemName
        Border : Thin Left
        FullWIdth : Yes
    
    [Field : IE Qty]
        Use : Number Field ;; Qty Primary Field
        Set as : $BilledQty
        Border : Thin Left
        Format : "NoSymbol,Primary"
        Align : Right
    
    [Field : IE rate]
        Use : Rate Price Field
        Set as : $Rate
        Border : Thin Left
    
    [Field : IE Amount]
        Use : Amount Field
        Set as : $Amount
        Border : Thin Left Right
        Format : "NoComma,NoZero"
    
    [Part : LE Details]
        Line : LE Details
        Repeat : LE Details : Ledger Entries
        Scroll : Vertical
    
    [Line : LE Details]
        Use : IE Details
        Local : Field : IE SrNo : Set as : ""
        Local : Field : IE SiName: Set as : $LedgerName
        Local : Field : IE Qty : Set as : ""
        Local : Field : IE Rate : Set as : $$String:$RateOfInvoiceTax+“%”
        Local : Field : IE Amount: Set as : $Amount
        Local : Field : IE SiName: Align : Right
        Local : Field : IE Qty : Format : "NoZero"
        Local : Field : IE Rate : InActive: $RateOfInvoiceTax = 0
        Local : Field : IE Rate : Type : String
        Empty : $LedgerName = $PartyLedgerName
    
    ;----- Bottom Part -----
    
    [Part : My Invoice Bottom Part]
        Line : MI Total Line, MI AmtInWords, MI ForCmp, MI AuthSign
    
    [Line : MI Total Line]
        Use : IE Details
        Local : Field : Default : Style : Normal Bold
        Local : Field : IE SrNo : Set as : ""
        Local : Field : IE SiName: Set as : "Totals"
        Local : Field : IE Qty : Set as : $$Total:IEQty
        Local : Field : IE Rate : Set as : ""
        Local : Field : IE Amount: Set as : $Amount
        Border : Totals
    
    [Line : MI AmtInWords]
        Field : MI AmtInWords
     
    [Field : MI AmtInWords]
        Use : Name Field
        Set as : $$InWords:$Amount
        FullWidth : yes
        Style : Small
    
    [Line : MI ForCmp]
        Right Field : MI ForCmp
    
    [Field : MI ForCmp]
        Use : Name Field
        Set as : "For " + @@CMPMailNAme
        Align : Right
        Width : 0
    
    [Line: MI AuthSign]
        Right Field : MI AuthSign
        Space Top : 2
    
    [Field: MI AuthSign]
        Use: Name Field
        Set as: "Signatory"
        Width: 0
        Align: Right
    
    [Part: CLPGBrk]
        Line: CLPGBrkln
    
    [Line :CLPGBrkln]
        Right Field: CLPG Brkfld
    
    [Field:CLPG Brkfld]
        Use: Name Field
        Set as: "Continued . . ."
    
    ;[Part: OPGBrk]
    ;    Use: My Invoice Top Part
     
    ;----- End-of-File -----
     
    Last edited: Nov 24, 2014


  2. garvan14

    garvan14 New Member


    when i use Vertical: Yes

    following problem arise in this format...
     

    Attached Files:



  3. garvan14

    garvan14 New Member


    Required Detail
     

    Attached Files:



  4. garvan14

    garvan14 New Member


    when i use very first code

    this error shows
     

    Attached Files:



  5. JObimon Arackal JOhn

    JObimon Arackal JOhn Active Member


    Sorry I could not go through in detail.

    Just check
    1) UDF type and field type are same.
    if you are using existing rate field to display string value you have to redefine the type of rate field( this is an example)
    2) Enough Height is given for each part.
     


  6. Maulik Patel

    Maulik Patel Active Member


    Dear Sir,

    If it is printing in vertical then it must be height problem. try to minimize your height, hope your issue will be resolved.
     


  7. garvan14

    garvan14 New Member


    Sir can you help

    to print half page report and invoice through tdl with DMP.
     


  8. garvan14

    garvan14 New Member


    Sir

    I am using follwoing code for category wise shorting but output shows blank

    please check in this regards

    Thank you
    Code:
        [System: Formula]
            InVoucherList : $$ReportObject:$$FilterCount:InventoryEntries:LineForStkCat > 0
            LineForStkCat : $Parent:StockItem:$StockItemName = $$ReqObject:$Name
            LineForStkItm : $StockItemName = $$ReqObject:$Name
    
        ;-----------------------------------Object Modifications---------------------------------------------
    
        [#Object: StockCategory]
            VchStkCatValue : $$ReportObject:$$FilterAmtTotal:InventoryEntries:LineForStkCat:$Amount
    
        [#Object: StockItem]
            V3Qty     : $$ReportObject:$$FilterQtyTotal:InventoryEntries:LineForStkItm:$BilledQty
            V3Amount     : $$ReportObject:$$FilterAmtTotal:InventoryEntries:LineForStkItm:$Amount
    
        ;-----------------------------------Collection Creation----------------------------------------------
    
        [Collection:V3StockCategory]
            Type         : Stock Category
            With Alias     : Yes
    
        [Collection:V3InvCollection]
            Type         : Stock Item
            Childof     : #StockCategoryName
            BelongsTo     : Yes
    
    
     


Share This Page