Code to print form letter notes like Purchase Order notes, Sales Quotation etc in AX 2012
Hi, print FormLetterRemarks::find(‘en-us’,FormTextType::ProjectQuotation).Txt; viz, PurchaseOrderConformation Regards,
Code to print attachment Notes in AX 2012
Hi, static void Job75(Args _args){ DocuRefSearch docuRefSearch; SalesQuotationTable quotationTable; quotationTable = SalesQuotationTable::find(‘CBI-000039’); docuRefSearch = DocuRefSearch::newTypeIdAndRestriction(quotationTable, ‘note’, DocuRestriction::External); // projActivityCostSummaryTmp.Notes = Docu::concatDocuRefNotes(docuRefSearch); print Docu::concatDocuRefNotes(docuRefSearch); print DocuRef::find(quotationTable.dataAreaId,quotationTable.RecId).Notes; pause;} Regards
Unretrieved Values in Grid AX 2012
Hi, You may face this kind of error / bugs during newly added fields to the table. Case 1:If the record is Unretrieved in table level- Sync issueSolution:Right click and select synchronize that concern table. Case 2:If it not let you to open that tableSolution:Synchronize entire AOT. Case 3.If it says Unretrieved Values in GridSolution:Restart the AOS. […]
From date and To date time conversion in AX 2012
Hi, print DateTimeUtil::newDateTime(fromDare,0); This will return day start time 12:00 AM print DateTimeUtil::newDateTime(ToDate,86400); This will return day end time 11:59 PM Regards,
Cannot insert the value NULL into column message in insert_recordset in AX 2012
Hi, When you are trying to insert the insert the record in to a table using insert_recordset method in the case of joining to table either pulling from view or a query then we cannot assign null vaues. Example:2 tables are joined in view and some filed in child table values may not be available […]
Conditional based decimal in SSRS
Hi, =iif(Fields!CurrencyCode.Value =”USD”,(FormatNumber(Fields!TotalAmountSumDebit.Value,2)),(FormatNumber(Fields!TotalAmountSumDebit.Value,4))) Regards,
Find number of hits and data usage in SQL * Applicable for all the applications (SQL as DB)
Hi, Right click on the DB and select script and page below one. SELECTtables.NAME AS TableName,indexes.name as IndexName,sum(partitions.rows) as NumberOfRows,sum(allocation_units.total_pages) as TotalPages,sum(allocation_units.used_pages) as UsedPages,sum(allocation_units.data_pages) as DataPages,(sum(allocation_units.total_pages) * 8) / 1024 as TotalSizeMB,(sum(allocation_units.used_pages) * 8) / 1024 as UsedSizeMB,(sum(allocation_units.data_pages) * 8) / 1024 as DataSizeMBFROMsys.tablesINNER JOIN sys.indexes ON tables.OBJECT_ID = indexes.object_idINNER JOINsys.partitions ON indexes.object_id = […]
Checkbox in dialog in X++
static void DialogCheckBox(Args _args){ Dialog dialog = new Dialog(“New dialog with checkBox”); NoYesId checkValue = NoYes::No; str strMessage = “Confirmation will create Variation. n […]
An update conflict occurred due to another user process deleting the record or changing one or more fields in the record
Hi, Record conflict errors. You needs to block the records to your session these are the ways you can lock the table records. 1. ttsbegain and ttscommit will also plays this role. 2. OCCEnabled true the property in table level. 3. In X++ a. select statement. select pessimisticLock purchTable where purchTable.PurchId == “XXXXX”; b. recordset statement. […]
Override the action pane methods in List Page AX 2012
Hi, Please change the Display Target properties to client instead of Auto / EP to get the override methods. Also this can be achieved by interaction class. Regards,
Due date based alert Configuration in AX 2012
Hi, 1. Create a a date field.2. Right click in form level and select create alerts.3. Select due in in the pop up.4. Select the email alert notification and no end time. // Now records get created in Event Table.5. Select Organisation Administration Setup Alert view details create the email template.6. Define the batch group […]
Alert customization – Getting a table details in email AX 2012
Hi, Please check for customization in EventActionEmailcreateEmailParameterMap class %data% will print the available notification message.%Message% will print the information event Table. You may add your values in createEmailParameterMap map method of EventActionEmail class. Regards,
Print table name by table id in AX 2012
Hi, static void TableAOTName(Args _args){ print tableId2Name(615); pause;} static void TableName(Args _args){ print tableId2PName(615); pause;}
Print management in AX 2012
Hi, There are 2 set of tables associated to Print management1. Default2 Print management design. 1. Default will be called by classPrintMgmtDocTypemethodsgetDefaultReportFormat where as we can change this values in form setup form level. 2. For Print management on customized design called byTables – PrintMgmtReportFormatMethodspopulate addOther(PrintMgmtDocumentType::SalesOrderPackingSlip, ssrsReportStr(SalesPackingSlip, ReportUD), ssrsReportStr(SalesPackingSlip, ReportInternational), #NoCountryRegionId); Here ReportInternational is my […]
FCB::Open failed: Could not open file D:TempDBtempdb.mdf for file number 1. OS error: 3(The system cannot find the path specified.). SQL 2014
Hi, Either of these below error persist in the SQL service stop then you need to check the Database location exist. (Particularly tempdb). Initializing the FallBack certificate failed with error code: 1, state: 20, error number: -2146893788. Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible […]
Code to get WBS and Summary cost and sales estimates of an smmActivity
public static void SummarySalesPriceEstimates(){ ProjWBSUpdateController controllerLoc; HierarchyIdBase hierarchyIdLoc; HierarchyTreeTable hierarchyTreeTableLoc; str […]