Code: [Report: SmReport] Use : DSP Template Form : PQRReport Title : "Quotation Report" Set : SVFromDate : $$MonthStart:##SVCurrentDate Set : SVToDate : $$MonthEnd:##SVCurrentDate Variable : vSalesManName : String Variables : ExplodeFlag, IsForexReport Variable : DSPShowMonthly, DSPHasMultiLevel Variable : IsMultiPage, InNewPages, ShowBillType, IsGrpBillReport Set : vSalesManName : "" [Form: PQRReport] Use : DSP Template Parts : PQRReport Height : 100% screen Width : 100% screen Delete : Buttons: ExplodeFlag Background: @@SV_RELEASEDLEAFGREEN_PL; Very Light Sea Green Bottom Toolbar Buttons : BottomToolBarBtn1, BottomToolBarBtn6, BottomToolBarBtn7, BottomToolBarBtn8, BottomToolBarBtn9, BottomToolBarBtn10, BottomToolBarBtn11, BottomToolBarBtn12, Add: Button: Salesmanfilter [Part: PQRReport] Lines:PQRTitile,PQRBody BottomLines : PQRBody Total Repeat : PQRBody :pQRSalesManVouchersColl CommonBorder: Yes Scroll : Vertical Total :PQRPartyAmount [Line: PQRTitile] Use:PQRBody Local : Field : Default : Type : String Local : Field : Default : Style : Tiny Bold Local : Field : Default : Align : Centre Local : Field : Default : set as : $$LocaleString:"S.No." Local : Field : PQRPartyDate : Set as: $$LocaleString:"Date" Local : Field : PQRPartyVchNo : Set as: $$LocaleString:"Quot No." Local : Field : PQRPartyName : Set as: $$LocaleString:"Party Name" Local : Field : PQRPartySalesMan: Set as: $$LocaleString:"Contact Name" Local : Field : PQRPartySalesMan : Align : Left Local : Field : PQRPartyVchType : Set as: $$LocaleString:"Vch Type" Local : Field : PQRPartyAmount : Set as: $$LocaleString:"Amount" Border : Flush Totals [Line: PQRBody] Field:PQRSno, PQRPartyDate,PQRPartyVchNo,PQRPartyName,PQRPartySalesMan,PQRPartyVchType,DSP VchMasterIDNo RightField:PQRPartyAmount Border :Thin Bottom Option : AlterVchOnEnter : Yes Explode : MyExplodPart : ($$KeyExplode OR ##ExplodeFlag) [Part : MyExplodPart] Lines : JlLedger Bills Title, JlLedger Bills,ZJlEmptyLine Repeat : JlLedger Bills : Inventory Entries Scroll : Vertical Vertical : Yes Bottom Line : JLedgerTotals Totals : JLQTY, JLAmount [Line : JLedgerTotals] Border : Column Titles LeftFields : JLITEMTitle, JLQTYTitle, JLRATETitle, JLAmountTitle Local : Field : JLITEMTitle : Info : "GRAND TOTAL" Local : Field : JLITEMTitle : Align : Right Local : Field : Default : BackGround : Yellow Local : Field : JLQTYTitle : Set As : $$Total:JLQTY Local : Field : JLAmountTitle : Set As : $$Total:JLAmount Local : Field : JLAmountTitle : Align : Right [Line : ZJlEmptyLine] Fields : Info Field Local : Field : Info Field : Info : "" [Line : JlLedger Bills Title] Line : JlLedger Bills Title1 [Line : JlLedger Bills Title1] Border : Column Titles LeftFields : JLITEMTitle, JLQTYTitle, JLRATETitle, JLAmountTitle Local : Field : Default : BackGround :Green Local : Field : JLITEMTitle : Info : "JOB NAME"+$$NewLine Local : Field : JLITEMTitle: Line : 0 Local : Field : JLQTYTitle : Info : "QTY"+$$NewLine Local : Field : JLQTYTitle: Line : 0 Local : Field : JLRATETitle : Info : "RATE"+$$NewLine Local : Field : JLRATETitle: Line : 0 Local : Field : JLAmountTitle : Info : "AMOUNT"+$$NewLine Local : Field : JLAmountTitle: Line : 0 [Field : JLITEMTitle] Use: Short Name Field Set as: "" Style: Small bold Width : 75% Screen Align: Left fixed : yes [Field : JLQTYTitle] Use: Short Name Field Set as: "" Style: Small bold Width : 10% Screen Align: Centre fixed : yes [Field : JLRATETitle] Use: Short Name Field Set as: "" Style: Small bold Width : 5% Screen Align: Centre fixed : yes [Field : JLAmountTitle] Use: Short Name Field Set as: "" Style: Small bold Width : 10% Screen Align: Centre fixed : yes [Line : JlLedger Bills] LeftFields: JLITEM, JLQTY, JLRATE, JLAmount Explode : DESCExplod [Part : DESCExplod] Lines : JLDescription Repeat : JLDescription : MyUdfs [Line : JLDescription] Field : JLDescription,JLSUBQTY,JLSUBRATE,JLSUBAMT [Field : JLDescription] Use: Name Field Set as: $UserDescription Color :Red [Field : JLSUBQTY] Use: Name Field Set as: $JAPDesc Color :Red [Field : JLSUBRATE] Use: Name Field Set as: $JJAPDesc1 Color :Red [Field : JLSUBAMT] Use: Name Field Set as: $JAPDesc2 Color :Red [Field : JLITEM] Use: Short Name Field Set as: $StockItemName Style: Small Width : 75% Screen Align: Left Border: Thin Left Right Color : Blue fixed : yes [Field : JLQTY] Use : Number Field Set as:$BilledQty Style: Small Width : 10% Screen Format : "NoSymbol" Border: Thin Left Right Align: Centre Color : Blue fixed : yes [Field : JLRATE] Use : Rate Price Field Set as: $Rate Style: Small Width : 5% Screen Align: Centre Border: Thin Left Right Color : Blue fixed : yes [Field : JLAmount] Use : AmountField Set as:$Amount Style: Small Width : 10% Screen Align: Right Color : Blue fixed : yes [Field:PQRSno] Set as : $$Line Width : 1.5 cm Align : Center [Field: PQRPartyDate] Set as : $Date Width : 10% Screen Align : Left ;Style : Tiny [Field: PQRPartyVchNo] Set as : $VoucherNumber Width : 10% Screen Align : Center ;Style : Tiny [Field: PQRPartyName] Use : Name Field Set as : $PartyLedgerName Width : 20% Screen Align : Centre ;Style : Tiny [Field: PQRPartySalesMan] Use :Name Field Set as : $$String:$MMSalesmanName Width : 40% Screen Align : Left ;Style : Tiny ;Key : Create SalesmanName [Field: PQRPartyVchType] Set as : $VoucherTypeName Width : 5% Screen Align : Centre ;Style : Tiny [Field: PQRPartyAmount] Use : Amount Forex Field Set as : $Amount Width : 10% Screen Align : Right ;Style : Tiny Format : "No Zero,DrCr,Symbol," + ##ShowForex [Line: PQRBody Total] Use:PQRBody Local : Field : Default : Type : String Local : Field : Default : Style : Tiny Bold Local : Field : Default : Align : Centre Local : Field : PQRSno : Set as: "" Local : Field : PQRPartyDate : Set as: "" Local : Field : PQRPartyVchNo : Set as: "" Local : Field : PQRPartyName : Set as: "TOTAL" Local : Field : PQRPartyName : Align : Centre Local : Field : PQRPartySalesMan: Set as: "" Local : Field : PQRPartyVchType : Set as: "" Local : Field : PQRPartyAmount : Set as: $$Total:PQRPartyAmount Border : Flush Totals ;============================== Filter =================================== [Button:SalesmanFilter] Key : Alt+S Action : Alter: SalesmanFilter Title : Contact Name [Report:SalesmanFilter] Form : SalesmanFilter [Form:SalesmanFilter] Part : SalesmanFilter No Confirmation : Yes [Part:SalesmanFilter] Line : SalesmanFilter [Line:SalesmanFilter] Field : Medium Prompt,SalesmanFilter Option : alter on enter Local : Field : Medium Prompt : Set as : "Select Contact Name: " [Field:SalesmanFilter] Table : ContactNameCollection,EndOfList ShowTable : Always Use : Name Field Width : 20 Border : Thin Box Variable : vSalesManName Modifies : vSalesManName ; Variable : PQRPartySalesman ; Modifies : PQRPartySalesman ;[Collection: ContactNameCollection] ; ListName : "" ;===================================== Collections =================================== [Collection: PQRSalesManVouchersColl] Type : Voucher Fetch : Date, VoucherNumber, VoucherTypeName,LedgerName,PartyLedgerName,MMSalesmanName, LedgerEntries.*,InventoryEntries.*,InventoryEntries.MyUdfs.* Filter : PQRSaleManVouchers , SalesManFilter [System:UDF] EnableSalesman : Logical : 1000 Commission : Number : 1001 [Variable:vSalesManName] Type : String ;[Variable:SalesManChqVar] ;Type : String [System:Variable] vSalesManName : "" ;SalesManChqVar : "" [System: Formula] PQRSaleManVouchers: $$IsSales:$VoucherTypeName OR $$IsCreditNote:$VoucherTypeName SalesManFilter : $MMSalesmanName = ##vSalesManName Or $$IsSysName:##vSalesManName
