Omar H. Kloub

Microsoft Dynamics GP Session

2011-01-01T18:22:00.001+02:00

I am pleased to announce that on Wednesday 5th Jan, me and my colleague Mohammad will have a Microsoft Dynamics GP Session (Location the session), Starting from 6:30 till 8:30 as a part of Microsoft Dynamics GP community in Jordan.

The session will handle Introduction and extending Dynamics GP (I am sure it will be interesting )

You are all welcome to join us.

For more information , please pay a visit to here or you can contact both of us me or Mohammad if you have any inquiries.

Journal Entry (number) has been entered in another window

2010-12-30T10:34:00.001+02:00

Unfortunately long time no posts , been really busy lately and as you know it is year end for most of the clients here.

Any way I faced this case , and I searched for a solution , but what I found did not help me to be honest, I solved the case another way around, and here are the details:

The case started when Windows stuck and Dynamics GP was opened on General Ledger Windows while creating a General Journal with MDA, After restart the user tried to retrieve the Journal but an error massage appeared :

So the proposed solutions I found were the following :

Solution 1:

Article # (863850) in the knowledge base is talking about it but I saw it kinda hard (Maybe I am lazy )

Solution 2:

Clear the following table after all Dynamics GP users logged out:

Dynamics –> (Activity , SY00800 and SY00801)
Tempdb –> (Dex_Lock and Dex_Session)

This solution did not solve my issue.

Solution 3 (This is what I did) :

I updated the missing required fields in GL10000 for that Journal and opened it from Dynamics then deleted it as a normal deletion.

I saw this easier and hope some one gets benefit from it

Until next post

How easy to unlock the iPhone

2010-12-06T23:47:00.001+02:00

Lol , check my 16 months kid how he unlocked the iPhone

iPhone unlock warning using redsn0w then ultrasn0w

2010-11-29T16:33:00.003+02:00

Hello again ,
I am following up regarding iPhone new basebands unlock, please read the below carefully.
First of all this article is really important for people who rely on unlock. if you don’t rely on that you can skip this page.
I will start from the beginning , the below table explains iPhone firmware versions with there baseband versions and if they are unlock able

iPhone Firmware	Related baseband	Is it unlocked
4.0.1	05.13.04	Yes
4.0.2	05.13.04	Yes
4.1	05.14.XX	No
4.2.1	05.15.XX	No

So what shall I do if I am stuck in 05.14.XX or 05.15.XX ?
The solution were found by Dev Team in there newest post. and it is like workarround , you will update your iPhone baseband to iPad (3.2.2) baseband which is unlock able. so the above table will look like the below :

iPhone Firmware	Related baseband	Is it unlocked
4.0.1	05.13.04	Yes
4.0.2	05.13.04	Yes
4.1	05.14.XX	No
4.2.1	05.15.XX	No
Your current Firmware	06.15.XX	Yes

So why should I pay attention ?
You should pay attention because even you will have an unlocked iPhone but you will lose the following :

Your iPhone warranty , it will be clearly Jailbroken because the baseband version will never be hidden.
You can not update to any Apple firmware if it has lower baseband than 06.15 unless it was prepared (cooked) with redsn0w.

for more info and tutorials , please pay a visit to iClarified.
That is it till now .

Integration Manager , eConnect and Dynamics GP Purchase Orders

2010-11-14T17:19:00.001+02:00

Hello,

Today , I have faced this new issue while I was trying to import Purchase Orders to Dynamics using Integration Manager and eConnect.

After solving some issues with the connection , date…etc purchase orders were imported to Dynamics GP, but guess what … no taxes were imported. I searched for a Tax fields in the integration Manager but did not find any … and I would love to have any comments telling where can I find such information to map. (By the way I riffled the sample data text file in the Samples folder)

So here is what I did to solve it after importing the POs.

Update the tax details per line item using SQL.
Run a macro to recalculate the tax on Dynamics Purchase Orders Window.

SQL scripts will be provided.

Copy Company and Don’t really know what is the issue SQL I/O error…etc.

2010-11-12T01:18:00.001+02:00

Hello there ,

