Thursday, December 18, 2014

Ax 2012 Database Entity Relationship Diagrams

The "AxErd" website hosts entity relationship (ER) diagrams for core tables of the application modules in Microsoft Dynamics AX 2012 R2. You can use the site to quickly list all the foreign key relationships for a table, involving both its child and parent tables. You can also use the site to determine which module a table is in, and which tables are in a module.
http://www.microsoft.com/dynamics/ax/erd/ax2012r2/

Example:
ERD: Accounts receivable, M2 CustTrans

http://www.microsoft.com/dynamics/ax/erd/ax2012r2/Erd-One-AcctRecv-M2-CustTrans-vsd.png

Ax 2012 SSRS List of Reporting Projects


Report name
Project name
AccountantInvestmentAnalysis
AccountantInvestmentAnalysis
AccountantLongTermSolvency
AccountantLongTermSolvency
AccountantOperationalEfficiency
AccountantOperationalEfficiency
AccountantProfitabilityAnalysis
AccountantProfitabilityAnalysis
AccountantShortTermSolvency
AccountantShortTermSolvency
AccountingManagerInvestmentAnalysis
AccountingManagerInvestmentAnalysis
AccountingManagerLongTermSolvency
AccountingManagerLongTermSolvency
AccountingManagerOperationalEfficiency
AccountingManagerOperationalEfficiency
AccountingManagerProfitabilityAnalysis
AccountingManagerProfitabilityAnalysis
AccountingManagerShortTermSolvency
AccountingManagerShortTermSolvency
AgreementConfirmation
AgreementConfirmationReport
AgreementFollowUp
AgreementFollowUpReport
AssetAcquisition
AssetAcquisitionReport
AssetAddition
AssetAdditionReport
AssetBalanceReportColumns
AssetBalanceReportColumnsReport
AssetBalancesPeriod
AssetBalancesPeriodReport
AssetBalances
AssetBalancesReport
AssetBarcode
AssetBarcodeReport
AssetBasis
AssetBasisReport
AssetBookCompare
AssetBookCompareReport
AssetConsumptionProposal
AssetConsumptionProposalReport
AssetDepBookMassUpdate
AssetDepBookMassUpdateReport
AssetDepreciationLedger_IT
AssetDepreciationLedger_IT
AssetDisposal
AssetDisposalReport
AssetDueReplacement
AssetDueReplacement
AssetFutureValue
AssetFutureValueReport
AssetInsurance
AssetInsuranceReport
AssetInventoryWorkSheet
AssetInventoryWorkSheet
AssetLendingHistory
AssetLendingHistoryReport
AssetLending
AssetLendingReport
AssetListing
AssetListingReport
AssetMidQuarter
AssetMidQuarterReport
AssetOverviewBE
AssetOverviewBE
AssetReplacementReport
AssetReplacement
AssetReserveTransactions
AssetReserveTransactionsReport
AssetsInAssetStatement
AssetsInAssetStatementReport
AssetStatementLowValuePool_AU
AssetStatementLowValuePool_AUReport
AssetStatement
AssetStatementReport
AssetStatementRowSetup
AssetStatementRowSetupReport
AssetTaxStatistic
AssetTaxStatisticReport
AssetTransactionListing
AssetTransactionListingReport
BankAccountBalance
BankAccountBalance
BankAccountReconciliation
BankAccountReconciliationReport
BankAccountStatement
BankAccountStatementReport
BankBillOfExchange_FR
BankBillOfExchange_FRReport
BankBillOfExchange
BankBillOfExchangeReport
BankCashflowReport
BankCashflowReport
BankChequeStatisticsReport
BankChequeStatistics
BankCodaDetails
BankCodaDetailsReport
BankDepositbyCustomer
BankDepositbyCustomerReport
BankDepositByDate
BankDepositByDateReport
BankDepositSlip
BankDepositSlipReport
BankDocumentFacility
BankDocumentFacilityReport
BankLCExportDetails
BankLCExportDetailsReport
BankLCImportApplication
BankLCImportApplicationReport
BankLCMiscChargeReport_SA
BankLCMiscChargeReport_SA
BankLedgerReconciliation
BankledgerReconciliationReport
BankLGApplication
BankLGApplicationReport
BankLGExpiryDate
BankLGExpiryDateReport
BankPaymAdviceCheque
BankPaymAdviceChequeReport
BankPaymAdviceCust
BankPaymAdviceCustReport
BankPaymAdviceVend
BankPaymAdviceVendReport
BankPaymentByDate
BankPaymentByDateReport
BankPaymentbyVendor
BankPaymentbyVendorReport
BankPaymIdTypesSetup_NO
BankPaymIdTypesSetup_NOReport
BankPromissoryNote_ES
BankPromissoryNote_ESReport
BankPromissoryNote_FR
BankPromissoryNote_FRReport
BankReconciliation
BankReconciliationReport
BankReconciliationSummary
BankReconSummaryReport
BankStatementImportValidation
BankStmtImportValidation
BlackList
BlackListReport
BOMCalcTrans
BOMCalcTransReport
BOMConsistOf
BOMConsistOfReport
BOMPartOf
BomPartOfReport
BudgetBalancesActuals
Budget
BudgetBalancesActualsChart
BudgetBalancesActualsChartReport
BudgetDetails
BudgetDetailReport
BudgetFundsAvailable
BudgetFundsAvailableReport
Case_MyCases
CaseReports
CFOInvestmentAnalysis
CFOInvestmentAnalysis
CFOLongTermSolvency
CFOLongTermSolvency
CFOOperationalEfficiency
CFOOperationalEfficiency
CFOProfitabilityAnalysis
CFOProfitabilityAnalysis
CFOShortTermSolvency
CFOShortTermSolvency
Cheque_CA
Cheque_CAReport
Cheque_DE
Cheque_DEReport
Cheque_DK
Cheque_DKReport
Cheque_ES
Cheque_ESReport
Cheque_FR
Cheque_FRReport
Cheque_UK
Cheque_UKReport
Cheque_US
Cheque_USReport
CommissionTrans
CommissionTransReport
ControllerInvestmentAnalysis
ControllerInvestmentAnalysis
ControllerLongTermSolvency
ControllerLongTermSolvency
ControllerOperationalEfficiency
ControllerOperationalEfficiency
ControllerProfitabilityAnalysis
ControllerProfitabilityAnalysis
ControllerShortTermSolvency
ControllerShortTermSolvency
ConvInventPriceIsZero
ConvInventPriceIsZeroReport
COSCalculation
COSCalculationReport
COSCostRatesPrint
COSCostRatesPrintReport
COSDiffAccount
COSDiffAccountReport
COSDiffLedger
COSDiffLedgerReport
COSDiffProd
COSDiffProdReport
COSJournalReport
COSJournalReport
COSReportPrint
COSReportPrintReport
COSTransPreview
COSTransPreviewReport
COSTrans
COSTransReport
CreditAndCollectionOperationalEfficiency
CreditAndCollectionOperationalEfficiency
CustBasedata
CRMReports
CustListReport
CRMReports
smmActivityAnalyses
CRMReports
smmCampaignResponseFrequency
CRMReports
smmCustRevenue
CRMReports
smmPhoneAverage
CRMReports
smmPhoneCalls
CRMReports
smmProspectsTurnover
CRMReports
smmSalesCustItemStatistics
CRMReports
smmSalesRanking
CRMReports
smmSalesTarget
CRMReports
smmTMCallListTelemarketingSummary
CRMReports
CustAccountStatement_FR
CustAccountStatement_FR
CustAccountStatementExt
CustAccountStatementExtReport
CustAccountStatementInt
CustAccountStatementIntReport
CustAgingReport
CustAgingReport
CustAuditor
CustAuditorReport
CustBalanceList_MY
CustBalanceList_MY
CustBalanceList
CustBalanceListReport
CustBillOfExchangeOpenTrans_ES
CustBillOfExchangeOpenTrans_ESReport
CustBillOfExchangeReport
CustBillOfExchangeReport
CustBillOpenTrans_FR
CustBillOpenTrans_FRReport
CustCashRcptJrnlTotalsTrxCount
CustCashRcptJrnlTotalsTrxCount
CustCheckSettlement
CustCheckSettlementReport
CustCOD
CustCODReport
CustCollectionJour
CustCollectionJourReport
CustCollectionLetterOverview
CustCollectionLetterOverviewReport
CustDomStatement_BE
CustDomStatement_BEReport
CustDueReportDetail
CustDueReportDetailReport
CustExchRateAdjSimulation
CustExchRateAdjSimulationReport
CustExchRateAdjustment
CustExchRateAdjustmentReport
CustExpectedCashNextXDays
CustExpectedCashNextXDays
CustGrossMarginbyAccount_NA
CustGrossMarginbyAccount_NAReport
CustGrossMarginbyItem_NA
CustGrossMarginbyItem_NAReport
CustInPaymentCH
CustInPaymentCHReport
CustInPaymNO
CustInPaymNOReport
CustInPaymSE
CustInPaymSEReport
CustInterestNote
CustInterestNote
CustInvoiceJour
CustInvoiceJourReport
CustInvoice
CustInvoiceReport
CustInvoiceSettled_TransDate_ES
CustInvoiceSettled_TransDate_ESReport
CustInvoiceSpec
CustInvoiceSpecReport
CustInvoiceVolume_BE
CustInvoiceVolume_BEReport
CustInvoiceVolume
CustInvoiceVolumeReport
CustLedgerReconciliation
CustLedgerReconciliationReport
CustLedgerTrans
CustLedgerTransReport
CustOpenBillId_ES
CustOpenBillId_ESReport
CustOutAttendingNoteAT_EDIFACT
CustOutAttendingNoteAT_EDIFACTReport
CustOutAttendingNoteDE_DTAUS
CustOutAttendingNoteDE_DTAUSReport
CustOutAttendingNote_BillRemittance
CustOutAttendNote_BillRemittanceReport
CustOutCoveringLetterDE_DTAUS
CustOutCoveringLetterDE_DTAUSReport
CustOutPaymAdviceAT_EDIFACT
CustOutPaymAdviceAT_EDIFACTReport
CustOutPaymAdviceCH_DebitDirect
CustOutPaymAdviceCH_DebitDirectReport
CustOutPaymAdviceCH_LSV
CustOutPaymAdviceCH_LSVReport
CustOutPaymOrderCH_DebitDirect
CustOutPaymOrderCH_DebitDirectReport
CustOutPaymOrderCH_LSV
CustOutPaymOrderCH_LSVReport
CustOutPaymControl
CustOutPaymReports
CustOutPaymControl_ES
CustOutPaymReports
CustOutPaymControl_FR
CustOutPaymReports
CustOutPaymControl_FR_LCR
CustOutPaymReports
CustOutPaymControl_IT
CustOutPaymReports
CustOutPaymLetter_FR
CustOutPaymReports
CustPaymentJournal_NA
CustPaymentJournal_NAReport
CustPaymManFeeHist
CustPaymManFeeHistReport
CustPaymManOutputReport
CustPaymManOutputReport
CustPaymManStepPosting
CustPaymManStepPostReport
CustPaymManUnpaid
CustPaymManUnpaidReport
CustPaymReconciliationPrint_DK_BS
CustPaymReconciliationPrint_DK_BS
CustPostedCustInvoiceTotalandTrxCnt
CustPostedCustInvoiceTotalandTrxCnt
CustPostPaymJournal_NA
CustPostPaymJournal
CustProvisionalBalance
CustProvisionalBalanceReport
CustReimbursement
CustReimbursementReport
CustSalesAnalysisByInvoice_NA
CustSalesAnalysisByInvoice_NAReport
CustSalesDistribution_NA
CustSalesDistribution
CustSalesItemGroupStatistics_NA
CustSalesItemGroupStatistics_NA
CustSalesOpenLines_NA
CustSalesOpenLines
CustSalesOpenLines_NA
CustSalesOpenLines_NAReport
CustSalesOpenOrders_NA
CustSalesOpenOrders_NAReport
CustSalesPastPeriodChart
CustSalesPastPeriodChart
CustShippedNotInvoiced_NA
CustShippedNotInvoiced_NA
CustTopCustomersbyYTDSales
CustTopCustomersbyYTDSales
CustTransList
CustTransListReport
CustTransOpen_ES
CustTransOpen_ESReport
CustTransOpenPerDate
CustTransOpenPerDateReport
CustVendAgingStaticticsAutoReport
CustVendAgingStaticticsAutoReport
CustVendOutPaymNL
CustVendOutPaymNL_InstructionLetter
CustVendPaymJournal
CustVendPaymJournalReport
CustVendPaymProposal
CustVendPaymProposalReport
CustVendPDCAckIssueReceipt
CustVendPDCAckIssueReceipt
DIOTDeclarationReport_MX
DIOTDeclarationReport_MX
EInvoiceReport_MX
EInvoiceReport_MX
EMSEnergyConsumption
EMSReports
EMSEnergyConsumptionDetail
EMSReports
EMSEnergyCost
EMSReports
EMSEnergyCostGraph
EMSReports
EMSGreenhouseGasEmissions
EMSReports
EMSGreenhouseGasEmissionsByProcess
EMSReports
EMSSubstanceEntry
EMSReports
EPSalesByRegion
EPSalesByRegionReport
EUSalesListReporting
EUSalesListReporting
EventAlertRulesReport
EventAlertRuleReport
AlertsetupReport
EventAlerts
AlerttrackingReport
EventAlerts
ForecastSalesItem
ForecastSalesItemReport
FreeTextInvoice
FreeTextInvoiceReport
Giro
Giro
HcmAbsenceAdministration
HcmAbsenceAdministrationReport
HcmAbsenceJournalMissingReport
HcmAbsenceJournalMissing
HcmAbsenceSetup
HcmAbsenceSetupReport
HcmAbsenceStatus
HcmAbsenceStatusReport
HcmAccommodationList
HcmAccommodationListReport
HcmADARequirement
HcmADARequirementReport
HcmAnniversary
HcmAnniversaryReport
HcmApplicantResume
HcmApplicantResumeReport
HcmApplicantStatus
HcmApplicantStatusReport
HcmBirthday
HcmBirthdayReport
HcmCourseAgenda
HcmCourseAgendaReport
HcmCourseAttendeeCollectionResult
HcmCourseAttendeeCollectionResultReport
HcmCourseAttendeeLine
HcmCourseAttendeeLineReport
HcmCourseAttendeeStatusList
HcmCourseAttendeeStatusListReport
HcmCourseConfirmation
HcmCourseConfirmationReport
HcmCourseDesign
HcmCourseDesignReport
HcmCourseSkills
HcmCourseSkillsReport
HcmCourseTableInstructor
HcmCourseTableInstructorReport
HcmDepartmentReport
HcmDepartments
HcmDueCertificate
HcmDueCertificateReport
HcmEmployeeLeave
HcmEmployeeLeaveReport
HcmEPAbsenceTransListThisYear
HcmEPAbsenceTransListThisYearReport
HcmEPAnniversaries
HcmEPAnniversariesReport
HcmEPAbsenceApproverReport
HcmEPApproverAbsenceAlarmList
HcmEPBirthdays
HcmEPBirthdaysReport
HcmGoalAlarm
HcmGoalAlarmReport
Hcmi9DocumentExpireList
Hcmi9DocumentExpireListReport
Hcmi9DocumentTypeExpireList
Hcmi9DocumentTypeExpireListReport
Hcmi9InspectionList
Hcmi9InspectionListReport
HcmIncidentCost
HcmIncidentCosts
HcmIncidentSummary
HcmIncidentSummary
HcmIncidentTreatment
HcmIncidentTreatments
HcmJobInformation
HcmJobInformationReport
HcmJobTemplateInformation
HcmJobTemplateInformationReport
HcmMassHireProjectReport
HcmMassHireProject
HcmNumberOfWorkersReport
HcmNumberOfWorkers
HcmPeopleDepartmentReport
HcmPeopleDepartment
HcmPositionsByDepartment
HcmPositionsByDepartmentReport
HcmRecruitingApplicationStatus
HcmRecruitingApplicationStatusReport
HcmRecruiting
HcmRecruitingReport
HcmSeniorityReport
HcmSeniority
HcmSkillBySkillTypeCount
HcmSkillBySkillTypeCountReport
HcmSkillBySkillType
HcmSkillBySkillTypeReport
HcmSkillGapJob
HcmSkillGapJobReport
HcmSkillProfile
HcmSkillProfileReport
HcmSkillType
HcmSkillTypeReport
HcmWorkerBenefitsReport
HcmWorkerBenefits
HcmWorkerNtAssignToPos
HcmWorkerNtAssignToPos
HcmWorkerResume
HcmWorkerResumeReport
HcmWorkersHiredInPeriodReport
HcmWorkersHiredInPeriod
HcmWorkerSkill
HcmWorkerSkillReport
IndirectCostOverview
IndirectCostOverviewReport
InfAdjCapital_MX
InfAdjReports_MX
InfAdjInventory_MX
InfAdjReports_MX
InfAdjRepomoPL_MX
InfAdjReports_MX
Simulation_MX
InfAdjSimulationReport_MX
InterCompanyGoodsInTransitTotals
InterCompanyGoodsInTransit
InterCompanyGoodsInTransitTransactions
InterCompanyGoodsInTransit
IntrastatFormLetterAT
IntrastatFormLetterATReport
IntrastatFormLetterDE
IntrastatFormLetterDEReport
IntrastatFormLetterES
IntrastatFormLetterESReport
IntrastatFormLetterFI
IntrastatFormLetterFIReport
IntrastatFormLetterFR
IntrastatFormLetterFRReport
IntrastatFormLetterIT
IntrastatFormLetterITReport
IntrastatFormLetter
IntrastatFormLetterReport
IntrastatFormLetterSE
IntrastatFormLetterSEReport
IntrastatFormLetterUK
IntrastatFormLetterUKReport
IntrastatListES
IntrastatListESReport
IntrastatListFI
IntrastatListFIReport
IntrastatListNL
IntrastatListNLReport
IntrastatList
IntrastatListReport
IntrastatListUK
IntrastatListUKReport
IntrastatPeriodReport_IT
IntrastatPeriodReport_IT
InventABC
InventABCReport
InventAdjOnHand
InventAdjOnHandReport
InventAdjTransaction
InventAdjTransactionReport
InventAgeDim
InventAgeGroupDimReport
InventAgeGroup
InventAgeGroupDimReport
InventCheckReceiptCostPricePcs
InventCheckReceiptCostPricePcsReport
InventCheckSettlement
InventCheckSettlementReport
InventCostValue
InventCostValueReport
InventCostVariances
InventCostVariancesReport
InventCountingList
InventCountingListReport
InventCountStatistics
InventCountStatisticsReport
InventDimPhys
InventDimPhys
InventFiscalLIFOValuation
InventFiscalLIFOValuationReport
InventJournalTrans_Tag
InventJournalTrans_TagReport
InventJournalTrans
InventJournalTransReport
InventJournalTransTransfer
InventJournalTransTransferReport
InventLedgerConflict
InventLedgerConflictReport
InventMovement_TH
InventMovement_THReport
InventNonConformanceTable
InventNonConformanceTableReport
InventNonConformanceTag
InventNonConformanceTagReport
InventOnhand
InventOnhandReport
InventOpenQtyCritical
InventOpenQtyCriticalReport
InventPhysicalPerWarehouseTrans_IT
InventPhysicalPerWarehouseTrans_ITReport
InventPriceOverview
InventPriceOverviewReport
InventProdCom_BE
InventProdCom_BEReport
InventQuarantineOrder
InventQuarantineOrderReport
InventSettlementAdjustment
InventSettlementAdjustmentReport
InventSiteDimensionLinkValidation
InventSiteDimensionLinkValidationReport
InventSpaceUtilizationAisleDetail
InventSpaceUtilization
InventSpaceUtilizationSiteWebpart
InventSpaceUtilization
InventSpaceUtilizationWarehouseDetail
InventSpaceUtilization
InventStdCostConvCheck
InventStdCostConvCheckReport
InventStdCostVariance
InventStdCostVarianceReport
InventSumCritical
InventSumCriticalReport
InventTableOverview
InventTableOverviewReport
InventTablePriceDiscount
InventTablePriceDiscountReport
InventTableQuantity
InventTableQuantityReport
InventTestCertOfAnalysis
InventTestCertOfAnalysisReport
InventTestCorrection
InventTestCorrectionReport
InventTransferOrderOverview
InventTransferOrderOverviewReport
InventTransferReceive
InventTransferReceiveReport
InventTransferShip
InventTransferShipReport
InventValue
InventValueReport
ISRDetailedDeclaration_MX
ISRDetailedDeclaration_MX
ISRProvisionalDeclaration_MX
ISRProvisionalDeclaration_MX
JmgAbsence
JmgAbsenceReport
JmgAbsenceStatistics
JmgAbsenceStatisticsReport
JmgEmployee
JmgEmployeeReport
JmgEmplSignedIn
JmgEmplSignedInReport
JmgFlexBalance
JmgFlexBalanceReport
JmgFlexCheck
JmgFlexCheckReport
JmgIndirectActivity
JmgIndirectActivityReport
JmgIpcBarcode
JmgIpcBarcodeReport
JmgPayAggreement
JmgPayAgreementReport
JmgPaySpec
JmgPaySpecReport
JmgPayStatTrans
JmgPayStatTransReport
JmgPlannedAbsence
JmgPlannedAbsence
JmgProfileDaily
JmgProfilesReport
JmgProfileWeek
JmgProfilesReport
JmgProjBarcode
JmgProjBarcodeReport
JmgActiveJobs
JmgReports
JmgAttendance
JmgReports
JmgWorkerCard
JmgWorkerCardReport
JmgWorkPlanner_Employee
JmgWorkPlannerEmployeeReport
JmgWorkPlanner_Profile
JmgWorkPlannerProfileReport
KanbanPage
KanbanPageReport
KanbanPickList
KanbanPickListReport
KMAnswersByPerson
KMAnswersByPersonReport
KMAnswersByQuestionnaire
KMAnswersByQuestionnaireReport
KMCollectionReport
KMCollection
KMKnowledgeCollector
KMKnowledgeCollectorReport
KMQuestionAnalyze
KMQuestionAnalyzeReport
KMQuestionandAnswer
KMQuestionandAnswerReport
LeanProductionFlowCost
LeanProductionFlowCostReport
LeanProductionFlowVariances
LeanProductionFlowVariancesReport
LedgerAccountSched
LedgerAccountSchedReport
LedgerAccountStatementPerCurrency
LedgerAccountStatementPerCurrencyReport
LedgerAccountSum_FR
LedgerAccountSum_FRReport
LedgerAllocationRules
LedgerAllocationRulesReport
LedgerAuditTrailReport
LedgerAuditTrailReport
LedgerBalanceControl
LedgerBalanceControlReport
LedgerCashInflowvsCashOutflow
LedgerCashInflowvsCashOutflow
LedgerCentralisationJournalReportBE
LedgerCentralisationJournalReportBE
LedgerCheckTrans
LedgerCheckTransReport
LedgerCheckVoucher
LedgerCheckVoucherReport
LedgerClosing
LedgerClosingReport
LedgerEliminationRules
LedgerEliminationRulesReport
LedgerEncumbranceReconciliation
LedgerEncumbranceReconciliation
LedgerFinancialJournalReportBE
LedgerFinancialJournalReportBE
LedgerFiscalJournal_IT
LedgerFiscalJournal_ITReport
LedgerGrossProfitinthePastXPeriods
LedgerGrossProfitinthePastXPeriods
LedgerInAccountStatementDE_DTAUS
LedgerInAccountStatementDE_DTAUSReport
LedgerInAccountStatementDE_MT940
LedgerInAccountStatementDE_MT940Report
LedgerJournalAccountMovement
LedgerJournalAccountMovementReport
LedgerJournalCashReport
LedgerJournalCashReport
LedgerJournalizeReport
LedgerJournalizeReport
LedgerJournalizeReport_DE
LedgerJournalizeReport_DEReport
LedgerJournalizeReport_ES
LedgerJournalizeReport_ESReport
LedgerJournalizeReportTransLog
LedgerJournalizeReportTransLog
LedgerJournalPostControlByUser
LedgerJournalPostControlByUserReport
LedgerJournal
LedgerJournalReport
LedgerJournalSummary_ES
LedgerJournalSummary
LedgerJournalSummary_ES
LedgerJournalSummary_ES
LedgerJournalPostControlByJournalType
LedgerJrnlPostControlByJrnlTypeReport
LedgerOpeningReport_ES
LedgerOpeningReport_ES
LedgerOpenTransactions
LedgerOpenTransactionsReport
LedgerOtherJournalBE
LedgerOtherJournalReportBE
LedgerPeriodSum_FR
LedgerPeriodSum_FR
LedgerPostingJournalList
LedgerPostingJournalList
LedgerPostingJournalTotal
LedgerPostingJournalTotalReport
LedgerPurchaseJournalReportBE
LedgerPurchaseJournalReportBEReport
LedgerReconciliation
LedgerReconciliation
LedgerRowDefinitionPrint
LedgerRowDefinitionPrintReport
LedgerRowStructureWhereUsed
LedgerRowStructureWhereUsedReport
LedgerSalesJournalReportBE
LedgerSalesJournalReportBE
LedgerTotalAcctReceivablesPastXPeriods
LedgerTotalAcctReceivablesPastXPeriods
LedgerTotalAcctsPayablePastXPeriod
LedgerTotalAcctsPayablePastXPeriod
LedgerTotalAndBalanceList
LedgerTotalAndBalanceListReport
LedgerTotalExpensesByPeriod
LedgerTotalExpensesByPeriod
LedgerTransAccountVoucher_FR
LedgerTransAccountVoucher_FRReport
LedgerTransBase
LedgerTransBaseReport
LedgerTransDateVoucher_FR
LedgerTransDateVoucher_FRReport
LedgerTransferOpening
LedgerTransferOpeningReport
LedgerTransListAccount
LedgerTransListAccountReport
LedgerTransListDate
LedgerTransListDateReport
LedgerTransOpen
LedgerTransOpenReport
LedgerTransPerJournal
LedgerTransPerJournalReport
LedgerTransStatement
LedgerTransStatementReport
LedgerTrialBalance
LedgerTrialBalanceReport
LedgerXBorderActivityAT
LedgerXBorderActivityAT
AssetsDepreciation_SA
LedgerZakatReports
LedgerActivityZakat_SA
LedgerZakatReports
LedgerMainReportZakat_SA
LedgerZakatReports
LedgerProvisions_SA
LedgerZakatReports
LedgerRevenueActivity_SA
LedgerZakatReports
VendConsultationFees_SA
LedgerZakatReports
VendSubcontractor_SA
LedgerZakatReports
OutstandingDebtByPeriod
OutstandingDebtByPeriodReport
PBAConfiguratedItem
PBAConfiguratedItemReport
PBAConsistOf
PBAConsistOfReport
ProcCategory
ProcCategoryReport
ProcCategoryCommodityCode
ProcCategoryReport
ProcCategoryVendor
ProcCategoryReport
ProdBusinessOverviewWebpart
ProdBusinessOverview
ProdDefectRatioDetail
ProdBusinessOverview
ProdEfficiencyDetail
ProdBusinessOverview
ProdLeadTimeDetail
ProdBusinessOverview
ProdOnTimeProdRateDetail
ProdBusinessOverview
ProdPlannedVsActualDetail
ProdBusinessOverview
ProdCalcTrans
ProdCalcTransReport
ProdCapacityReservationsDetail
ProdCapacityReservations
ProdCapacityReservationsWebpart
ProdCapacityReservations
ProdCom_BE
ProdCom_BEReport
ProdDefectRatioDetail
ProdDefectRatio
ProdDefectRatioWebpart
ProdDefectRatio
ProdEfficiencyDetail
ProdEfficiency
ProdFinishGoodsInProgress
ProdFinishGoodsInProgressReport
ProdIndirectCostInProgress
ProdIndirectCostInProgressReport
ProdJobCard
ProdJobCardReport
ProdLeadTimeDetail
ProdLeadTime
ProdOnTimeProdRateDetail
ProdOnTimeProdRate
ProdOverview
ProdOverviewReport
ProdPicklist
ProdPicklistReport
ProdPlannedVsActualDetail
ProdPlannedVsActual
ProdPlannedVsActualWebpart
ProdPlannedVsActual
ProdRawmaterialInProgress
ProdRawmaterialInProgressReport
ProdReport
ProdReport
ProdResourcesInProgress
ProdResourcesInProgressReport
ProdRouteCard
ProdRouteCardReport
ProdRouteJob
ProdRouteJobReport
ProdTopTenDelayedOrders
ProdTopTenDelayedOrdersReport
ProjBeginningBalances
ProjBeginningBalancesReport
ProjActualvsBudgetCashFlowDetail
ProjCashFlow
ProjActualvsBudgetNetCashflow
ProjCashFlow
ProjCashFlowCategory
ProjCashFlowCategoryReport
ProjCashFlowEmplItem
ProjCashFlowEmplItemReport
ProjCashFlowProject
ProjCashFlowProjectReport
ProjClosingProfile
ProjClosingProfileReport
ProjConsumCateg2Column
ProjConsumCateg2ColumnReport
ProjConsumCateg2Prd
ProjConsumCateg2PrdReport
ProjConsumCateg
ProjConsumCategReport
ProjConsumEmpl2Column
ProjConsumEmpl2ColumnReport
ProjConsumEmpl2Prd
ProjConsumEmpl2PrdReport
ProjConsumEmpl
ProjConsumEmplReport
ProjConsumProj2Column
ProjConsumProj2ColumnReport
ProjConsumProj2Prd
ProjConsumProj2PrdReport
ProjConsumProj
ProjConsumProjReport
ProjTotalBudgetCost
ProjCostControl
ProjTotalBudgetCostDetail
ProjCostControl
ProjTotalBudgetCostProject
ProjCostControl
ProjTotalBudgetCostProjectDetail
ProjCostControl
ProjEstimateList
ProjEstimateListReport
ProjHourRateCateg
ProjHourRateCategReport
ProjHourRateEmpl
ProjHourRateEmplReport
ProjHourRateProj
ProjHourRateProjReport
ProjUtilizationEfficiency
ProjHourUtilization
ProjUtilizationEfficiencyDetail
ProjHourUtilization
ProjUtilizationEfficiencyEmpl
ProjHourUtilization
ProjUtilizationEfficiencyEmplDetail
ProjHourUtilization
ProjInvoiceJournal
ProjInvoiceJournalReport
ProjInvoice
ProjInvoiceReport
ProjJournalEmpl
ProjJournalEmplReport
ProjJournalRevenue
ProjJournalRevenueReport
ProjKPI
ProjKPI
ProjListBudget
ProjListBudgetReport
ProjListEstimateHourRate
ProjListEstimateHourRateReport
ProjListEstimate
ProjListEstimateReport
ProjListInvoiceTable
ProjListInvoiceTableReport
ProjListInvoiceTableDetail
ProjListInvoiceTableReport
ProjListLedgerRecon
ProjListLedgerReconReport
ProjListLedgerReconWIPAccount
ProjListLedgerReconWIPAccountReport
ProjListLedgerUpdatesProfitLoss
ProjListLedgerUpdatesProfitLossReport
ProjListLedgerUpdates
ProjListLedgerUpdatesReport
ProjListLineProperty
ProjListLinePropertyReport
ProjListPostingReady
ProjListPostingReadyReport
ProjListProjPosting
ProjListProjPostingReport
ProjListProjTable
ProjListProjTableReport
ProjListProjWIPCustTable
ProjListProjWIPCustTableReport
ProjListTransCommittedCost
ProjListTransCommittedCostReport
ProjListTransProj
ProjListTransProjReport
ProjListTrans
ProjListTransReport
ProjMissingHourReg
ProjMissingHourRegReport
ProjOnAccountInvoicePlan
ProjOnAccountInvoicePlanReport
ProjOnAccProj2Column
ProjOnAccProj2ColumnReport
ProjOnAccProj2Prd
ProjOnAccProj2PrdReport
ProjOnAccProj
ProjOnAccProjReport
ProjPayrollCateg2Column
ProjPayrollCateg2ColumnReport
ProjPayrollCateg2Prd
ProjPayrollCateg2PrdReport
ProjPayrollCateg
ProjPayrollCategReport
ProjPayrollEmpl2Column
ProjPayrollEmpl2ColumnReport
ProjPayrollEmpl2Prd
ProjPayrollEmpl2PrdReport
ProjPayrollEmpl
ProjPayrollEmplReport
ProjPayrollProj2Column
ProjPayrollProj2ColumnReport
ProjPayrollProj2Prd
ProjPayrollProj2PrdReport
ProjPayrollProj
ProjPayrollProjReport
ProjPeriodPosting
ProjPeriodPostingReport
ProjPriceGroupList
ProjPriceGroupListReport
ProjPriceList
ProjPriceListReport
ProjProfitLossCateg2Column
ProjProfitLossCateg2ColumnReport
ProjProfitLossCateg2Prd
ProjProfitLossCateg2PrdReport
ProjProfitLossCateg
ProjProfitLossCategReport
ProjProfitLossEmpl2Column
ProjProfitLossEmpl2ColumnReport
ProjProfitLossEmpl2Prd
ProjProfitLossEmpl2PrdReport
ProjProfitLossEmpl
ProjProfitLossEmplReport
ProjProfitLossProj2Column
ProjProfitLossProj2ColumnReport
ProjProfitLossProj2Prd
ProjProfitLossProj2PrdReport
ProjProfitLossProj
ProjProfitLossProjReport
ProjActualvsBudgetConsumption
ProjStatements
ProjActualvsBudgetCost
ProjStatements
ProjActualvsBudgetCostDetail
ProjStatements
ProjActualvsBudgetGrossMargin
ProjStatements
ProjActualvsBudgetNetWIP
ProjStatements
ProjActualvsBudgetPayroll
ProjStatements
ProjActualvsBudgetRevenue
ProjStatements
ProjActualvsBudgetRevenueDetail
ProjStatements
ProjUtilCategory
ProjUtilCategoryReport
ProjUtilEmpl
ProjUtilEmplReport
ProjUtilProject
ProjUtilProjectReport
ProjValCategory
ProjValCategoryReport
ProjValEmplCategory
ProjValEmplCategoryReport
ProjValEmployeeProj
ProjValEmployeeProjReport
ProjValEmployee
ProjValEmployeeReport
ProjValProjCategory
ProjValProjCategoryReport
ProjValProject
ProjValProjectReport
ProjWIPCateg2Column
ProjWIPCateg2ColumnReport
ProjWIPCateg2Prd
ProjWIPCateg2PrdReport
ProjWIPCateg
ProjWIPCategReport
ProjWIPEmpl2Column
ProjWIPEmpl2ColumnReport
ProjWIPEmpl2Prd
ProjWIPEmpl2PrdReport
ProjWIPEmpl
ProjWIPEmplReport
ProjWIPProj2Column
ProjWIPProj2ColumnReport
ProjWIPProj2Prd
ProjWIPProj2PrdReport
ProjWIPProj
ProjWIPProjReport
PurchPackingSlip
PurchPackingSlipReport
PurchPurchaseOrder
PurchPurchaseOrderReport
PurchRanking
PurchRankingReport
PurchReceiptsList
PurchReceiptsListReport
Purchreq
PurchREQ
PurchReqStatistics
PurchReqStatistics
RFQSend
PurchRFQSend
PurchRFQItemVend
PurchRFQSRS
PurchRFQReplyFollowUp
PurchRFQSRS
PurchRFQVendItem
PurchRFQSRS
PurchStatisticsItemVend
PurchRFQSRS
PurchStatisticsVendItem
PurchRFQSRS
VendorPerformance
PurchRFQVendPerformance
SupplyPerformance
PurchSupplyPerformance
PurchSupplyPerformanceOnReceipt
PurchSupplyPerformanceOnReceipt
RCSalesList_UK
RCSalesList_UKReport
ReqItemJournalSafetyStock
ReqItemJournalSafetyStockReport
ReqTransAction
ReqTransActionReport
ReqTransFutures
ReqTransFuturesReport
ReturnAcknowledgmentAndDocument
ReturnAcknowledgmentAndDocumentReport
SalesCODLabel
SalesCODLabelReport
SalesConfirm
SalesConfirmReport
SalesHeading
SalesHeadingReport
SalesInvoice
SalesInvoiceReport
SalesLinesExtended
SalesLinesExtendedReport
SalesNotInvoiced
SalesNotInvoicedReport
SalesOrderEntryStatistics
SalesOrderEntryStatisticsReport
SalesPackingSlip
SalesPackingSlipReport
SalesQuotationConfirmation
SalesQuotationConfirmationReport
SalesQuotation
SalesQuotationReport
SalesShippingLabel
SalesShippingLabelReport
SalesTaxByCustomer
SalesTaxByCustomerReport
SMAKeyPerformanceIndicatorsWeb
SMAKeyPerformanceIndicatorsReport
SMA_ServiceActivityWebPart
SMAServiceActivity
SMAServiceOrderMargin
SMAServiceOrderMarginReport
SMAWorkNote
SMAWorkNoteReport
smmLeadsAnalysis
smmLeadReports
smmLeadSummaryBySourceType
smmLeadReports
smmLeadSummaryBySourceTypeDetail
smmLeadReports
smmLeadSummaryBySourceTypeRC
smmLeadReports
smmNewLeadsTrend
smmLeadReports
smmPipelineAnalysis
smmOpportunityReports
smmPipelineByProcessStage
smmOpportunityReports
smmPipelineByProcessStageDetail
smmOpportunityReports
smmPipelineByProcessStageRC
smmOpportunityReports
smmPipelineMonthOverMonthClosingTrend
smmOpportunityReports
smmPipelineWinAnalysis
smmOpportunityReports
SalesAnalysis
smmSalesReports
SalesVsTarget
smmSalesReports
SalesVsTargetRC
smmSalesReports
SysCompanySize
SysCompanySizeReport
SysDataAreaPrintCollections
SysDataAreaPrintCollectionsReport
SysDatabaseLog
SysDatabaseLog
SysFillUtilityLog
SysFillUtilityLogReport
SysRecordLevelSecurity
SysRecordLevelSecurityReport
SysSqlSyncInfo
SysSqlSyncInfoReport
SysUserLicenseCountReport
SysUserLicenseCountReport
SysUsersOnline
SysUsersOnlineReport
Tax1099Detail
Tax1099DetailReport
Tax1099DupTIN
Tax1099DupTINReport
Tax1099Report
Tax1099Report
Tax1099Summary
Tax1099SummaryReport
TaxAmountByCustomer_BE
TaxAmountByCustomer_BEReport
TaxAmountByVendor_BE
TaxAmountByVendor_BEReport
TaxAmountByVendor
TaxAmountByVendorReport
TaxBookReport_ES
TaxBookReport_ESReport
TaxBookReportSum_ES
TaxBookReportSum_ESReport
TaxCodeReportSetup
TaxCodeReportSetupReport
TaxDeviation
TaxDeviationReport
TaxLedgerReconciliation
TaxLedgerReconciliationReport
TaxList_BE
TaxList_BEReport
TaxList
TaxListReport
TaxPackagingTaxItem
TaxPackagingTaxItemReport
TaxPurchaseTaxReport
TaxPurchaseTaxReport
TaxPurchLedger
TaxPurchLedgerReport
TaxReconciliationReport
TaxReconciliationReport
TaxReport_AU
TaxReport_AU
TaxReport_BE
TaxReport_BE
TaxReport_DE
TaxReport_DE
TaxReport_FI
TaxReport_FIReport
TaxReport_IT
TaxReport_ITReport
TaxReport_NL
TaxReport_NLReport
TaxReport_NO
TaxReport_NOReport
TaxReport_SE
TaxReport_SE
TaxReport_SG
TaxReport_SG
TaxReport_UK
TaxReport_UKReport
TaxReport_US
TaxReport_US
TaxReport347Report
TaxReport347Report
TaxReportAlandImport_FI
TaxReportAlandImport_FIReport
TaxReportById
TaxReportByIdReport
TaxReportCorrectionBE
TaxReportCorrectionBEReport
TaxReportInclAdjustment
TaxReportInclAdjustmentReport
TaxReporting
TaxReportingReport
TaxReportIntervat
TaxReportIntervatReport
TaxReportUnrealizedInputOutput
TaxReportUnrealizedInputOutputReport
TaxSalesLedger
TaxSalesLedgerReport
TaxSpecPerLedgerTrans
TaxSpecPerLedgerTransReport
TaxTable
TaxTableReport
TaxTrans_BE
TaxTrans_BEReport
TaxTransCode
TaxTransCodeReport
TaxTransDetail_BE
TaxTransDetail_BEReport
TaxTransDetail
TaxTransDetailReport
TaxTrans
TaxTransReport
TaxVatDetailedReport_MX
TaxVatDetailedReport_MX
TaxVatSummaryReport_MX
TaxVatSummaryReport_MX
TaxWithholdCertification_IT
TaxWithholdCertification_ITReport
TaxWithholdMonthlyReport_IT
TaxWithholdMonthlyReport_ITReport
TaxWithholdMonthlyReport_SA
TaxWithholdMonthlyReport_SA
TaxWithholdReport_TH
TaxWithholdReport_TH
TaxWithholdReportPND_TH
TaxWithholdReportPND_THReport
TaxWithholdSlip_TH
TaxWithholdSlip_THReport
TaxWithholdTrans
TaxWithholdTransReport
TaxWithholdYearlyReport_IT
TaxWithholdYearlyReport_ITReport
TaxWithholdYearlyReport_SA
TaxWithholdYearlyReport_SA
TaxYearlyComReport_IT
TaxYearlyComReport_ITReport
TradeNonStockedConversionChangeLog
TradeNonStockConvChangeLog
TradeNonStockedConversionCheckLog
TradeNonStockedConvCheckLog
TreasurerAssetAnalysis
TreasurerAssetAnalysis
TreasurerLiabilitiesAnalysis
TreasurerLiabilitiesAnalysis
TrvAllowance
TrvAllowanceReport
TrvEmployeeBarcodeCoverReport
TrvBarcodeCoverPage
TrvExpReportsBarcodeCoverReport
TrvBarcodeCoverPage
TrvCost
TrvCostReport
TrvCostStatistics
TrvCostStatisticsReport
TrvDisputeAuditTrail
TrvDisputedCreditCardTransactionsReports
TrvPostedDisputeTransactionsReport
TrvDisputedCreditCardTransactionsReports
TrvEstimatedVsActualExpenses
TrvEstimatedVsActualExpenses
TrvExpense
TrvExpenseReport
TrvExpenseSettlementReport
TrvExpenseSettlementReport
TrvExpenseTaxRecoverableReport
TrvExpenseTaxRecoverable
TrvMileage
TrvMileageReport
TrvPersonalExpenses
TrvPersonalExpensesReport
TrvRequisitionSummary
TrvRequisitionSummary
TS_DeliveryPerformanceDetail
TSDeliveryPerformance
TS_DeliveryPerformanceWebpart
TSDeliveryPerformance
TS_InvoicedPurchaseAmountDetail
TSInvoicedPurchaseAmount
TS_InvoicedPurchaseAmountWebpart
TSInvoicedPurchaseAmount
TS_NetsalesVsCOGSDetail
TSNetsalesVsCOGS
TS_NetsalesVsCOGSWebpart
TSNetsalesVsCOGS
TS_PurchaseReturnsDetail
TSPurchaseReturns
TS_PurchaseReturnsWebPart
TSPurchaseReturns
TSTimesheetSignOff
TSTimesheetSignOffReport
TS_TopTenReturnedItemsWebPart
TSTopTenReturnedItems
TS_TopTenVendHighReturnsRateWebpart
TSTopTenVendHighReturnsRate
TS_VendorPerformanceTimeDetail
TSVendorPerformanceTime
TS_VendorPerformanceTimeWebpart
TSVendorPerformanceTime
VendAccountStatement_FR
VendAccountStatement_FR
VendAccountStatementInt
VendAccountStatementIntReport
VendAccruedPurchases_NA
VendAccruedPurchases_NAReport
VendAgingReport
VendAgingReport
VendBalanceList
VendBalanceListReport
VendCheckSettlement
VendCheckSettlementReport
VendDueReportDetail_NA
VendDueReportDetailReport_NA
VendEUVatInvoice
VendEUVatInvoiceReport
VendExchRateAdjSimulation
VendExchRateAdjSimulationReport
VendExchRateAdjustment
VendExchRateAdjustmentReport
VendInvoiceDocument
VendInvoiceDocumentReport
VendInvoiceJournalTotalTrxCount
VendInvoiceJournalTotalTrxCount
VendInvoiceJour
VendInvoiceJourReport
VendInvoicePoolNotposted
VendInvoicePoolNotpostedReport
VendInvoice
VendInvoiceReport
VendInvoiceSettled_TransDate_ES
VendInvoiceSettled_TransDate_ESReport
VendInvoiceSpec
VendInvoiceSpecReport
VendInvoiceVolume
VendInvoiceVolumeReport
VendLedgerReconciliation
VendLedgerReconciliationReport
VendLedgerTrans
VendLedgerTransReport
VendOpenPaymDocu_ES
VendOpenPaymDocu_ESReport
VendReportApproveCollection
VendorReportApproveCollectionReport
Vend
VendorSRS
VendBaseData
VendorSRS
VendPhoneList
VendorSRS
VendOutAttendingNote_ATEDIFACT
VendOutAttendingNote_ATEDIFACTReport
VendOutAttendingNote_DEDTAZV
VendOutAttendingNote_DEDTAZVReport
VendOutAttendingNote_PNRemittance
VendOutAttendingNote_PNRemittanceReport
VendOutAttendingNoteDE_DTAUS
VendOutAttendingNoteDE_DTAUSReport
VendOutCoveringLetter_DEDTAUS
VendOutCoveringLetter_DEDTAUSReport
VendOutCoveringLetter_DEDTAZV
VendOutCoveringLetter_DEDTAZVReport
VendOutInvoiceSumByDeclaration_IS
VendOutInvoiceSumByDeclaration_IS
VendOutPaymAdvice_ATEDIFACT
VendOutPaymAdvice_ATEDIFACTReport
VendOutPaymAdvice_CHDTA
VendOutPaymAdvice_CHDTAReport
VendOutPaymAdvice_CHEZAG
VendOutPaymAdvice_CHEZAGReport
VendOutPaymAdvice_FRAFB
VendOutPaymAdvice_FRAFBReport
VendOutPaymControl
VendOutPaymControl
VendOutPaymControl_DEDTAZV
VendOutPaymControl
VendOutPaymControl_ES
VendOutPaymControl
VendOutPaymControl_FI_FOR
VendOutPaymControl
VendOutPaymControl_FI_LM
VendOutPaymControl
VendOutPaymControl_FR
VendOutPaymControl
VendOutPaymControl_IT
VendOutPaymControl
VendOutPaymControl_SE
VendOutPaymControl
VendOutPaymOrder_CHDTA
VendOutPaymOrder_CHDTAReport
VendOutPaymOrder_CHEZAG
VendOutPaymOrder_CHEZAGReport
VendPaymentJournal_NA
VendPaymentJournal_NA
VendPaymRefReport_BE
VendPaymRefReport_BE
VendPostPaymJournal_NA
VendPostPaymJournal_NA
VendPromissoryNoteOpenTrans_ES
VendPromissoryNoteOpenTrans_ESReport
VendPromissoryNoteOpenTrans_FR
VendPromissoryNoteOpenTrans_FRReport
VendPromissoryNoteReport
VendPromissoryNoteReport
VendProvisionalBalance
VendProvisionalBalanceReport
VendPurchaseDistribution_NA
VendPurchaseDistribution_NAReport
VendPurchasePastXPeriods
VendPurchasePastXPeriods
VendPurchOpenLines_NA
VendPurchOpenLines
VendPurchOpenOrders_NA
VendPurchOpenOrders_NAReport
VendPurchReceivingLog_NA
VendPurchReceivingLog_NAReport
VendRequestAudit
VendRequestAudit
VendRequestProcureAudit
VendRequestAudit
VendRequest
VendRequestSRS
VendRequestRejected
VendRequestSRS
VendSpendCategoryDiversity
VendSpendReview
VendSpendCategoryInvoice
VendSpendReview
VendSpendCategoryYears
VendSpendReview
VendSpendLocation
VendSpendReview
VendSpendReviewByCategory
VendSpendReview
VendSpendReviewByCompany
VendSpendReview
VendSpendReviewByInvoiceType
VendSpendReview
VendSpendReviewByTopVendor
VendSpendReview
VendSpendReviewByVendorType
VendSpendReview
VendSpendTopInvoice
VendSpendReview
VendSpendCategory
VendSpendStatistics
VendSpendCategoryDiversity
VendSpendStatistics
VendSpendCategoryInvoice
VendSpendStatistics
VendSpendCategoryYears
VendSpendStatistics
VendSpendDiversity
VendSpendStatistics
VendSpendLocation
VendSpendStatistics
VendSpendOptimization
VendSpendStatistics
VendSpendShipToLocation
VendSpendStatistics
VendSpendTopInvoice
VendSpendStatistics
VendSpendVendorLE
VendSpendStatistics
VendTopXVendorsByYTDPurchases
VendTopXVendorsByYTDPurchases
VendTransListReport
VendTransListReport
VendTransOpen_PaymMode_ES
VendTransOpen_PaymMode_ES
VendVendorPaymentJournalTotalTrxCount
VendVendorPaymentJournalTotalTrxCount
WMSBillOfLading
WMSBillOfLadingReport
WMSCheckABCZones
WMSCheckABCZonesReport
WMSJournalTrans
WMSJournalTransReport
WMSLocationLabel
WMSLocationLabelReport
WMSPalletList
WMSPalletListReport
WMSPalletNumber
WMSPalletNumberReport
WMSPickingList_OrderPick
WMSPickingList_OrderPickReport
WMSPickingList
WMSPickingListReport
WMSPickingLocations
WMSPickingLocationsReport
WMSShipmentList
WMSShipmentListReport
WorkflowinstancebystatusReport
Workflow
WorkflowtrackingReport
Workflow
WorkflowAutomationReport
WorkflowAutomationReports
WorkflowElementsAutomationReport
WorkflowAutomationReports
WorkflowElementsPerformanceReport
WorkflowReports
WorkflowParticipantPerformanceReport
WorkflowReports
WorkflowPerformanceReport
WorkflowReports
WrkCtrCapRes
WrkCtrCapResReport
WrkCtrJobs
WrkCtrJobsReport

