Use idea from the part of TDL [Part : CEO DB Top 5 Cust] Line : CEO DB Top 5 Cust Title, CEO DB Top 5 Cust Repeat : CEO DB Top 5 Cust : CEO DB Top 5 Cust Border : Thin Top [Line : CEO DB Top 5 Cust Title] Field : Name Field Local : Field : Name Field : Setas : "Top 10 Customers" Local : Field : Name Field : Align : Centre Local : Field : Name Field : Border : Thin Bottom Local : Field : Default : Style : Small Local : Field : Default : BackGround : CEO DB Title Color Local : Field : Name Field : Width : @@NameWidth+@@AmountWidth Local : Field : Amount Field : Display : CEO DB Top 5 Cust Report Local : Field : Name Field : FullWidth : Yes Local : Field : Name Field : Style :Small Bold Local : Field : Name Field : Style :Small Bold [Line : CEO DB Top 5 Cust] Border : Thin Bottom Empty : $$Line >=11 OR $$IsEmpty:$BSDebits Fields :Medium Prompt RightFields: Amount Field Local : Field : Medium Prompt : Setas : $Name+" :" Local : Field : Amount Field : Setas : $BSDebits ;;@@CEODBDrsNett ;;;;$ClosingBalance ;;;@@CEODBDrsNett Local : Field : Amount Field : Format : "DrCr" Local : Field : Default : Style : Tiny Local : Field : Amount Field : Display : CEO DB Top 5 Cust Report [Report : CEO DB Top 5 Cust Report] Use : Group Summary Title : $$LocaleString:"SundryDebtors" Set : GroupName : $$GroupSundryDebtors Set : IsLedgerwise : "YES" Set : DSPShowTrans : "Yes" Set : DSPShowClosing : "No" Set : DSPSHowNett : "Yes" Local : Collection : Default : Sort : Default : $BSDebits ;;@@CEODBDrsNett Local : Collection : Default : Add : Filter : CEO DB Only Drs [Collection : CEO DB Top 5 Cust] Type : Ledger Childof : $$GroupSundryDebtors BelongsTo: Yes Sort efault : $BSDebits Filter : CEO DB Only Drs [System : Formula] CEO DB Only Drs : $BSDebits>0 ;;$$IsDr@CEODBDrsNett ;;;$$IsDr:$ClosingBalance ;;;;;@@CEODBDrsNett CEO DB Drs Nett : $$NettAmount:$BSDebits:$BSCredits
He has shared the code, now you can do the changes what you want in that file. I think he has developed this thing for his customer and as per requirement of his customer. Now if you want to make some changes in it then you can do it by yourself, he is not suppose to do those changes which are your requirements. Try to do some efforts by yourself. Everything should not be readymade for you as per your requirements. This forum is for sharing knowledge not for getting ready code.
[Report:XXXXXX Dash Board] Object: Company Form: ODBReport Variable : SVFromDate,SVToDate Set : SVFromDate : $$MonthStart:##SVFromdate Set : SVToDate : $$YearEnd:##SVFromdate [Form:ODBReport] Top Part: ODBTitle, ODBTopPart Space Top : If $$InPrintMode Then 0.5 Else 0 inches Space Left: If $$InPrintMode Then 0.5 Else 0 inches Space Right: If $$InPrintMode Then 0.5 Else 0 inches Button : Print Button,Export Button,F2 Change Period Part: ODBBodyPart,ODBBottomPart1,ODBBottomPart Width : 100% Screen Height:90% Screen Background : @@SV_UNYELLOW
Very Good Work Knsivam. Just one Advice finishing or touch up is needed in the Outstanding Recievebales & Payables. It is not accurate. Try at you end if you don't get it. Then surely i will tell you. Once again Keep It Up.
Bro here is the print and export button......... [#Keyrint Button] Key : Alt+P Type: PrintButton Title : $$LocaleString:"Print" Inactive: No Action: Print:XXXXXX Dash Board [#Key: ExportButton] Key : Alt+E Title : $$LocaleString:"Export" Type : ExportButton Action : Export :XXXXXX Dash Board
Dear Experts, What i am trying to do is in Top 5 Item I should also get Alias Name, but unable to do so. Can anybody help? Marked in red are changes made. [Collection: TopItemDefault] Type: Vouchers : VoucherType Child of: $$VchTypeSales Belongs to: Yes Fetch: StockItemName,PartyLedgerName,BilledQty,Rate,Amount,InventoryEntries.ItmAliasName [Collection:TopItems] Source Collection : TopItemDefault Walk : Inventory Entries By : IName: $StockItemName Aggr Compute : BilledQty: SUM : $BilledQty Sort : Default: $BilledQty [#Object: Inventory Entry] ItmAliasName : $OnlyAlias:StockItem:$StockItemName [Line:TopItems] Fields: ODBMedium Prompt;TopItemName Right Fields: ODBQty Field Empty: If $$Line>5 Then Yes Else No Space Bottom: 1 mm Local: Field: ODBQty Field: Set as: $BilledQty Local: Field: ODBMedium Prompt: Set as: $IName + " " + $ItmAliasName
Opening & Closing Stock Report in DashBoard...... [Partummy1] Use: ODBDefault Part Line: ODBSTitle,ODBOpening,ODBClosing Width: 18% Screen [Line:ODBSTitle] Field: ODBTitle Field Local: Field: ODBTitle Field: Set as: "Stock" [Line:ODBOpening] Field: ODBMedium Prompt,ODBAmount Field Local: Field: Default : Full Width: Yes Local: Field: ODBMedium Prompt: Set as: "Opening Value" Local: Field: ODBAmount Field: Set as: @@STKIOpValueTot Local: Field: ODBAmount Field: Format: "DrCr" [Line:ODBClosing] Field :ODBMedium Prompt, ODBAmount Field Local :Field : Default :Full Width :Yes Local: Field: ODBMedium Prompt: Set as: "Closing Value" Local: Field: ODBAmount Field: Set as: @@STKIClValueTot Local: Field: ODBAmount Field: Format: "DrCr" [System:Formula] STKIOpValueTot :$OpeningBalance:Group:$$GroupStock STKIClValueTot :$ClosingBalance:Group:$$GroupStock
Dear Joharfchhil, Kindly try below code [#Object: Inventory Entry] ItmAliasName : $OnlyAlias:StockItem:$StockItemName [#Object:Inventory Entry] ItemAliasName : $_Name1:StockItem:$StockItemName This will return you alias name of stock item. I have given sample, now you have to make change in your code accordingly where you have red marked your code.
[#Object: Inventory Entry] ItmAliasName : $$AliasName Set As : $ItmAliasName :StockItem:$StockItemName