Axapta

To find mainaccountId,mainaccount name,dimensions separately to display in ssrs report based on custinvoicejournal voucher: [SRSReportParameterAttribute(classStr(FCC_SalesInvoiceVoucherContract))] public class FCC_SalesInvoiceVoucherReportDP extends SrsReportDataProviderPreProcessTempDB {     FCC_SalesInvoiceVoucherTmp               salesInvoiceVoucherTmp;     FCC_SalesInvoiceVoucherLineTmp       salesInvoiceVoucherLineTmp;     GeneralJournalAccountEntry           generalJournalAccountEntry,generalJournalAccountEntryLoc;     CustInvoiceJour                                        custInvoiceJour;     SalesLine               ...

In CustAgingReport- Need to add new contact number field and showing in output CustTable tmpCustTable; INSERT_RECORDSET custAgingReportTmp (AccountNum, Name, CustAccount, Txt, Currency, CustGroup, BillingClassification, Balance, SortOrder, SalesGroup, CreditMax, CreditMaxCust, SegmentId, PaymTermId,  ContactNo )  SELECT AccountNum, Name, AccountNum, Txt, CurrencyCode, GroupId, BillingClassification, balance FROM tmpAccountSum JOIN SortOrder FROM custVendTransAging WHERE tmpAccountSum.AccountNum == custVendTransAging.AccountNum JOIN SalesGroup, CreditMax, CreditMaxCust, SegmentId, PaymTermId FROM tmpCustTable WHERE tmpCustTable.AccountNum == tmpAccountSum.AccountNum join dirPartyTable where tmpCustTable.Party == dirPartyTable.RecId join  Locator from logisticsElectronicAddress where logisticsElectronicAddress.RecId == dirPartyTable.PrimaryContactPhone;

How to write an Excel file through X++ code In This Post you will found two code sample 1.Write data in excel through X++ code. 2. Read from an Excel through X++ code 1.Write data in excel through X++ code. static void thaAxapta_Write2Excel(Args _args) { InventTable inventTable; SysExcelApplication application;  SysExcelWorkbooks workbooks; SysExcelWorkbook workbook; SysExcelWorksheets worksheets; SysExcelWorksheet worksheet; SysExcelCells cells; SysExcelCell cell; int row; ; application = SysExcelApplication::construct(); workbooks = application.workbooks(); workbook = workbooks.add(); worksheets = workbook.worksheets(); worksheet = worksheets.itemFromNum(1); cells = worksheet.cells(); cells.range('A:A').numberFormat('@'); cell = cells.item(1,1); cell.value("Item"); cell = cells.item(1,2); cell.value("Name"); row = 1; while select inventTable {     row++;     cell = cells.item(row, 1);     cell.value(inventTable.ItemId);   ...