I have faced a new issue and to be honest I don’t know what exactly was the reason. and I am not sure if it is really related to my article.

The issue started when I run inventory reconcile and the little reconcile window just freeze without even Not responding (Dynamics was working normally if you retrieve date) , so I thought check links may solve it. but even check links window acted the same.

by the way this company was created normally, use copy company and run the script in the above article.

I don’t know how but an idea just came to my mind , I run (Select * from IV00102) , SQL started to run and then woops SQL I/O error…etc

(I will try to re-create the case and provide screen shots and the exact error massage)

Any way not to make it long , this is the case I faced and the solution was to drop and create Item master quantity table from Dynamics.

Again I don’t know exactly what was the reason.

I will test the script again above, and fix it if it needs.

Before I go , one more thing to add , all items quantities were ZERO, not even one transaction.

Dynamics GP 10.0 creates empty and clear budget

2010-11-07T11:26:00.000+02:00

Hello ,

Yup long time no posts , been really very busy lately but I found this case and it was interesting to be posted, after I spent some time looking and searching here and there for answers with this issue with no answers around.

The issue occurred when my client tried to import Dynamics GP budget to Microsoft Excel, the out put was like an empty budget , it creates the layout , headers …etc. but there are no accounts or even value.

The computer region and language settings was like :

The format was in Arabic but the settings were customized to have English numbers, dates...etc.

The solution was simple although it was discovered by (mmm) luck or try and try again if it doesn’t solve it, I Just change the format to English

Notes:

The Arabic format was changed and modified to have the original English format, even this did not work.

I shared it , just because I don’t want any one to waste time with really simple undiscoverable issue.

iPhone 4.1 firmware Critical bug found…

2010-10-25T23:35:00.001+03:00

Just now , I was working and thought to give it a break by reading the RSS feeds , I read a funny news as if you allow me to call.

A bug was found in iPhone 4.1 firmware , that bug simply allow you to make a phone call with any of the already saved phone contacts , and yup that is true… for me it is LOLOLOLOL…

Check the following link and video.

The thing which makes me really wonder , how did that guy or who ever he/she is discover that .

New Jailbreak was released by Geohot

2010-10-11T16:28:00.001+03:00

A new Jailbreak was released by Geohot called Limera1n , this will Jailbreak all iPhones.

For more information and support , please pay a visit to Dev-Team Blog.

Edit: A bit more information :

The new jailbreak applies only for 3GS and 4G.
Below are table for iPhone models , firmware versions and best way to jailbreak and unlock.

iPhone Model	Firmware	How to Jailbreak	How to unlock
3G	3.1.3	Spirit	Ultransn0w
	4.0 , 4.0.1	Jailbreak me.com	Ultransn0w
	4.0.2	Redsn0w	Ultransn0w
	4.1 If you rely on unlock DON’T update.	Redsn0w (Mac Only)	No Unlock
3GS	3.1.3	Spirit	Ultransn0w
	4.0 , 4.0.1	Jailbreak me.com	Ultransn0w
	4.0.2	Redsn0w (Mac Only)	Ultransn0w
	4.1 If you rely on unlock DON’T update.	Limera1n	No Unlock
4G	4.0 , 4.0.1	Jailbreak me.com	Ultransn0w
	4.0.2	Redsn0w (Mac Only)	Ultransn0w
	4.1 If you rely on unlock DON’T update.	Limera1n	No Unlock

Important Notes :

If you have iPhone 4G and you rely on Unlock , you can update iPhone firmware to 4.1 without updating the baseband by using Tinyumbrella.
For 3G 4.0.1 is the best option.

Another New Certificates

2010-10-05T20:26:00.001+03:00

Today me and 2 Muhannads (My colleagues) Muhannad Daoud (Yes Mohammad R. Daoud brother) and Muhannad Assaf , went again to the training center to give it a shot for more Microsoft Certificates (Dynamics GP 10.0 Installation and Configurations & Managing Microsoft Dynamics Using Sure Step Methodology), and Gratz for the two they both did it (and me :P).

Any way big Gratz for Muhannad Daoud he passed his first Certificate with 100% mark. (I saw him eating the books and the manuals by the way).

