Category: sql server

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

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

• dynamics ax
• sql server

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

• dynamics ax
• others
• sql server

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

• dynamics ax
• others
• sql server

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

• dynamics ax
• sql server

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)”

• dynamics ax
• sql server

What is the difference between replication and mirroring in SQL Server 2008

• sql server