Wednesday, September 24, 2014

Ax2012: Using ADO.Net with X++

http://floditt.blogspot.in/2011/08/using-adonet-with-x.html

public void adoConnection()
{
    str serverName;
    str catalogName;
    str ConnectionString;
    str sqlQuery;
    //ADO.Net via CLR objects. Requires referenced System.Data
    System.Data.SqlClient.SqlConnectionStringBuilder connectionStringBuilder;
    System.Data.SqlClient.SqlConnection connection;
    System.Data.SqlClient.SqlCommand command;
    System.Data.SqlClient.SqlParameterCollection parameterCollection;
    System.Data.SqlClient.SqlDataReader dataReader;
    System.Exception netExcepn;
    ;
    new InteropPermission( InteropKind::ClrInterop ).assert();
   
    sqlQuery = "SELECT * from  INVENTTABLE";
    //ceating the ConnectionString dynamically, based on the current connection
    serverName = SysSQLSystemInfo::construct().getLoginServer();
    serverName = "GBSQLDEV2"; //change to different server
    catalogName = SysSQLSystemInfo::construct().getloginDatabase();
    catalogName="MicrosoftDynamicsAx"; //change to different database
    connectionStringBuilder = new System.Data.SqlClient.SqlConnectionStringBuilder();
    connectionStringBuilder.set_DataSource(serverName);
   
    //here it becomes interesting. The current execution context will be used to
    //establish a conection. If this is executed by a batch, this is the user
    //configured for the batch
    connectionStringBuilder.set_IntegratedSecurity(true);
    connectionStringBuilder.set_InitialCatalog(catalogName);
    //all this to prevent working with a fixed string...
    //on my computer, this would be equal to
    //"Data Source=DYNAMICSVM;Initial Catalog=DynamicsAx1;Integrated Security=True"
    ConnectionString = connectionStringBuilder.get_ConnectionString();

    //initializing connection and command
    connection = new System.Data.SqlClient.SqlConnection(ConnectionString);
    command = new System.Data.SqlClient.SqlCommand(sqlQuery);
    command.set_Connection(connection);

    //executing SQL-query
    try
    {
        //open within catch, so that the object can correcly be disposed
        //all these try-catch are quite ennoying in X++, but this because
        //X++ does not know finally...
        connection.Open();
        try
        {
            //All code after the open must be in a seperate catch, so that the
            //open connection-object can correcly be disposed.
            dataReader = command.ExecuteReader();

            while(dataReader.Read())
            {
                //use the named columns instead of index.
               info( dataReader.get_Item("ItemId"));
            }
            //Dispose ADO.Net objects ASAP
            dataReader.Dispose();
        }
        catch //should be more precise in a real-world application
        {
            //if exception occures while reading, DataReader need to be
            dataReader.Dispose();
        }
        catch(Exception::CLRError) //CLR exception need to be handled explicitely
        //otherwise they might be 'lost'. Happy copy&pasteing
        {
            //if exception occures while reading, DataReader need to be
            dataReader.Dispose();
        }
        connection.Dispose();
    }
    catch (Exception::Error) //should be more precise in a real-world application
    {      
       
        connection.Dispose(); //disposing connection if it fails before opening it
    }
    catch(Exception::CLRError)
    {
        netExcepn = CLRInterop::getLastException();
        info(netExcepn.ToString());
        connection.Dispose();
    }
    command.Dispose();
    CodeAccessPermission::revertAssert();
   
   
}

