Sales Report with Pending Amount Part-13th (How to Show value in Our Report-4th)

 Hello Friend welcome. Here we Learn How to create Sales Report with Pending Amount Part-13th

Here we learn How to Show value in Our Report.(Part-4th)

In Previous Section we Learn 

In 1st Part :- We Saw Demo of the Code.

In 2nd Part :- We Learn How to Create Menu Item

In 3rd Part :- How to Open a Report When Users Click on Menu Item

In 4th Part :- What is the Structure of Tally Report and it's attributes

In 5th Part :- How to Show Company Name in our Report

In 6th Part :- How to show Sales Register Name in our Report

In 7th Part :- How to show Period in our Report

In 8th Part :- How to Add Heading in our Report

In 9th Part :- How to give the gap between Heading in Our Report

In 10th Part :- How to Show value in Our Report-1st

In 11th Part :- How to Show value in Our Report-2nd

In 12th Part :- How to Show value in Our Report-3rd

This is the 13th Part Here we learn How to Show Value in Our Report-4th Here we learn How to fetch  More (Party Name and Invoice Amt)Value From Collection 

For More for this You can visit  in My Channel (Just Type @anuragtiwari7149 on Your Browser) 

Tally Screen (Sales Report with Pending Amount):-




Now Friend we can learn more about this in next Chapter Sales Report with Pending Amount Part-14th

Now Friends your assignment 

Crate a Menu Item on Gateway of Tally and when users click on this Menu Item it's show a Report
Show Company Name , Sales Register and Period on Your Report Prepare Heading on Your Report
Give Gap Between your Heading. And write a Comment on What is Repeat Attribute and how it's Help us to Show the Value. and Field Attribute Set as using $ symbol for fetch value From collection.


