Author: Ronny
if we had custom table in ax 2012, we cannot find the custom table in database log wizard so this is the solution open AOT create the Configuration Key (see the picture below) in this sample, I make a new configuration key called RON_CustomConfigurationKey, so every custom table that I made will be added in […]
Read Moremanagement reporter 2012, the security
- Nov 03, 2016
just read from dax finance blog so, if we created a rule that consist in those aot, the security user type will be impact (but need to wait 2-3 minutes to see if changes or not) I am using Microsoft Dynamics AX 2012 FP (Feature Pack) for reporting data thanks to dax finance blog […]
Read Morethis is an old article that I posted on wordpress you can visit the old article here while Im doing inventory calculation Im searching on net, why it would happen, it happens because The error always occurs when it is trying to pass an adjustment through a production order (“Batch order”). Every other month we encounter this […]
Read Morethis source is to send a notification after event to any user ax via ax client apps EventNotification event = EventNotification::construct(EventNotificationSource::Sync); ; event.parmUserId(“admi1”); event.parmSubject(“demo only”); event.parmMessage(strFmt(“message from from %1”,curuserid())); event.create();
Read Moreyou already create the new field on table, but on form datasource, this field did not shows up, how to solve it? Right click the forms, click restore, the new fields will shows up on the datasource
Read MoreCase How to validate production from sales order while advanced payment condition not meet story: we have 2 company using the same AX, both company use intercompany to create order from first company to second company first company are selling stuff, and the second are manufacture company when the first company have order from customer, the […]
Read Moreax2012-how to get financial dimension by code
- Aug 12, 2016
how to get financial dimension on ax 2012 and update it Q : we have case that all customers financial dimension department must change because one of two reason, the old customer financial dimension from 111130 must change to 111135, how to do it? A : we can do that with sql server query. First […]
Read MoreMicrosoft PowerBI
- Jul 21, 2016
Microsoft PowerBI -The preface- Two words to describe about Microsoft PowerBI, fascinating awesome! As the earlier, we already provide the custom own Business Intelligent application for our management, as the usual, we must do the same task we’d did before such as Designing the data, Designing the Chart, creating the application, manage the security and so on. We did this entirely using Microsoft Visual Studio Express to create the application, and we’re using Microsoft SQL Server 2008 R2 (Express edition) as the RDBMS.
Read Morecase is: when your logistics manager wants to know, what packing slip from others entity sent to your company in some periode this is the query /* declare @DataAreaID varchar(4) = ‘[your entity]’; declare @dtStart date = ‘2016-04-01’; declare @dtEnd date = ‘2016-05-04’; */ select CPSJ.DATAAREAID as Sender, CPSJ.PACKINGSLIPID, CPSJ.INTERCOMPANYPURCHID, CPST.ORIGSALESID, CPST.DELIVERYDATE, CPST.LINENUM, CPST.ITEMID, ID.CONFIGID, […]
Read Moreyear end closing – more notes
- Apr 24, 2016
please note: while you’re do the year end closing, (resetting or closing and opening), please consider while doing it in peak hour. if you must do in peak hour, and sometimes the aos hang and then restart, database might have some error record, and you must repair it by records -RF-
Read More