Tuesday, September 2, 2014

Ax 2012 SSRS row visibility in case of hierarchy groups.

When having multiple grouping and totals for each grouping in SSRS reports, the row visibility property cannot be used to hide or show based on certain conditions

In such scenario, the split cells functionality can be used. Once we use the split cells, then the row visibility property will be available.

So if we have 3 groups hierarchy, we should first  do the group by for the first required column, add totals and then split the column. Now the row visible property will be available. Set the required expression for showing or hidding the group.
Again do the grouping for next one and follow the same steps as above.
Once a new group is added, the previous group row visibility will not be available.

Uploading MS Word documents to Blogger - via Google Docs

RDP based SSRS report

A RDP based SSRS report consist of the following:
Temporary table
Data contract class
UI builder class
RDP class
Controller class
SSRS report
Output menu item

Step 1: Temporary table
Create a new inmemory temporary table which will be used in the RDP class.


Step 2: Data contract class.

  1. Class declaration
The following should be set before the class declaration.
[
   DataContractAttribute,
   SysOperationContractProcessingAttribute(classStr(xxxReportUIBuilder)),
 SysOperationGroupAttribute('Parameter',"Parameter",'1'),
   SysOperationGroupAttribute('Select',"Select",'2')

]

Where xxxReportUIBuilder is the UI builder class name.
SysOperationGroupAttribute should be used if we need to group parameters and the order in which the group should be shown.