Comments

  1. KrishnenduFebruary 10, 2024 at 8:57 AM

    [#Menu : Gateway of Tally]
    Add : Item : Anurag Tiwari : Display : Pending Amount
    /*Since we use command display Report so we define Report since Report is a definition and the we define Report since we know
    that Report uses Form Form uses Part Part uses Line and Line uses Field */
    [Report : Pending Amount]
    Form : Form Name
    [Form : Form Name]
    Height : 100% Screen
    Width : 100% Screen
    Part : Part Name,Part2

    [Part : Part Name]
    Line : Line Name , Line2

    [Line : Line Name]
    Border:Myborder
    Space Bottom:1
    Field : Field Name

    [Field : Field Name]
    Set as : @@cmpmailname
    Full Width : Yes
    Align : Centre
    Style : Extra Large Bold
    Skip : Yes

    [Line : Line2]
    Border:Myborder
    Field : Field2
    Right Field : RightField2

    [Field : Field2]
    use : Name Field
    Set as : "Sales Register"
    Fullwidth : Yes
    Align : Centre
    Skip : Yes
    Style :Large Bold

    [Field : RightField2]
    Set as : "From "+$$String:##svfromdate+" To "+$$String:##svtodate
    Skip : Yes
    Style :Large Bold
    [Part : Part2]
    Line : Line1P ,Line2P
    Repeat : Line2P : Salescoll

    [Line : Line1P]
    Border:Myborder2
    Field : Invno, invdt,Party,Invamt,PendAmt
    Local : Field : Party : Set as: "Buyer Name"
    Local : Field : invdt : Set as :"Inv Dt"
    Local : Field : Invno : Set as :"Invno."
    Local : Field : Invamt : type : String
    Local : Field : Invamt : Set as : "Inv.Amt"
    Local : Field : PendAmt : Type : String
    Local : Field : PendAmt : Set as : "Pending Amount"


    [Line : Line2P]
    Field : Invno, invdt,Party,Invamt,PendAmt

    [Field : Invno]
    use : Name Field
    Set as : $Vouchernumber
    width : 15% Screen

    [Field : invdt]
    Set as : $Date
    width : 25% Screen

    [Field : Party]
    use : Name Field
    set as : $PartyLedgername
    width : 25% Screen

    [Field : Invamt]
    use : Amount Field
    Set as : $Amount
    width : 15% Screen

    [Field : PendAmt]
    Use : Amount Field
    Align : Right
    Width : 15% Screen
    Style : bold italic
    Set as: $PendingAmount
    Set always : Yes
    Skip : Yes
    width : 15% Screen
    [System : Formula]
    Issale : $$IsSales:$vouchertypename
    [Collection : Salescoll]
    Type : voucher
    Filter : IsSale
    Fetch : Vouchernumber , Date , PartyLedgername,Amount,PendAmt

    [Border:Myborder]
    Top:full Length,Thick
    Bottom:Full Length,Thick
    [Border:Myborder2]
    Bottom:Full Length,Thick

    ReplyDelete
  2. Ashok SinghviFebruary 10, 2024 at 6:50 PM

    Krishnendu Code Not Show Perfect Result Where Is Mistake Pls Rply: infojainam@gmail.com

    ReplyDelete

Post a Comment

Popular posts from this blog

How to Customize Sale Invoice

Image
 In this Blog we learn Internal Parts of Sale Invoice in Tally Software for Customize Sale invoice using TDL This is the left top part of Sale Invoice here we also learn PrintBG attribute  Now Friend in Second Part we learn Delete : Parts attribute Add Own Line and Field attribute Now friend Practice it for More details. visit my YouTube Channel (@anuragtiwari7149) This is the Right top part of Sale Invoice here we also learn PrintBG attribute , Delete Parts attribute Now friend Practice it for More details. visit my YouTube Channel  (@anuragtiwari7149) Expinv Basicinfo Further divided into Two Parts Part : ExpinvBasicLeft also divvied into Further Parts Use Print BG Print FG Delete Parts and Add own Field on the above Part. EXPINV COLUMN                                                             EXPINV Details   EXPIN...
Read more

Sales Report with Pending Amount Part-14th (Final)

Image
 Hello Friends Welcome We Complete our Task How to Create a Report in Tally using TDL which show us Sales Register with Pending Amount Now Your assignment is Create this whole Report and have any issue please comment. For More help watch My YouTube Channel  In 1st Part :- We Saw Demo of the Code. In 2nd Part :- We Learn How to Create Menu Item In 3rd Part :- How to Open a Report When Users Click on Menu Item In 4th Part :- What is the Structure of Tally Report and it's attributes In 5th Part :- How to Show Company Name in our Report In 6th Part :- How to show Sales Register Name in our Report In 7th Part :- How to show Period in our Report In 8th Part :- How to Add Heading in our Report In 9th Part :- How to give the gap between Heading in Our Report In 10th to 14th :- How to Fetch Value From Collection ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;...
Read more

How to create customize Software in Tally using TDL

Image
  Dear Friends there are Many Accounting Software Like Sap ERP , Tally ERP , Bussy , KhataBook and Zoho Books. etc. All accounting Software has Three Funda (Rule) 1. Master :- Like Group , Ledger , Stock Item , Stock Group , Unit etc. 2.Transection :- Like Contra , Payment , Receipt , Journal , Sales , Purchase , Debit Note , Credit Note etc. 3.Report :- Like Balance Sheet , Trial Balance , Profit & Loss , Sales Register , Purchase Register , Payment Register , Receipt Register etc. First we learn how to create Master in Tally Software. When we save any Master this save into Tally Database like a Table. In the First Part we learn How to create Group Ledger using TDL. In the Second Part we learn How to create Ledger Master in Tally using TDL. In the Third Part we learn How to create Cost Centre in Tally Using TDL. In the Fourth Part we learn How to create Cost Category in Tally Using TDL. In the Fifth Part we learn How to create Stock Group in Tally Using TDL. In the Sixth Pa...
Read more