Good to have such certificates and go forward for more.

New Exam Certificates

2010-10-03T22:36:00.001+03:00

Before few two days or so , me , Mohammad and Nancy decided to take a shot with “Managing Microsoft Dynamics Using Sure Step Methodology” , so today we went to the training center and woops.

To be honest as Mohammad mentioned , it was a nice new experience with those kinds of questions , we all passed.

I would like to thumb up both for the results especially Nancy , who got the highest mark (98%). and one more thing Nancy , Next time if i try to cheat don’t tell me SHSHSHSHSHSHSHSH , since Microsoft has a methodology in projects implementations to make them easier to manage , i have also mine in exams to make them easier to pass :) .

Fixed Assets History Report (Version 2)

2010-09-30T09:30:00.002+03:00

After my post Fixed Assets History Report , I have re-created the view trying to be more efficient and here you go :
SELECT     dbo.FA00100.ASSETINDEX, dbo.FA00100.ASSETID, dbo.FA00100.ASSETDESC, dbo.FA00100.ASSETCLASSID, dbo.FA00100.ACQDATE,
                      dbo.FA00100.Acquisition_Cost, dbo.FA00902.BOOKINDX, dbo.FA00902.GLINTBTCHNUM, dbo.GL20000.JRNENTRY, dbo.FA00902.AMOUNT,
                      dbo.FA00902.TRANSACCTTYPE, dbo.FA00902.SOURCDOC, dbo.PM00200.VENDNAME, dbo.FA01400.VENDORID, dbo.GL20000.TRXDATE,
                      dbo.FA00902.FAYEAR, dbo.FA00902.FAPERIOD
FROM         dbo.FA00100 INNER JOIN
                      dbo.FA00902 ON dbo.FA00100.ASSETINDEX = dbo.FA00902.ASSETINDEX INNER JOIN
                      dbo.GL20000 ON dbo.FA00902.GLINTBTCHNUM = dbo.GL20000.ORGNTSRC AND dbo.FA00902.GLINTACCTINDX = dbo.GL20000.ACTINDX INNER JOIN
                      dbo.FA01400 ON dbo.FA00100.ASSETINDEX = dbo.FA01400.ASSETINDEX INNER JOIN
                      dbo.PM00200 ON dbo.FA01400.VENDORID = dbo.PM00200.VENDORID
WHERE     (dbo.FA00902.BOOKINDX =
                          (SELECT     CORPBOOKINDX
                             FROM         dbo.FA49900)) AND (dbo.FA00902.GLINTBTCHNUM IS NOT NULL) AND (dbo.FA00902.AMOUNT > 0)

Hope that helps

Edit : I thought that i should also post the conditions and some more explanations :

If you summarize the financails from fixed assets this SQL script will not work.
Some fileds are missing comparing to the below first script , like Assets Class Description.
GL posting from Fixed Assets and Posting Fixed Assets Journals from GL should be performed (2 Posts should be completed before running the script. other wise records will not be retrieved.)
As Mark mentioned, is it "problematic" .

Dynamics GP Copy Company Tool

2010-09-27T08:50:00.001+03:00

After i have created a new Dynamics GP Company , i used The Copy Company Tool , which copies master files and setup tables from an old company to a new one as below. (It seems i just discovered something now while trying to capture a screen shot , As i can see it doesn’t detect 64 Bit ODBC i am running Windows 7 64 which i use for Dynamics GP, you should define normal ODBC) .

After running through the process everything went smoothly , I logged to Dynamics GP and Opened Inquiry –> Inventory –> Item. I found some quantities there . It seems it just copied the tables fields, So directly i run a Inventory reconcile but quantities are still there . weird isn’t it ?

Note : I only run reconcile on Inventory and it didn’t work, so you better try to reconcile the others first.

Any way , i created SQL scripts for resetting and below they are :