If validation is required, The class should implement SysOperationValidatable
public class LF_BookedSalesReportContract implements SysOperationValidatable

Variables should be declared which are required as parameters.
TransDate           fromDate;
TransDate           toDate;
DimensionValue      branch;
hcmWorkerRecId      employee;


  1. Add parm methods for the variables declared.
[
DataMemberAttribute('FromDate'),
SysOperationLabelAttribute(literalstr("@SYS24050")),
SysOperationGroupMemberAttribute('Parameter'),
SysOperationDisplayOrderAttribute('1')

]
public TransDate parmFromDate(TransDate _fromDate = fromDate)
{
   fromDate = _fromDate;
   return fromDate;
}

SysOperationGroupMemberAttribute should be used identify the group name and SysOperationDisplayOrderAttribute should be used to set the display order of the parameter in the group.

///
/// Gets or sets the value of the datacontract parameter ToDate.
///
///
/// The new value of the datacontract parameter ToDate; optional.
///
///
///  The current value of datacontract parameter ToDate
///
[
   DataMemberAttribute('ToDate'),
   SysOperationLabelAttribute(literalstr("@SYS80934"))
]
public TransDate parmToDate(TransDate _toDate = toDate)
{
   toDate = _toDate;
   return toDate;
}

  1. Validate variables.

