1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Petty Cash report

Discussion in 'Free Source Codes' started by vinayprasad.Dubai, Dec 14, 2018.

    
Tags:
  1. vinayprasad.Dubai

    vinayprasad.Dubai Member


    Code:
    ;;;;;;; OM Gan Ganapathaye Namha
;:::::; Author : Vinay Prasad
;;;;;;; Dated 13.12.2018
;;;;;;; This is a TDL to know the petty cash expenses and income


[#Menu :Gateway of TAlly]
    Add: Key Item: Petty Cash :C: Display: Petty cash
   

[Report: PettyCash]
    Form: petty cash
   
   
[Form: Petty Cash]
   
Part: New part1
Bottom Part: total left
Use: DSP template
Background: Green

[Part: NEw Part1]
    Add : Left Part : Petty cash receipt,
    Add: Right Parts: petty cash paid
    ;Total: total parts
    ;Repeat:Petty Cash Body : mycoll1
    ;Add    : Bottom Part:    Bottom Part cash
    Border: thick box
   
   
[Part: Petty cash receipt]
    Add: Lines: Title Left line ,column left titles,Petty Cash left body,
    Repeat:Petty Cash left body : mycoll1
    ;Total: left total
    ;Height : 100 % Page
    ;Width : 50 % Page
    Horizontal Align: left
    Scroll: Vertical
    Common Borders: Yes
    Background: Light Sea Green

[Part:Petty cash paid]   
    Add: Lines: Title Right line, column  right titles,Petty Cash right body
    Repeat:Petty Cash right body : mycoll2
    ;Height : 100 % Page
    ;;Width : 100 % Page
    Horizontal Align: Right
    Scroll: Vertical
   

[Line: Title Left line]
    Field: Simple Field, ;Petty cash,
    ;Right Field: Name Field, Date1
    Local: Field : Simple Field : Set as: "Petty cash Received"
    Local: Field : Simple Field : Style: Large Serif Bold
    Local: Field : Simple Field : Align: Center
    Local: Field : Simple Field : Full Width: Yes
    Local: Field : Simple Field : Color: BLue
   
    ;Local: Field: Name Field : Set as: "Date :"
   

[Line: Title right line]
    Field: Simple Field, ;Petty cash,
    ;Right Field: Name Field, Date1
    Local: Field : Simple Field : Set as: "Petty cash Expenses"
    Local: Field : Simple Field : Style: Large Serif Bold
    Local: Field : Simple Field : Align: Center
    Local: Field : Simple Field : Full Width: Yes
    Local: Field : Simple Field : Color: BLue

   
;::::::::::::::::::::::::::::;Column;::::::::::::::::::::::;
   
;[Part: Column Parts]
;    Add: Line: Column line
;    Scroll: Vertical
   
[Line: column left titles]
    ;;Field: Pt Sl No, PT Name, pt Amount Rcd, Amount paid, Customer Name, Place
   
            Use         : Petty cash left body
            Local: Field: Default         : Lines     : 2
            Local: Field: Default         : Type      : String
            Local: Field: Default         : Style     : Normal Bold
            ;Local: Field: LC SlNo        : Info        : "Sr No"
            Local: Field: Lc Date        : Info        : "Date"
            Local: Field: Lc Name        : Info        : "Particulars"
            Local: Field: LC Notes        : Info        : "Remarks"
            Local: Field: Lc Amount Rcd : Info         : "Amount Received"
            Border      : Column Titles
           
[Line: column right titles]
            Use: Petty cash right body
            Local: Field: Default         : Lines     : 2
            Local: Field: Default         : Type      : String
            Local: Field: Default         : Style     : Normal Bold
            Local: Field: RC Date        : Info        : "Date"
            Local: Field: RC Customer   : Info       : "Particulars"
            Local: Field: RC Amount Paid: Info         : "Amount Paid"
            Local: Field: Rc Place       : Info       : "Remarks"
            Border      : Column Titles
           
;[Part: Petty Cash Body]
;    Line: Column titles
;    Line: Petty Cash body
   

[Line: Petty Cash left body]
        Fields: Lc date, Lc Name, LC notes, Lc Amount Rcd,
       
[Line: Petty Cash Right body]   
       
        Field: Rc Date,Rc customer,Rc Place, Rc Amount Paid,
       

[Field: Lc date]
    Use: short date field
    Type: Date
    Width: 20 MM
    Set as: $Date
    Align: Left
   
[Field: Lc Name]
    Use: Name Field
    Type: String
    Full Width: Yes
    Set as: $LedgerName
    Lines: 2
   
[Field: LC notes]   
    Use: Name Field
    Type:String
    Set as : $NARRATION
    Width: 40 MM
    Lines: 2
   
[Field: Lc amount Rcd]
        Use: Amount Field
        Type: Amount
        Width: 30 MM
        Set as: $Amount
        Border: Double Right
        Align:Center
       
;Right Fields

[Field: Rc date]
    Use: short date field
    Type: Date
    Width: 20 MM
    Set as: $Date
    Align: Left

[Field: Rc Amount paid]
    Use: Amount Field
    Type: Amount
    Width: 30 MM
    Set as: $amount
    Align: Right
    Style: normal bold
[Field:Rc customer]
    Use: Name Field
    Type: String
    Full Width: Yes
    Set as: $ledgername
    Lines: 2

[Field:Rc Place]
    Use: Name FIeld
    Width: 30 MM
    Set as: $Narration
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;Bottpom parts


[Part: total left]

Line: TOtal left line,TOtal Right line, Balance amount
Space Left: 110
Background: Geranium

[Line: total left line]
    Right Field: Simple Field, left total
    Local: Field: Simple Field : Set as: "Total Cash Received"
    Local: Field: Simple Field : Style: Normal bold
    Border: thick left right
   
[Field: left total]
    Use: amount field
    Set as: $$CollAmtTotal:mycoll1:$amount   
    Width: 20
    Style: large bold
    Border: thick left
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

[Line: total right line]
    Right Field: Simple Field,right total
    Local: Field: Simple Field : Set as: "Total Expenses"
    Local: Field: Simple Field : Style: Normal bold
    Border: thick cover
   
[Field: right total]
    Use: amount field
    Set as: $$CollAmtTotal:mycoll2:$amount   
    Width: 20
    Style: large bold
    Border: thick left
   
[Line: Balance Amount]
    Right Field: Simple Field, Balance Field
    Local: Field: Simple Field : Set as: "Balance Cash"
    Local: Field: Simple Field : Style: Normal bold
    Border:thick box
   
[Field: Balance Field]
    Use: amount field
    Set as : $$CollAmtTotal:mycoll1:$amount - $$CollAmtTotal:myColl2:$amount
    Width: 20
    Style: large bold
    Align: Right
    Border: thick left

[Collection: mycoll2]
    Type: voucher
    Fetch: *.*,LedgerEntries.*
    Filter: Onlypayment
   
[Collection: Mycoll1]
    Type: Voucher
    Fetch: *.*,LedgerEntries.*
    Filter: onlyreceipt
   
[System: Formulae]
    Onlypayment:  $VOUCHERTYPENAME=" pettyPayment" or $VOUCHERTYPENAME= "PettyExp"
    onlyreceipt : $VOUCHERTYPENAME="pettyReceipts"

;;;End code
    I have created this report to know the petty cash expense and petty cash received. Can you help me in adding the opening balance of the ledger "Petty cash" in this report please.
     
    vinayprasad.Dubai, Dec 14, 2018
    #1
    nasir likes this.


  2. nasir

    nasir Member


    u grate bro bur data is not showing in this report
     
    nasir, Dec 15, 2018
    #2


  3. vinayprasad.Dubai

    vinayprasad.Dubai Member


    create 2 vouchers petty exp under journal and petty receipts under receipts then pass the transactions

    pettyPayment
     
    vinayprasad.Dubai, Dec 15, 2018
    #3


  4. vinayprasad.Dubai

    vinayprasad.Dubai Member


    updated file with opening balance of Petty cash ledger
    Code:
    ;;;;;;; OM Gan Ganapathaye Namha
;:::::; Author : Vinay Prasad
;;;;;;; Dated 13.12.2018
;;;;;;; This is a TDL to know the petty cash expenses and income


[#Menu :Gateway of TAlly]
    Add: Key Item: Petty Cash :C: Display: Petty cash
   

[Report: PettyCash]
    Form: petty cash
   
   
[Form: Petty Cash]
   
Part: New part1
Bottom Part: bottom part
Use: DSP template
Background: Green
Width: 100% page

[Part: NEw Part1]
    Add : Left Part : Petty cash receipt,
    Add: Right Parts: petty cash paid
    ;Total: total parts
    ;Repeat:Petty Cash Body : mycoll1
    ;Add    : Bottom Part:    Bottom Part cash
    Border: thick box
    Sync: Yes
   
[Part: Petty cash receipt]
    Add: Lines: Title Left line ,column left titles,Petty Cash left body,
    Repeat:Petty Cash left body : mycoll1
    ;Total: left total
    ;Height : 100 % Page
    ;Width : 50 % Page
    Horizontal Align: left
    Scroll: Vertical
    Common Borders: Yes
    Background: Green16Bit
    Width: 50% page
   

[Part:Petty cash paid]   
    Add: Lines: Title Right line, column  right titles,Petty Cash right body
    Repeat:Petty Cash right body : mycoll2
    ;Height : 100 % Page
    ;;Width : 100 % Page
    Horizontal Align: Right
    Scroll: Vertical
    Width: 50% page
    Common Borders: Yes

[Line: Title Left line]
    Field: Simple Field, ;Petty cash,
    ;Right Field: Name Field, Date1
    Local: Field : Simple Field : Set as: "Petty cash Received"
    Local: Field : Simple Field : Style: Large Serif Bold
    Local: Field : Simple Field : Align: Center
    Local: Field : Simple Field : Full Width: Yes
    Local: Field : Simple Field : Color: BLue
   
    ;Local: Field: Name Field : Set as: "Date :"
   

[Line: Title right line]
    Field: Simple Field, ;Petty cash,
    ;Right Field: Name Field, Date1
    Local: Field : Simple Field : Set as: "Petty cash Expenses"
    Local: Field : Simple Field : Style: Large Serif Bold
    Local: Field : Simple Field : Align: Center
    Local: Field : Simple Field : Full Width: Yes
    Local: Field : Simple Field : Color: BLue

   
;::::::::::::::::::::::::::::;Column;::::::::::::::::::::::;
   
;[Part: Column Parts]
;    Add: Line: Column line
;    Scroll: Vertical
   
[Line: column left titles]
    ;;Field: Pt Sl No, PT Name, pt Amount Rcd, Amount paid, Customer Name, Place
   
            Use         : Petty cash left body
            Local: Field: Default         : Lines     : 1
            Local: Field: Default         : Type      : String
            Local: Field: Default         : Style     : Normal Bold
            ;Local: Field: LC SlNo        : Info        : "Sr No"
            Local: Field: Lc Date        : Info        : "Date"
            Local: Field: Lc Name        : Info        : "Particulars"
            Local: Field: LC Notes        : Info        : "Remarks"
            Local: Field: Lc Amount Rcd : Info         : "Amount R'cd"
            Border      : Column Titles
           
[Line: column right titles]
            Use: Petty cash right body
            Local: Field: Default         : Lines     : 1
            Local: Field: Default         : Type      : String
            Local: Field: Default         : Style     : Normal Bold
            Local: Field: RC Date        : Info        : "Date"
            Local: Field: RC Customer   : Info       : "Particulars"
            Local: Field: RC Amount Paid: Info         : "Amount Paid"
            Local: Field: Rc Place       : Info       : "Remarks"
            Border      : Column Titles
           
;[Part: Petty Cash Body]
;    Line: Column titles
;    Line: Petty Cash body
   

[Line: Petty Cash left body]
        Fields: Lc date, Lc Name, LC notes, Lc Amount Rcd,
            Border: thin bottom
   


[Line: Petty Cash Right body]   
       
        Field: Rc Date,Rc customer,Rc Place, Rc Amount Paid,
        Border: thin bottom

[Field: Lc date]
    Use: short date field
    Type: Date
    Width: 20 MM
    Set as: $Date
    Align: Left
   
[Field: Lc Name]
    Use: Name Field
    Type: String
    Full Width: Yes
    Set as: $LedgerName
    Lines: 2
   
[Field: LC notes]   
    Use: Name Field
    Type:String
    Set as : $NARRATION
    Width: 60 MM
    Lines: 2
   
[Field: Lc amount Rcd]
        Use: Amount Field
        Type: Amount
        Width: 35 MM
        Set as: $Amount
        Border: Double Right
        Align:Center
       
;Right Fields

[Field: Rc date]
    Use: short date field
    Type: Date
    Width: 20 MM
    Set as: $Date
    Align: Left

[Field: Rc Amount paid]
    Use: Amount Field
    Type: Amount
    Width: 30 MM
    Set as: $amount
    Align: Right
    Style: normal bold
[Field:Rc customer]
    Use: Name Field
    Type: String
    Full Width: Yes
    Set as: $ledgername
    Lines: 2

[Field:Rc Place]
    Use: Name FIeld
    Width: 60 MM
    Set as: $Narration
    Lines: 2
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;Bottpom parts


[Part: bottom part]
Add: left Part: total left, total Right
Local: Part: default : Width: 51% page
Common Border: Yes
Sync: no
[Part: total left]

Lines: Ledgername1, OPngline
Background: Geranium
;Width: 50% page

[Line: ledgername1]
    Field: simple prompt, NAme field
    ;Local: Field: Default : Width: 30
    Local: Field: Simple prompt : Set as: "Ledger Name"
    Local: Field: Simple prompt : Width: 20
    ;Local: Field: Name Field : Set as: $ledgername
    Local: Field: Name Field : Set as:  "Petty cash"
    Local: Field: Default : Style: Large bold
    Border: thickleftright

[Line: opngline]
    Field: simple prompt, NAme Field;Amount Field
    Local: Field: Default : Width: 20
    Local: Field: Default : Style: Large bold
    Local: Field: Simple prompt : Set as: "Opening Cash"
    Local: Field: Name Field : Set as:@@PartyOpBalance   
    Local: Field: Name Field : Style: Large bold
    Border: thickbox

[System: Formula]

PartyOpBalance            : $OpeningBalance:Ledger:"Petty Cash"
partyname1                : $Ledgername:Group:"Cash In hand"

[Part: total Right]

Line: TOtal left line,TOtal Right line, Balance amount
;Space Left:
Background: Geranium
;Width: 50% page

[Line: total left line]
    Right Field: Simple Field, left total
    Local: Field: Simple Field : Set as: "Total Cash Received"
    Local: Field: Simple Field : Style: Normal bold
    Border: thick left right
   
[Field: left total]
    Use: amount field
    Set as: $$CollAmtTotal:mycoll1:$amount   
    Width: 20
    Style: large bold
    Border: thick left
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

[Line: total right line]
    Right Field: Simple Field,right total
    Local: Field: Simple Field : Set as: "Total Expenses"
    Local: Field: Simple Field : Style: Normal bold
    Border: thick cover
   
[Field: right total]
    Use: amount field
    Set as: $$CollAmtTotal:mycoll2:$amount   
    Width: 20
    Style: large bold
    Border: thick left
   
[Line: Balance Amount]
    Right Field: Simple Field, Balance Field
    Local: Field: Simple Field : Set as: "Balance Cash"
    Local: Field: Simple Field : Style: Normal bold
    Border:thick box
   
[Field: Balance Field]
    Use: amount field
    Set as : $$CollAmtTotal:mycoll1:$amount - $$CollAmtTotal:myColl2:$amount
    Width: 20
    Style: large bold
    Align: Right
    Border: thick left

[Collection: mycoll2]
    Type: voucher
    Fetch: *.*,LedgerEntries.*
    Filter: Onlypayment
   
[Collection: Mycoll1]
    Type: Voucher
    Fetch: *.*,LedgerEntries.*
    Filter: onlyreceipt
   
[System: Formulae]
    Onlypayment:  $VOUCHERTYPENAME=" pettyPayment" or $VOUCHERTYPENAME= "PettyExp"
    onlyreceipt : $VOUCHERTYPENAME="pettyReceipts"

;;;End code
     
    vinayprasad.Dubai, Dec 15, 2018
    #4
    nasir likes this.


  5. nasir

    nasir Member


    bro u have to add a little more kindly set formula as opening balance+receipts-expenses=net balance

    will waiting Ur reply

    thanks
     
    nasir, Dec 16, 2018
    #5


  6. nasir

    nasir Member


    one more thing bro u should add company name and period of report at top of the page
    thanks
     
    nasir, Dec 16, 2018
    #6


  7. nasir

    nasir Member


     
    nasir, Dec 16, 2018
    #7


Share This Page