Eclipse BIRT Designer Version 2.6.0.v20100531 Build <2.6.0.v20100609-1613> in /templates/blank_report.gif ltr static string true simple text-box Unformatted static string true simple text-box Unformatted 0 glFiscalTypeId string 1 acctgTransTypeId string 2 transactionDate date-time 3 postedDate date-time 4 transDescription string 5 glJournalId string 6 invoiceId string 7 paymentId string 8 glAccountId string 9 debitCreditFlag string 10 amount decimal 11 currencyUomId string 12 origAmount decimal 13 origCurrencyUomId string 14 glAccountTypeId string 15 accountCode string 16 accountName string 17 glAccountClassId string glFiscalTypeId glFiscalTypeId acctgTransTypeId acctgTransTypeId transactionDate transactionDate postedDate postedDate transDescription transDescription glJournalId glJournalId invoiceId invoiceId paymentId paymentId glAccountId glAccountId debitCreditFlag debitCreditFlag amount amount currencyUomId currencyUomId origAmount origAmount origCurrencyUomId origCurrencyUomId glAccountTypeId glAccountTypeId accountCode accountCode accountName accountName glAccountClassId glAccountClassId 1 glFiscalTypeId string 2 acctgTransTypeId string 3 transactionDate date-time 4 postedDate date-time 5 transDescription string 6 glJournalId string 7 invoiceId string 8 paymentId string 9 glAccountId string 10 debitCreditFlag string 11 amount decimal 12 currencyUomId string 13 origAmount decimal 14 origCurrencyUomId string 15 glAccountTypeId string 16 accountCode string 17 accountName string 18 glAccountClassId string OFBiz = totalRow) return false; var acctgTransAndEntry = acctgTransAndEntries.get(countOfRow); row["glFiscalTypeId"] = acctgTransAndEntry.get("glFiscalTypeId"); row["acctgTransTypeId"] = acctgTransAndEntry.get("acctgTransTypeId"); row["transactionDate"] = acctgTransAndEntry.get("transactionDate"); row["postedDate"] = acctgTransAndEntry.get("postedDate"); row["transDescription"] = acctgTransAndEntry.get("transDescription"); row["glJournalId"] = acctgTransAndEntry.get("glJournalId"); row["invoiceId"] = acctgTransAndEntry.get("invoiceId"); row["paymentId"] = acctgTransAndEntry.get("paymentId"); row["glAccountId"] = acctgTransAndEntry.get("glAccountId"); row["debitCreditFlag"] = acctgTransAndEntry.get("debitCreditFlag"); row["amount"] = acctgTransAndEntry.get("amount"); row["currencyUomId"] = acctgTransAndEntry.get("currencyUomId"); row["origAmount"] = acctgTransAndEntry.get("origAmount"); row["origCurrencyUomId"] = acctgTransAndEntry.get("origCurrencyUomId"); row["glAccountTypeId"] = acctgTransAndEntry.get("glAccountTypeId"); row["accountCode"] = acctgTransAndEntry.get("accountCode"); row["accountName"] = acctgTransAndEntry.get("accountName"); row["glAccountClassId"] = acctgTransAndEntry.get("glAccountClassId"); countOfRow ++; return true;]]> 1 invoiceId string 2 description string 3 invoiceTypeDescription string 4 statusDescription string 5 invoiceDate date-time 6 partyId string 7 partyName string invoiceId invoiceId description description invoiceTypeDescription invoiceTypeDescription statusDescription statusDescription invoiceDate invoiceDate partyId partyId partyName partyName 1 invoiceId string 2 description string 3 invoiceTypeDescription string 4 statusDescription string 5 invoiceDate date-time 6 partyId string 7 partyName string OFBiz = 1) return false; row["invoiceId"] = invoice.get("invoiceId"); row["description"] = invoice.get("description"); row["invoiceTypeDescription"] = invoice.getRelatedOne("InvoiceType", false).get("description"); row["statusDescription"] = invoice.getRelatedOne("StatusItem", false).get("description"); row["invoiceDate"] = invoice.get("invoiceDate"); var partyId = null; if ("PURCHASE_INVOICE".equals(invoice.get("invoiceTypeId")) || "PURCHASE_INVOICE".equals(invoice.getRelatedOne("InvoiceType", false).get("parentTypeId"))) { partyId = invoice.get("partyIdFrom"); } else { partyId = invoice.get("partyId"); } var partyName = ""; partyNameView = delegator.findOne("PartyNameView", UtilMisc.toMap("partyId", partyId), false); if (partyNameView.get("firstName")) { partyName += partyNameView.get("firstName") + " "; } if (partyNameView.get("lastName")) { partyName += partyNameView.get("lastName") + " "; } if (partyNameView.get("groupName")) { partyName += partyNameView.get("groupName") + " "; } row["partyId"] = partyId; row["partyName"] = partyName; countOfRow ++; return true;]]> landscape 2.7in 10.363636363636363in 1.494949494949495in bold right 3.696969696969697in 2.585858585858586in 10pt bold right 2.585858585858586in 2 1 left url false bold right Username: if (userLogin != null ) {userLoginNameView.getString("firstName") + "&nbsp;&nbsp;&nbsp;&nbsp;" + userLoginNameView.getString("lastName")} html bold right Invoice ID: Invoice invoiceId invoiceId dataSetRow["invoiceId"] string invoiceId bold right Date: Invoice invoiceDate invoiceDate dataSetRow["invoiceDate"] date-time invoiceDate bold right Description: Invoice description description dataSetRow["description"] string description bold right Party ID: Invoice partyId partyId dataSetRow["partyId"] string partyId bold right Status: Invoice statusDescription statusDescription dataSetRow["statusDescription"] string statusDescription bold right Party Name: Invoice partyName partyName dataSetRow["partyName"] string partyName bold right Reference Number: 4 1 16pt bold center nowrap Invoice invoiceTypeDescription invoiceTypeDescription dataSetRow["invoiceTypeDescription"] string invoiceTypeDescription 0.4583333333333333in 10.354166666666666in 4.041666666666667in 0.71875in 0.3541666666666667in 0.6875in 4.552083333333333in 0.4583333333333333in right page-number center plain right left total-page right #000000solidthin#000000solidthin#000000solidthin#000000solidthin10.505050505050505inAcctgTransAndEntries glFiscalTypeId dataSetRow["glFiscalTypeId"] string acctgTransTypeId dataSetRow["acctgTransTypeId"] string transactionDate dataSetRow["transactionDate"] date-time postedDate dataSetRow["postedDate"] date-time transDescription dataSetRow["transDescription"] string glJournalId dataSetRow["glJournalId"] string invoiceId dataSetRow["invoiceId"] string paymentId dataSetRow["paymentId"] string glAccountId dataSetRow["glAccountId"] string debitCreditFlag dataSetRow["debitCreditFlag"] string amount dataSetRow["amount"] decimal currencyUomId dataSetRow["currencyUomId"] string origAmount dataSetRow["origAmount"] decimal origCurrencyUomId dataSetRow["origCurrencyUomId"] string glAccountTypeId dataSetRow["glAccountTypeId"] string accountCode dataSetRow["accountCode"] string accountName dataSetRow["accountName"] string glAccountClassId dataSetRow["glAccountClassId"] string 1.4895833333333333in 4.090909090909091in 1.3232323232323233in center 1.3232323232323233in center 1.1111111111111112in center 1.1515151515151516in center

#BFBFBF bold #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin center #000000 solid thin #000000 solid thin Account Code #000000 solid thin #000000 solid thin Account Name #000000 solid thin #000000 solid thin Original Currency #000000 solid thin #000000 solid thin Exchange Rate #000000 solid thin #000000 solid thin Debit #000000 solid thin #000000 solid thin Credit

#000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin accountCode #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin accountName #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin origCurrencyUomId #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin cursive all row["origCurrencyUomId"].equals(row["currencyUomId"]) #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Currency #,##0.00{RoundingMode=HALF_UP} #000000 solid thin #000000 solid thin #000000 solid thin #000000 solid thin Currency #,##0.00{RoundingMode=HALF_UP} 9.727272727272727in 1.2323232323232323in 1.4747474747474747in 1.7777777777777777in 1.5555555555555556in 1.9191919191919191in 1.7676767676767677in 0.5in right auto 0.5in center auto 0.5in right auto 0.5in center auto 0.5in right auto 0.5in center auto 0.5in right auto 0.5in center auto 0.5in right auto 0.5in center auto 0.5in right auto 0.5in center auto