public boolean validate()
{
   boolean isValid = true;

if (this.parmToDate() && this.parmFromDate() > this.parmToDate())
   {
       // Invalid date interval
        isValid = checkFailed("@SYS91020");
   }
       if(isValid )
       {
           return true;
       }
       else
       {
           return false;
       }

   }

To validate dimensions:
   DimensionAttribute              dimAttribute;
   DimensionAttributeDirCategory   dimAttributeDirCategory;
   DimensionFinancialTag           DimensionFinancialTag;

   void checkDimension(DimensionValue  _value, Name    _dimname)
   {
       dimAttribute = DimensionAttribute::findByName(_dimname);
       select RecId from DimensionFinancialTag where DimensionFinancialTag.Value == _value
         join DirCategory from dimAttributeDirCategory
         where dimAttributeDirCategory.DimensionAttribute == dimAttribute.recId &&
            dimAttributeDirCategory.DirCategory == DimensionFinancialTag.FinancialTagCategory ;
       if (!DimensionFinancialTag.RecId)
           isValid = checkFailed(strfmt("%1 value %2 does not exist.",_dimname,_value));
   }

   department = this.parmDepartment();
   if(department)
   {
checkDimension(department,"Departments"); checkDimension(department,"Departments");
   }



Step 3: UI builder class.
  1. Class declaration