AR Reset Script	AP Reset Script
UPDATE [TWO].[dbo].[RM00103] SET [CUSTBLNC] = 0 ,[AGPERAMT_1] = 0 ,[AGPERAMT_2] = 0 ,[AGPERAMT_3] = 0 ,[AGPERAMT_4] = 0 ,[AGPERAMT_5] = 0 ,[AGPERAMT_6] = 0 ,[AGPERAMT_7] = 0 ,[LPYMTAMT] = 0 ,[LSTTRXAM] = 0 ,[LSTFCHAM] = 0 ,[UPFCHYTD] = 0 ,[TDTKNYTD] = 0 ,[TDTKNLYR] = 0 ,[TDTKNLTD] = 0 ,[TDISAYTD] = 0 ,[RETAINAG] = 0 ,[TNSFCYTD] = 0 ,[UNPSTDSA] = 0 ,[UNPSTDCA] = 0 ,[UNPSTOSA] = 0 ,[UNPSTOCA] = 0 ,[NCSCHPMT] = 0 ,[TTLSLYTD] = 0 ,[TTLSLLTD] = 0 ,[TTLSLLYR] = 0 ,[TCOSTYTD] = 0 ,[TCOSTLTD] = 0 ,[TCOSTLYR] = 0 ,[TCSHRYTD] = 0 ,[TCSHRLTD] = 0 ,[TCSHRLYR] = 0 ,[TFNCHYTD] = 0 ,[TFNCHLTD] = 0 ,[TFNCHLYR] = 0 ,[FNCHCYTD] = 0 ,[FNCHLYRC] = 0 ,[TBDDTYTD] = 0 ,[TBDDTLYR] = 0 ,[TBDDTLTD] = 0 ,[TWVFCYTD] = 0 ,[TWVFCLTD] = 0 ,[TWVFCLYR] = 0 ,[TWROFYTD] = 0 ,[TWROFLTD] = 0 ,[TWROFLYR] = 0 ,[WROFSLIF] = 0 ,[WROFSLYR] = 0 ,[WROFSYTD] = 0 ,[HIBALLYR] = 0 ,[HIBALYTD] = 0 ,[HIBALLTD] = 0 ,[LSTSTAMT] = 0 ,[ONORDAMT] = 0 ,[TTLRTYTD] = 0 ,[TTLRTLTD] = 0 ,[TTLRTLYR] = 0	UPDATE [TWO].[dbo].[PM00201] SET [HIESTBAL] = 0 ,[CURRBLNC] = 0 ,[NOINVYTD] = 0 ,[NOINVLIF] = 0 ,[NOINVLYR] = 0 ,[NOPINYTD] = 0 ,[NOPILIFE] = 0 ,[AMBLDTYD] = 0 ,[AMBLDLIF] = 0 ,[AMBLDLYR] = 0 ,[AMTPDYTD] = 0 ,[AMTPDLIF] = 0 ,[AMTPDLYR] = 0 ,[TEN99AYTD] = 0 ,[TEN99ALIF] = 0 ,[TEN99ALYR] =0 ,[DISAVYTD] = 0 ,[DISAVLIF] = 0 ,[DISAVLYR] = 0 ,[DISTKYTD] = 0 ,[DISTKNLF] = 0 ,[DISTKLYR] = 0 ,[DISLSYTD] = 0 ,[DISLSTLF] = 0 ,[DISLSLYR] = 0 ,[FINCHLIF] = 0 ,[FINCHLYR] = 0 ,[FINCHYTD] = 0 ,[WROFSYTD] = 0 ,[WROFSLIF] = 0 ,[WROFSLYR] = 0 ,[RTRNSYTD] = 0 ,[RTRNSLIF] = 0 ,[RTRNSLYR] = 0 ,[TRDTKLIF] = 0 ,[TRDTLYR] = 0 ,[TRDTYTD] = 0 ,[NFNCHLIF] = 0 ,[NFNCHLYR] = 0 ,[NFNCHYTD] = 0 ,[RTNGOWED] = 0 ,[LSTCHAMT] = 0 ,[LSTINVAM] = 0 ,[CURUNPBN] = 0 ,[UNPDFNCH] = 0 ,[DYCHTCLR] = 0 ,[AVGDTPYR] = 0 ,[AVDTPLIF] = 0 ,[ACCRDINV] = 0 ,[ONORDAMT] = 0 ,[WITHYTD] = 0 ,[WITHLYR] = 0
BR Reset Script	INV Reset Script
UPDATE [TWO].[dbo].[CM00100] SET [Last_Reconciled_Balance] = 0 ,[CURRBLNC] = 0 ,[Reconcile_In_Progress] = 0 ,[Deposit_In_Progress] = 0 ,[ADPVADLR] = 0	Update IV00102 Set [QTYRQSTN] = 0 ,[QTYONORD] = 0 ,[QTYBKORD] = 0 ,[QTY_Drop_Shipped] = 0 ,[QTYINUSE] = 0 ,[QTYINSVC] = 0 ,[QTYRTRND] = 0 ,[QTYDMGED] = 0 ,[QTYONHND] = 0 ,[ATYALLOC] = 0 ,[QTYCOMTD] = 0 ,[QTYSOLD] = 0 ,[LSORDQTY] = 0 ,[LRCPTQTY] = 0

