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.

• others

case 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, […]

• dynamics ax
• sql server

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-

• dynamics ax

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  

• dynamics ax

we 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-  

• dynamics ax

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 […]

• dynamics ax

we 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 –> […]

• dynamics ax

We have a new case, related to workflow, the error was: the error occured because user (or one users) have open the sales order and locked it, the solution is, ask to user to close the open Sales Order, and system admin can resume the workflow     -RF-  

• dynamics ax

this quick tutorial shows how to restore windows server from backup image copy the folder \WindowsImageBackup\ to your external drive prepared 1 alternate server, with free partition drives insert windows 2008 R2 dvd into your dvd’s tray plug the external drive into this alternate server turn the alternate server on, type any key to boot […]

• windows server