Sales Report with Pending Amount Part-10th (How to Show value in Our Report-1st)

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

Here we learn How to Show value in Our Report.(Part-1st)

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


This is the 10th Part Here we learn How to Show Value in Our Report-1st. Here we learn what is attribute Repeat  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-11th

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.



Comments

  1. Ashok SinghviFebruary 6, 2024 at 6:32 PM

    [#Menu : Gateway of Tally]
    Add : Item : Ashok Singhvi : Display : Report Name

    [Report : Report Name]
    Form : Form Name

    [Form : Form Name]
    Part : Part Name,Part2

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

    [Line : Line Name]
    Field : Field Name

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

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

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

    [Field : RightField2]
    Set as : "From "+$$String:##svfromdate+" To "+$$String:##svtodate
    Skip : Yes

    [Part : Part2]
    Line : Line1P

    [Line : Line1P]
    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 : CollectedAmountInfo : Type : String
    Local : Field : PendAmt : Set as : "Pending Amount"


    [Field : Invno]
    Width:10% Screen

    [Field : invdt]
    Width:20% Screen

    [Field : Party]
    Width:25% Screen

    [Field : Invamt]
    Width:15% Screen

    [Field : PendAmt]
    Width:15% Screen
    ;;Feb-07Cade Cont Is It Right?
    [Part : Part2]
    Line:Line1P, Line2P
    Repeat:Line2P:SalesColl

    ReplyDelete
  2. HemantSoniFebruary 6, 2024 at 10:32 PM



    Jis line me heading hoti hai.,
    Us line ki sabhi field me
    "info" ka use karna chahiye
    Agar heading wali line ke field me "set as" ka use karte ho to
    ek aur field ka attribute "skip" ka use hoga.

    Islye yahi better hoga ki aap heading wali line me har Field me jo show karana chahte ho uske liye "info" ka use kare.

    Example : 1

    [Line:line]
    Field: hks invno

    Local : Field : hks invno : Set as : "invoice No."
    Local : Field : hks invno : skip : yes
    Local : Field : hks invno : width: 5% screen


    Example : 2

    [Line:line]
    Field: hks invno

    Local : Field : hks invno : info : "invoice No."

    Local : Field : hks invno : width: 5% screen

    Example : 3

    [Line:line]
    Field: hks invno

    [Field: hks invno]
    Info : "invoice No."
    width. : 5% screen

    Example 1,2,3
    Inme se koi bhi 1 tarike se aap yh code likh sakte hai.

    Heading wali line ke sabhi field ka type string hi hota hai,
    jb tak aap usme kisi dusre field ka use na kiye ho.

    Field ka attribute
    Type ke prakar = string, number, date, amount

    ReplyDelete
  3. Learn With AT (Tally TDL Python )February 7, 2024 at 4:51 PM

    Tnx Ashok ji and Hemant Ji for Comment

    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