During a normal implementation, customers using the Inventory module are faced with testing numerous transaction scenarious prior to going live with their Dynamics GP system. However, the conversion to the live company requires transfering the Inventory Master tables, including the Item Quantity Master (IV00102) table. This table hosts the Quantity On Hand and Quantity Available fields per site which can already be affected by the transactions previously tested.
In order to reset the values in these fields without any SQL query involved (ok, not completely), you can try this simple solution: create a physical count for all items!
1) Create a stock count schedule for all items. Go to Transactions > Inventory > Stock Count Schedule. Enter a Stock Count ID, i.e., CLRQTYS.
2) Mass Add all items in your inventory by any criteria
3) Start the count by clicking on the Start button. Close the Stock Count Schedule window.
NOTE: you can choose to uncheck the Reuse Stock Count checkmark.
4) Open the Stock Count Entry window. Go to Transactions > Inventory > Stock Count Entry. Mark all items as counted without entering any values (they are automatically defaulted to zero).
NOTE: If the company has a great number of products, the items can be marked as counted with the following SQL script
declare @stockcountID char(20)
set @stockcountID = 'CLRQTYS' -- replace for the actual stock count you createdupdate IV10300
set ATPSTVRNC = 1 where stckcntid = @stockcountID
update IV10301 set VERIFIED = 1 where stckcntid = @stockcountID5)
Post the count.
Click on the Process button to process and post the count.Now you are good to transfer your Inventory Master tables!
6/4/08
Wipe Blackberry using OS command
Wipe using OS command
You can do a limited wipe (of data only–not applications or the OS) by doing Options > Security Options > General Settings > (press Menu key) > Wipe Handheld.
You are warned before proceeding that you will lose all your application data, and that message services will be turned off. You have a choice of not wiping data for your custom (3rd party) applications by clicking a checkbox. Click the Continue button to proceed or Escape to cancel.
To make sure you really want to do this, you are forced to type the word blackberry and press Enter to proceed. Then you will see a progress bar showing how complete the wipe process is.
The phone will reboot (reset) itself. Before you can make a phone call or send/receive messages, you will active to restore your connections. The simplest way is to attempt to dial a number and you will be guided to do that.
Enter wrong password 10 times
I don’t really recommend this because it’s just silly, but you might want to know what this is about. If you set a password on your BlackBerry (Options > Security Options > General Settings > Password: Enabled), and if you enter the wrong password 10 times in a row, your BlackBerry will wipe its data. Why? If someone finds/steals your phone and attempts to crack the password, then your Address Book, messages, etc. cannot be read. This is a built-in security measure, especially for corporate or government users.
You can do a limited wipe (of data only–not applications or the OS) by doing Options > Security Options > General Settings > (press Menu key) > Wipe Handheld.
You are warned before proceeding that you will lose all your application data, and that message services will be turned off. You have a choice of not wiping data for your custom (3rd party) applications by clicking a checkbox. Click the Continue button to proceed or Escape to cancel.
To make sure you really want to do this, you are forced to type the word blackberry and press Enter to proceed. Then you will see a progress bar showing how complete the wipe process is.
The phone will reboot (reset) itself. Before you can make a phone call or send/receive messages, you will active to restore your connections. The simplest way is to attempt to dial a number and you will be guided to do that.
Enter wrong password 10 times
I don’t really recommend this because it’s just silly, but you might want to know what this is about. If you set a password on your BlackBerry (Options > Security Options > General Settings > Password: Enabled), and if you enter the wrong password 10 times in a row, your BlackBerry will wipe its data. Why? If someone finds/steals your phone and attempts to crack the password, then your Address Book, messages, etc. cannot be read. This is a built-in security measure, especially for corporate or government users.
Subscribe to:
Posts (Atom)