Should extend SrsReportDataContractUIBuilder
Declare a variable for the contract class created above.
xxxDPContract rdpContract

  1. Post run method
This method can be overridden and can be used to register overridden method for controls like the lookup, modified method etc. Also can be used to set the labels for the controls.

public void postRun()
{
   DialogField dialogField;
   Dialog dialogLocal = this.dialog();
   ;

   super();
dialogLocal.caption("Report Name");

// This method should be called in order to handle events on dialogs. This method should not be called in case of multi select control overridden.
   dialogLocal.dialogForm().formRun().controlMethodOverload(false);
   rdpContract = this.dataContractObject();
   //Set default values in the contract
rdpContract.parmToDate(systemDateGet());
   rdpContract.parmSalesEmpType(LF_SalesEmpType::LF_SalesResponsible);
   dialogField = this.bindInfo().getDialogField(this.dataContractObject(),
methodStr(LF_BookedSalesReportContract, parmToDate));
   dialogField.value(systemDateGet());

   dialogField = this.bindInfo().getDialogField(this.dataContractObject(),
methodStr(LF_BookedSalesReportContract, parmSalesChannel));
   dialogField.registerOverrideMethod(methodstr(FormStringControl, lookup),
methodstr(LF_BookedSalesReportUIBuilder,  lookupSalesChannel), this);

}

