Tally Chapter 159 TDL for Item History in Invoice By Rajiv Mishra Computer Class

-

 




fel lines are missing here.

Pls Watch the lesson video for full coding.





[Collection : RajivMscom]

    Type     : Vouchers : Stock Item

    Child Of : $$BaseOwner:#VchStockItem

    Filter   : SalesFilter 

    Fetch : LedgerEntries.PartyLedgerName, LedgerEntries.LedgerName

[System : Formula]

    RajivMStock      : $StockItemName = $$BaseOwner:#VCHStockItem

    SalesFilter : $$IsSales:$VoucherTypeName

PurchaseFilter : $$IsPurchase:$VoucherTypeName

CreditNoteFilter : $$IsCreditNote:$VoucherTypeName

DebitNoteFilter : $$IsDebitNote:$VoucherTypeName

[#Field : VCH StockItem]

    Key : LWItemLWHs

[Key : LWItemLWHs]

    Key : 

    Action : Display : RajivMIH

[Report : RajivMIH]

Title:"www.RajivMs.com-Item_History"

    Form : RajivMIHform

      

[Form : RajivMIHform]

Part : LWSalesH,LWPurchaseH,LWCRNH,LWDRNH

Buttons  : ChangeCompany, ChangeDybkDate, ChangePeriod

Buttons: PrintButton, ExportButton


[Part : LWSalesH]

Line   : LWSalesLWHsTitle, LWSalesLWHsHD, LWSalesLWHsData

Repeat : LWSalesLWHsData : RajivMscom

Scroll : Vertical

Common Border : Yes

Bottom Line : LW Total

Total: LWNSalesLWHs3,LWNSalesLWHs4,LWNSalesLWHs5,LWNSalesLWHs6


[Line : LWSalesLWHsTitle]

Field : RajivMStkItem

Fixed : Yes

Option : alter on enter

Border:thin top


[Field : RajivMStkItem]

Use        : Short Name Field

Set As     : "History of : " + #VCHStockItem

Full Width : Yes

Align      : Centre        

[Line : LWSalesLWHsHD]

Use : LWSalesLWHsData

Local : Field : Default : Type : String

Local : Field : LWNSalesLWHs0 : Set As : "Voucher Type"

Local : Field : LWNSalesLWHs1 : Set As : "Invoice No"

Local : Field : LWNSalesLWHsDt: Set As : "Date"

Local : Field : LWNSalesLWHs2 : Set As : "Party Name"

Local : Field : LWNSalesLWHs3 : Set As : "Qty"

Local : Field : LWNSalesLWHs4 : Set As : "Rate"

Local : Field : LWNSalesLWHs5 : Set As : "Discount"

Local : Field : LWNSalesLWHs6 : Set As : "Amount"

Local : Field : LWNSalesLWHs7 : Set As : "Godown"

Border : Column Titles

[Line : LWSalesLWHsData]

Field : LWNSalesLWHs1,LWNSalesLWHs0,LWNSalesLWHsDt, LWNSalesLWHs2,

Right Field : LWNSalesLWHs3, LWNSalesLWHs4, LWNSalesLWHs5, LWNSalesLWHs6,LWNSalesLWHs7

Local : Field : LWNSalesLWHs0 : Set As : $VoucherTypeName

Local : Field : LWNSalesLWHs1 : Set As : $VoucherNumber

Local : Field : LWNSalesLWHsDt: Set As : $Date

Local : Field : LWNSalesLWHs2 : Set As : $PartyLedgerName

Local : Field : LWNSalesLWHs3 : Set As : $$FilterValue:$BilledQty:InventoryEntries:1:RajivMStock 

Local : Field : LWNSalesLWHs4 : Set As : $$FilterValue:$Rate:InventoryEntries:1:RajivMStock 

Local : Field : LWNSalesLWHs5 : Set As : $$FilterValue:$discount:InventoryEntries:1:RajivMStock 

Local : Field : LWNSalesLWHs6 : Set As : $$FilterValue:$Amount:InventoryEntries:1:RajivMStock 

Local : Field : LWNSalesLWHs7 : Set As : $$FilterValue:$BatchAllocations[1].GodownName:InventoryEntries:1:RajivMStock 

Explode : RajivMHData : $$FilterCount:InventoryEntries:RajivMStock  -1 > 0

Border : Thin Bottom


[Part : RajivMHData]

Line : LWSalesLWHsData1

Repeat : LWSalesLWHsData1 : InventoryEntries


[Line : LWSalesLWHsData1]

Field : LWNSalesLWHs1,LWNSalesLWHs0,LWNSalesLWHsDt, LWNSalesLWHs2 

Right Field : LWNSalesLWHs3, LWNSalesLWHs4, LWNSalesLWHs5, LWNSalesLWHs6,LWNSalesLWHs7

Local : Field : LWNSalesLWHs0 : Set As : $$Owner:$VoucherTypeName

Local : Field : LWNSalesLWHs1 : Set As : $$Owner:$VoucherNumber

Local : Field : LWNSalesLWHsDt: Set As : $$Owner:$Date

Local : Field : LWNSalesLWHs2 : Set As : $$Owner:$PartyLedgerName

Local : Field : LWNSalesLWHs3 : Set As : $BilledQty

Local : Field : LWNSalesLWHs4 : Set As : $Rate

Local : Field : LWNSalesLWHs5 : Set As : $Discount

Local : Field : LWNSalesLWHs6 : Set As : $Amount

Local : Field : LWNSalesLWHs6 : Set As : $BatchAllocations[1].GodownName

Empty if : NOT @@RajivMStock   OR $$ItemSerial=0 

Border : Thin Bottom 


[Field : LWNSalesLWHs0]

Use : Short Name Field    

Align: Center 

border:thin left Right

[Field : LWNSalesLWHs1]

    Use : Short Name Field    

Width:10

    Align:Right

border:thin left Right 

[Field : LWNSalesLWHsDt]

    Use : Date Field    

Width:10

Align:Right

border:thin Right

[Field : LWNSalesLWHs2]

    Use : Name Field

Width: Full Width

Indent : 1

    Variable : ledgername

Display : Voucher

QuickSearch : Yes

[Field : LWNSalesLWHs3]

    Use : Qty Field

Align : Right

[Field : LWNSalesLWHs4]

    Use : Rate Price Field

Width: Full Width 

Indent : 2

[Field : LWNSalesLWHs5]

    Use : Number Field

    Align : Right

    Format : "Percentage"

border:thin left Right

Width:5

[Field : LWNSalesLWHs6]

    Use : Amount Field

border:thin Right

[Field : LWNSalesLWHs7]

    Use : Name Field

border:thin Right

[Collection : RajivMscom1]

    Type     : Vouchers : Stock Item

    Child Of : $$BaseOwner:#VchStockItem

    Filter   : PurchaseFilter 

    Fetch : LedgerEntries.PartyLedgerName, LedgerEntries.LedgerName

[Part :LWPurchaseH]

Line   : LearnWPLWHsHD, LearnWPLWHsData

Repeat : LearnWPLWHsData : RajivMscom1

Scroll : Vertical

Bottom Line : LW Total

Total: LWNSalesLWHs3,LWNSalesLWHs4,LWNSalesLWHs5,LWNSalesLWHs6

[Line: LearnWPLWHsHD]

Use: LWSalesLWHsHD

[Line: LearnWPLWHsData]

Use: LWSalesLWHsData

[Line:LW Total]

Use : LWSalesLWHsData

Local : Field : LWNSalesLWHs2: Set As : " Total"

Local : Field : LWNSalesLWHs3 : Set As : $$Total:LWNSalesLWHs3 

Local : Field : LWNSalesLWHs6  : Set As : $$Total:LWNSalesLWHs6

Border : Thin top 


[Collection : RajivMscom2]

    Type     : Vouchers : Stock Item

    Child Of : $$BaseOwner:#VchStockItem

    Filter   : CreditNoteFilter 

    Fetch : LedgerEntries.PartyLedgerName, LedgerEntries.LedgerName

[Part :LWCRNH]

Line   :LearnWCrLWHsHD, LearnWCrLWHsData

Repeat : LearnWCrLWHsData : RajivMscom2

Scroll : Vertical

Bottom Line : LW Total1

Total: LWNSalesLWHs3,LWNSalesLWHs4,LWNSalesLWHs5,LWNSalesLWHs6

[Line: LearnWCrLWHsHD]

Use: LWSalesLWHsHD

[Line: LearnWCrLWHsData]

Use: LWSalesLWHsData

[Line:LW Total1]

Use : LWSalesLWHsData

Local : Field : LWNSalesLWHs2: Set As : " Total"

Local : Field : LWNSalesLWHs3 : Set As : $$Total:LWNSalesLWHs3 

Local : Field : LWNSalesLWHs6  : Set As : $$Total:LWNSalesLWHs6

Border : Thin top 


[Collection : RajivMscom3]

    Type     : Vouchers : Stock Item

    Child Of : $$BaseOwner:#VchStockItem

    Filter   : DebitNoteFilter 

    Fetch : LedgerEntries.PartyLedgerName, LedgerEntries.LedgerName

[Part :LWDRNH]

Line   : LearnWDrLWHsHD, LearnWDrLWHsData

Repeat : LearnWDrLWHsData : RajivMscom3

Scroll : Vertical

Bottom Line : LW Total2

Total: LWNSalesLWHs3,LWNSalesLWHs4,LWNSalesLWHs5,LWNSalesLWHs6

[Line: LearnWDrLWHsHD]

Use: LWSalesLWHsHD

[Line: LearnWDrLWHsData]

Use: LWSalesLWHsData

[Line:LW Total2]

Use : LWSalesLWHsData

Local : Field : LWNSalesLWHs2: Set As : " Total"

Local : Field : LWNSalesLWHs3 : Set As : $$Total:LWNSalesLWHs3 

Local : Field : LWNSalesLWHs6  : Set As : $$Total:LWNSalesLWHs6

Border : Thin top 


टिप्पणियाँ

एक टिप्पणी भेजें

इस ब्लॉग से लोकप्रिय पोस्ट

Tally Chapter 153 TDL for Custom List of Stock Item By Rajiv Mishra Computer Class

-
चित्र
  Few lines are missing Here. Watch the full video for full code.   Use            : ExtractAlias Collection     Source Collection    : Stock Item Src     Collection        : StockItem PartNo With Closing     Title               : $$LocaleString:"List of Items                                     Stock Qty     LastSale Price "         Fetch               : Name, VchStkItmBalance,LastSalePrice,ClosingBalance     Set as             : $FirstName     Keep Source        : ().     Client Only        : Yes     Format          : $VchStkItmBalance...
Read more »

Tally Chapter 130 TDL for Stamp & Signature By Rajiv Mishra Computer Class

-
चित्र
  Few lines of the code is missing. pls watch the video for full coding. Add: Right Parts: EXPSMPSignature2 [Part: EXPSMPSignature1] ;;Width: 100% page Horizontal Alignment:Right Vertical:No Lines : EXPINV Logo1 Graph Type : "C:\Users\user\Desktop\tdl image.jpg" Height : 1.00 Cm Width : 10.80 Cm [Line: EXPINV Logo1] Field : EXPINV Logo1 [Field: EXPINV Logo1] Set as : "Authorized Signatory" [Part:EXPSMPSignature2] Border:ll Vertical:No Horizontal Alignment:Right Width:20% Page Right Part:EXPSMPSignature1 Width:70% Page Width:50% Page
Read more »

Tally Chapter 105 TDL for Receipt contra Payment BULK Entry by Rajiv Mishra Computer Class

-
चित्र
 TDL CODE --------------TDL CODE STARTS HERE------------------------ [#Menu: Gateway of Tally] Add : Item : "Bulk Pay/ Rec/ Contra Entry" : Alter : JennyPayment EntryRpt [Report : JennyPayment EntryRpt] Form : JennyPayment EntryFrm Title : $$LocaleString:"Bulk Payment Entry" Object : Company [Form : JennyPayment EntryFrm] Part : Form SubTitle, JennyPayment DrLedPrt;JennyPayment CrLedPrt, JennyPayment DrLedPrt Width : 100% Page Height : 100% Page Space Left : 0.25 Space Right : 0.25 Horizontal Align: Left Local : Field : Form SubTitle : Info : "Bulk Payment / Receipt / Contra Entry" On : Form Accept : yes : Form Accept On : Form Accept : yes : Call : CphSale BulkAutoEntry ;; Sales Credit Part ;; ;;------------------------------------------------------------------------------------------ ; [Part : JennyPayment CrLedPrt] ; ; Line : JennyPayment CrLedLne;,JennyPayment SalesLedName ; ; [Line : JennyPayment CrLedLne] ; ; Field : Medium Prompt, JennyPayment CrLed...
Read more »