Author Archive:

rss feed

Historical Stock Status Script

| 04/22/2013 | 0 Comments
Historical Stock Status Script

We been suffering from Historical Stock Status report issues when it comes to customers with big inventory transactions, I am providing a script that recalculate the historical stock status for your items based on the IV10200 and IV10201 tables, it will allow you to estimate your inventories using a historical date: Historical Stock Sttus Summary DECLARE @ASOFDATE DATETIME SET @ASOFDATE = ’2016-12-31′   SELECT ITEMNMBR AS Item Number , TRXLOCTN AS Location , SUM ( Quantity ) AS Quantity , SUM ( Extended Cost ) AS Total Cost   FROM   ( SELECT ITEMNMBR ,   ( dbo . IV10200 .

Continue Reading

Dynamics GP 2013 MVP

| 04/16/2013 | 0 Comments

In April 1st I got a mail from Microsoft telling me that I got a new MVP for 2013! That was a great news to hear but wanted to postpone publishing the announcement before getting the below!

Continue Reading

Installing SQL Failover Clustering Without SAN Storage – Windows 2008 R2

| 02/26/2013 | 0 Comments
Installing SQL Failover Clustering Without SAN Storage – Windows 2008 R2

It always been hard to test out the failover clustering as it requires SAN Storage device to be connected and requires many servers for testing. This morning I have seen an interesting article in the community the Microsoft has released “Microsoft iScsi Software Target” free of charge, by using the utility you can create a storage and share it across multiple servers, “fooling” the windows to think that a SAN Storage is available

Continue Reading

LinkedIn

| 02/21/2013 | 0 Comments

As many of you might notice that Linked In is celebrating their 200,000,000 users and started sending thanks for people who help spreading their name! They have ranked their users per the the viewing of their profile, so you either be one of the top 1% most viewer profiles, 5% or 10%. I made the 5% List! Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 me@mohdaoud.com http://www.di.jo

Continue Reading

How to Track unused Journal Numbers

| 02/17/2013 | 0 Comments
How to Track unused Journal Numbers

I got an interesting question from one of the GP users requesting a list of unused Journal Number, therefore I decided to scratch my head and write this query, below will help: SELECT DISTINCT NUMBER FROM MASTER..spt_values WHERE NUMBER BETWEEN (SELECT MIN(JRNENTRY) AS FROMNUMBER FROM (SELECT DISTINCT JRNENTRY FROM GL20000) AS JOURNALS) AND (SELECT MAX(JRNENTRY) AS TONUMBER FROM (SELECT DISTINCT JRNENTRY FROM GL20000) AS JOURNALS) AND number NOT IN (SELECT DISTINCT JRNENTRY FROM GL20000) Happy tracking…! Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 me@mohdaoud.com http://www.di.jo

Continue Reading

Dynamics GP Excel Paste V 4.0

| 01/28/2013 | 0 Comments
Dynamics GP Excel Paste V 4.0

We have finally released and uploaded a new version for the Excel Paste, this one has the following coverage: 1. The major move was the ability to integrate into multiple products, like combining the GL Transaction Entry with the Analytical Accounting

Continue Reading

Dynamics GP 2013 Demo Image

| 01/19/2013 | 0 Comments
Dynamics GP 2013 Demo Image

Yes it has been released, Microsoft team is doing everything fast in relation to GP 2013! take a look into the following article: http://blogs.msdn.com/b/gp/archive/2013/01/15/where-s-the-demo-image-here-today.aspx Regards, — Mohammad R.

Continue Reading