lookup method overridded:
public void lookupSalesChannel(FormStringControl _control)
{
    SysTableLookup          sysTableLookup;
    Query                   query;
    QueryBuildDataSource    qbdsdimFinancialTag,qbdsSPSContract;
    DialogField             dlgFldSalesProjType;

    dlgFldSalesProjType = this.bindInfo().getDialogField(this.dataContractObject(),
methodStr(LF_BookedSalesReportContract, parmSalesProjType));
    if (dlgFldSalesProjType.value() == LF_SalesProjType::LF_SmallProjSales)
    {
        sysTableLookup  = SysTableLookup::newParameters(tableNum(DimensionFinancialTag), _control);
        sysTableLookup.addLookupfield(fieldNum(DimensionFinancialTag, Value));
        sysTableLookup.addLookupfield(fieldNum(DimensionFinancialTag, Description));

        query   = new query();
        qbdsdimFinancialTag = query.addDataSource(tableNum(DimensionFinancialTag));
        qbdsSPSContract = qbdsdimFinancialTag.addDataSource(tableNum(LF_SmallProjSalesData));
       qbdsSPSContract.addLink(fieldNum(DimensionFinancialTag,RecId),fieldNum(LF_SmallProjSalesData,LF_SalesChannelRecId));
        qbdsSPSContract.joinMode(JoinMode::ExistsJoin);

        sysTableLookup.parmQuery(Query);
        sysTableLookup.performFormLookup();
    }
}

