Hi Any one guide me or crt d code.. how to get stock closing and stock opening Value ,, [Collection : MyCompanySalesColl] Type:Vouchers:VoucherType Child Of: $$VchTypeSales Walk : All Inventory Entries Compute : MycompanyInventryTotal:$$CollAmtTotal:InventoryEntries:$Amount Fetch : Amount, AllLedgerEntries.Amount,Date,AllLedgerEntries.Date,inventoryentries:$billedqty [Collection : MyCompanyPurchaseColl] Type:Vouchers:VoucherType Child Of: $$VchTypePurchase Walk : All Inventory Entries Compute : MycompanyInventryTotalPur:$$CollAmtTotal:InventoryEntries:$Amount Fetch : Amount, AllLedgerEntries.Amount,Date,AllLedgerEntries.Date,inventoryentries:$billedqty [Collection : MyCompanyExpIndColl] Type:Vouchers ;Child Of: $$VchTypePurchase Walk : All Inventory Entries Compute : MycompanyInventryTotalExpInd:$$FilterAmtTotal:LedgerEntries:discount:$Amount Fetch : Amount, AllLedgerEntries.Amount,Date,AllLedgerEntries.Date,inventoryentries:$billedqty [Collection : MyCompanyStockColl] Type : Stock Item ;Child Of: $$VchTypePurchase ;Walk : All Inventory Entries ;Compute : MycompanyInventryTotalExpInd:$$FilterAmtTotal:LedgerEntries:discount:$Amount Fetch : ClosingBalance;",";Amount, AllLedgerEntries.Amount,Date,AllLedgerEntries.Date,inventoryentries:$billedqty [#Part: PLHorzParts] Vertical : No Parts : PL Expenses, PL Income ;Add:Top PartL New Sync : Yes CommonBorder: Yes Local : Field : BSPercent : Set as : if ($$ExplodeLevel > 0) then 0 else @VertPLVal Local : Field : BSPercentTotal: Set as : 0 [#Part: PLGPExpenses] Parts : PLDirExpenses, PLInDirExpenses Scroll : Vertical Add:Top PartL New [PartL New] Linel New Sales,Pl New Purchase,Pl New Stock Opeing ,Pl New Stock Closing Height:4 [LineL New Sales] Fieldl New Sales T,PL New Sales Local:Fieldefault:Color:Blue [LineL New Purchase] Fieldl New Purchase T,PL New Purchase Local:Fieldefault:Color:Blue [FieldL New Sales T] Use:Name Field Set as:"Total Sales" Full Width:Yes [FieldL New Sales] Use:Amount Field Set as:$$CollAmtTotal:MyCompanySalesColl:$MycompanyInventryTotal [FieldL New Purchase T] Use:Name Field Set as:"Total Purchase" Full Width:Yes [FieldL New Purchase] Use:Amount Field Set as:$$CollAmtTotal:MyCompanyPurchaseColl:$MycompanyInventryTotalPur [Linel New Stock Opeing] Fieldl New Stock Opeing T,Pl New Stock Opeing Local:Fieldefault:Color:Blue [Fieldl New Stock Opeing T] Use:Name Field Set as:"Total Stock Opeing" Full Width:Yes [Fieldl New Stock Opeing] Use:Amount Field Set as:"" [Linel New Stock Closing] Fieldl New Stock Closing T,Pl New Stock Closing Local:Fieldefault:Color:Blue [Fieldl New Stock Closing T] Use:Name Field Set as:"Total Stock Closing" Full Width:Yes [Fieldl New Stock Closing] Use:Amount Field Set as:""