Hope that helps

Edit : Please refer to This, it is so important to read.

Dynamics GP Utilities hang up while trying to update some companies

2010-09-23T08:18:00.001+03:00

Before few days , I have received an issue which needed to be solved.The issue was Dynamics GP utilities hang up while trying to update companies as below screenshot shows .

After running the SQL profiler , Dynamics GP was like going into infinite loop or something like that looking for those databases which actually are not exist. The issue started by deleting some companies in Dynamics and the SQL databases , but for some reason records were available in dbo.dynamics.db_upgrade.

So to solve the issue , just delete those records in db_upgrade which related to already deleted companies or databases.

Hope that helps.

Fixed Assets History Report

2010-09-23T00:07:00.002+03:00

As we all know , after you do the year end closing to Fixed Assets in Dynamics the automatic printed report can’t be re-printed.
so i have tried to create some sort of SQL script to retrieve a detailed data for the Assets Depreciation (Asset ID , Asset Description , Year , Period , Depreciation General Journal Number , General Journal Date , Vendor ID , Vendor Name (If the asset was purchased of course) . Purchase document number ,..etc) i did that although it has some limitations which are :

It only applies for cooperate book which is in the Fixed Assets Company Setup.
Transactions should be posted from Fixed Assets to General Ledger and posted from General Ledger .
If summarize financial process for a specific year , this year transactions will not appear for sure.
If the automatic created fixed assets general journal batch changed in General Ledger it will not be detected in the query.
This query detects depreciation journals only (Can be modified by removing filters).

