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
.jpg)
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें