you 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 Morehow to year end closing
- Apr 13, 2016
how to year end closing go to ax->general ledger->periodic->fiscal year close->opening transactions print created transactions : check this if you want to notified after created transactions if you already closed the year end, and you need to reopen, change the balance accounts to reset
Read Morewe have a new case, A CLR error occurred while involving the scheduling engine this is happen if we have more than one AOS active in production. how to solve it? open the AX Configuration Server unchecked the “enable the hot-swapping of assemblies for each development session” restart the AOS -RF-
Read MoreWorkflow delegation Approval
- Jan 14, 2016
As far as I know, they were 2 ways to delegate workflow approval beside using workflow structure, using workflow history: Open Module that use workflow, for example : Sales Order / Purchase Order Look for Workflow details, and click “Reassign” button pick the user to delegate using user info delegation Open System Administration –> Common […]
Read Morewe have a new case related (again) to workflow, the workflow stopped because the target date not found in work calendar this error occurred usually while we change the period times (change year) that the year weren’t set in working calendar (today is 2016, the calendar only consists to 31 dec 2015) Organization administration –> […]
Read MoreDeprecated: mb_convert_encoding(): Handling HTML entities via mbstring is deprecated; use htmlspecialchars, htmlentities, or mb_encode_numericentity/mb_decode_numericentity instead in /var/www/project/axhelper.erakarta.com/wp-content/themes/focus-magazine/functions.php on line 133