Dear Sir's, Kindly help me on below code : how to get total of highlight field with sub total & total.
Dear Sir, it changes USD RATE field by default with 50000 which i don't required, also total and sub total is not coming. as i required sub total & total of USD column field.
add ur 2 fields in part: bill subtotal also why and what u cannot understand........... i assume you have made this code yourself?? Same way u added in previous parts....add it here too.
[#Line: VCHBILL MainLine] Fields : VCHBILLType, OldBillName, SVForceDebit, VCHBILLName, VCHBILLDate, VCHBILLExpiry Add: Field: test [Field : Test] ;Set as: "" Use: Number Field Storage: myamt [System: UDF] myamt : Number: 50000 [#Line: BILLCol1] Local : Field : pendingcheck : Set as: "USD" Local : Field : pendingcheck : Width: 8 Local : Field : pendingAMT : Set as: "USD" Local : Field : pendingAMT : Width: 10 [#Line: BILLCol2] Local : Field : pendingcheck : Set as: "Rate" Local : Field : pendingAMT : Set as: " " [#Line: BILLWithDates] Right Fields : BillDue, BILLOverdue, PENDINGCHECK,pendingamt [Field: PENDINGCHECK] Set as: $myamt Width: 8 Type: Number Align: Right Border: thin right [Field: pendingamt] Use : AmountField Type : Amount Set as#BillCL/#PENDINGCHECK) Width: 10 Align: Right ;Format : "DrCr,NoZero," [#Line: BILL Total] Local : Field : pendingamt : Set as :$$Totalendingamt Local : Field : pendingcheck : Set as :$$Totalendingcheck [#Part: BILL Body] Lines : BILL Column, BILL Detail BottomLines : BILL Total Scrolled : Vertical Total : BILLCl, BILLInterest, BILLPDC, BILLFinal, BILLOp, BILLForex,pendingamt [#Part: BILL SubTotal] Local : Line : BILLSubTotal : Replace : Field : Pendingamt : Subpendingamt [Field: Subpendingamt] Use : pendingamt Set as : $$SubTotalendingamt Style : Normal Italic Border : FullThinTop
Maybe you should read once again and very carefully what I instructed...... I said ADD..... never said replace..... and how can you replace a field when it is not there in the first place
very good....same way you can have it ready for group-wise also....... just like LEDBILL Body.....find the Group body and just add your field.