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

 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




;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
[#Menu     : Gateway of Tally]
Add : Item :  Anurag Tiwari : DISPLAY : Sales Report

[Report      : SalesReport]
Form         : SalesReport
Set: variable   : svfromdate, svtodate
Set                 : SVFromDate    : $$MonthStart:##SVCurrentDate
Set             : SVToDate        : $$MonthEnd:##SVCurrentDate

[Form      : SalesReport]
Part         : AnuragTitle,AnuragDtls
Bottom Part   : AnuragTotal
Height        : 100% Screen
use           : DSP Template

[Part        : AnuragTitle]
Line         : AnuragTL1,AnuragTL2

[Line         : AnuragTL1]
Field         : AnuragTL1

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

  [Line         : AnuragTL2]
  Field         : AnuragTL2
  Right Field   : AnuragPeriod
; Border       : Column Titles

[Field        : AnuragTL2]
use           : Name Field
  Set as      : "Sales Register"
  Fullwidth   : Yes
Align        : Centre
Skip        : Yes
[Field        : Anuragperiod]
Set as        : "From "+$$String:##svfromdate+" To "+$$String:##svtodate
Skip        : Yes


[Part          : AnuragDtls]
Line           : saleTitles,salesdtls
Repeat       :  salesdtls : Salescoll
Total          : Invamt
Scroll         : Vertical

[Line          : Saletitles]
Field          : Invno, invdt,Party,Invamt,CollectedAmountInfo
Local         : Field : Party : Set as: "Buyer Name"
Local         : Field : Party : Line : 0
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 : CollectedAmountInfo : Set as : "Pending Amount"
Border       : Column Titles


[Line          : salesdtls]
Field          : invno,invdt,Party, Invamt,CollectedAmountInfo
Option          : AlterOnEnter

[Field        : Party]
use          : Name Field
set as       : $PartyLedgername
Width       : 30% Screen

[Field       : InvNO]
use          : Name Field
Set as      : $Vouchernumber
Width       : 15% Screen

[Field       : Invdt]
Set as      : $Date
Width       : 15% Screen

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

[Field: CollectedAmountInfo]
Use : Amount Field
Align : Right
Width : 15% Screen
Style : bold italic
Set as: $PendingAmount
Set always : Yes
Skip : Yes
Background:Grey

[Part : AnuragTotal]
Line  : Anuragtotal

[Line         : Anuragtotal]
Field          : Invno,invdt,party, Invamt,CollectedAmountInfo
Local         : Field : Party : Set as: "Total..."
Local         : Field : Cstno : Set as : ""
Local         : Field : invdt  : Set as :""
Local         : Field : Invno : Set as :""
Local         : Field : Invamt : Set as : $$Total:Invamt
Local         : Field : goods  : type : String
Local         :Field : goods : Set as :""
Local         : Field : CollectedAmountInfo : Set as : $$Total:CollectedAmountInfo
Border       : Column Titles


[Collection:CollForBills]
Type: Bills
Compute : VoucherNumber : $$CollectionField:$VoucherNumber:1:LedgerEntries

[Collection: MycollforCollection]
Source Collection : CollForBills
Fetch : ClosingBalance, VoucherNumber
Compute : LedgerName : $$CollectionField:$LedgerName:1:LedgerEntries
Search Key : $VoucherNumber

[Collection : Salescoll]
Type          : voucher
Filter          : IsSale
Fetch         : Vouchernumber,PartyLedgername,Amount,Buyerscstnumber,Date
Compute : qty:$$CollQtyTotal:Inventoryentries:$BilledQty
Compute : PendingAmount:$$ReportObject:$$CollectionFieldByKey:$ClosingBalance:$VoucherNumber:MycollforCollection

[Collection : SalesColldtl]
Source Collection : Salescoll
Walk    : Inventoryentries
By     : Vouchernumber: $Vouchernumber
Fetch         : Vouchernumber,PartyLedgername,Amount,Buyerscstnumber,Date,Amount

;,Stockitemname

[System     : Formula]
Issale        : $$IsSales:$vouchertypename
ChkParty   : $PartyLedgername = ##Newchangecoll



Comments

  1. KrishnenduFebruary 11, 2024 at 9:31 AM

    sir pending amount show nehi ho rahi hai....pls describe

    ReplyDelete
  2. Learn With AT (Tally TDL Python )February 11, 2024 at 8:50 PM

    compute : PendingAmount:$$Report---------------------------(write this IN front of Compute)
    this code
    [Collection : Salescoll]
    Type : voucher
    Filter : IsSale
    Fetch : Vouchernumber,PartyLedgername,Amount,Buyerscstnumber,Date
    Compute : qty:$$CollQtyTotal:Inventoryentries:$BilledQty
    Compute : PendingAmount:$$ReportObject:$$CollectionFieldByKey:$ClosingBalance:$VoucherNumber:MycollforCollection

    (Just Put PendingAmount:$$ReportObject:$$CollectionFieldByKey:$ClosingBalance:$VoucherNumber:MycollforCollection
    in front of Compute : PendingAmount:$$ReportObject:--------------------(I hope you understand it)

    ReplyDelete
  3. Ozair AhmadMarch 24, 2025 at 5:24 AM

    Pending Ampunt Calculation
    Compute : PendingAmt:$$ReportObject:$$CollectionFieldByKey:$ClosingBalance:@@VchNumWParty:MycollforCollection

    [System: Formula]
    VchNumWParty : $VoucherNumber+$LedgerName

    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

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