Example of modified method
public boolean modifiedCustAcct(FormStringControl _control)
{
   CustTable               custTable;
   LogisticsPostalAddress  deliveryAddress;
   DialogField             dialogField;


   dialogField = this.bindInfo().getDialogField(this.dataContractObject(), methodStr(LF_ShippingLabelContract, parmCustAccount));

   if(dialogField.value())
   {
       select firstonly custTable where custTable.AccountNum == dialogField.value();
       if (custTable)
       {
           deliveryAddress = LogisticsLocationEntity::findPostalAddress(custTable,LogisticsLocationRoleType::Delivery);
           if (deliveryAddress)
               this.setAddressFields(deliveryAddress);
           else
               this.setAddressFields(custTable.postalAddress());

           dialogField = this.bindInfo().getDialogField(this.dataContractObject(), methodStr(LF_ShippingLabelContract, parmCustName));
           dialogField.value(custTable.name());
           contract.parmCustName(custTable.name());
       }
   }
   return true;
}

Example to clear control values.
public void preBuild()
{
   FormBuildGroupControl       formBuildGroupControl;


   super();
   contract = this.dataContractObject();



   contract.parmJobNum("");
   contract.parmCustName("");
   

   formBuildGroupControl = dialog.curFormGroup();
   formBuildGroupControl.columns(2);
}

Step 4: RDP class.
  1. Class declaration
The following should be set before the class declaration.
[
   SRSReportParameterAttribute(classstr(xxxReportContract)),
SRSReportQueryAttribute(queryStr(QueryName)) //used when query is also part of the rdp.

]

Where xxxReportContract is the Data Contract class name.

The class should extends SRSReportDataProviderBase //SrsReportDataProviderPreProcess //
SrsReportDataProviderPreProcess can be used for debugging the rdp class.

In the class declartion, declare a variable for the tmp which will be sent to the SSRS report, and for the queryrun.
LF_BookedContractSalesTmp    bookedContractSalesTmp;
QueryRun                 queryRun;



  1. Process report
Write the logic to insert the data into the temp table
   LF_ScheduledDollarsBranchContract      dataContract; // Get the query from the runtime using a dynamic query.

   dataContract = this.parmDataContract();
   projFromDate = dataContract.parmProjectFromDate();
   queryRun = new SysQueryRun(this.parmQuery());

   //Add more filters to the query based on the user selected values
    refer the setQueryRanges() below.

   while (queryRun.next()
   {


   }


Example to modify the query.
private void setQueryRanges(ProjResponsibleFinancialWorker _projectAccountant)
{
   QueryBuildDataSource qbdsProjTable, qbdsContractLineItems, qbdsProjInvTeamTable;
   qbdsProjTable = queryrun.query().dataSourceTable(tablenum(ProjTable));
   qbdsContractLineItems = qbdsProjTable.addDataSource(tableNum(PSAContractLineItems));
   qbdsContractLineItems.addSelectionField(fieldnum(PSAContractLineItems, FeeProjId));
   qbdsContractLineItems.addSelectionField(fieldnum(PSAContractLineItems, ChangeOrderNum));
   qbdsContractLineItems.addSelectionField(fieldnum(PSAContractLineItems, LineDesc));
   qbdsContractLineItems.addSelectionField(fieldnum(PSAContractLineItems, LineValue));
   qbdsContractLineItems.addSelectionField(fieldnum(PSAContractLineItems, CreatedDateTime));
   //qbdsContractLineItems.addSelectionField(fieldnum(PSAContractLineItems, ProjInvoiceProjId));
   qbdsContractLineItems.addRange(fieldnum(PSAContractLineItems,LF_ContractLineStatusId )).value("TM");
   qbdsContractLineItems.addRange(fieldnum(PSAContractLineItems,LF_ContractLineStatusId )).value("PN");
   qbdsContractLineItems.addRange(fieldnum(PSAContractLineItems,LF_ContractLineStatusId )).value("P$");
   qbdsContractLineItems.addRange(fieldnum(PSAContractLineItems,LF_ContractLineStatusId )).value(SysQuery::valueEmptyString());
   qbdsContractLineItems.addRange(fieldnum(PSAContractLineItems, FeeProjId)).value(SysQuery::valueNotEmptyString());
   qbdsContractLineItems.addSortField(fieldNum(PSAContractlineitems,FeeProjId));
   qbdsContractLineItems.addSortField(fieldNum(PSAContractlineitems,ChangeOrderNum));
   qbdsContractLineItems.addLink(fieldNum(ProjTable, ProjId), fieldNum(PSAContractLineItems, FeeProjId));
   qbdsContractLineItems.joinMode(JoinMode::InnerJoin);

   qbdsProjInvTeamTable = qbdsContractLineItems.addDataSource(tablenum(LF_ProjInvoiceTeamTable));
   qbdsProjInvTeamTable.addSelectionField(fieldnum(LF_ProjInvoiceTeamTable, LF_ProjectAcct));
   qbdsProjInvTeamTable.addLink(fieldNum(PSAContractLineItems, ProjInvoiceProjId), fieldNum(LF_ProjInvoiceTeamTable, LF_ProjInvoiceId));
   if (_projectAccountant)
   {
       qbdsProjInvTeamTable.joinMode(JoinMode::InnerJoin);
       qbdsProjInvTeamTable.addRange(fieldNum(LF_ProjInvoiceTeamTable,LF_ProjectAcct)).value(queryValue(_projectAccountant));
   }
   else
   {
       qbdsProjInvTeamTable.joinMode(JoinMode::OuterJoin);
   }
}



  1. method to set the tmp table
This method should set the report dataset attribute to the temporary table

[
   SRSReportDataSetAttribute("scheduledDollarBySchedulerTmp")
]
public LF_ScheduledDollarBySchedulerTmp getScheduledDollarBySchedulerTmp()
{
   select * from scheduledDollarBySchedulerTmp;

   return  scheduledDollarBySchedulerTmp;
}


Step 4: Controller class.
This class should extend SrsReportRunController. In the class declaration, declare a macro for the report name

#define.ReportName('LF_BookedSalesReport.Report')

Create a main method to call the SSRS report.
public static void main(Args _args)
{
   LF_BookedSalesReportController controller  = new LF_BookedSalesReportController();
   controller.parmReportName(#ReportName);
   controller.parmArgs(_args);
   controller.startOperation();
}

Override heh prePromptModifyContract to make changes to query filter.
protected void prePromptModifyContract()
{
   ProjTable   projTableLocal;
   //super();
   //add a range in the report query
   if(this.parmArgs().record())
   {
       projTableLocal = this.parmArgs().record();
       SrsReportHelper::addParameterValueRangeToQuery(this.getFirstQuery(),tableNum(ProjTable),fieldNum(ProjTable, ProjId),SysQuery::value(projTableLocal.projId));
   }
}



Step 5: SSRS Report.
Create a SSRS report in the VS report designer. Create an RDP based precision report and the dataset should use the rdp class created before.

Step 6: Output menu item.


Step 7: Add Output menu item to menu.