Category: sql server
ax2012-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 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 Moreax 2012, KDC_ERR_S_PRINCIPAL_UNKNOWN case-solved
- Nov 23, 2015
there was a symptom, that around 7-10 minutes, AOS services in one of my AOS server suddenly terminate. I check the AOS server log, it said that the APP craSH. but the problem is, this case happen only start from this month only. and it happens maybe 100times until today I check the event log, […]
Read Morehi, today we’ll learning how to solve case sales invoice cannot be posted our finance while generating sales invoice has occurred and error, cannot posting sales invoice, account number for transaction type sales order issue does not exists as the picture below the problem begin when the user created this sales order, it contains […]
Read Morehow import contoso data on AX 2012 R3
- Oct 30, 2015
if you are an ax functional you must familiar with contoso demo data in microsoft dynamics ax 2012 R3, contoso demo data is not available in default database or demo database, you must import the database and execute tools to import it this article will show you how to get the data, how to import […]
Read Morenotexists join in ax 2012 x++
- Aug 19, 2015
you have 2 tables, the first table contains ‘123’ record and the second table do not the question: how to view table in first table that not contains record in second table case: I want to know, what item that is not in sales
Read Moreax 2012, SSRS not working, login failed
- Jul 06, 2015
SSRS is not working, it shows error like this: “The report server has encountered a configuration error. Logon failed for the unattended execution account. (rsServerConfigurationError)”
Read Moresql server 2008 replication vs mirroring
- Jul 02, 2015
What is the difference between replication and mirroring in SQL Server 2008
Read More