Sales Report with Pending Amount Part-5th (How to Show Company Name in our Report)

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

Here we learn How to Show Company Name in Our Tally Report

In Previous Section we learn how to Display a Report when users click on Menu Item




But our Required Report given below :-




Now first we learn How to add Company Name in Our Tally Report. Since we Know only the Field is a Definition where we show any thing.

Old code :- 

[#Menu : Gateway of Tally]
Add : Item : Anurag Tiwari : Display : Report Name

[Report : Report Name]
Form : Form Name

[Form : Form Name]
Part : Part Name

[Part : Part Name]
Line : Line Name

[Line : Line Name]
Field : Field Name

[Field : Field Name]
Set as : "Learn with AT"

Now Change The Code:-

[#Menu : Gateway of Tally]
Add : Item : Anurag Tiwari : Display : Report Name

[Report : Report Name]
Form : Form Name

[Form : Form Name]
Part : Part Name

[Part : Part Name]
Line : Line Name

[Line : Line Name]
Field : Field Name

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

Here we use Some attribute of Field Definition

1. Set as :- Use for Show any thing
2. Full Width :- Use for Full Width
3.Align :- Use for Align like Left , Right Or Centre
4.Style :- Use for Bold , Normal Bold or Large Bold etc.
5.Skip :- Use for Skip the Field or Not


Set as      : @@cmpmailname --------------> { @@FieldName display Field Value Here it Show the Company Name  }

Now the output of our Code 



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

(Your assignment is create a menu Item and display a Report and also show the Company Name using Field attribute)








Comments

  1. HemantSoniFebruary 1, 2024 at 9:51 PM

    Dear sir
    Please यदि मुझ से कोई गलती हो तो माफ करे
    @@ यह system फार्मूला को दर्शाता है। मतलब कंपनी नाम की फील्ड की वैल्यू को cmpmailname में स्टोर किया गया है। फिर इस system फार्मूला को कही भी यूज़ करने के लिए @@ का उपयोग किया जाता है।

    सरजी, अगर मुझ से कोई गलती हो तो please sorry. आगे आप बताये......

    ReplyDelete
  2. Learn With AT (Tally TDL Python )February 2, 2024 at 7:34 AM

    प्रिय हेमन्त जी आप सही कह रहे हैं
    There are two type of formula
    1. Access using @ (local Formula)
    2.Access using @@ (Global or System Formula)
    Example of Local Formula
    [Field : Field ]
    Fld1 : Hemant Ji
    Fld2 : You
    Fld3 : are
    Fld4 :Right
    Set as : @Fld1 + @Fld2 + @Fld3 + @Fld4
    Example of Global Or System Forumula
    [Field : Filed]
    Set as : @@cmpmailname (Show Company Name)
    Set as : @@cmpmobNo (Show Company Mobile No.)
    Set as : @@cmpNetProfit (Show Compnay Net Profit)
    Set as : @@LedgerGSTIN (Show Ledger GST No.)
    Set as : @@LedgerCountry (Show Ledger Country Name)
    Set as : @@LedgerMobile (Show Ledger Mobile No.)
    Set as : @@StockItemParent (Show Stock Item Parent)
    Set as : @@StockItemCat (Show Stock Item Category)
    And Many More.
    हम सब बहुत जल्द इसका गहनता से अध्ययन करते हैं
    Hemant Ji Thank You Very Much for Comment
    Please write something in our Blog
    Thanks again Hemant Ji

    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