~~The query will be posted tomorrow , after testing.~~
Edit : This is the script
USE [TWO] GO /****** Object: View [dbo].[FIXED_ASSETS_HISTORY] Script Date: 09/23/2010 06:53:38 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER VIEW [dbo].[FIXED_ASSETS_HISTORY] AS SELECT dbo.FA00100.ASSETINDEX AS [Asset Index], dbo.FA00100.ASSETID AS [Asset ID], dbo.FA00100.ASSETDESC AS [Asset Description], dbo.FA00902.BOOKINDX, dbo.FA00902.FAYEAR AS Year, dbo.FA00902.FAPERIOD AS Period, dbo.FA01400.Acquisition_Cost AS [Acquisition Cost], dbo.FA00902.AMOUNT AS Amount, dbo.FA00902.SOURCDOC, dbo.GL20000.JRNENTRY AS [Journal Entry Number], dbo.GL20000.TRXDATE AS [Journal Entry Date], dbo.FA01400.VENDORID AS [Vendor ID], dbo.PM00200.VENDNAME AS [Vendor Name], dbo.FA00902.TRANSACCTTYPE, dbo.FA00902.GLINTBTCHNUM AS [General Ledger Batch Number], dbo.FA40201.ASSETCLASSIDDESC AS [Asset ClassDescription], dbo.FA00100.ACQDATE AS [Acquisition Date], dbo.FA00100.ASSETCLASSID AS [Asset Class ID] FROM dbo.FA00100 INNER JOIN dbo.FA00902 ON dbo.FA00100.ASSETINDEX = dbo.FA00902.ASSETINDEX INNER JOIN dbo.FA40201 ON dbo.FA00100.ASSETCLASSID = dbo.FA40201.ASSETCLASSID LEFT OUTER JOIN dbo.GL20000 ON dbo.FA00902.GLINTBTCHNUM = dbo.GL20000.ORTRXSRC LEFT OUTER JOIN dbo.FA01400 ON dbo.FA00100.ASSETINDEX = dbo.FA01400.ASSETINDEX LEFT OUTER JOIN dbo.PM00200 ON dbo.FA01400.VENDORID = dbo.PM00200.VENDORID RIGHT OUTER JOIN dbo.FA00400 ON dbo.GL20000.ACTINDX = dbo.FA00400.DEPREXPACCTINDX AND dbo.FA00100.ASSETINDEX = dbo.FA00400.ASSETINDEX WHERE (dbo.FA00902.BOOKINDX = (SELECT CORPBOOKINDX FROM dbo.FA49900)) AND (dbo.FA00902.GLINTBTCHNUM IS NOT NULL) AND (dbo.FA00902.TRANSACCTTYPE = 2)
So you can do the math on Crystal Report to calculate depreciation amount for an asset or asset class for a year …etc , accumulated deprecation till specific period , Netbook value …etc
Hope this helps.

Thank you Mohammad

2010-09-14T23:13:00.002+03:00

This is a special thanks for my colleague Mohammad R. Daoud for supporting my new blog.

Thanks again Mohammad.

Don’t marry a Software Engineer… :x

2010-09-14T16:01:00.001+03:00

If you want to marry a Software Engineer , You should read this before :

Husband: (Get home late from office) Good night darling, I am now logged in
Wife: Do you bring the souvenirs that I asked you?
Husband: Bad command or filename

Wife: But I already told you this morning!
Husband: Syntax error. Abort?

Wife: Then, how about to buy a new television?
Husband: Variable not found…

Wife: Ok then, if that so, I want your credit card. I would like to go shop alone.
Husband: Sharing violation. Access denied…

Wife: Do you love computer more than me? Or you just play joke with me?
Husband: Too many parameters…

Wife: It’s a big mistake to married with an idiot person like you.
Husband: Data type mismatch.

Wife: You are useless.
Husband: It’s by default

Wife: How about your wages?
Husband: File in use … Please try again later.

Wife: If that so, what is my position in this family !!!???
Husband: Unknown virus…

Manual Payment : Cash account is missing

2010-09-14T09:21:00.002+03:00

While i was browsing Dynamics GP forum , a question was asked “ In Manual Payment module the bank account distribution is not automatically appearing on the distribution ” , in other words , Why is the Cash account in the Manual Payment Distribution is Empty even the Checkbook is linked to a General Ledger Account (since that filed is required) ?
The Question is screenshot :
It shows the Checkbook Account is linked already with General Ledger Account.
The same checkbook was selected.
The account is missing in the Manual Payment Distribution Window.

How to Solve it :

Be sure NOT to select Cash Account from Vendor and leaves the Cash Account Blank as below :

Please read below paragraph as it was taken (Copy and Paste) from Dynamics GP Help :
“
Use Cash Account From
Mark Checkbook or Vendor to indicate the Cash account you use most often for this vendor's transactions. If you mark Vendor, enter the Cash account for the vendor in the Cash field. If you mark Checkbook, the Cash account assigned to the checkbook you used for the transaction appears as the default account.
If you use Bank Reconciliation, we recommend you use the Cash account from the checkbook so you can easily reconcile the Cash account for a checkbook entered in the Checkbook Maintenance window to the Cash account balance in General Ledger.
If you are using European Electronic Funds Transfers, the cash in transit account assigned to the checkbook is used, regardless of which option is marked in this field
“
Even if you select the above (Not recommended) , and the Cash Accounts in the Posting Account –> Purchasing was filled up , Dynamics GP will FILL up the Cash Account in the Manual Payment Distribution.

So to have an Empty Cash Account in the Manual Payment Distribution Entry 2 conditions should be true.

Select Cash account from vendor accounts and the cash account should be blank.
Cash account in the Purchasing posting account should be blank.

Hope this helps

Edit : If the above is not working , please check and complete Payment Document Management setup

Checkbook Balance Inquiry

2010-09-05T17:32:00.001+03:00

An e-mail was received with only the below screen shot (Screenshots were recreated on a Fabrikam Inc.) for testing and for this post)

Three things were found in this screen shot :

Since in the Checkbook Setup , every checkbook is linked to one General Ledger Account , Current Checkbook Balance and Current Account Balance fields should be matched but they are not.
The Checkbook Balance after the first transaction is not correct.
The totals for the transactions in not correct it should be 1300 (As per screen shot above)

After searching and looking inside , reason for the above case was found , updating CURRBLNC field in CM00100 directly by SQL script , 3rd party product…etc , and it seems the form above taking as “Copy and Paste” the currblnc field and do the math for the transactions total if they match then no problem everyone is happy , but if not it will adjust the first transaction balance.
Hope this helps.

A good question : How can i know if my iPhone is factory unlocked or not ?

2010-09-04T18:21:00.001+03:00

A friend of mine called me , he got an 3Gs iPhone used one with 16 GB.

The phone was JB with spirit since it has 3.1.3 Firmware. (most probably) , and he wanted to reset it to factory settings ,the answer was NO, Don’t do that because you don’t know the origin for the iphone.

Explanation :

If you don’t have the official sim carrier and your iphone is NOT a factory unlocked , your little toy will lock and since there is no hactivation tool for 3Gs new bootroom and you will through it to the Oops (Garbage).

So How can i know from where my Iphone came from and is it factory unlocked or not ?

This is the How to :

Go to Settings –> General –> About
Scorlldown for Model as below screenshot and get the number :

Search for your model number in the below list :

Belgium, Mobistar ————————— MB489NF/A MB496NF/A MB500NF/A MC131NF/A MC132NF/A MC133NF/A MC134NF/A	CzechRepublic, O2 ————————— MB489CZ/A MB496CZ/A MB500CZ/A MC131CZ/A MC132CZ/A MC133CZ/A MC134CZ/A	CzechRepublic, T-Mobile ————————— MB490CZ/A MB497CZ/A MB501CZ/A MC139CZ/A MC140CZ/A MC141CZ/A MC142CZ/A
Greece, Vodafone ————————— MB489GR/A MB496GR/A MB500GR/A MC131GR/A MC132GR/A MC133GR/A MC134GR/A	Hong Kong, 3 ————————— MB489ZP/A MB496ZP/A MB500ZP/A MC131ZP/A MC132ZP/A MC133ZP/A MC134ZP/A	Italy, TIM ————————— MB489T/A MB496T/A MB500T/A MC131T/A MC132T/A MC133T/A MC134T/A
Macau, 3 ————————— MB489ZP/A MB496ZP/A MB500ZP/A MC131ZP/A MC132ZP/A MC133ZP/A MC134ZP/A	New Zealand, Vodafone ————————— MB489X/A MB496X/A MB500X/A MC131X/A MC132X/A MC133X/A MC134X/A	Singapore, SingTel ————————— MB489ZA/A MB496ZA/A MB500ZA/A MC131ZA/A MC132ZA/A MC133ZA/A MC134ZA/A
Saudi Arabia, Mobily ————————— MB489AB/A MB496AB/A MB500AB/A MC131AB/A MC132AB/A MC133AB/A MC134AB/A	UAE, etisalat ————————— MB489AB/A MB496AB/A MB500AB/A MC131AB/A MC132AB/A MC133AB/A MC134AB/A	South Africa, Vodacom ————————— MB489SO/A MB496SO/A MB500SO/A MC131SO/A MC132SO/A MC133SO/A MC134SO/A
Turkey, TurkCell ————————— MB489TU/A MB496TU/A MB500TU/A MC131TU/A MC132TU/A MC133TU/A MC134TU/A	Russia, MegaFon ————————— MB489RS/A MB496RS/A MB500RS/A MC131RS/A MC132RS/A MC133RS/A MC134RS/A	Russia, MTS ————————— MB489RS/A MB496RS/A MB500RS/A MC131RS/A MC132RS/A MC133RS/A MC134RS/A
Luxembourg, Vox Mobile ————————— MB489NF/A MB496NF/A MB500NF/A MC131NF/A MC132NF/A MC133NF/A MC134NF/A	Luxembourg, LUXGSM ————————— MB489FB/A MB496FB/A MB500FB/A MC131FB/A MC132FB/A MC133FB/A MC134FB/A	Usa , AT&T ————————— MC126LL/A MC137LL/A MC150LL/A MC161LL/A MC167LL/A MC178LL/A MC185LL/A
Luxembourg, Tango ————————— MB489FB/A MB496FB/A MB500FB/A MC131FB/A MC132FB/A MC133FB/A MC134FB/A	Russia, Beeline ————————— MB489RS/A MB496RS/A MB500RS/A MC131RS/A MC132RS/A MC133RS/A MC134RS/A	Taiwan,Chunghwa Telecom ————————— MB489TA/A MB496TA/A MB500TA/A MC131TA/A MC132TA/A MC133TA/A MC134TA/A
Slovakia, Orange ————————— MB489SL/A MB496SL/A MB500SL/A MC131SL/A MC132SL/A MC133SL/A MC134SL/A	Italy, Vodafone ————————— MB489T/A MB496T/A MB500T/A MC131T/A MC132T/A MC133T/A MC134T/A	CzechRepublic, Vodafone ————————— MB489CZ/A MB496CZ/A MB500CZ/A MC131CZ/A MC132CZ/A MC133CZ/A MC134CZ/A
Jordan ,Orange —————————MB489AB/A MB496AB/A MB500AB/A MC131AB/A MC132AB/A MC133AB/A MC134AB/A	UAE, DU —————————MB489AB/A MB496AB/A MB500AB/A MC131AB/A MC132AB/A MC133AB/A MC134AB/A	Egypt,Mobnil —————————MB489AB/A MB496AB/A MB500AB/A MC131AB/A MC132AB/A MC133AB/A

After determining the country , Go to apple website : (http://support.apple.com/kb/HT1937).
Select the region and look for Locked to carrier field .

Note : Some Countries and Carries may have same model number.

Hope this helps

Voiding Accounts Payables Payment

2010-08-29T10:25:00.002+03:00

Hello ....
I have recieved this case and thought it worth it to be posted.
Below screen shots are example for the case.

One of Clients sent me the following screen shots :

finally

The question was How can a Manual Payment appear as an open transaction in Accounts Payables Transactions Inquiry screen in the same time it appears as a voided transaction in Checkbook Register Inquiry , also if you zoom the transaction it appears like any normal transaction.

I have searched for the answer a lot here and there until it came to my mind another question , Can i void a Manual Payment from Bank transaction screen ? , unfortunately the answer is YES.
Although Dynamics GP gives you a warning massage as below , but what can you do if Dynamics GP users is kind of sleepy head ? and press yes without even read the massage ?

In the other hand , I am wondering is there any business case can may lead to do create such kind of void ???

KeepAwake

2010-08-28T02:20:00.000+03:00

As all we know , new iPhone jailbreak was released with a very nice idea which is web based.
Any way after jailbreaking as usual we go to Cydia install needed tools and programs.
One of them is KeepAwake which keeps the iPhone wifi working while it is locked.
If you search for it directly you will not find it as what happened with me , it seems the repo was removed from Cyndia as a default installed one because i didn't need to do that with 3.1.3

Any way to add the repo related and install KeepAwake ,find the below How to :

Go to Cydia -> Sections -> Scroll down for Repositories

2. Search for iSpazio

3. Now you can search again for KeepAwake

Finally you can install it .

iPhone

2010-08-27T18:50:00.000+03:00

This label will contain some article ,tips, news and useful information about iPhone

Welcome

2010-08-27T18:48:00.003+03:00

Welcome ...
First i would like to welcome all visitors for this Blog , wishing that beneficial knowledge and information can be found here.
I will start soon posting on my blog , but as knows Layouts takes time to be finalized trying to make it easy to for browsing searching ...etc.

~~That means it is~~ ~~still under construction...~~

Update : This blog is live now