tag:blogger.com,1999:blog-32133665318876541922024-03-14T22:50:48.613-07:00Dynamics GP - Knowledge ShareSandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.comBlogger40125tag:blogger.com,1999:blog-3213366531887654192.post-38077197297053454622015-07-28T09:01:00.000-07:002015-07-28T09:01:40.989-07:00Delete/Unassigned bulk items from Sites or Assign bulk Items to Sites<div style="text-align: justify;">
<br /></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;">Few days before I was having client requirement to
unassigned around 50K + items from specific sites. There were several help
available on web one of is from MVP Mohood (<a href="http://mahmoudsaadi.blogspot.com/2013/11/delete-item-site-assignment.html">http://mahmoudsaadi.blogspot.com/2013/11/delete-item-site-assignment.html</a>)
. I followed his sql query to delete all those items from sites.<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<br />
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;">But recently I found new feature in Dynamics GP 2013. From Navigation-->Click
on Inventory --> Click
Items. You have option to add filters base on your requirements. Check mark items you want to unassigned from
sites. Click on Unassigned Site icon. Select
Site and click Unassigned.</span><o:p></o:p></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0k5HBloXYWuYR8VzfXZ75Cfty3WsIC-uM5m_JO-NM34zpUUpMsvjs6yFXrGI10P795Kov1_Kh_Cuutgsp0OZEvAyQYX7Ymd1i6sarQ_AMBGPHKb_n7B_5n6JauiSDdFH9yzytEYmJcLQ/s1600/UnAssignedSite.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0k5HBloXYWuYR8VzfXZ75Cfty3WsIC-uM5m_JO-NM34zpUUpMsvjs6yFXrGI10P795Kov1_Kh_Cuutgsp0OZEvAyQYX7Ymd1i6sarQ_AMBGPHKb_n7B_5n6JauiSDdFH9yzytEYmJcLQ/s640/UnAssignedSite.PNG" width="640" /></a></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;">You have option to to add site with same screen.</span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;">Thanks much</span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;">Sandip Jadhav</span></div>
Sandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.com0tag:blogger.com,1999:blog-3213366531887654192.post-4135605600219959912015-07-14T11:44:00.004-07:002015-07-14T12:02:31.984-07:00Bank Deposit Slip from Dynamics GP.<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;">I want to document one of forgotten feature in Dynamics GP
i.e. printing Bank Deposit Slip from Dynamics GP.<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;">User can print Bank Deposit Slip right from Dynamics GP.<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<br />
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;">Goto</span><span style="text-align: start;">--&gt</span><span style="font-family: Verdana, sans-serif;">Transactions</span><span style="text-align: start;">--&gt</span><span style="font-family: Verdana, sans-serif;">;</span><span style="font-family: Verdana, sans-serif;">Financial</span><span style="text-align: start;">--&gt</span><span style="font-family: Verdana, sans-serif;">;</span><span style="font-family: Verdana, sans-serif;"> Bank Deposits</span><br />
<o:p></o:p></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEih2AvC3zoS6XV_P1dNDEZSZBwBXgcDUJQ7_0ajr-oMz5cILfdJ5yXizTtOIOXtDYSCRuRykhSAF8LlRuIVJ4wZnrp6ifXx-0Fz0SxmmNHM7qIRyNl6F_TglUD5CJcoiEhYBbzf8k8R7I4/s1600/BankDepositEntryScreen.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEih2AvC3zoS6XV_P1dNDEZSZBwBXgcDUJQ7_0ajr-oMz5cILfdJ5yXizTtOIOXtDYSCRuRykhSAF8LlRuIVJ4wZnrp6ifXx-0Fz0SxmmNHM7qIRyNl6F_TglUD5CJcoiEhYBbzf8k8R7I4/s1600/BankDepositEntryScreen.png" /></a></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif;">Select your transactions</span>--&gt<span style="font-family: Verdana, sans-serif; text-align: justify;">;</span><span style="font-family: Verdana, sans-serif;">Click
on Print button to print Deposit Slip.</span><o:p></o:p></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6Lgp9OMzQVWWhz4gE6H9sdwaIl06DRMWh2vsUz616oQWBlFTerijgCdYlBv4Z_nuXq2TDIuZc0pneQ3fhAmCxaXMHbSBXuH30zbnv3RMZyWbNQDcy81WwTTN64TGe8o7zMp5NLiXoE98/s1600/BankDepositReport.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6Lgp9OMzQVWWhz4gE6H9sdwaIl06DRMWh2vsUz616oQWBlFTerijgCdYlBv4Z_nuXq2TDIuZc0pneQ3fhAmCxaXMHbSBXuH30zbnv3RMZyWbNQDcy81WwTTN64TGe8o7zMp5NLiXoE98/s1600/BankDepositReport.png" /></a></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif;">Depend on yours transactions </span><span style="font-family: Verdana, sans-serif;">report has all details – Checks #, Cash Details etc . User can take this form to Bank.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal">
</div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif;">I have updated this forms as per customers bank preprinted
format.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif;">Thanks much for reading !!!</span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif;">Until Next Post!!!</span></div>
<div class="MsoNormal">
<br /></div>
Sandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.com1tag:blogger.com,1999:blog-3213366531887654192.post-29489075569842226432015-07-13T13:25:00.002-07:002015-07-13T13:25:39.853-07:00Dynamics GP SQL Password - Something Interesting must test it !!!<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;">Dynamics GP – SQL Password.<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;">While working one of my colleague
here I found something unusual in Dynamics GP2013 R2 and even GP2015 R2.<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;">We have asked our IT department
to create VM with SQL server. They have installed SQL server with ‘sa’ password
‘sql2k12@myowncompany’.<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;">When we were trying to install
GP. Utilities ran successfully with 'sa' user id and above password, we was able to create Production Company through
Dynamics GP utilities but not able to login to Dynamics GP.<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;">Spend almost 2 days to see why we
are not able to Login GP. Asked IT team to reformatted server reinstalled SQL
but again they given same ‘sql2k12@myowncompany’ password. Again same story able to login GP Utility but
not able to login GP. DYNSA user ID and password is working. Even we have
checked all other security screen in Dynamics GP and log file was not showing any error.</span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;">Somehow I saw GP user login
screen not taking password more than 15 character….!!! Whereas I can type
password more than 15 characters in GP utility...!!! We got issue.<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;">Now question is how come Dynamics
GP Utility allow to enter password more than 15 character and GP Login screen
user password restricted to 15 characters only.<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;">Until Next Post!!!<o:p></o:p></span></div>
<div style="text-align: justify;">
</div>
<div class="MsoNormal" style="text-align: justify;">
<br /></div>
Sandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.com1tag:blogger.com,1999:blog-3213366531887654192.post-24343690951073683382015-06-13T10:21:00.001-07:002015-06-13T10:23:07.472-07:00Inventory Cycle Count<div class="MsoNormal">
<b><span style="font-family: Verdana, sans-serif;">Stock count
requirements:<span style="font-size: xx-small;"><o:p></o:p></span></span></b></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Before you set up and use stock counts, you should be aware
of the requirements and restrictions. Item types Only Sales Inventory or
Discontinued items can be assigned to a stock count. “Freeze” inventory when
starting a stock count It’s a good business practice to restrict access to the
inventoried items that are being counted during a stock count.<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Steps:<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"> Create Stock Count Schedule<o:p></o:p></span></div>
<br />
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Goto --> Dynamics GP-->Inventory-->Stock
Count Schedule<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhT2F-LfuHObpOpAmJUP_HiSMuNXFy40SGdRbF7Jtwd0xi_OzuBPvkasuNckch2UnxSWrVwG_6FCU3HG_YuQ_GJ5xZwBBtD_wSeFN2XHPG5BtVKdJGlpOxAt2RRiyRwKWwuWtoPMfiS_y4/s1600/StockCountSchedule.png" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><img border="0" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhT2F-LfuHObpOpAmJUP_HiSMuNXFy40SGdRbF7Jtwd0xi_OzuBPvkasuNckch2UnxSWrVwG_6FCU3HG_YuQ_GJ5xZwBBtD_wSeFN2XHPG5BtVKdJGlpOxAt2RRiyRwKWwuWtoPMfiS_y4/s400/StockCountSchedule.png" width="400" /></span></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: Verdana, sans-serif; font-size: xx-small;">Stock Count Schedule </span></td></tr>
</tbody></table>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<br /></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpMiddle">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">When you’re ready to begin work on a stock
count at a specific site, create a stock count schedule- specify which
item-site combinations are to be included in this stock count. (If you’re using
multiple bins, you specify which item-site-bin combinations are included.) You
can save the stock count schedule or you can choose to start it. You also can
reuse stock counts.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<b><span style="font-family: Verdana, sans-serif; font-size: x-small;">To
create a reusable stock schedule, mark the Reuse option.<o:p></o:p></span></b></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpLast">
</div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">If you need to add many items in your stock
count click on “Mass Add” button. <o:p></o:p></span></div>
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjv-XyAGPcssKDlXjvtDTpbs8gYEUXTKnGd1LUzAfxgwVnmwkRLF78ML5HOJwim8F2m2BmrHJrlECykuvbdLXAz-r4IoTNP5NOQ4LHhmsLkiACyxXnxSfMctzpby9ZE2sQ4JVuoRaO35sc/s1600/StockCountMassAdd.png" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><img border="0" height="300" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjv-XyAGPcssKDlXjvtDTpbs8gYEUXTKnGd1LUzAfxgwVnmwkRLF78ML5HOJwim8F2m2BmrHJrlECykuvbdLXAz-r4IoTNP5NOQ4LHhmsLkiACyxXnxSfMctzpby9ZE2sQ4JVuoRaO35sc/s400/StockCountMassAdd.png" width="400" /></span></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: Verdana, sans-serif; font-size: xx-small;">Stock Count Mass Add</span></td></tr>
</tbody></table>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">You have many option to add Mass Items base
on Range you have selected. Like Item Number or Class or by Site ID.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Once Item Range is selected then click on
Add Button<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpLast">
</div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">In my example I have selected one Item:
SUGAR.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijDK2XL4TVH7xxgFCdPmVJKF6Q-N6JnH1rvi-aseV32URMI47SIitE6icXsw-C_tXAsmyHHV7WbvlvOqs7i-fiK0JQMsTqY1akvgQnFu4tht2dEcddRFf6kW1gQolVp_IZevX38SsBNQE/s1600/StockCountScheduleWithItem.png" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><img border="0" height="301" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijDK2XL4TVH7xxgFCdPmVJKF6Q-N6JnH1rvi-aseV32URMI47SIitE6icXsw-C_tXAsmyHHV7WbvlvOqs7i-fiK0JQMsTqY1akvgQnFu4tht2dEcddRFf6kW1gQolVp_IZevX38SsBNQE/s400/StockCountScheduleWithItem.png" width="400" /></span></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: Verdana, sans-serif; font-size: xx-small;">Stock Count Schedule with Item</span></td></tr>
</tbody></table>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpMiddle">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpMiddle">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpMiddle">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpMiddle">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpMiddle">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpMiddle">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpMiddle">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpMiddle">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">When you’ve finished, choose Save and close
the window. Need to call back Stock Count ID again to start Stock Count.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<b><span style="font-family: Verdana, sans-serif; font-size: x-small;">Starting
a stock count schedule <o:p></o:p></span></b></div>
<div class="MsoListParagraphCxSpMiddle">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Use the Stock Count Schedule window to
start a stock count. If the stock count can be started—if there are no
exceptions—the status of the count will be changed to Started, stock count
forms will be printed and information about the on-hand quantity of each
item-site combination will be captured.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<b><span style="font-family: Verdana, sans-serif; font-size: x-small;">Choose
Start Count.<o:p></o:p></span></b></div>
<div class="MsoListParagraphCxSpMiddle">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">When you start a stock count schedule, the
quantity on hand for each line in the stock count schedule is captured. Later,
the actual count number quantities will be compared to the captured values to
create default variance transactions. <o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpLast">
</div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">The report destination window for the Stock
Count Exceptions report appears. Choose the destination for the Stock Count
Exceptions report.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCs8ZxU4yPLNdX8uzFGwGlwRbfY-sOrWtugy12ipTTZDB3uv6SuViMHm75AuQPQAb3VX-ToQUy29M421vqwB9BveHLFLxXRkzO3qf5Ab22iM8-xJrmzR15RyUC2mKZ8BhJ2Jwnk_PEgOE/s1600/StockCountScheduleWithItem_1.png" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><img border="0" height="301" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCs8ZxU4yPLNdX8uzFGwGlwRbfY-sOrWtugy12ipTTZDB3uv6SuViMHm75AuQPQAb3VX-ToQUy29M421vqwB9BveHLFLxXRkzO3qf5Ab22iM8-xJrmzR15RyUC2mKZ8BhJ2Jwnk_PEgOE/s400/StockCountScheduleWithItem_1.png" width="400" /></span></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: Verdana, sans-serif; font-size: xx-small;">Stock Count Schedule</span></td></tr>
</tbody></table>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<b><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></b></div>
<div class="MsoListParagraph">
<b><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></b></div>
<div class="MsoListParagraph">
<b><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></b></div>
<div class="MsoListParagraph">
<b><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></b></div>
<div class="MsoListParagraph">
<b><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></b></div>
<div class="MsoListParagraph">
<b><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></b></div>
<div class="MsoListParagraph">
<b><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></b></div>
<div class="MsoListParagraph">
<b><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></b></div>
<div class="MsoListParagraph">
<b><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></b></div>
<div class="MsoListParagraph">
<b><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></b></div>
<div class="MsoListParagraph">
<b><span style="font-family: Verdana, sans-serif; font-size: x-small;">Please select
Print on Hand Quantities and Print Item Lot or Serial Number if you need to
count by Tracking Option then Click on OK.<o:p></o:p></span></b></div>
<div class="MsoListParagraph">
<b><span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></b></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif;"><span style="font-size: x-small;">Below report will print if there is no exceptions.</span><span style="font-size: xx-small;"><o:p></o:p></span></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCgN7XQ_a2lBv37-QpBuOqxJtXXmBZI-4gnOmvvpNgJB0pySCIhV2lt8SI8P7qxx6DiEUB7DJ-4tvlSFLvWrHBUB6L9VAJtPFc7jJ9Cm5NQ96f_396Bud47VYKamKjlNsReET8McbgkAU/s1600/Report.png" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><img border="0" height="257" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCgN7XQ_a2lBv37-QpBuOqxJtXXmBZI-4gnOmvvpNgJB0pySCIhV2lt8SI8P7qxx6DiEUB7DJ-4tvlSFLvWrHBUB6L9VAJtPFc7jJ9Cm5NQ96f_396Bud47VYKamKjlNsReET8McbgkAU/s640/Report.png" width="640" /></span></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: Verdana, sans-serif; font-size: xx-small;">Stock Count Form</span></td></tr>
</tbody></table>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Use this report to do your physical stock
count. <o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><o:p> </o:p> </span></div>
<div class="MsoListParagraphCxSpMiddle">
<b><span style="font-family: Verdana, sans-serif; font-size: x-small;">Open
Stock Count Entry<o:p></o:p></span></b></div>
<div class="MsoListParagraph">
</div>
<div class="MsoListParagraphCxSpLast">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Got--> Dynamics GP-->Transaction>>Inventory-->Stock Count Entry<o:p></o:p></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5-PCukcDCikeRSea4mfe5H7PlYWlAeuBQjA8Cc74dNUXIA7blC2pRerUwJTGJYWptaRlTFMnCvEM3xJzqvFuouoECn_umzqRQPcm-cnY7q6d2jL6SKmq38mKJfdOQ38OS1-ADtMPocJk/s1600/Stock+Count+Entry.png" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><img border="0" height="270" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5-PCukcDCikeRSea4mfe5H7PlYWlAeuBQjA8Cc74dNUXIA7blC2pRerUwJTGJYWptaRlTFMnCvEM3xJzqvFuouoECn_umzqRQPcm-cnY7q6d2jL6SKmq38mKJfdOQ38OS1-ADtMPocJk/s400/Stock+Count+Entry.png" width="400" /></span></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: Verdana, sans-serif; font-size: xx-small;">Stock Count Entry</span></td></tr>
</tbody></table>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Select Your Stock Count ID<o:p></o:p></span></div>
<div class="MsoListParagraph">
</div>
<div class="MsoListParagraphCxSpLast" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">It will display
all items. If Item is Lot/Serial --> Click on Serial/Lot button and can enter count quantity.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjY75Rw-pVIc69e6dnY4-vZIMqTO42L06ITPXMxscXZUHos_1kIXKlysrewq-kJWw7xSZk1iQnJSqoGMYE_3Z0P1tkKrZ8Cu3i7whLuntUOzpLfPAqIcF0nbCnqh0TwvmiA7RmxHaglAd0/s1600/Stock+Lot+Count.png" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><img border="0" height="277" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjY75Rw-pVIc69e6dnY4-vZIMqTO42L06ITPXMxscXZUHos_1kIXKlysrewq-kJWw7xSZk1iQnJSqoGMYE_3Z0P1tkKrZ8Cu3i7whLuntUOzpLfPAqIcF0nbCnqh0TwvmiA7RmxHaglAd0/s400/Stock+Lot+Count.png" width="400" /></span></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: Verdana, sans-serif; font-size: xx-small;">Stock Lot Count Entry Screen</span></td></tr>
</tbody></table>
<div class="MsoListParagraphCxSpLast" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Click Okay to go main screen- Stock Count
Entry.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle">
<br /></div>
<div class="MsoListParagraphCxSpMiddle">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">On Stock Count Entry screen:<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: .75in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: Verdana, sans-serif; font-size: x-small;">1)<span style="font-stretch: normal;">
</span><!--[endif]-->Distribution- It will show each Items GL
Distributions.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: .75in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: Verdana, sans-serif; font-size: x-small;">2)<span style="font-stretch: normal;">
</span><!--[endif]-->Serial/Lot- Enter Inventory count by Lot or
Serial as explained above.<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: .75in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: Verdana, sans-serif; font-size: x-small;">3)<span style="font-stretch: normal;">
</span><!--[endif]-->Unposted Transaction Button- To display if there
is unposted transaction are </span></div>
<div class="MsoListParagraphCxSpMiddle" style="margin-left: .75in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"> considered in stock count or not for specific item.
<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpLast" style="margin-left: .75in; mso-add-space: auto; mso-list: l0 level1 lfo1; text-indent: -.25in;">
<!--[if !supportLists]--><span style="font-family: Verdana, sans-serif; font-size: x-small;">4)<span style="font-stretch: normal;">
</span><!--[endif]-->Trx History- It display total historical
transactions for specific item<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Once you have enter Count system will enter Variance for
you. <o:p></o:p></span></div>
<div class="MsoListParagraph">
</div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">e.g. Stock Count Lot Number Entry screen.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaMwDAWgFQn3XHGtQjVIkDTA02zJSrI7yLlxmBR5kE-A06H65ot6NxFG15UWf6YApZgtJMvVYzDmew9fFyAQ_Y-T8ZtXOQO6DjVtA4ohFJU2WiHvudPvK1HPq1_uZaaEbcBGJqlmNVkQc/s1600/Stock+Lot+Count1.png" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><img border="0" height="296" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaMwDAWgFQn3XHGtQjVIkDTA02zJSrI7yLlxmBR5kE-A06H65ot6NxFG15UWf6YApZgtJMvVYzDmew9fFyAQ_Y-T8ZtXOQO6DjVtA4ohFJU2WiHvudPvK1HPq1_uZaaEbcBGJqlmNVkQc/s400/Stock+Lot+Count1.png" width="400" /></span></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: Verdana, sans-serif; font-size: xx-small;">Stock Count Lot Entry Screen</span></td></tr>
</tbody></table>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Click Okay to goto Main screen.<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEji7TE4UrcJmjQ4lk9oFch9cDj43OXx9S-MgeVUCBkg6O1gchFYc7OBQDbxs0qwUmSEa6Hn7mCE_0ZKU_oxtrv1o5thdZDZ0gzwDXUoWpV5XfrNzNuIIJ7nC4NlCpoyu6xLSpLBTDlh9fo/s1600/Stock+Count+Entry2.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><img border="0" height="272" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEji7TE4UrcJmjQ4lk9oFch9cDj43OXx9S-MgeVUCBkg6O1gchFYc7OBQDbxs0qwUmSEa6Hn7mCE_0ZKU_oxtrv1o5thdZDZ0gzwDXUoWpV5XfrNzNuIIJ7nC4NlCpoyu6xLSpLBTDlh9fo/s400/Stock+Count+Entry2.png" width="400" /></span></a></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal" style="text-align: justify;">
<b><i><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></i></b></div>
<div class="MsoNormal" style="text-align: justify;">
<b><i><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></i></b></div>
<div class="MsoNormal" style="text-align: justify;">
<b><i><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></i></b></div>
<div class="MsoNormal" style="text-align: justify;">
<b><i><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></i></b></div>
<div class="MsoNormal" style="text-align: justify;">
<b><i><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></i></b></div>
<div class="MsoNormal" style="text-align: justify;">
<b><i><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></i></b></div>
<div class="MsoNormal" style="text-align: justify;">
<b><i><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></i></b></div>
<div class="MsoNormal" style="text-align: justify;">
<b><i><span style="font-family: Verdana, sans-serif; font-size: x-small;">If you’re using autoposting
options for stock count variances,variance transactions will be posted and
reports will be printed when you process a stock count. If you’re not using
autoposting, variance transactions are saved in a batch; you’ll need to post
the batch.<o:p></o:p></span></i></b></div>
<div class="MsoNormal" style="text-align: justify;">
<b><i><span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></i></b></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Once you are satisfied with result click “Process” button. <o:p></o:p></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: x-small;">System will prompt for following Reports:</span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: x-small; text-indent: -0.25in;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: Verdana, sans-serif; font-size: x-small; text-indent: -0.25in;">1) Exception Report</span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaZ9h7gJ0duOpQTbK6ZMIAhF_pgXCeUrIOsJIYLdP4vKp8bi33P0vMRGOoXmwJByCaMVViWqzz2ezW3oHxIKJtlaf1Dy8FpgsDuSwgRp_FopuFPkzysRRzF-6WQLS8Qg5c64Ojvl2ZXIc/s1600/StockCount+ExceptionReport.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><img border="0" height="250" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaZ9h7gJ0duOpQTbK6ZMIAhF_pgXCeUrIOsJIYLdP4vKp8bi33P0vMRGOoXmwJByCaMVViWqzz2ezW3oHxIKJtlaf1Dy8FpgsDuSwgRp_FopuFPkzysRRzF-6WQLS8Qg5c64Ojvl2ZXIc/s640/StockCount+ExceptionReport.png" width="640" /></span></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjaZ9h7gJ0duOpQTbK6ZMIAhF_pgXCeUrIOsJIYLdP4vKp8bi33P0vMRGOoXmwJByCaMVViWqzz2ezW3oHxIKJtlaf1Dy8FpgsDuSwgRp_FopuFPkzysRRzF-6WQLS8Qg5c64Ojvl2ZXIc/s1600/StockCount+ExceptionReport.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></a></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoNormal">
<b><span lang="EN"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></span></b></div>
<div class="MsoNormal">
<b><span lang="EN"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></span></b></div>
<div class="MsoNormal">
<b><span lang="EN"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></span></b></div>
<div class="MsoNormal">
<b><span lang="EN"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></span></b></div>
<div class="MsoNormal">
<b><span lang="EN"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></span></b></div>
<div class="MsoNormal">
<b><span lang="EN"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><br /></span></span></b></div>
<div class="MsoNormal">
<b><span lang="EN"><span style="font-family: Verdana, sans-serif; font-size: x-small;">Effects of processing a stock count<o:p></o:p></span></span></b></div>
<div class="MsoNormal" style="text-align: justify;">
<span lang="EN"><span style="font-family: Verdana, sans-serif; font-size: x-small;">When you process a stock count, several
things happen:<o:p></o:p></span></span></div>
<ul type="disc">
<li class="MsoNormal" style="text-align: justify;"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><a href="https://www.blogger.com/null" name="XIV03_04StockCountEntry1279666"></a><span lang="EN">Variance
transactions are created. If the Autopost Stock Count Variances option is
marked, the transactions also will be posted. <o:p></o:p></span></span></li>
</ul>
<table border="0" cellpadding="0" class="MsoNormalTable" style="mso-cellspacing: 1.5pt; mso-padding-alt: 0in 0in 0in 0in; mso-yfti-tbllook: 1184; width: 100%px;">
<tbody>
<tr>
<td style="padding: 0in 0in 0in 0in; width: 99.36%;" width="99%"><div class="MsoNormal" style="text-align: justify;">
<!--[if gte vml 1]><v:rect id="Rectangle_x0020_15"
o:spid="_x0000_s1027" alt="mk:@MSITStore:C:\Program%20Files%20(x86)\Microsoft%20Dynamics\GP2013\GreatPlains.chm::/1p.gif"
style='position:absolute;left:0;text-align:left;margin-left:0;margin-top:0;
width:12pt;height:24pt;z-index:251657216;visibility:visible;
mso-wrap-style:square;mso-width-percent:0;mso-height-percent:0;
mso-wrap-distance-left:0;mso-wrap-distance-top:0;mso-wrap-distance-right:0;
mso-wrap-distance-bottom:0;mso-position-horizontal:left;
mso-position-horizontal-relative:text;mso-position-vertical:absolute;
mso-position-vertical-relative:line;mso-width-percent:0;
mso-height-percent:0;mso-width-relative:page;mso-height-relative:page;
v-text-anchor:top' o:gfxdata="UEsDBBQABgAIAAAAIQC75UiUBQEAAB4CAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSRvU7DMBSF
dyTewfKKEqcMCKEmHfgZgaE8wMW+SSwc27JvS/v23KTJgkoXFsu+P+c7Ol5vDoMTe0zZBl/LVVlJ
gV4HY31Xy4/tS3EvRSbwBlzwWMsjZrlprq/W22PELHjb51r2RPFBqax7HCCXIaLnThvSAMTP1KkI
+gs6VLdVdad08ISeCho1ZLN+whZ2jsTzgcsnJwldluLxNDiyagkxOquB2Knae/OLUsyEkjenmdzb
mG/YhlRnCWPnb8C898bRJGtQvEOiVxjYhtLOxs8AySiT4JuDystlVV4WPeM6tK3VaILeDZxIOSsu
ti/jidNGNZ3/J08yC1dNv9v8AAAA//8DAFBLAwQUAAYACAAAACEArTA/8cEAAAAyAQAACwAAAF9y
ZWxzLy5yZWxzhI/NCsIwEITvgu8Q9m7TehCRpr2I4FX0AdZk2wbbJGTj39ubi6AgeJtl2G9m6vYx
jeJGka13CqqiBEFOe2Ndr+B03C3WIDihMzh6RwqexNA281l9oBFTfuLBBhaZ4ljBkFLYSMl6oAm5
8IFcdjofJ0z5jL0MqC/Yk1yW5UrGTwY0X0yxNwri3lQgjs+Qk/+zfddZTVuvrxO59CNCmoj3vCwj
MfaUFOjRhrPHaN4Wv0VV5OYgm1p+LW1eAAAA//8DAFBLAwQUAAYACAAAACEAkIBb2DsDAAABBwAA
HwAAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWysVVtv2yAUfp+0/4CQJm0Pji9x0tia
27W5VJXaLWrat75QTGI0DB6Q26b99x1w0qSt1IdtvBgOh4/vXD78+WxTC7Ri2nAlCxx3IoyYpKrk
clHg+7tJMMDIWCJLIpRkBd4yg89O37/7TPKFJk3FKQIEaXJS4MraJg9DQytWE9NRDZOwN1e6JhaW
ehGWmqwBuRZhEkX9sCZc4tMD1IhYgpaa/wWUUPQ7K4dErogBSEHzY8uOo6D/jkxyubrUzayZasec
fl1NNeJlgSFzktSQIhzuNnZusAxfnFocADZzXTt/NZ+jTYGzbjftAdQWijHIkm4UtXBsYxGF/biX
pGBDFBy6UTrY79Pq29sAtBq/CQEUWyowOaJnGkdOrl7HG/f2Ad8yCh2yEAw5W8kM1QWuv+dfbmZX
dzOrNMuH+cNUK+iY+kMSTbhgBr4fN4P+p4cbTrUyam7BMtpCCjk1D5fTJIq7D5eaETsV0CamQ6s6
z8O46Sz4/CnFe1qmuYYGMEiqYQVU2LlpgBSkCzjuTVqrdcVIaZy5LQpUr0XwBTqAQUkf1zeqhGqS
pVW+R/9LoZ6yTPJGG3vJVI3cpMAa+Pp7yOra2Jbe3sWXQEHahG8tIZ8ZALO1QI/AUbfnusXr6FcW
ZePBeJAGadIfB2k0GgXnk2Ea9CfxSW/UHQ2Ho/i3uzdO84qXJZPumr2m4/SVYKA8bbk6VNUhdC2n
bK9rUHUcHVRtlOClg3OUjF48DoVGKyIKPPFjV4Qjt/A5DS8ciOVFSDFI4CLJgkl/cBKkk7QXZCfR
IIji7CLrR2mWjibPQ7rmkv17SGgN8uwlPV+lI9IvYov8eB0byWtumUaC1wUG3cJo29j15FiWvrSW
cNHOj1Lh6B9SAeXeFxqmZvcO2c3MK9VuLlS5dQl7hC/0sVbQXPBgwBsPk0rpnxit4eUusPmxJJph
JK4kSCKL0xTcrF+kvZMEFvp45/F4h0gKUAW2GLXToYUVHFk2mi8quCn2aZLqHPQz57uGbjk5dsLY
md0K5qP2zJksp0STW+AsQMIFZjK4n+3yCB4Q7CG4pWGzxr07rVDa6H06wPHF4++P7n5W7g9zvD79
AwAA//8DAFBLAwQUAAYACAAAACEAtjsEIlQGAAALGgAAGgAAAGNsaXBib2FyZC90aGVtZS90aGVt
ZTEueG1s7FlLbxs3EL4X6H9Y7L2x3oqNyIGtR9zGToJISZEjpaV2GXOXC5Kyo1uRHAsUKJoWPTRA
bz0UbQMkQC/pr3Gbok2B/IUOuQ+RElU7RgoYQSzA2J39Zjicmf2G5F65+iCm3hHmgrCk41cvVXwP
JxMWkCTs+HdGg48u+56QKAkQZQnu+HMs/KvbH35wBW1NKEnHDPFgFOEYe2AoEVuo40dSplsbG2IC
YiQusRQn8GzKeIwk3PJwI+DoGAaI6UatUmltxIgk/jZYlMpQn8K/RAolmFA+VGawl6AYRr85nZIJ
1tjgsKoQYi66lHtHiHZ8sBmw4xF+IH2PIiHhQcev6D9/Y/vKBtrKlahco2voDfRfrpcrBIc1PSYP
x+WgjUaz0dop7WsAlau4frvf6rdKexqAJhOYaeaLabO5u7nba+ZYA5RdOmz32r161cIb9usrPu80
1c/Ca1Bmv7GCHwy6EEULr0EZvrmCbzTatW7DwmtQhm+t4NuVnV6jbeE1KKIkOVxBV5qtereYbQmZ
MrrnhG82G4N2LTe+QEE1lNWlhpiyRK6rtRjdZ3wAAAWkSJLEk/MUT9EEarKLKBlz4u2TMILCS1HC
BIgrtcqgUof/6tfQVzoiaAsjQ1v5BZ6IFZHyxxMTTlLZ8T8Bq74Bef3ip9cvnnknD5+fPPz15NGj
k4e/ZIYsrT2UhKbWqx++/OfJZ97fz75/9fhrN16Y+D9+/vz3375yA2GmixC8/Obpn8+fvvz2i79+
fOyA73A0NuEjEmPh3cDH3m0Ww8R0CGzP8Zi/mcYoQsTU2ElCgRKkRnHY78vIQt+YI4ocuF1sR/Au
B4pxAa/N7lsODyM+k8Rh8XoUW8ADxugu484oXFdjGWEezZLQPTifmbjbCB25xu6ixMpvf5YCtxKX
yW6ELTdvUZRIFOIES089Y4cYO2Z3jxArrgdkwplgU+ndI94uIs6QjMjYqqaF0h6JIS9zl4OQbys2
B3e9XUZds+7hIxsJbwWiDudHmFphvIZmEsUukyMUUzPg+0hGLieHcz4xcX0hIdMhpszrB1gIl85N
DvM1kn4d6MWd9gM6j20kl+TQZXMfMWYie+ywG6E4dWGHJIlM7MfiEEoUebeYdMEPmP2GqHvIA0rW
pvsuwVa6T2eDO8CspkuLAlFPZtyRy2uYWfU7nNMpwppqgPgtPo9Jciq5L9F68/+ldSDSl989cczq
ohL6DifON2pvicbX4ZbJu8t4QC4+d/fQLLmF4XVZbWDvqfs9dfvvPHWve5/fPmEvOBroWy0Vs6W6
XrjHa9ftU0LpUM4p3hd66S6gMwUDECo9vT/F5T4ujeBSvckwgIULOdI6HmfyUyKjYYRSWN9XfWUk
FLnpUHgpE7Ds12KnbYWns/iABdl2tVpVW9OMPASSC3mlWcphqyEzdKu92IKV5rW3od4qFw4o3Tdx
whjMdqLucKJdCFWQ9MYcguZwQs/srXix6fDisjJfpGrFC3CtzAosnTxYcHX8ZgNUQAl2VIjiQOUp
S3WRXZ3Mt5npdcG0KgDWEUUFLDK9qXxdOz01u6zUzpBpywmj3GwndGR0DxMRCnBenUp6FjfeNNeb
i5Ra7qlQ6PGgtBZutC//lxfnzTXoLXMDTUymoIl33PFb9SaUzASlHX8K2364jFOoHaGWvIiGcGA2
kTx74c/DLCkXsodElAVck07GBjGRmHuUxB1fTb9MA000h2jfqjUghAvr3CbQykVzDpJuJxlPp3gi
zbQbEhXp7BYYPuMK51Otfn6w0mQzSPcwCo69MZ3x2whKrNmuqgAGRMDpTzWLZkDgOLMkskX9LTWm
nHbN80RdQ5kc0TRCeUcxyTyDayov3dF3ZQyMu3zOEFAjJHkjHIeqwZpBtbpp2TUyH9Z23dOVVOQM
0lz0TItVVNd0s5g1QtEGlmJ5viZveFWEGDjN7PAZdS9T7mbBdUvrhLJLQMDL+Dm67hkaguHaYjDL
NeXxKg0rzs6ldu8oJniKa2dpEgbrtwqzS3Ere4RzOBCeq/OD3nLVgmharCt1pF2fJg5Q6o3DaseH
zwNwPvEAruADgw+ympLVlAyu4KsBtIvsqL/j5xeFBJ5nkhJTLyT1AtMoJI1C0iwkzULSKiQt39Nn
4vAdRh2H+15x5A09LD8iz9cW9veb7X8BAAD//wMAUEsDBBQABgAIAAAAIQCcZkZBuwAAACQBAAAq
AAAAY2xpcGJvYXJkL2RyYXdpbmdzL19yZWxzL2RyYXdpbmcxLnhtbC5yZWxzhI/NCsIwEITvgu8Q
9m7SehCRJr2I0KvUBwjJNi02PyRR7Nsb6EVB8LIws+w3s037sjN5YkyTdxxqWgFBp7yenOFw6y+7
I5CUpdNy9g45LJigFdtNc8VZ5nKUxikkUigucRhzDifGkhrRykR9QFc2g49W5iKjYUGquzTI9lV1
YPGTAeKLSTrNIXa6BtIvoST/Z/thmBSevXpYdPlHBMulFxagjAYzB0pXZ501LV2BiYZ9/SbeAAAA
//8DAFBLAQItABQABgAIAAAAIQC75UiUBQEAAB4CAAATAAAAAAAAAAAAAAAAAAAAAABbQ29udGVu
dF9UeXBlc10ueG1sUEsBAi0AFAAGAAgAAAAhAK0wP/HBAAAAMgEAAAsAAAAAAAAAAAAAAAAANgEA
AF9yZWxzLy5yZWxzUEsBAi0AFAAGAAgAAAAhAJCAW9g7AwAAAQcAAB8AAAAAAAAAAAAAAAAAIAIA
AGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWxQSwECLQAUAAYACAAAACEAtjsEIlQGAAAL
GgAAGgAAAAAAAAAAAAAAAACYBQAAY2xpcGJvYXJkL3RoZW1lL3RoZW1lMS54bWxQSwECLQAUAAYA
CAAAACEAnGZGQbsAAAAkAQAAKgAAAAAAAAAAAAAAAAAkDAAAY2xpcGJvYXJkL2RyYXdpbmdzL19y
ZWxzL2RyYXdpbmcxLnhtbC5yZWxzUEsFBgAAAAAFAAUAZwEAACcNAAAAAA==
" o:allowoverlap="f" filled="f" stroked="f">
<o:lock v:ext="edit" aspectratio="t"/>
<w:wrap type="square" anchory="line"/>
</v:rect><![endif]--><!--[if gte vml 1]><v:rect id="Rectangle_x0020_14"
o:spid="_x0000_s1026" alt="mk:@MSITStore:C:\Program%20Files%20(x86)\Microsoft%20Dynamics\GP2013\GreatPlains.chm::/Hint.gif"
style='position:absolute;left:0;text-align:left;margin-left:0;margin-top:0;
width:24pt;height:24pt;z-index:251658240;visibility:visible;
mso-wrap-style:square;mso-width-percent:0;mso-height-percent:0;
mso-wrap-distance-left:0;mso-wrap-distance-top:0;mso-wrap-distance-right:0;
mso-wrap-distance-bottom:0;mso-position-horizontal:left;
mso-position-horizontal-relative:text;mso-position-vertical:absolute;
mso-position-vertical-relative:line;mso-width-percent:0;
mso-height-percent:0;mso-width-relative:page;mso-height-relative:page;
v-text-anchor:top' o:gfxdata="UEsDBBQABgAIAAAAIQC75UiUBQEAAB4CAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSRvU7DMBSF
dyTewfKKEqcMCKEmHfgZgaE8wMW+SSwc27JvS/v23KTJgkoXFsu+P+c7Ol5vDoMTe0zZBl/LVVlJ
gV4HY31Xy4/tS3EvRSbwBlzwWMsjZrlprq/W22PELHjb51r2RPFBqax7HCCXIaLnThvSAMTP1KkI
+gs6VLdVdad08ISeCho1ZLN+whZ2jsTzgcsnJwldluLxNDiyagkxOquB2Knae/OLUsyEkjenmdzb
mG/YhlRnCWPnb8C898bRJGtQvEOiVxjYhtLOxs8AySiT4JuDystlVV4WPeM6tK3VaILeDZxIOSsu
ti/jidNGNZ3/J08yC1dNv9v8AAAA//8DAFBLAwQUAAYACAAAACEArTA/8cEAAAAyAQAACwAAAF9y
ZWxzLy5yZWxzhI/NCsIwEITvgu8Q9m7TehCRpr2I4FX0AdZk2wbbJGTj39ubi6AgeJtl2G9m6vYx
jeJGka13CqqiBEFOe2Ndr+B03C3WIDihMzh6RwqexNA281l9oBFTfuLBBhaZ4ljBkFLYSMl6oAm5
8IFcdjofJ0z5jL0MqC/Yk1yW5UrGTwY0X0yxNwri3lQgjs+Qk/+zfddZTVuvrxO59CNCmoj3vCwj
MfaUFOjRhrPHaN4Wv0VV5OYgm1p+LW1eAAAA//8DAFBLAwQUAAYACAAAACEAK+43Jj8DAAAGBwAA
HwAAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWysVU1v4zYQvRfofyAIFGgPsihFdiRh
lW3ij3SBpDXWu7dcGIq2iKVIlaS/WvS/d0jJaycBWqBbXTQcjh7fzJuh3r0/tBLtuLFCqwonI4IR
V0zXQm0q/PnTIsoxso6qmkqteIWP3OL3N99/946WG0O7RjAECMqWtMKNc10Zx5Y1vKV2pDuuYG+t
TUsdLM0mrg3dA3Ir45SQSdxSofDNGWpGHUVbI/4DlNTsC6+nVO2oBUjJykvPwFGyb0empdrdm27V
LY1nzn7dLQ0SdYWhcoq2UCIcDxtDGCzjV19tzgCHtWl9vF6v0QEUIPk4HwPWEey8SK8I6fH4wSEG
AVcky8GHGAQMdn9e89u/ILBm/o8YQLInA8YFQdt5emr3NuMkO6X8kTPokY3kyPtqbpmpcPul/Plx
9eHTymnDy2n5tDQaeqb9ISULIbmF94+HfPLT06NgRlu9duCZHaGIgtmn+2VKkqune8OpW0poFDti
TVuW8S9CudFGrL+W+UTMdg/QBBYpPW2ADL+1HdCCMgLLk8sYvW84ra1398KAgj1CEOkMBrI+7x91
DYrSrdOhT/8fsb4Wmpadse6e6xZ5o8IGCIeD6O7Bup7fKSSooKFyMugt1QsHYPYe6BP41O/5jgnD
9GdBink+z7MoSyfzKCOzWXS7mGbRZJFcj2dXs+l0lvzlz02yshF1zZU/5jTYSfZmakChXrER020M
rSsYPw03jHZCzqNttRS1h/OUrNk8T6VBOyorvAjPoMJFWPySRpgeyOVVSkmakbu0iBaT/DrKFtk4
Kq5JHpGkuCsmJCuy2eJlSg9C8W9PCe0rXIzTcVDpgvSr3Eh43uZGy1Y4bpAUbYVhjuHp+9g35VzV
QVpHhezti1J4+udSgNwnocG0w2XkDqswrO5wp+ujL9gzvKGRjYbmgksDLnowGm3+wGgP13eF7e9b
ajhG8oOCmSiSLIMwFxbZ+DqFhbnceb7coYoBVIUdRr05dbCCT7adEZsGTkpCmZS+hQFai6Ghe06e
nbRu5Y6Sh6wDc67qJTX0I3CWMMMV5ir6vBrqCBGQ7Dm5reWrzl89/aD02YdyQOCrP0D4dPhj+d/M
5frmbwAAAP//AwBQSwMEFAAGAAgAAAAhALY7BCJUBgAACxoAABoAAABjbGlwYm9hcmQvdGhlbWUv
dGhlbWUxLnhtbOxZS28bNxC+F+h/WOy9sd6KjciBrUfcxk6CSEmRI6WldhlzlwuSsqNbkRwLFCia
Fj00QG89FG0DJEAv6a9xm6JNgfyFDrkPkRJVO0YKGEEswNid/WY4nJn9huReufogpt4R5oKwpONX
L1V8DycTFpAk7Ph3RoOPLvuekCgJEGUJ7vhzLPyr2x9+cAVtTShJxwzxYBThGHtgKBFbqONHUqZb
GxtiAmIkLrEUJ/BsyniMJNzycCPg6BgGiOlGrVJpbcSIJP42WJTKUJ/Cv0QKJZhQPlRmsJegGEa/
OZ2SCdbY4LCqEGIuupR7R4h2fLAZsOMRfiB9jyIh4UHHr+g/f2P7ygbaypWoXKNr6A30X66XKwSH
NT0mD8floI1Gs9HaKe1rAJWruH673+q3SnsagCYTmGnmi2mzubu522vmWAOUXTps99q9etXCG/br
Kz7vNNXPwmtQZr+xgh8MuhBFC69BGb65gm802rVuw8JrUIZvreDblZ1eo23hNSiiJDlcQVearXq3
mG0JmTK654RvNhuDdi03vkBBNZTVpYaYskSuq7UY3Wd8AAAFpEiSxJPzFE/RBGqyiygZc+LtkzCC
wktRwgSIK7XKoFKH/+rX0Fc6ImgLI0Nb+QWeiBWR8scTE05S2fE/Aau+AXn94qfXL555Jw+fnzz8
9eTRo5OHv2SGLK09lISm1qsfvvznyWfe38++f/X4azdemPg/fv7899++cgNhposQvPzm6Z/Pn778
9ou/fnzsgO9wNDbhIxJj4d3Ax95tFsPEdAhsz/GYv5nGKELE1NhJQoESpEZx2O/LyELfmCOKHLhd
bEfwLgeKcQGvze5bDg8jPpPEYfF6FFvAA8boLuPOKFxXYxlhHs2S0D04n5m42wgducbuosTKb3+W
ArcSl8luhC03b1GUSBTiBEtPPWOHGDtmd48QK64HZMKZYFPp3SPeLiLOkIzI2KqmhdIeiSEvc5eD
kG8rNgd3vV1GXbPu4SMbCW8Fog7nR5haYbyGZhLFLpMjFFMz4PtIRi4nh3M+MXF9ISHTIabM6wdY
CJfOTQ7zNZJ+HejFnfYDOo9tJJfk0GVzHzFmInvssBuhOHVhhySJTOzH4hBKFHm3mHTBD5j9hqh7
yANK1qb7LsFWuk9ngzvArKZLiwJRT2bckctrmFn1O5zTKcKaaoD4LT6PSXIquS/RevP/pXUg0pff
PXHM6qIS+g4nzjdqb4nG1+GWybvLeEAuPnf30Cy5heF1WW1g76n7PXX77zx1r3uf3z5hLzga6Fst
FbOlul64x2vX7VNC6VDOKd4XeukuoDMFAxAqPb0/xeU+Lo3gUr3JMICFCznSOh5n8lMio2GEUljf
V31lJBS56VB4KROw7Ndip22Fp7P4gAXZdrVaVVvTjDwEkgt5pVnKYashM3SrvdiClea1t6HeKhcO
KN03ccIYzHai7nCiXQhVkPTGHILmcELP7K14senw4rIyX6RqxQtwrcwKLJ08WHB1/GYDVEAJdlSI
4kDlKUt1kV2dzLeZ6XXBtCoA1hFFBSwyval8XTs9Nbus1M6QacsJo9xsJ3RkdA8TEQpwXp1KehY3
3jTXm4uUWu6pUOjxoLQWbrQv/5cX58016C1zA01MpqCJd9zxW/UmlMwEpR1/Ctt+uIxTqB2hlryI
hnBgNpE8e+HPwywpF7KHRJQFXJNOxgYxkZh7lMQdX02/TANNNIdo36o1IIQL69wm0MpFcw6SbicZ
T6d4Is20GxIV6ewWGD7jCudTrX5+sNJkM0j3MAqOvTGd8dsISqzZrqoABkTA6U81i2ZA4DizJLJF
/S01ppx2zfNEXUOZHNE0QnlHMck8g2sqL93Rd2UMjLt8zhBQIyR5IxyHqsGaQbW6adk1Mh/Wdt3T
lVTkDNJc9EyLVVTXdLOYNULRBpZieb4mb3hVhBg4zezwGXUvU+5mwXVL64SyS0DAy/g5uu4ZGoLh
2mIwyzXl8SoNK87OpXbvKCZ4imtnaRIG67cKs0txK3uEczgQnqvzg95y1YJoWqwrdaRdnyYOUOqN
w2rHh88DcD7xAK7gA4MPspqS1ZQMruCrAbSL7Ki/4+cXhQSeZ5ISUy8k9QLTKCSNQtIsJM1C0iok
Ld/TZ+LwHUYdh/teceQNPSw/Is/XFvb3m+1/AQAA//8DAFBLAwQUAAYACAAAACEAnGZGQbsAAAAk
AQAAKgAAAGNsaXBib2FyZC9kcmF3aW5ncy9fcmVscy9kcmF3aW5nMS54bWwucmVsc4SPzQrCMBCE
74LvEPZu0noQkSa9iNCr1AcIyTYtNj8kUezbG+hFQfCyMLPsN7NN+7IzeWJMk3ccaloBQae8npzh
cOsvuyOQlKXTcvYOOSyYoBXbTXPFWeZylMYpJFIoLnEYcw4nxpIa0cpEfUBXNoOPVuYio2FBqrs0
yPZVdWDxkwHii0k6zSF2ugbSL6Ek/2f7YZgUnr16WHT5RwTLpRcWoIwGMwdKV2edNS1dgYmGff0m
3gAAAP//AwBQSwECLQAUAAYACAAAACEAu+VIlAUBAAAeAgAAEwAAAAAAAAAAAAAAAAAAAAAAW0Nv
bnRlbnRfVHlwZXNdLnhtbFBLAQItABQABgAIAAAAIQCtMD/xwQAAADIBAAALAAAAAAAAAAAAAAAA
ADYBAABfcmVscy8ucmVsc1BLAQItABQABgAIAAAAIQAr7jcmPwMAAAYHAAAfAAAAAAAAAAAAAAAA
ACACAABjbGlwYm9hcmQvZHJhd2luZ3MvZHJhd2luZzEueG1sUEsBAi0AFAAGAAgAAAAhALY7BCJU
BgAACxoAABoAAAAAAAAAAAAAAAAAnAUAAGNsaXBib2FyZC90aGVtZS90aGVtZTEueG1sUEsBAi0A
FAAGAAgAAAAhAJxmRkG7AAAAJAEAACoAAAAAAAAAAAAAAAAAKAwAAGNsaXBib2FyZC9kcmF3aW5n
cy9fcmVscy9kcmF3aW5nMS54bWwucmVsc1BLBQYAAAAABQAFAGcBAAArDQAAAAA=
" o:allowoverlap="f" filled="f" stroked="f">
<o:lock v:ext="edit" aspectratio="t"/>
<w:wrap type="square" anchory="line"/>
</v:rect><![endif]--><span style="font-family: Verdana, sans-serif; font-size: x-small;">Cost
information for variance transactions will be based on the cost of the items
at the time of the stock count. Cost information is based on the item’s cost
trends, so variance transactions might not match the true cost of the
items. <o:p></o:p></span></div>
</td>
</tr>
</tbody></table>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: justify;">
<br /></div>
<ul type="disc">
<li class="MsoNormal" style="text-align: justify;"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><a href="https://www.blogger.com/null" name="XIV03_04StockCountEntry1279668"></a><span lang="EN">New Next
Stock Count Dates are calculated for the items in the stock count
schedule. <o:p></o:p></span></span></li>
<li class="MsoNormal" style="text-align: justify;"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><a href="https://www.blogger.com/null" name="XIV03_04StockCountEntry1279670"></a><span lang="EN">History
information about the results of the stock count is stored. History is
kept to be the basis of the Accuracy Comparison report, which helps you
monitor the accuracy of your stock counts over time.<o:p></o:p></span></span></li>
<li class="MsoNormal" style="text-align: justify;"><span lang="EN"><span style="font-family: Verdana, sans-serif; font-size: x-small;">If the stock count wasn’t marked to be reused, it’s deleted. If it was
marked to be reused, the stock count results are cleared and the status of
the count is set to Available. <o:p></o:p></span></span></li>
<li class="MsoNormal" style="text-align: justify;"><span style="font-family: Verdana, sans-serif; font-size: x-small;"><a href="https://www.blogger.com/null" name="XIV03_04StockCountEntry1279672"></a><span lang="EN">The
exceptions report for processing a stock count is printed. The report
lists the problems, if any, that prevent the stock count information from
being processed. Even if a stock count is successfully processed, the
exceptions report is printed. If the stock count had no variance
transactions that is noted in the exception report; otherwise, the report
lists the batch number and variance transaction numbers used. <o:p></o:p></span></span></li>
</ul>
<div class="MsoNormal" style="text-align: justify;">
<br /></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
</div>
<div class="MsoNormal" style="text-align: justify;">
<span style="font-family: Verdana, sans-serif;"><span style="font-size: x-small;"><span lang="EN">Goto </span><span lang="EN">--></span><span lang="EN">
Inquiry--></span><span lang="EN">Inventory--></span></span><span lang="EN"><span style="font-size: x-small;">Inventory Transaction.</span><span style="font-size: xx-small;"><o:p></o:p></span></span></span></div>
<div class="MsoNormal" style="text-align: justify;">
<span lang="EN"><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></span></div>
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjh42cniv9W1Ms2DtoD-pTlpWtzFjCzDcrTAYLpAUv_GXxgiFxtXnUO22qiTddcx_sTqzSlL8LKqxzvcBGK9LnTlZzVPHutauIG_D9Kfzsz36mUoRTB_we-0iztiHfK3hvWuZZju_KE52g/s1600/InventoryAdj.png" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><img border="0" height="282" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjh42cniv9W1Ms2DtoD-pTlpWtzFjCzDcrTAYLpAUv_GXxgiFxtXnUO22qiTddcx_sTqzSlL8LKqxzvcBGK9LnTlZzVPHutauIG_D9Kfzsz36mUoRTB_we-0iztiHfK3hvWuZZju_KE52g/s400/InventoryAdj.png" width="400" /></span></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: Verdana, sans-serif; font-size: xx-small;">Inventory Adjustment<br /><br /><br />Until Next Post.. !!!!</span></td></tr>
</tbody></table>
<div class="MsoNormal" style="text-align: justify;">
<span lang="EN"><span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span></div>
<div class="MsoListParagraph" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<br /></div>
Sandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.com0tag:blogger.com,1999:blog-3213366531887654192.post-61075759182553717162013-12-27T10:09:00.001-08:002013-12-27T11:04:10.139-08:00Smart Lookup for Dynamics GP<h2 class="discussion-title" style="background-color: white; border: 0px; font-family: Arial, sans-serif; font-size: 16px; line-height: 18px; margin: 10px 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
This <a href="http://www.linkedin.com/redirect?url=http%3A%2F%2Flnkd%2Ein%2Fb_uhEqY&urlhash=PY6t&_t=tracking_anet" rel="nofollow" style="border: 0px; color: #006699; font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; outline: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;" target="blank">http://lnkd.in/b_uhEqY</a> will change your views about Dynamics GP Lookup. Contact me for free demo copy or additional information.</h2>
<div>
<br /></div>
<div>
Please feel free to call/email me if you need more information.</div>
<div>
<br /></div>
<div>
Thanks<br />
Sandip Jadhav</div>
<div>
210.440.9855</div>
Sandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.com1tag:blogger.com,1999:blog-3213366531887654192.post-10627641765173291802013-08-08T09:35:00.002-07:002013-08-08T10:00:06.234-07:00Error: This document has been removed from Sales Order Processing history Or Sales Transaction Inquiry drill down show different Invoice No.<br />
<span style="font-family: Verdana, sans-serif;">
<span style="font-family: Times New Roman;">
</span><br />
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 10pt;">
<span style="font-family: Verdana, sans-serif;"><span style="font-family: "Verdana","sans-serif"; font-size: 10pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">When I goto
-->Inquiry-->Sales-->Transaction by Document or Customer and try to
lookup that invoice it was showing me different invoice and on some invoice it
was<span style="mso-spacerun: yes;"> </span>throwing <span style="mso-spacerun: yes;"> </span>“This Document has been removed from Sales
Order Process history” even though invoice is open.</span><span style="font-family: "Times New Roman","serif"; font-size: 10pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></span></div>
<span style="font-family: Verdana, sans-serif;">
<span style="font-family: Times New Roman;">
</span><br />
</span><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 10pt;">
<span style="font-family: Verdana, sans-serif;"><span style="font-family: "Verdana","sans-serif"; font-size: 10pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">I have tried everything but it didn't
resolve issue and at last open support request with Microsoft and found very
strange issue that if in<span style="mso-spacerun: yes;">
</span>Transactions-->Sales-->Edit Transaction Information “Description
field” was not same as Invoice No e.g. if your Invoice # is : INV000324354<span style="mso-spacerun: yes;"> </span>Description must match INV000324354 otherwise
you get same error. In our production environment somehow in Description shows
other Invoice no and that’s reason it was drill down to wrong invoice no.</span><span style="font-family: "Times New Roman","serif"; font-size: 10pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></span></div>
<span style="font-family: Verdana, sans-serif;">
</span><span style="font-family: Times New Roman;">
</span><br />
<span style="font-family: Verdana, sans-serif;">
</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7qIEY25WJ0BwQFzRAgNRGI5ulkJr9eWoIyzPIEUO7Br9LW2UTcqvZDso35ezXJ0z7ICcB3ew7UIfgXmZKcC3YQvgvFeav7kOhKxKTJ01keqPIOTMEbf_A3oHnoNv-O-YmSOChYu1HrXo/s1600/Error_Rec.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="326" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7qIEY25WJ0BwQFzRAgNRGI5ulkJr9eWoIyzPIEUO7Br9LW2UTcqvZDso35ezXJ0z7ICcB3ew7UIfgXmZKcC3YQvgvFeav7kOhKxKTJ01keqPIOTMEbf_A3oHnoNv-O-YmSOChYu1HrXo/s640/Error_Rec.PNG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPpxLP5O076-DFBy02cGJxpFuNwqAkYLv3ogTLJnW1-i445DDziu8TKYR327_GnSdoNqm4cIozp-VP479cddMRgZWC4MJTXH8eX64szkqfJGBjDXUyLUt23txKXiBE1bkPTWZctF-0zUE/s1600/Error_Rec.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: Verdana, sans-serif;"></span></a><br /></div>
<span style="font-family: Verdana, sans-serif;"></span><br />
<span style="font-family: Verdana, sans-serif;">
</span><br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
</div>
<span style="font-family: Verdana, sans-serif;"></span><br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Verdana, sans-serif;"><span style="font-family: Times New Roman;">
</span></span></div>
<span style="font-family: Verdana, sans-serif;">
</span><div class="MsoNormal" style="line-height: normal; margin: 0in 0in 10pt;">
<span style="font-family: Verdana, sans-serif;"><span style="font-family: "Verdana","sans-serif"; font-size: 10pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Note: If Description is blank it work
perfectly but if Description is other than Invoice No then it act differently.</span><span style="font-family: "Times New Roman","serif"; font-size: 10pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></span></div>
<span style="font-family: Verdana, sans-serif;">
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Times New Roman;">
</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 10pt;">
<span style="font-family: "Verdana","sans-serif"; font-size: 10pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Good news is that Microsoft confirms
that it is “Bug” and already reported but don’t know when Microsoft is going to
resolve this issue.</span><span style="font-family: "Times New Roman","serif"; font-size: 10pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Times New Roman;">
</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 10pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 10pt; mso-fareast-font-family: "Times New Roman";"> <o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Times New Roman;">
</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 10pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 10pt; mso-fareast-font-family: "Times New Roman";"> <o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Times New Roman;">
</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 10pt;">
<span style="font-family: "Verdana","sans-serif"; font-size: 10pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Until Next Post !!!</span><span style="font-family: "Times New Roman","serif"; font-size: 10pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Times New Roman;">
</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 10pt;">
<span style="font-family: "Verdana","sans-serif"; font-size: 10pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Thanks</span><span style="font-family: "Times New Roman","serif"; font-size: 10pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Times New Roman;">
</span></div>
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 10pt;">
<span style="font-family: "Verdana","sans-serif"; font-size: 10pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Sandip</span><span style="font-family: "Times New Roman","serif"; font-size: 10pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
</span><br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Times New Roman;">
</span></div>
<o:p></o:p><br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
</div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
</div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Verdana, sans-serif;">
</span></div>
<br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: Verdana, sans-serif;"></span><br /></div>
Sandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.com6tag:blogger.com,1999:blog-3213366531887654192.post-14029353844684604262012-04-14T18:59:00.001-07:002013-02-13T10:02:55.418-08:00Next Document Number Web Service using eConnect<span style="font-family: Calibri;"><span style="font-family: Times New Roman;"> </span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">Below is sample code for creating custom Web Service using eConnect for Next Document Number.<o:p></o:p></span></span><br />
<span style="font-family: Calibri;"><span style="font-family: Times New Roman;"> </span><br />
</span><br />
<span style="font-family: Calibri;"></span><br />
<span style="font-family: Calibri;"></span><br />
<span style="font-family: Calibri;"><div class="MsoNormal" style="margin: 0in 0in 0pt;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">using</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> Microsoft.Dynamics.GP.eConnect;</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<br /></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">[<span style="color: #2b91af;">WebMethod</span>]</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">public</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: blue;">string</span> NextSopDocumentNumber(<span style="color: blue;">string</span> TransactionType, <span style="color: blue;">string</span> salesDocID)</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">{</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;">
<span style="color: #2b91af; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">GetNextDocNumbers</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> sopTransNumber = <span style="color: blue;">new</span> <span style="color: #2b91af;">GetNextDocNumbers</span>();</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">string</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> nextTransactionNumber = <span style="color: blue;">string</span>.Empty;</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">try</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in;">
<span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">{</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1in; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">///string</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> sConnectionString = <span style="color: #2b91af;">ConfigurationManager</span>.ConnectionStrings[<span style="color: #a31515;">"GpeConnectConnectionString"</span>].ToString();</span><br />
<br />
<span style="font-family: Consolas;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"><span style="color: red; font-family: Consolas; font-size: x-small;"></span></span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">string<span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"><span style="color: black;"> sConnectionString = </span><span style="color: #2b91af;"></span></span>=</span></span></span><span style="font-family: Consolas; font-size: x-small;"><span style="font-family: Consolas; font-size: x-small;">"</span></span><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;">server=YourServerName;database=YourDatabaseName;Integrated Security=SSPI;persist security info=False</span></span></span><br />
<span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"><span style="color: blue; font-family: Consolas; font-size: x-small;"></span></span></span></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1in; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">switch</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> (TransactionType)</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1in; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">{</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1.5in; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">case</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: #a31515;">"SalesQuote"</span>:</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1.5in; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">nextTransactionNumber = sopTransNumber.GetNextSOPNumber(<span style="color: #2b91af;">IncrementDecrement</span>.Increment, salesDocID, <span style="color: #2b91af;">SopType</span>.SOPQuote, sConnectionString);</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1.5in; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">break</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">;</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1.5in; mso-layout-grid-align: none;">
<br /></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1.5in; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">case</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: #a31515;">"SalesOrder"</span>:</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1.5in; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">nextTransactionNumber = sopTransNumber.GetNextSOPNumber(<span style="color: #2b91af;">IncrementDecrement</span>.Increment, salesDocID, <span style="color: #2b91af;">SopType</span>.SOPOrder, sConnectionString);</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1.5in; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">break</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">;</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1.5in; mso-layout-grid-align: none;">
<br /></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1.5in; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">case</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: #a31515;">"SalesInvoice"</span>:</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1.5in; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">nextTransactionNumber = sopTransNumber.GetNextSOPNumber(<span style="color: #2b91af;">IncrementDecrement</span>.Increment, salesDocID, <span style="color: #2b91af;">SopType</span>.SOPInvoice, sConnectionString);</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1.5in; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">break</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">;</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1.5in; mso-layout-grid-align: none;">
<br /></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1.5in; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">case</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: #a31515;">"SalesReturn"</span>:</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1.5in; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">nextTransactionNumber = sopTransNumber.GetNextSOPNumber(<span style="color: #2b91af;">IncrementDecrement</span>.Increment, salesDocID, <span style="color: #2b91af;">SopType</span>.SOPReturn, sConnectionString);</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1.5in; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">break</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">;</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1.5in; mso-layout-grid-align: none;">
<br /></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1.5in; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">case</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> <span style="color: #a31515;">"SalesBackOrder"</span>:</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1.5in; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">nextTransactionNumber = sopTransNumber.GetNextSOPNumber(<span style="color: #2b91af;">IncrementDecrement</span>.Increment, salesDocID, <span style="color: #2b91af;">SopType</span>.SOPBackOrder, sConnectionString);</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1.5in; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">break</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">;</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1in; mso-layout-grid-align: none;">
<br /></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1in; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">}</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1in; mso-layout-grid-align: none;">
<br /></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">return</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> nextTransactionNumber;</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">}</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">catch</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> (<span style="color: #2b91af;">Exception</span> ex)</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">{<span style="color: green;">// If an error occurs, diplay the error information to the user</span></span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1in; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">throw</span><span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";"> ex;</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">}</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in; mso-layout-grid-align: none;">
<span style="color: blue; font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">finally</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">{</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 1in; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">sopTransNumber.Dispose();</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><br />
<div class="MsoNormal" style="margin: 0in 0in 0pt 0.5in; mso-layout-grid-align: none;">
<span style="font-family: Consolas; font-size: 9.5pt; mso-fareast-font-family: "Times New Roman";">}</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;"> </span><span style="font-family: Consolas; font-size: 9.5pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US;">}</span><br />
<br />
<br />
<br />
<span style="font-family: Consolas; font-size: 9.5pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US;">Below are eConnect schemas to get other transaction type Next Doucment Number.</span><br />
<span style="font-family: Consolas; font-size: 9.5pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US;"><a href="http://msdn.microsoft.com/en-us/library/ff623613.aspx">http://msdn.microsoft.com/en-us/library/ff623613.aspx</a></span><br />
<span style="font-family: Consolas;"></span><br />
<span style="font-family: Consolas;"></span><br />
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">To Rollback Transactions
Number:<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><o:p> </o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-tab-count: 1;"> </span><span style="mso-spacerun: yes;"> </span>[</span><span style="background: white; color: #2b91af; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">WebMethod</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">]<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span style="background: white; color: blue; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">public</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> </span><span style="background: white; color: blue; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">void</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> RollBackMyDocumentNumber(</span><span style="background: white; color: blue; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">string</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> strTransactionType,
</span><span style="background: white; color: blue; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">string</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> strDocNumber)<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span>{<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span style="background: white; color: #2b91af; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">DocumentRollback</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> TransRollback = </span><span style="background: white; color: blue; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">new</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> </span><span style="background: white; color: #2b91af; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">DocumentRollback</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">();<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><o:p> </o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span style="background: white; color: blue; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">string</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> sConnectionString = </span><span style="background: white; color: #2b91af; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">ConfigurationManager</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.ConnectionStrings[</span><span style="background: white; color: #a31515; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">"GpeConnectConnectionString"</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">].ToString();<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span style="background: white; color: blue; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">try</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span>{<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span style="background: white; color: blue; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">switch</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> (strTransactionType)<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span>{<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span><span style="mso-tab-count: 1;"> </span></span><span style="background: white; color: blue; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">case</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> </span><span style="background: white; color: #a31515; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">"SOP"</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">:<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span><span style="mso-tab-count: 2;"> </span>TransRollback .Add(</span><span style="background: white; color: #2b91af; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">TransactionType</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.SOP, strDocNumber);<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span><span style="mso-tab-count: 2;"> </span></span><span style="background: white; color: blue; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">break</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">;<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span style="background: white; color: blue; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">case</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> </span><span style="background: white; color: #a31515; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">"Adjustment"</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">: </span><span style="background: white; color: green; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">//Adjustment</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span>TransRollback.Add(</span><span style="background: white; color: #2b91af; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">TransactionType</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.IVTrans, strDocNumber);<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span style="background: white; color: blue; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">break</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">;<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span style="background: white; color: blue; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">case</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> </span><span style="background: white; color: #a31515; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">"IVTransfer"</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">:<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span><span style="mso-spacerun: yes;"> </span>TransRollback.Add(</span><span style="background: white; color: #2b91af; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">TransactionType</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.IVTransfer, strDocNumber);<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span style="background: white; color: blue; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">break</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">;<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span style="background: white; color: blue; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">case</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> </span><span style="background: white; color: #a31515; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">"POPReceipt"</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">:<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span>TransRollback.Add(</span><span style="background: white; color: #2b91af; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">TransactionType</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">.POPReceipt, strDocNumber);<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span style="background: white; color: blue; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">break</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">;<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span>}<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span><o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span>}<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span style="background: white; color: blue; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">catch</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> (</span><span style="background: white; color: #2b91af; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">Exception</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> ex)<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span>{</span><span style="background: white; color: green; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">// If an error occurs, diplay
the error information to the user</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span style="background: white; color: blue; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">throw</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"> ex;<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span>}<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span></span><span style="background: white; color: blue; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;">finally</span><span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span>{<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span>TransRollback.Dispose();<o:p></o:p></span></div>
<span style="font-family: Times New Roman;">
</span><br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; line-height: 115%; mso-bidi-font-family: Consolas; mso-highlight: white;"><span style="mso-spacerun: yes;"> </span>}</span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; line-height: 115%; mso-bidi-font-family: Consolas; mso-highlight: white;"></span> </div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; line-height: 115%; mso-bidi-font-family: Consolas; mso-highlight: white;">Below is more details on RollBackDocument </span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; line-height: 115%; mso-bidi-font-family: Consolas; mso-highlight: white;"><a href="http://msdn.microsoft.com/en-us/library/ff623621.aspx">http://msdn.microsoft.com/en-us/library/ff623621.aspx</a></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; line-height: 115%; mso-bidi-font-family: Consolas; mso-highlight: white;"><a href="http://msdn.microsoft.com/en-us/library/ff623629.aspx">http://msdn.microsoft.com/en-us/library/ff623629.aspx</a></span></div>
<div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="background: white; color: black; font-family: "Verdana","sans-serif"; font-size: 8pt; line-height: 115%; mso-bidi-font-family: Consolas; mso-highlight: white;"></span> </div>
<span style="font-family: Times New Roman;">
</span>
<br />
<span style="font-family: Consolas; font-size: 9.5pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US;">Feel free to email me if you need any further assistance or please share your code for same.</span><br />
<br />
<span style="font-family: Consolas; font-size: 9.5pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US;">Happy coding!!!</span><br />
<span style="font-family: Consolas; font-size: 9.5pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: EN-US;">Thanks<br />
Sandip</span></span><br />
<br />Sandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.com13tag:blogger.com,1999:blog-3213366531887654192.post-42790360355529586122011-12-08T08:14:00.000-08:002012-09-08T11:07:21.035-07:00Professional Services Tools – Import Button<span style="font-family: Verdana, sans-serif;"><span style="font-family: Times New Roman;"></span><span style="font-family: "Verdana","sans-serif";">Got request from user that they want to modified Item Numbers, we already have Professional Service Tools license but problem was it not just one item I have to modify where I will enter starting number and ending and it’s done.<o:p></o:p></span></span><br />
<span style="font-family: Verdana, sans-serif;"><span style="font-family: Times New Roman;"></span><br /><div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: "Verdana","sans-serif";">There were 100 + items need to modify!!! I was trying to use Import button to update Item Number using excel </span><span style="font-family: Wingdings; mso-ascii-font-family: Verdana; mso-char-type: symbol; mso-hansi-font-family: Verdana; mso-symbol-font-family: Wingdings;"><span style="mso-char-type: symbol; mso-symbol-font-family: Wingdings;">à</span></span><span style="font-family: "Verdana","sans-serif";"> created excel file with header “Starting Item Number” , “New Item Number” to match what I see in PSTL Item Modifier screen and then converted Excel file into CSV , validate but it didn’t work it was giving me error “Source Item not found” <span style="mso-spacerun: yes;"> </span>to find answer searched in Partnersource, <span style="mso-spacerun: yes;"> </span>Google didn’t help much as Integration Manager support CSV file even Sql Profiler and DexSQL Log file was not showing any logical error which help me to import these Items. <span style="mso-spacerun: yes;"> </span>Other options I was thinking to create Mail Merge Macros to import these Items to avoid manual entry.<o:p></o:p></span></div>
<span style="font-family: Times New Roman;"></span><br /><div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: "Verdana","sans-serif";">Just to check I converted Excel file into Tab Delimited without Tab header information Validated Walla!!! It works no more error!!! Imported all items using Tab Delimited file instead of going each items or creating mail merge macro.<o:p></o:p></span></div>
<span style="font-family: Times New Roman;"></span><br /><div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<span style="font-family: Times New Roman;"></span><br /><div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: "Verdana","sans-serif";">Until Next post!!!<o:p></o:p></span></div>
<span style="font-family: Times New Roman;"></span><br /><div class="MsoNormal" style="margin: 0in 0in 10pt;">
<br /></div>
<span style="font-family: Times New Roman;"></span><br /><div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: "Verdana","sans-serif";">Thanks<o:p></o:p></span></div>
<span style="font-family: Times New Roman;"></span><br /><div class="MsoNormal" style="margin: 0in 0in 10pt;">
<span style="font-family: "Verdana","sans-serif";">Sandip Jadhav<o:p></o:p></span></div>
</span><span style="font-family: Times New Roman;"></span>Sandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.com0tag:blogger.com,1999:blog-3213366531887654192.post-50964085986038172742011-11-22T17:23:00.000-08:002013-02-12T09:42:20.190-08:00Refund Cash to CustomerRefund Cash to customer <br />
<br />
<br />
In Dynamics GP have option for "Refund to Customer" (Transactions-->Sales-->Refund Checks) but in small scale company it is not possible to make payment through checks for every customers. <br />
<br />
When we create Refund from Dynamics GP it transfer Receivable balance to Payables Management creating checks for customer.<br />
<br />
Scenarios:<br />
<br />
1) Received access payment from customer through credit card and need to return cash back to him.<br />
<br />
2) Access Payment Received from customer and need to pay back cash.<br />
<br />
<br />
Make Debit Memo from Transaction-->Sales-->Receivable Transaction-->Debit Memo and apply to Invoice.<br />
<br />
<strong><u>Distributions:</u></strong><br />
<br />
Debit : Accounts Receivable (Refund Amount)<br />
Credit : Accounts Receivable Misc <br />
<br />
<br />
With above distribution your Receivable will be get zero.<br />
<br />
<br />
<strong><u>To Bank:</u></strong><br />
<br />
Transaction-->Financial -->Bank Transactions<br />
<br />
Change entry to "Decrease Adjustment" and enter the amount for Refund.<br />
<br />
<strong><u>Distribution:</u></strong><br />
<br />
Debit: Accounts Receivable Misc (Refund Amount)<br />
<br />
Credit: Cash A/c <br />
<br />
<br />
<br />
Simple Cash Refund entry without Checks(Cheques)<br />
<br />
<br />
Thanks<br />
Sandip JadhavSandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.com1tag:blogger.com,1999:blog-3213366531887654192.post-52608649250907237842011-08-23T17:28:00.000-07:002011-08-23T17:28:47.445-07:00How to get beginning account balance when past year not closed yet? <span style="font-family: Calibri;">If previous year is not closed Microsoft Dynamics GP does not displaying account balances for Balance Sheet accounts for New Year. This can give wrong account information to Financial users.</span><br />
<br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;"><span style="font-family: Calibri;">Suggestions:</span></div><br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;"><span style="font-family: Calibri;">1)<span style="mso-spacerun: yes;"> </span>If you know your previous year balance i.e. Closing Balance pass one GL Entry for opening entry i.e.<span style="mso-spacerun: yes;"> </span>on 01/01/2011 and then reverse it before you close the Year</span></div><br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;"><span style="font-family: Calibri;">This way you will see opening Balance for new year and once you ready to close previous year reverse the same entry.</span></div><br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;"><span style="font-family: Calibri;">2)<span style="mso-spacerun: yes;"> </span>There is no issue to close Fiscal Year because transactions still be posted to closed Fiscal Year. With this solution no need to pass and reverse dummy entry to get opening balance.</span></div><br />
<div class="MsoNormal" style="margin: 0in 0in 10pt;"><span style="font-family: Calibri;">I will recommend to go for second suggestion if you can close Fiscal Year.</span></div><div class="MsoNormal" style="margin: 0in 0in 10pt;"><br />
</div><div class="MsoNormal" style="margin: 0in 0in 10pt;">Thanks </div><div class="MsoNormal" style="margin: 0in 0in 10pt;">Sandip</div>Sandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.com2tag:blogger.com,1999:blog-3213366531887654192.post-11908738836050869912010-10-12T07:44:00.000-07:002010-10-12T07:49:00.301-07:00Installing, Troubleshooting Dynamics GP Smart TagDynamics GP Smart Tag really work “smart” and after installing users was very excited to see inquiry window from Word, Excel and Outlook. <br />
<br />
<br />
Below are steps I followed to installed Smart Tag on Production Environment and it working successfully.<br />
<div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;">1) Created Windows Security Group for each type of Security e.g.</div><br />
<div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0lP-SKUqW1j-uq78fzU8RA2pjXX1db07gZ7TGNBMDKxGhHtm2VYnNJHu86imd1xZi47okn8Y3ex0DGwXnRgDg03yPqVsJq8a-79kCfPZReSRsj_AKdKnhFAKfdXR2khRr-5HCA-8bAEA/s1600/SmartTag1.bmp" imageanchor="1" style="clear: left; cssfloat: left; float: left; height: 136px; margin-bottom: 1em; margin-right: 1em; width: 337px;"><img border="0" ex="true" height="136" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0lP-SKUqW1j-uq78fzU8RA2pjXX1db07gZ7TGNBMDKxGhHtm2VYnNJHu86imd1xZi47okn8Y3ex0DGwXnRgDg03yPqVsJq8a-79kCfPZReSRsj_AKdKnhFAKfdXR2khRr-5HCA-8bAEA/s320/SmartTag1.bmp" width="320" /></a></div><div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;"><br />
</div> <br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Make sure one user should not available in another group e.g. if you think user “abc” is having access of Accounts Receivable and Accounts Payable do not assign that user in both group instead of create another group call “Dynamics GP_APnAR” and assigned to it. <br />
<br />
<br />
If user is exist in more than one group in Smart Tag Configuration window on client machine you will not see Entities.<br />
<br />
2) a) After creating Window Security Group installed Smart Tag Server on Dynamics GP Database Server, run Dynamics GP Utilities to get require table populated. Make sure take good backup of Dynamics and Production DB.<br />
b) Add Group in Smart Tag Manager Enable respective Entities, Action and most important Companies <br />
for each Windows Group.<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLWcWhlHC1hsWg_YvtpqFmwXvJDFVQ7U8qBH3wQoyIZjnAEDu4ErhMGCIIkn9CKIv8ME9weP3Cnht2jduDTvnkvBvWw7s0WHSKupxhvT8dgwBeQcISFOfDRhwWLZBIIQwAP04d7RaWcFk/s1600/SmartTag2.bmp" imageanchor="1" style="clear: left; cssfloat: left; float: left; height: 244px; margin-bottom: 1em; margin-right: 1em; width: 374px;"><img border="0" ex="true" height="244" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLWcWhlHC1hsWg_YvtpqFmwXvJDFVQ7U8qBH3wQoyIZjnAEDu4ErhMGCIIkn9CKIv8ME9weP3Cnht2jduDTvnkvBvWw7s0WHSKupxhvT8dgwBeQcISFOfDRhwWLZBIIQwAP04d7RaWcFk/s320/SmartTag2.bmp" width="320" /></a></div><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Now ready to install Smart Tag on Client Machine before that do the following setup or check following important task in Word, Excel and Outlook.<br />
<br />
<br />
1) In Word, Excel and Outlook -->Goto-->Tools-->Macros-->Security In Security Level Select “Medium” and in Trusted Publisher tab select “Trust all Installed add-ins and templates”<br />
<br />
2) Goto--> Auto Correct options-->Smart Tag mark “Label data with smart tag”<br />
<br />
Installed Smart Tag client version , Goto--> Administration page you should see “Entities” and verify on Word or Excel smart tag is working or not. <br />
<br />
If not then follow below steps:-<br />
<br />
a) windows Security for user is assigned or not <br />
<br />
b) User should not be duplicate in other Groups <br />
<br />
c) Check Company is enable or not for windows group in GP Server “Manage Groups” screen.<br />
<br />
d) Close Smart Tag Manager and then Goto --> C:\Program Files\Office Smart Tag Manager\temp and Delete/Rename “stConfig” and “Stterms” files. “stConfig” is hidden file. Reopen Smart Tag Manager and verify Entities in Administration. Type any Smart Tag word in Word or Excel to recreate above files.<br />
<br />
e) If above option didn’t work reinstalled smart tag Manger. <br />
<br />
f) Generate Debug Report to understand issue.<br />
<br />
1. Click Start, click Run, type Regedit, then press ENTER.<br />
2. In Registry Editor, locate the following registry subkey: <br />
HKey_Local_Machine\Software\Microsoft\BusinessSolutions\Office Smart Tag Manager\9.0<br />
\Administration<br />
3. Set the Debug key to ON. Then, re-create the issue. After the error occurs, set the Debug key to <br />
OFF. <br />
4. Submit the OXPSTMAdminDLL-DebugLog.txt file to Support. <br />
<br />
g) If Smart Tag is not recognizing in Word or Excel in my case in Excel Smart Tag was not working. Detect and Repair utility in Excel help me to resolve issue.It will repair Ms-Office application.<br />
Goto--> Help-->Detect and Repair Select both options and start repairs. You may need to do setup again for Outlook. Remove and reinstalled smart tag again. After detect and repairs check security and AutoCorrect options and mark “Label data with smart tag” in smart tag tab before installing Dynamics GP Smart Tag.<br />
<br />
<br />
To change Update Rate for Smart Tag :-<br />
1. Click Start, click Run, type regedit, and then click OK. <br />
<br />
2. Expand HKEY_LOCAL_MACHINE. <br />
3. Expand Software. <br />
4. Expand Microsoft. <br />
5. Expand Business Solutions. <br />
6. Expand Microsoft Office Smart Tag Manager. <br />
7. Expand 9.0. <br />
8. Click Engine. <br />
9. Right-click LOADREFRESHRATE, and then click Modify. <br />
10. Change the value in the Value data field. <br />
Note: The change is instant and does not require that you restart the computer.<br />
<br />
Thanks<br />
<br />
SandipSandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.com2tag:blogger.com,1999:blog-3213366531887654192.post-52595372438038688322010-09-04T09:09:00.000-07:002010-09-04T09:09:54.988-07:00Common mistake by Payable Clerk with POP transactions1) Purchase Order-->Received Inventory . When Invoice is received instead of matching Invoice created Payable Transaction with same invoice no. PO which is has Inventory Receipt didn't matched with Invoice. PO Status is still show open.<br />
<br />
<br />
2) Purchase Order created --> Receipt with Landed Cost . Invoice Matched without Landed Cost.<br />
<br />
3) Purchase Order created-->Receipt with Landed Cost. matched Invoice for Receipt , AP Clerk forgot to matched / Apply Landed cost in Purchasing Invoice. After receiving separate Invoice for Landed Cost Expenses AP clerk created Payable Transaction for Landed Cost Invoice and paid.<br />
<br />
4) Purchase Order -->Partial Receipt with Vendor Confirmation that he is not going to ship other Item. Instead of cancelling other Line Items in Receipt. AP Clerk Received Item --> Matched Invoice. As line Item for those PO is not cancelled PO status still show open.<br />
<br />
<br />
<br />
All above mistake can cause Purchase Order status open and Accrued Purchase Account will show balance. Make sure to check when you will do edit PO it will create some GL Transaction for cancelled/closed PO Line Items.<br />
<br />
For landed cost Invoiced adjustment which is not matched, to closed PO user must need to matched Landed Cost and create Credit Memo with proper GL Account and apply Landed Cost Invoice to avoid Voiding all payment and payable transactions.Sandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.com4tag:blogger.com,1999:blog-3213366531887654192.post-24344088108074640822010-07-16T13:09:00.000-07:002010-07-20T08:32:21.230-07:00Customers Item same like Vendor Items ???Do we have same option like Vendor Item in Dynamics GP for Customer Items? Yes. How it useful in Purchasing Module when user select “Vendor Item Option” it shows only those items which is assigned to Vendors and it help user for smooth data entry. Same option is available in Dynamics GP called “Customer Items Maintenance”<br />
<br />
Once user assigns Customer Items in Customer in Sales Transactions it will display only those Items which is assigned to customer.<br />
<br />
How to assign – GOTO --> Cards-->Sales-->Customer Items<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEig2QIKus4E4zcBvITcDfCR7IMgwLOKQlw1C2TRRE2ls-Xd2zVTUJsnDhYMUWJ6PwJWq5qInLRNuiy8otyo8dEkQSp36CYffX18WZM1m1rDB2Ka3uUCG9eYI1HIMh1YcnwAIvSxJ0xsKCU/s1600/CustomerItemMaintenance.bmp" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="253" hw="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEig2QIKus4E4zcBvITcDfCR7IMgwLOKQlw1C2TRRE2ls-Xd2zVTUJsnDhYMUWJ6PwJWq5qInLRNuiy8otyo8dEkQSp36CYffX18WZM1m1rDB2Ka3uUCG9eYI1HIMh1YcnwAIvSxJ0xsKCU/s320/CustomerItemMaintenance.bmp" width="320" /></a></div> <br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
In Sales Transaction Entry <br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYtVTmUVqdLEroAjr3rvAO4BwwlAIFEYF7yH3nbdC3TQ1GghwS-e8IAsK-KVC3CDBYLg9yfGHg6aOg6eBIGglorguDmI5gvfUOJwSVdVHo_cRZI4qWYmWF7PlWB2SSlN0vnHetPWRHvXc/s1600/CustomerItemMaintenance2.bmp" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="226" hw="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYtVTmUVqdLEroAjr3rvAO4BwwlAIFEYF7yH3nbdC3TQ1GghwS-e8IAsK-KVC3CDBYLg9yfGHg6aOg6eBIGglorguDmI5gvfUOJwSVdVHo_cRZI4qWYmWF7PlWB2SSlN0vnHetPWRHvXc/s320/CustomerItemMaintenance2.bmp" width="320" /></a></div> <br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Select Customer Items in Item Lookup and it will display only those Items which assigned in Customer Items Maintenance window. <br />
<br />
<br />
<br />
Thanks<br />
<br />
SandipSandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.com0tag:blogger.com,1999:blog-3213366531887654192.post-5851137726881152752010-06-27T20:27:00.000-07:002010-06-27T20:27:18.485-07:00There was a problem ascertaining product version information. Microsoft Dynamics GP Utilities will now exit. Check DUinstall.log for more informationOkay, So I was upgrading Dynamics GP 9.0 installed service pack 4 and Payroll Year end 2009 but I was getting error.. "There was a problem ascertaining product version information.. ..... check Duinstall.log for more information"<br />
<br />
When I checked for Duinstall.log file it was showing Error for product id 0 and 309 that is Dynamics GP and Fixed Assets Module. Spend 4 days almost to research on this issue but no luck. There were several blogs about above error but nothing was helping me and Microsoft KB article 952054 was not just enough to resolve issue it didn't give any resolution.<br />
<br />
Decided not to leave this issue and not to open support request with Microsoft. After going through Microsoft Knowledgebase on Dynamics GP 9.0 upgrade path it says if Upgrading GP9.0 or other older version for Dynamics GP10.0 need to install Patch.. it installed and upgrade went to very smoothly.<br />
<br />
<br />
<br />
** Link to upgrade path.<br />
<br />
<a href="https://mbs.microsoft.com/Cms/Templates/document/General.aspx?NRMODE=Published&NRNODEGUID={300CEDF2-CB9E-4934-BAB8-FC2ABED28439}&NRORIGINALURL=/customersource/support/knowledgebase/hottopics/hot_topic_updatingmicrosoftdynamicsgp10.htm?printpage=false&NRCACHEHINT=Guest&printpage=false">https://mbs.microsoft.com/Cms/Templates/document/General.aspx?NRMODE=Published&NRNODEGUID={300CEDF2-CB9E-4934-BAB8-FC2ABED28439}&NRORIGINALURL=/customersource/support/knowledgebase/hottopics/hot_topic_updatingmicrosoftdynamicsgp10.htm?printpage=false&NRCACHEHINT=Guest&printpage=false</a><br />
<br />
I try to list all blogs and other links reference to above error. Hope it will help you.<br />
<br />
1) <a href="http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.greatplains&tid=7f497181-9aad-4745-9b87-d3452b951ab4">http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.greatplains&tid=7f497181-9aad-4745-9b87-d3452b951ab4</a><br />
<br />
2) <a href="http://dynamicsconfessions.blogspot.com/2009/02/problem-ascertaining-product-version.html">http://dynamicsconfessions.blogspot.com/2009/02/problem-ascertaining-product-version.html</a><br />
<br />
3) <a href="http://www.keyongtech.com/5254080-upgrade-failure-release-10-0-a">http://www.keyongtech.com/5254080-upgrade-failure-release-10-0-a</a><br />
<br />
4) <a href="http://www.keyongtech.com/3603302-product-0-does-not-support">http://www.keyongtech.com/3603302-product-0-does-not-support</a><br />
<br />
5) <a href="https://community.dynamics.com/forums/p/34451/60089.aspx">https://community.dynamics.com/forums/p/34451/60089.aspx</a><br />
<br />
May be one of them will help you to resolve this error.. I got it resolved by GP10 hotfix.<br />
<br />
Until next post !!!<br />
<br />
SandipSandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.com1tag:blogger.com,1999:blog-3213366531887654192.post-683895422259969812010-04-27T19:27:00.000-07:002010-05-01T09:58:40.531-07:00Types of Integration methods with Dynamics GP1) Integration Manager-To import Masters and Transactional data from excel sheet, Tab Delimited or comma delimited files. Integration Manager can used to import opening balances. It required user interfere but can schedule integration manager.<br />
<br />
Microsoft allowed 90 days free use of Integration Manager<br />
<br />
2) eConnect- One of the another way to integrated Data into Dynamics GP, required programming experience to used eConnect API. user can do VB,VB.NET or C# coding to use eConnect. Required license for Developer Toolkit to used eConnect.<br />
<br />
Pro-eConnect used windows login id that means user need not to be Dynamics GP user. <br />
<br />
Cos-Need to install eConnect on every machine where it required to used.<br />
<br />
3) Dynamics GP Web Services- Web Services created using behind the screen eConnect API, again user need to have programming experience to create integration utility using web services. Dynamics GP Web Service Management Console offer user level integration rights where it can assigned specific user certain right e.g. to only import purchasing information or Receiving Transaction only.<br />
<br />
4) Rapid Implementation Tools- Used to copy existing data from one company to another with all setup information. useful to migrate data from QuickBooks and version 2.0 can migrate from Peachtree.<br />
<br />
5) SQL Query (Insert statement)- again need to be very careful need to follow all Dynamics GP logic to run Insert statement against table. Need to verify and populate all related table.. risky process !!!<br />
<br />
6) Macro's - Macros can also used to create integration in Dynamics GP and it follow all GP Logic <br />
<br />
7) Table Import-Dynamics GP utility that allow to import data from file directly into Dynamics GP table which I don't recommend because if you miss a related table it will be problem or must need to populate those table also or must run checklinks after table import in mostly it created required data in related table.<br />
<br />
8) Copy Company Utility-This utility allows you to set up new company from existing company and can import all master records as well as transactional data also.<br />
<br />
Do you know any other way to integrate data into Dynamics GP ?Sandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.com2tag:blogger.com,1999:blog-3213366531887654192.post-23863511701888034672010-03-27T20:23:00.000-07:002010-04-04T08:06:34.374-07:00Chage Item Option from "None" to "Lot" or "Serial"<div class="separator" style="clear: both; text-align: center;"></div>To change Item tracking option from None to Lot Number Item Qty on hand must be zero.<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXFF7xapt0qf1nmbjeNeYYbyYDJLG82YDThxU5vLxaFK4N4oyfYBka1R47lloGfmigcAe6OZiuWZi6fB4E5szgGwSZ4w4s_Dzke5kxLN_An3GRtGjDoi0leDhvMFyR7CivLlLfhBpt8y4/s1600/NoneToLot.png" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="246" nt="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjXFF7xapt0qf1nmbjeNeYYbyYDJLG82YDThxU5vLxaFK4N4oyfYBka1R47lloGfmigcAe6OZiuWZi6fB4E5szgGwSZ4w4s_Dzke5kxLN_An3GRtGjDoi0leDhvMFyR7CivLlLfhBpt8y4/s320/NoneToLot.png" width="320" /></a><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Click on Option<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: left;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKf3cABKGucrcAakH1ZtDZtJGDy44KOp9iUV8Smr775-N5VAGkqPrRjGqLKkS3rfXOC3fxtiGhUWIhanEPMx3Lk1FiYmfvgcAgC1sllq2iCw0XEou6sXcN93CM01hocOf13sRpBLSbzjo/s1600/NoneToLot2.png" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="242" nt="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKf3cABKGucrcAakH1ZtDZtJGDy44KOp9iUV8Smr775-N5VAGkqPrRjGqLKkS3rfXOC3fxtiGhUWIhanEPMx3Lk1FiYmfvgcAgC1sllq2iCw0XEou6sXcN93CM01hocOf13sRpBLSbzjo/s320/NoneToLot2.png" width="320" /></a></div><div class="separator" style="clear: both; text-align: left;">Following steps to change Item tracking option from "None" to "Lot"</div><br />
<br />
<div class="separator" style="clear: both; text-align: left;">1) Create negative Adjustment Entry from Transactions---> Inventory ---> Transaction Entry for those Item you want to change to "lot item"</div><div class="separator" style="clear: both; text-align: left;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfs0gGmIiTu6-LayZigaPequ2_WsecNYMy2obTg-eTtQa3ELDWLvZGApXGLIpPsWCv65ikR4tHS41MMgfcvb71U7STBqmxUiCcWqFsW1qN58nj1L0YdACnAeDU1MoLaeRASWNuLPqEQz8/s1600/NoneToLot3.png" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="250" nt="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfs0gGmIiTu6-LayZigaPequ2_WsecNYMy2obTg-eTtQa3ELDWLvZGApXGLIpPsWCv65ikR4tHS41MMgfcvb71U7STBqmxUiCcWqFsW1qN58nj1L0YdACnAeDU1MoLaeRASWNuLPqEQz8/s320/NoneToLot3.png" width="320" /></a></div><div class="separator" style="clear: both; text-align: left;">2) Post Transaction.</div>3) Goto Item Maintenance-->Option, make Changes in Item Maintenance from None to Lot.<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9OaoxfjFlPqm3PQMLZ4ABHy4M1A-3yAmOsrL-Ihmh0Vh5QtuVcrAVHFolAm-I_CddzWotIOXht2IB87M1wORxOBYsFdw7tK-w4UAgdiFDF0Y-U_MZcENlWNk1K90AK3KpzkSLznR8Exc/s1600/NoneToLot4.png" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="211" nt="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9OaoxfjFlPqm3PQMLZ4ABHy4M1A-3yAmOsrL-Ihmh0Vh5QtuVcrAVHFolAm-I_CddzWotIOXht2IB87M1wORxOBYsFdw7tK-w4UAgdiFDF0Y-U_MZcENlWNk1K90AK3KpzkSLznR8Exc/s320/NoneToLot4.png" width="320" /></a></div><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
4) Add Adjustment Entry for "On Hand" Qty with Lot information <br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2U-iO0q10w9X_TXMJIDb8IZY7QRhzD56NQ1eSYtad_MwxYJN_WGibtcVdcCcDndZG-sTso30dMWG7y4cdMQGtW7CXGONeWbh-vDEtdB_RIqCVbDWSkgqspr2B1kZEx7ltE5Q1iH-vVBA/s1600/NoneToLot5.png" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="139" nt="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2U-iO0q10w9X_TXMJIDb8IZY7QRhzD56NQ1eSYtad_MwxYJN_WGibtcVdcCcDndZG-sTso30dMWG7y4cdMQGtW7CXGONeWbh-vDEtdB_RIqCVbDWSkgqspr2B1kZEx7ltE5Q1iH-vVBA/s320/NoneToLot5.png" width="320" /></a>Sandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.com0tag:blogger.com,1999:blog-3213366531887654192.post-12196933519520915392010-02-11T19:02:00.000-08:002010-02-11T19:57:50.088-08:00Creating Test CompanySeveral time user want production data in Test company. Once you create Test Company and Restore Production database on Test Company please make sure to cover following two important point. <br />
<br />
1) Make sure your test company name will end with "<TEST>" i.e. “MY Dummy Company <TEST>"<br />
<br />
Advantage :<br />
<br />
a) System will understand this is test company as well as user will get prompt that your login in test company<br />
<br />
b) If user create test company and assigned company name without word "<TEST>" and Payroll module is installed system will count total number employees from Production Company + Test Company. But if test company name is created "<TEST>" word it won’t count Employee of test company.<br />
<br />
If you are changing existing Test company Name with word "<TEST>" do not forget to run check link on Employee Maintenance to get correct employee count.<br />
<br />
Again it’s very small but important "<TEST>" word to avoid all future confusion after creating test company.<br />
<br />
2) Run Microsoft SQL Script after restoring Production Data into Test Company its available in KB872370Sandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.com1tag:blogger.com,1999:blog-3213366531887654192.post-90613729195412188042010-01-17T19:59:00.000-08:002010-01-19T07:26:07.744-08:00Account Alias-Speed up your GL Transaction Entry<div align="justify" class="separator" style="clear: both; text-align: center;"><br />
</div><div align="justify"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdKjGH7PYYjYXSrn500AazwNZhhq-5LWSKSulK9hieFzGFAhktpdX8znHEtxE4utoDfuWuF0022TwrRJSp1oIWXbrau2q7SxBTrOH6ChZ2UzmMvgEJrnC4pUIZZxQ1F1A0VehahfsKoSE/s1600-h/Alias4.jpg" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" ps="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdKjGH7PYYjYXSrn500AazwNZhhq-5LWSKSulK9hieFzGFAhktpdX8znHEtxE4utoDfuWuF0022TwrRJSp1oIWXbrau2q7SxBTrOH6ChZ2UzmMvgEJrnC4pUIZZxQ1F1A0VehahfsKoSE/s400/Alias4.jpg" /></a><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Account Alias use to speed up GL Transaction Entry. In above Example “LI-A” alias assigned to Life Insurance - Administration, instead of typing whole Account No user can use Alisa to speed up Journal General Entry (Transactions-->Financial-->General) .<br />
</div><div align="justify"><br />
<br />
</div><div class="separator" style="clear: both; text-align: center;"><br />
</div><br />
<div align="justify"><br />
</div><div align="justify"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiVKuZZMOcwi0M7cfqiEvYsBB3ApkSUYx8KpFWp8OrlMJ8RV-ra9feMgs46qzuOReCDcNPjQQvEtHM-nQxfLrvUp7VEJrMi0YMXhBBzO1jQzDTmp6mCc11z0q1gRcxrD8CWoOZB2k_wIw/s1600-h/Alias7.jpg" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" ps="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiVKuZZMOcwi0M7cfqiEvYsBB3ApkSUYx8KpFWp8OrlMJ8RV-ra9feMgs46qzuOReCDcNPjQQvEtHM-nQxfLrvUp7VEJrMi0YMXhBBzO1jQzDTmp6mCc11z0q1gRcxrD8CWoOZB2k_wIw/s400/Alias7.jpg" /></a><br />
</div><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Click on arrow to open Account Entry window Type “LI-A” in Alias field and press tab, as soon as user press tab Alias will recognized Account Number and display same in Transaction Entry screen.<br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNYUuaS6kizxtntZOLjdFXSQea7u1xTjTA69wojlNm9ferdtGEzStjzxzTCzSWtV5ighIDOj_v2NSWttsr8vW5vo_oJM7noGS86XwDpTT-iwYU19KucggaGKwp2VWMXBq2ziLAddlH5C0/s1600-h/Alias8.jpg" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" ps="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNYUuaS6kizxtntZOLjdFXSQea7u1xTjTA69wojlNm9ferdtGEzStjzxzTCzSWtV5ighIDOj_v2NSWttsr8vW5vo_oJM7noGS86XwDpTT-iwYU19KucggaGKwp2VWMXBq2ziLAddlH5C0/s400/Alias8.jpg" /></a><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
</div><div align="justify"><br />
<br />
<br />
Very small but interesting feature , have you ever used Alias feature before ?<br />
<br />
PS: Use Alias feature not only for General Transaction but for entering big Distributions in other Transactions.<br />
</div><div align="justify"><br />
<br />
</div>Sandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.com1tag:blogger.com,1999:blog-3213366531887654192.post-34233991788496589422010-01-15T17:09:00.000-08:002010-01-15T17:14:27.259-08:00Remove Dynamics GP Web Service<span style="font-family: Verdana, sans-serif;">Steps to remove Microsoft Dynamics GP Web Services </span><br />
<br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;">1. Remove “Adam Instance DynamicsSecurityService” in Add\Remove Programs.</span><br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;">2. In IIS Manager, delete “Dynamics Security Admin Service” Web site.</span><br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;">3. In IIS Manager, delete “DynamicsGPWebServices” and DynamicsSecurityService” virtual directories from the Web site that the Web Services for Microsoft Dynamics GP was installed on.</span><br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;">4. In IIS Manager, delete the “DynamicsSecurityAdminServiceAppPool”, DynamicsSecurityServiceAppPool”, and “GPWebServicesAppPool” application pools.</span><br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;">5. Delete the “Microsoft Dynamics” folder from C:\Program Files\Common Files\Microsoft Shared.</span><br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;">6. Delete “GPWebServices” folder from C:\Program Files\Microsoft Dynamics (This is the default location for Web site files.).</span><br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;">7. Delete “Dynamics GP Web Service Exception Management Console” and “Dynamics Security Console” shortcuts from Administrative Tools program folder.</span><br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;">8. Delete related Registry Keys for Web Services for Microsoft Dynamics GP 9.0. </span><br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;">9. Remove the DynamicsGPWebServices key under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\</span><br />
<br />
<br />
Run following SQL Script to remove SQL Objects from DYNAMICS as well as Company Database.<br />
<br />
<br />
Against DYNAMICS DB :<br />
<br />
<span style="font-size: x-small;">drop view ReqCurrency</span><br />
<span style="font-size: x-small;">drop view ReqCurrencyAccess</span><br />
<span style="font-size: x-small;">drop table WSErrorProperties</span><br />
<span style="font-size: x-small;">drop table WSExceptionLog</span><br />
<span style="font-size: x-small;">drop table WSInstallStatus</span><br />
<span style="font-size: x-small;">drop table WSInstallSteps</span><br />
<span style="font-size: x-small;">drop procedure ws_delete_WSExceptionLog</span><br />
<span style="font-size: x-small;">drop procedure ws_deleteall_WSExceptionLog</span><br />
<span style="font-size: x-small;">drop procedure ws_get_MC40200</span><br />
<span style="font-size: x-small;">drop procedure ws_get_SY01500</span><br />
<span style="font-size: x-small;">drop procedure ws_get_WSErrorProperties</span><br />
<span style="font-size: x-small;">drop procedure ws_get_WSExceptionLog</span><br />
<span style="font-size: x-small;">drop procedure ws_get_WSExceptionLog_Summary</span><br />
<span style="font-size: x-small;">drop procedure ws_get_WSExceptionLog_ValidationException</span><br />
<span style="font-size: x-small;">drop procedure ws_get_WSInstallStatus</span><br />
<span style="font-size: x-small;">drop procedure ws_getall_WSInstallStatus</span><br />
<span style="font-size: x-small;">drop procedure ws_insert_WSExceptionLog</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE in('WSCompany', 'WSCurrency', 'WSCurrencyAccess')</span><br />
<br />
<span style="font-family: Verdana;">Run following sql script against all Company Database</span><br />
<br />
<span style="font-size: x-small;">drop view ReqCurrencyPostingAccountView</span><br />
<span style="font-size: x-small;">drop view ReqGLAcct</span><br />
<span style="font-size: x-small;">drop view ReqGLFixedAllocAcct</span><br />
<span style="font-size: x-small;">drop view ReqGLFixedAllocDistAcct</span><br />
<span style="font-size: x-small;">drop view ReqGLHeaderView</span><br />
<span style="font-size: x-small;">drop view ReqGLLineView</span><br />
<span style="font-size: x-small;">drop view ReqGLPostingAcct</span><br />
<span style="font-size: x-small;">drop view ReqGLPostingAcctCurrencies</span><br />
<span style="font-size: x-small;">drop view ReqGLUnitAcct</span><br />
<span style="font-size: x-small;">drop view ReqGLVarAllocAcct</span><br />
<span style="font-size: x-small;">drop view ReqGLVarAllocDistAcct</span><br />
<span style="font-size: x-small;">drop view ReqGLVarAllocDistBreakAcct</span><br />
<span style="font-size: x-small;">drop view ReqIVFee</span><br />
<span style="font-size: x-small;">drop view ReqIVHeaderView</span><br />
<span style="font-size: x-small;">drop view ReqIVItemCurrency</span><br />
<span style="font-size: x-small;">drop view ReqIVItemHeader</span><br />
<span style="font-size: x-small;">drop view ReqIVItemQuantity</span><br />
<span style="font-size: x-small;">drop view ReqIVItemQuantityBinDetail</span><br />
<span style="font-size: x-small;">drop view ReqIVItemVendor</span><br />
<span style="font-size: x-small;">drop view ReqIVItemWarehouse</span><br />
<span style="font-size: x-small;">drop view ReqIVKit</span><br />
<span style="font-size: x-small;">drop view ReqIVKitComponent</span><br />
<span style="font-size: x-small;">drop view ReqIVLineBinDetailView</span><br />
<span style="font-size: x-small;">drop view ReqIVLineLotDetailView</span><br />
<span style="font-size: x-small;">drop view ReqIVLineSerialDetailView</span><br />
<span style="font-size: x-small;">drop view ReqIVLineView</span><br />
<span style="font-size: x-small;">drop view ReqIVPricing</span><br />
<span style="font-size: x-small;">drop view ReqIVPricingDetail</span><br />
<span style="font-size: x-small;">drop view ReqIVSalesItem</span><br />
<span style="font-size: x-small;">drop view ReqIVService</span><br />
<span style="font-size: x-small;">drop view ReqPAAccounts</span><br />
<span style="font-size: x-small;">drop view ReqPAChangeOrderHeader</span><br />
<span style="font-size: x-small;">drop view ReqPAContractHeader</span><br />
<span style="font-size: x-small;">drop view ReqPAEmpExpDist</span><br />
<span style="font-size: x-small;">drop view ReqPAEmpExpHeader</span><br />
<span style="font-size: x-small;">drop view ReqPAEmpExpLine</span><br />
<span style="font-size: x-small;">drop view ReqPAEmpExpLineTax</span><br />
<span style="font-size: x-small;">drop view ReqPAMiscLog</span><br />
<span style="font-size: x-small;">drop view ReqPAMiscLogDist</span><br />
<span style="font-size: x-small;">drop view ReqPAMiscLogLines</span><br />
<span style="font-size: x-small;">drop view ReqPAProjectBudgetHeader</span><br />
<span style="font-size: x-small;">drop view ReqPAProjectHeader</span><br />
<span style="font-size: x-small;">drop view ReqPATimesheetDist</span><br />
<span style="font-size: x-small;">drop view ReqPATimesheetHeader</span><br />
<span style="font-size: x-small;">drop view ReqPATimesheetLine</span><br />
<span style="font-size: x-small;">drop view ReqPaymentCard</span><br />
<span style="font-size: x-small;">drop view ReqPMHeaderDistView</span><br />
<span style="font-size: x-small;">drop view ReqPMHeaderTaxView</span><br />
<span style="font-size: x-small;">drop view ReqPMHeaderView</span><br />
<span style="font-size: x-small;">drop view ReqPMVendor</span><br />
<span style="font-size: x-small;">drop view ReqPMVendorInetAddress</span><br />
<span style="font-size: x-small;">drop view ReqPMVendorPAOptions</span><br />
<span style="font-size: x-small;">drop view ReqPOHeaderFreightTaxView</span><br />
<span style="font-size: x-small;">drop view ReqPOHeaderMiscTaxView</span><br />
<span style="font-size: x-small;">drop view ReqPOHeaderTaxView</span><br />
<span style="font-size: x-small;">drop view ReqPOHeaderView</span><br />
<span style="font-size: x-small;">drop view ReqPOLineTaxView</span><br />
<span style="font-size: x-small;">drop view ReqPOLineView</span><br />
<span style="font-size: x-small;">drop view ReqPurInvDistView</span><br />
<span style="font-size: x-small;">drop view ReqPurInvHeaderFreightTaxView</span><br />
<span style="font-size: x-small;">drop view ReqPurInvHeaderMiscTaxView</span><br />
<span style="font-size: x-small;">drop view ReqPurInvHeaderTaxView</span><br />
<span style="font-size: x-small;">drop view ReqPurInvHeaderView</span><br />
<span style="font-size: x-small;">drop view ReqPurInvLineApplyRecptView</span><br />
<span style="font-size: x-small;">drop view ReqPurInvLineTaxView</span><br />
<span style="font-size: x-small;">drop view ReqPurInvLineView</span><br />
<span style="font-size: x-small;">drop view ReqPurRecptDist</span><br />
<span style="font-size: x-small;">drop view ReqPurRecptHeader</span><br />
<span style="font-size: x-small;">drop view ReqPurRecptLine</span><br />
<span style="font-size: x-small;">drop view ReqPurRecptLineBin</span><br />
<span style="font-size: x-small;">drop view ReqPurRecptLineLotNum</span><br />
<span style="font-size: x-small;">drop view ReqPurRecptLineSerNum</span><br />
<span style="font-size: x-small;">drop view ReqRecvDocComm</span><br />
<span style="font-size: x-small;">drop view ReqRecvDocDist</span><br />
<span style="font-size: x-small;">drop view ReqRecvDocHeader</span><br />
<span style="font-size: x-small;">drop view ReqRecvDocTax</span><br />
<span style="font-size: x-small;">drop view ReqRMCashReceiptDist</span><br />
<span style="font-size: x-small;">drop view ReqRMCashReceiptHeader</span><br />
<span style="font-size: x-small;">drop view ReqRMCorporateAccount</span><br />
<span style="font-size: x-small;">drop view ReqRMCustomer</span><br />
<span style="font-size: x-small;">drop view ReqRMCustomerAddress</span><br />
<span style="font-size: x-small;">drop view ReqRMCustomerInetAddress</span><br />
<span style="font-size: x-small;">drop view ReqRMSalesPersonCommisionsView</span><br />
<span style="font-size: x-small;">drop view ReqRMSalespersonInetAddress</span><br />
<span style="font-size: x-small;">drop view ReqSODistributionView</span><br />
<span style="font-size: x-small;">drop view ReqSOHeaderFreightTaxView</span><br />
<span style="font-size: x-small;">drop view ReqSOHeaderMiscTaxView</span><br />
<span style="font-size: x-small;">drop view ReqSOHeaderTaxView</span><br />
<span style="font-size: x-small;">drop view ReqSOHeaderView</span><br />
<span style="font-size: x-small;">drop view ReqSOLineComponentView</span><br />
<span style="font-size: x-small;">drop view ReqSOLineTaxView</span><br />
<span style="font-size: x-small;">drop view ReqSOLineView</span><br />
<span style="font-size: x-small;">drop view ReqSOLotDetailView</span><br />
<span style="font-size: x-small;">drop view ReqSOSerialDetailView</span><br />
<span style="font-size: x-small;">drop table WSPolicyBehaviorSelectionParameter</span><br />
<span style="font-size: x-small;">drop table WSPolicyBehaviorSelection</span><br />
<span style="font-size: x-small;">drop table WSPolicyBehavior</span><br />
<span style="font-size: x-small;">drop table WSPolicy</span><br />
<span style="font-size: x-small;">drop table WSParameter</span><br />
<span style="font-size: x-small;">drop table WSBehaviorOption</span><br />
<span style="font-size: x-small;">drop table WSBehavior</span><br />
<span style="font-size: x-small;">drop procedure ws_delete_WSBehavior</span><br />
<span style="font-size: x-small;">drop procedure ws_delete_WSBehaviorOption</span><br />
<span style="font-size: x-small;">drop procedure ws_delete_WSParameter</span><br />
<span style="font-size: x-small;">drop procedure ws_delete_WSPolicy</span><br />
<span style="font-size: x-small;">drop procedure ws_delete_WSPolicyBehavior</span><br />
<span style="font-size: x-small;">drop procedure ws_delete_WSPolicyBehaviorSelection</span><br />
<span style="font-size: x-small;">drop procedure ws_delete_WSPolicyBehaviorSelectionParameter</span><br />
<span style="font-size: x-small;">drop procedure ws_get_Behavior</span><br />
<span style="font-size: x-small;">drop procedure ws_get_MC40000</span><br />
<span style="font-size: x-small;">drop procedure ws_get_Policy</span><br />
<span style="font-size: x-small;">drop procedure ws_get_PolicyByOperation</span><br />
<span style="font-size: x-small;">drop procedure ws_get_PolicyNoDefaulting</span><br />
<span style="font-size: x-small;">drop procedure ws_get_SY00300</span><br />
<span style="font-size: x-small;">drop procedure ws_insert_WSBehavior</span><br />
<span style="font-size: x-small;">drop procedure ws_insert_WSBehaviorOption</span><br />
<span style="font-size: x-small;">drop procedure ws_insert_WSParameter</span><br />
<span style="font-size: x-small;">drop procedure ws_insert_WSPolicy</span><br />
<span style="font-size: x-small;">drop procedure ws_insert_WSPolicyBehavior</span><br />
<span style="font-size: x-small;">drop procedure ws_insert_WSPolicyBehaviorSelection</span><br />
<span style="font-size: x-small;">drop procedure ws_insert_WSPolicyBehaviorSelectionParameter</span><br />
<span style="font-size: x-small;">drop procedure ws_update_WSPolicyBehaviorSelection</span><br />
<span style="font-size: x-small;">drop procedure ws_update_WSPolicyBehaviorSelectionParameter</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSBank'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSCashReceipt'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSCompanyAddress'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSCorporateAccount'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSCountryRegionCode'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSCurrencyPostingAccount'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSCustomer'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSCustomerAddress'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSFee'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSGLAccount'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSGLAccountCategory'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSGLAccountFormat'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSGLFixedAllocationAccount'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSGLPostingAccount'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSGLTransaction'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSGLUnitAccount'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSGLVariableAllocationAccount'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSInventoriedItem'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSInventoryAdjustment'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSInventoryTransfer'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSInventoryVariance'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSItem'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSItemClass'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSItemCurrency'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSItemVendor'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSItemWarehouse'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSKit'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSMulticurrencySetup'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSPayablesCreditMemo'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSPayablesDocument'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSPayablesFinanceCharge'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSPayablesInvoice'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSPayablesMiscellaneousCharge'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSPayablesReturn'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSPaymentCardType'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSPaymentTerms'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSPriceLevel'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSPricing'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSProject'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSProjectBudget'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSProjectChangeOrder'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSProjectContract'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSProjectEmployeeExpense'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSProjectMiscellaneousLog'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSProjectTimesheet'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSPurchaseInvoice'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSPurchaseOrder'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSPurchaseReceipt'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSReceivablesCreditMemo'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSReceivablesDebitMemo'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSReceivablesDocument'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSReceivablesFinanceCharge'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSReceivablesInvoice'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSReceivablesReturn'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSReceivablesServiceRepair'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSReceivablesWarranty'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSSalesBackorder'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSSalesDocument'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSSalesDocumentTypeSetup'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSSalesFulfillmentOrder'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSSalesInvoice'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSSalesItem'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSSalesOrder'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSSalesperson'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSSalespersonCommissions'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSSalesProcessHoldSetup'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSSalesQuote'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSSalesReturn'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSSalesSetup'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSSalesTerritory'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSService'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSShippingMethod'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSUofMSchedule'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSVendor'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSVendorAddress'</span><br />
<span style="font-size: x-small;">delete eConnect_Out_Setup where DOCTYPE = 'WSWarehouse'</span>Sandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.com8tag:blogger.com,1999:blog-3213366531887654192.post-81210946985949066442010-01-05T14:19:00.000-08:002010-01-06T10:02:43.532-08:00Dynamics GP Web Service Installation Error<span style="font-family: Verdana, sans-serif;"></span><br />
<div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;"></span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;"><strong>Dynamics GP Web Service Installation Error troubleshooting.</strong></span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;"></span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;">1) Uninstalled Completely Dynamics GP Web Services.</span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;">2) Remove ADAM instance prior to the reinstall of GP WebService</span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;">3) Make sure eConnect is not installed on Dynamics Database server before installing Dynamics GP Web Service. If eConnect is installed Uninstalled eConnect with all SQL objects.</span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;">4) Run following SQL Script to verify Dynamics GP Database is exist in SQL Server or not</span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;"> a. Select CMPANYID,CMPNYNAM,INTERID from Dynamics..SY01500</span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;"> b. Select * from Dynamics..DB_Upgrade</span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;"> c. Select * from Dynamics..DU000020 order by companyID</span><br />
</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;">5) DB_Upgrade will show if any company is not with Current Version and SP.</span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;">6) If you found any discrepancy in physically available Dynamics GP Company Database in SQL and Select Statement in “SY01500” run clearcompanies sql script from Microsoft, Download from KB973027 (Point No : 4)</span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;"></span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;">If you found any discrepancy in Version please upgrade company or if you don’t want those company drop Company DB and run above script to clear company from system table.</span><br />
</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;">7) Verify ISO code enter or not with following script or Login to Dynamics GP and Enter ISO code to all Currency follow Microsoft Dynamics GP Web service Installation document for ISO Code.</span><br />
</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;">Run the following script against each company that is running in Dynamics:</span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;"> select CURNCYID, CURRNIDX, ISOCURRC from DYNAMICS..MC40200</span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;"> go</span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;"> select FUNLCURR, FUNCRIDX from MC40000</span><br />
</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;"><strong><em><span style="font-family: Verdana, sans-serif;">Most important in ISO code make sure it 3 Digit ISO Code for each currency.</span></em></strong><br />
</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;">8) Once you've finished removing Web Services, verify that you are logged onto the IIS Server as a domain account with these permissions:</span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana;"> a) Use Domain Account is SQL Server is on a different machine than IIS server.</span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana;"> b) Local Administrator permission on both the IIS and SQL Servers.</span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana;"> c) Rights to create objects in SQL Server. I usually recomment the dbCreator and SecurityAdmin SQL Role if not sysadmin </span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana;"> d) Also Make sure this Domain Account user has the DYNGRP and public role permission for "DYNAMICS" and all of your GP Company Databases. DYGRP will give Domain Account user the Select, Insert , Delete and Update permission needed to update Dynamics GP Database.</span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana;"> e) Create anew WebSite in IIS Manager to install Web Services. I would recommend using a New Site Name and New Port Number if possible.</span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;"></span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;"> </span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;">9) Run Installation file with following command it will help to create log if it show any installation error.</span><br />
</div><span style="font-family: Verdana, sans-serif;"></span><br />
<div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;"> </span><br />
</div><div style="text-align: left;"><span style="font-family: Verdana, sans-serif;">msiexec.exe/i "C:\Path\DynamicsGPWebServices.msi"/l*v C:\WSVerbose.log"</span><br />
</div><span style="font-family: Verdana, sans-serif;"></span><span style="font-family: Verdana, sans-serif;">*****replace Path with the actual pathname to the DynamicsGPWebServices.msi file, in which you're using to start the install*****</span><br />
<div style="text-align: left;"><br />
</div><br />
<div style="text-align: justify;"><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;">Hope it will help you to resolve issue. Do not forget to go through Log file it will help you to understand issue.</span><br />
</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;"><br />
</span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;"><br />
</span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;"><br />
</span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;"><br />
</span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;"><br />
</span><br />
</div><div style="text-align: justify;"><span style="font-family: Verdana, sans-serif;"></span><br />
</div>Sandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.com9tag:blogger.com,1999:blog-3213366531887654192.post-39476564628050867792009-12-29T12:07:00.000-08:002009-12-29T12:14:23.063-08:00Account Rollup, Summaries Group of Account<span style="font-family: Verdana, sans-serif;">How to monitor total of Group of Accounts say Cash A/c, Inventory or Payroll Account from different department, Account Rollup features in Dynamics GP is good option to create summary total of group of Accounts.</span><br />
<span style="font-family: Verdana, sans-serif;"></span><br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;">Following steps to create Account Rollup inquiry.</span><br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;">1) Goto--->Inquiry--->Financial-->Account Rollup</span><br />
<div class="separator" style="clear: both; text-align: center;"><span style="font-family: Verdana, sans-serif;"></span><br />
</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVIXprzGQ_0n0VIzX-GSbFlZ3YE8HC6rehVOvqyVTLjmIF93ppze0KTu8EKhc6CyTa7TDYD-cL_bJoKoAxD6mqXwFb1sh-14JgM-B77UkAiuV3XXeaWJIZNsZMjrOuCLtMiDd1liIzRMA/s1600-h/AccountRollup1.jpg" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><span style="font-family: Verdana, sans-serif;"><img border="0" ps="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVIXprzGQ_0n0VIzX-GSbFlZ3YE8HC6rehVOvqyVTLjmIF93ppze0KTu8EKhc6CyTa7TDYD-cL_bJoKoAxD6mqXwFb1sh-14JgM-B77UkAiuV3XXeaWJIZNsZMjrOuCLtMiDd1liIzRMA/s400/AccountRollup1.jpg" /></span></a><br />
</div><span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana;"></span> <br />
<span style="font-family: Verdana, sans-serif;">2) Click on Modify button</span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiImTOoRjuuafzB2L67jpVDl58r57y_N1ZXXE_8LYu0h7EFpdJuBhWPN0Wt_2ila3C3iCmmuCtOVe84Uu9TI_bydzsevnCWLrYAU4hTFrh4dSKkxABdfVnXlk8JwyMWJKRPjCuXk1uRX_w/s1600-h/AccountRollup2.jpg" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><span style="font-family: Verdana, sans-serif;"><img border="0" ps="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiImTOoRjuuafzB2L67jpVDl58r57y_N1ZXXE_8LYu0h7EFpdJuBhWPN0Wt_2ila3C3iCmmuCtOVe84Uu9TI_bydzsevnCWLrYAU4hTFrh4dSKkxABdfVnXlk8JwyMWJKRPjCuXk1uRX_w/s400/AccountRollup2.jpg" /></span></a><br />
</div><span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;">3) Enter Option ID </span><br />
<span style="font-family: Verdana, sans-serif;"></span><br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;">4) Select Segment for sorting option</span><br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;">5) Enter No of Columns in above example I selected 2 Columns one is for Actual and another for budget . Give column Name like “Actual” and “Budget”.</span><br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;"> How to create Calculated Columns please go through with Dynamics GP Help.</span><br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;">6) Select option for Accounts i.e. Accounts is Posting Account or Unit Account</span><br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;">7) Select Range of Accounts and insert.</span><br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;">8) Save Accounts Rollup Inquiry options</span><br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;">9) User can callback Option Id from same screen and click on Inquiry Button or</span><br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;">Goto -->Inquiry-->Financial-->Account Rollup</span><br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;">Recall Option ID and Click on Redisplay</span><br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQ1PyvCvEd9n8kJN-i-uGsIyP1AAJXJYX-2ubMmjRSMMLmTG01CLzX7Hb-sOXhTyFrwJzeAZXDj8fKbonJlTmcTKWWZeBngZLnP1meKWnWMuhDEcl1lKBs7AB9ly2aiPqIBZe2YOUE1nE/s1600-h/AccountRollup3.jpg" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><span style="font-family: Verdana, sans-serif;"><img border="0" ps="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQ1PyvCvEd9n8kJN-i-uGsIyP1AAJXJYX-2ubMmjRSMMLmTG01CLzX7Hb-sOXhTyFrwJzeAZXDj8fKbonJlTmcTKWWZeBngZLnP1meKWnWMuhDEcl1lKBs7AB9ly2aiPqIBZe2YOUE1nE/s400/AccountRollup3.jpg" /></span></a><br />
</div><span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;">Keep checking for my next post.. Happy Holidays !!!</span>Sandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.com0tag:blogger.com,1999:blog-3213366531887654192.post-79943457993396260202009-12-21T18:29:00.000-08:002009-12-22T19:02:00.356-08:00How to post Payroll Manual Transaction where Gross Amount is Zero.<div align="left" class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjoX2TmqZNWJoOhN1Z6tMgiSnBqzg0wg0gF0FGvn-nRXEvvQ0xydCMrxv78GuYOrQcx0Atvo-zOu2X9KOoSvqkg41Yu3d-g1QnGW4ZAqtIae7hHhTK3R-o_TrhDY3tlAfvYxw17EWcYyQI/s1600-h/Payroll1.jpg" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><span style="font-family: Verdana, sans-serif;"><img border="0" ps="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjoX2TmqZNWJoOhN1Z6tMgiSnBqzg0wg0gF0FGvn-nRXEvvQ0xydCMrxv78GuYOrQcx0Atvo-zOu2X9KOoSvqkg41Yu3d-g1QnGW4ZAqtIae7hHhTK3R-o_TrhDY3tlAfvYxw17EWcYyQI/s400/Payroll1.jpg" /></span></a><br />
</div><div align="left"><br />
</div><div align="left"><br />
</div><div align="left"><br />
</div><div align="left"><br />
</div><div align="left"><br />
</div><div align="left"><br />
</div><div align="left"><br />
</div><div align="left"><br />
</div><div align="left"><br />
</div><div align="left"><br />
</div><div align="left"><br />
</div><div align="left"><br />
</div><div align="left"><br />
</div><div align="left"><br />
</div><div align="left"><br />
</div><div align="left"><br />
</div><div align="left"><br />
</div><div align="left"><span style="font-family: Verdana, sans-serif;">1) Goto--> Transaction --> Payroll -->Manual Checks</span><br />
</div><span style="font-family: Verdana, sans-serif;"></span><br />
<br />
<div class="separator" style="clear: both; text-align: center;"><span style="font-family: Verdana, sans-serif;"></span><br />
</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbd41L2rqGauYakVYvXC05u32z49xIqVvk-E1asbuut8tSMGOaoMnW_OnJYua9vId8zZigFuXuDu4TWAVjUa_oHq6RF4T2StCOo0I4aK1O7Wj9OacUFUhrSrpMEdj2rVbAKxEJLnDdfqI/s1600-h/Payroll3.jpg" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><span style="font-family: Verdana, sans-serif;"><img border="0" ps="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbd41L2rqGauYakVYvXC05u32z49xIqVvk-E1asbuut8tSMGOaoMnW_OnJYua9vId8zZigFuXuDu4TWAVjUa_oHq6RF4T2StCOo0I4aK1O7Wj9OacUFUhrSrpMEdj2rVbAKxEJLnDdfqI/s400/Payroll3.jpg" /></span></a><br />
</div><span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<br />
<span style="font-family: Verdana, sans-serif;">2) Call back transaction by entering Payment No. </span><br />
<span style="font-family: Verdana, sans-serif;"></span><br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;">3) Note down Check Date and then Clear Batch ID – Once you clear Batch ID Check date and Post Date will be enable. Make sure to enter correct Post Date and Check Date. </span><br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPGRsaOg80SGWCfGT8e-aO8uW-pg8np1a8jEiTKuVDSUqjIlvH6uNVZj2mVzzSG2lGaUFEPEjWYtgRGLInx5wmiNCikaeRrWIGhuL9n8KlnYv8miDNcnUHDPjpWcpUIWDNMt_lFCcVDHA/s1600-h/Payroll4.jpg" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><span style="font-family: Verdana, sans-serif;"><img border="0" ps="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhPGRsaOg80SGWCfGT8e-aO8uW-pg8np1a8jEiTKuVDSUqjIlvH6uNVZj2mVzzSG2lGaUFEPEjWYtgRGLInx5wmiNCikaeRrWIGhuL9n8KlnYv8miDNcnUHDPjpWcpUIWDNMt_lFCcVDHA/s400/Payroll4.jpg" /></span></a><br />
</div><span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;"></span><br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"></span> <br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;">Click on Post button to post transaction.</span><br />
<span style="font-family: Verdana, sans-serif;"><br />
</span><br />
<span style="font-family: Verdana, sans-serif;"></span>Sandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.com1tag:blogger.com,1999:blog-3213366531887654192.post-62308844191309105322009-12-06T16:08:00.000-08:002013-10-21T06:53:45.656-07:00Dynamics GP Year End Procedure<div style="text-align: justify;">
Year End Closing for Dynamics GP Module must be done in following order </div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<strong>A) Inventory</strong></div>
<div style="text-align: justify;">
<strong>B) Receivable</strong></div>
<div style="text-align: justify;">
<strong>C) Payables</strong></div>
<div style="text-align: justify;">
<strong>D) Fixed Assets</strong></div>
<div style="text-align: justify;">
<strong>E) GL Year End</strong></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
GL Year End Close should be done after you have completed Year End Closing for all above Module in above order.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
Let see Module wise Year End Close procedure and its affects.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<br />
<strong><span style="font-size: large;">A) Inventory</span></strong></div>
<strong>GOTO-->Tools-->Routines-->Inventory-->Year End Close</strong><br />
<br />
<div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3RKozMG9rma1VrrqlUkCjoQXmNtAjIK4u8UPXKu4D-JkHGb318KseQBcE8lxU3Q5OSMY-2GWRniesqP07vLh3iJu-PV_3EEygQ8g5CYb-glz_ykqJ9y6WMPdLdxGEumSFFkK_d3rBZUs/s1600-h/YearEnd1.bmp" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" er="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3RKozMG9rma1VrrqlUkCjoQXmNtAjIK4u8UPXKu4D-JkHGb318KseQBcE8lxU3Q5OSMY-2GWRniesqP07vLh3iJu-PV_3EEygQ8g5CYb-glz_ykqJ9y6WMPdLdxGEumSFFkK_d3rBZUs/s400/YearEnd1.bmp" /></a></div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<strong>Inventory Year End Close affects</strong></div>
<br />
i) Transfers all summarized current-Year Quantity, Cost and Sales Amounts to last-year for the Items for which you have been keeping summarized sales history<br />
<br />
ii) Updates each item’s beginning Quantity from the Quantity on hand at each site<br />
<br />
iii) Zeros the Quantity sold field in the Item Quantities maintenance (Cards-->Inventory-->Quantities/sites) for each site<br />
<br />
iv) Give you the Option to: Remove Discontinued Items, remove sold Receipts, Remove Sold Lot Attributes, and update Item’s Standard cost.<br />
<br />
<strong>Key Points to remember while/before running Inventory Year End Updates</strong><br />
<br />
i) Enter and post all PO Processing , Invoicing/sales Order Processing and Inventory Transaction for the current year<br />
<br />
ii) Follow KB872713- Describes how to close the year and how to prepare your inventory records for the new fiscal year in Inventory Control in Microsoft Dynamics GP.<br />
<br />
iii) Restorable Backups of Production and as well as Dynamics Database<br />
<br />
iv) Reconciles SOP and POP and IV Module .. Reconcile SOP,POP and Then Inventory.<br />
<br />
<strong>Knowledge Base Reference</strong><br />
<br />
i) KB872713 Describes how to close the year and how to prepare your inventory records for the new fiscal year in Inventory Control in Microsoft Dynamics GP.<br />
<br />
ii) KB855316 Inventory Accidentally Closed Twice<br />
<br />
iii) KB872182 Inventory Year End Close Does Not Remove Discontinued Items.<br />
<br />
<br />
<br />
<strong><span style="font-size: large;">B) Accounts Receivables</span></strong><br />
<strong><span style="font-size: large;"></span></strong><br />
<br />
<strong>GOTO-->Tools-->Routines-->Sales-->Year End Close</strong><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdhX4LboUa7zIE6YUrKdHHfb-lJPS-OfbtkEPg_Vw54Iw260bwgXOIUMezC956CByIUHJNS53-Hg2ULkgWdYdEyUK56KwUUOrcsv_LMoKExcT8ozQeRDZ6bBVCqQoW7yP_ns2GWg2gTbk/s1600-h/ReceivableYearEnd.bmp" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" er="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdhX4LboUa7zIE6YUrKdHHfb-lJPS-OfbtkEPg_Vw54Iw260bwgXOIUMezC956CByIUHJNS53-Hg2ULkgWdYdEyUK56KwUUOrcsv_LMoKExcT8ozQeRDZ6bBVCqQoW7yP_ns2GWg2gTbk/s640/ReceivableYearEnd.bmp" /></a></div>
<div style="text-align: justify;">
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<strong>Affects of Receivable Management Year End Close</strong> </div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
i) Calendar year End Close clears the Calendar Year to Date Finance charges and moves them to the last year Calendar field in Customer Finance Charge summary(Cards-->sales-->Summary-->Finance Charges)</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
ii) The Fiscal year End close transfer all amounts other than the Calendar YTD Finance charge amount to the Last Year Column in Customer Summary using the Amounts since Last closed view(Cards-->Sales-->Summary)</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<strong>Key Points to remember</strong></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
i) Post all transactions for current year</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
ii) Keep Restorable backup</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
iii) Follow KB857444- Describes how to perform the year-end closing routine in Receivables Management. Contains preparation steps and troubleshooting information for the year-end closing routine.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
iv) Receivable management is not completely date sensitive there are some date sensitive features. It would still be the best option to close the year on time</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
v) KB851140- Explains the effects of performing the year-end closing procedure in Receivables Management after December 31.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<span style="font-size: large;"><strong>C) Payable Management Year End Close</strong></span></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<strong>Goto-->Tools-->Routines-->Purchasing-->Year End</strong><br />
<br /></div>
<div align="justify" class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGC7BR_CxwCpGiDOeLh1Oebw50czQGICRqLjFAWL5CSDo6C42WCgSTb82HODKKC_XaAEiIjBAgUnFB79nJrMyAPBq3ohfavZlcfWrzHjVkjgGQ_YRMzE7zpwNoddy6sg_Gt8EUlUIQk4U/s1600-h/PayableYearEnd.bmp" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" er="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGC7BR_CxwCpGiDOeLh1Oebw50czQGICRqLjFAWL5CSDo6C42WCgSTb82HODKKC_XaAEiIjBAgUnFB79nJrMyAPBq3ohfavZlcfWrzHjVkjgGQ_YRMzE7zpwNoddy6sg_Gt8EUlUIQk4U/s640/PayableYearEnd.bmp" /></a></div>
<div style="text-align: justify;">
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Calendar year End Close Routine should be run at the End of the Calendar year prior to posting transactions in the New Year </div>
<br />
<br />
The Fiscal Year End close Routine should be run at the end of the fiscal year Prior to posting transactions in the New year<br />
<br />
<strong>What does not Payable Management Year End Close does</strong><br />
<br />
i) The Fiscal year End Close Process transfers all other amounts from the Year to Date column to the Last Year Column in the Amounts since Last Close view.<br />
<br />
ii) The Calendar year End Close process transfers the 1099 Amount from the Year to Date Column to the Last Year Column in the Amounts Since Last Close view in the Vendor yearly Summary window (Cards-->Purchasing -->Summary-->Yearly button)<br />
<br />
<strong>Key Point to Remember</strong><br />
<br />
i) Post all transactions for the current year<br />
<br />
ii) Make sure transaction for the new year are saved not posted<br />
<br />
iii) Make a backup<br />
<br />
iv) Follow the KB 875169 -Describes how to perform the year-end closing routine in Payables Management in Microsoft Dynamics GP. This article also lists preparation steps and troubleshooting information for the year-end closing routine.<br />
<br />
v) Payable Management is not fully date sensitive , so it sill still recommended that you process your Year End closing routine at the Actual Year End<br />
<br />
<br />
<br />
<strong><span style="font-size: large;">D) Fixed Assets Year End Close</span></strong><br />
<br />
<strong>GOTO-->Tools-->Routines-->Fixed Assets-->Year End</strong><br />
<br />
<div align="justify" class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj12whEE30rWE7j6rrzG6GqpN07-IDv_ztk8ooXlGt4GqcYls2QsDAyDxGkNu5D4OdEf-w_TLxBl9a77QEeXS_5aYVmYT-1sAFgfSL2yDoeobhpHGUAFsyugvYv6IITQ0ul88zWwdCQKtU/s1600-h/FixedAssetsYrEnd.bmp" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" er="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj12whEE30rWE7j6rrzG6GqpN07-IDv_ztk8ooXlGt4GqcYls2QsDAyDxGkNu5D4OdEf-w_TLxBl9a77QEeXS_5aYVmYT-1sAFgfSL2yDoeobhpHGUAFsyugvYv6IITQ0ul88zWwdCQKtU/s400/FixedAssetsYrEnd.bmp" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<strong>When should the Fixed Assets Year End close to be done?</strong> <br />
<br />
i) The Fixed Assets Year End close should be run after you close Payable management but before you close General Ledger<br />
<br />
ii) You can close each book separately, but you must close all books before you can do any processing in Fixed Assets for the New Year.<br />
<br />
<strong>What does the Year End Close Process do?</strong><br />
<br />
1) In the Asset General information Window (Card-->Fixed Assets--> General)<br />
<br />
a) YTD Maintenance amount is removed<br />
<br />
b) The Quantity is copied to the Begin Quantity field<br />
<br />
2) In the Asset book window (Cards-->Fixed Assets-->Book)<br />
<br />
a) The YTD Depreciation Amount is removed<br />
<br />
b) Cost basis is copied to Begin year Cost<br />
<br />
c) Life to Date Depreciation is copied to Begin Reserve<br />
<br />
d) Salvage is copied to Begin salvage<br />
<br />
e) Increase the Current fiscal year by on Year for Each book that is being closed.<br />
<br />
<br />
<strong>Key Points to Remember</strong><br />
<br />
1) Print all the reports that you need for the year that you are closing<br />
<br />
2) Backup of Production Database<br />
<br />
3) KB865653- Describes the year-end closing routine in Fixed Asset Management in Microsoft Dynamics GP. Also lists preparation steps and troubleshooting information.<br />
<br />
4) You must take depreciation to the last day of the year that you are closing before you close the year<br />
<br />
<br />
<strong><span style="font-family: "Courier New", Courier, monospace; font-size: large;">E) GL Year End</span></strong><br />
<br />
<strong>GOTO-->Tools-->Routines-->Financial-->Year End Closing</strong><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2QbhPHfbXeZC8awm-HZ-t1smBE2dcaEBel3ddwgxi2nc7KDYfJfQ_JCeAcxGvkFsBJuSzf0qd6QtBi3z7UXwzFSdqAkz3rJgkmnkwu-hB_sr_rI8D9U-eJ2pMQdck6nsG4RUEHVwj79g/s1600-h/GLYrEnd.bmp" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" er="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2QbhPHfbXeZC8awm-HZ-t1smBE2dcaEBel3ddwgxi2nc7KDYfJfQ_JCeAcxGvkFsBJuSzf0qd6QtBi3z7UXwzFSdqAkz3rJgkmnkwu-hB_sr_rI8D9U-eJ2pMQdck6nsG4RUEHVwj79g/s400/GLYrEnd.bmp" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<strong>What does the year End close process do? </strong><br />
<br />
1) The Year End close process close all P & L Account out to Retained Earnings, Leaving the P&L Ac with Zero Balance at the beginning of the New year<br />
<br />
2) All Balance Sheet Accounts are updated with the Beginning Balance in the New year which will be the same as the Ending balance from the Year you are closing<br />
<br />
3) The Retained Earning Account is updated with Amount from All P&L accounts if you close to one Retained Earning Account or with the Amount from P&L Account in that division if you close to divisional Retained Earning Account. The Retained Earning Accounts are the Only Balance sheet Accounts that should have different beginning balance than the Ending Balance from the year that you closing<br />
<br />
4) The year End close routine moves all open year transactions from the GL20000 to the GL30000 table<br />
<br />
5) The Fiscal Period Table is updated to Mark the year that you are closing as Historical.<br />
<br />
<strong>Key Points</strong><br />
<br />
1) Restorable Backup of Dynamics as well as Production Database.<br />
<br />
2) Follow KB888003- Describes the recommended year-end closing procedures for General Ledger in Microsoft Dynamics GP.<br />
<br />
3) Make sure you have enough space on SQL Server to allow GL20000 table double in Size.<br />
<br />
4) Perform Year End at Server.<br />
<br />
5) Have all user out of Dynamics GP when you perform Year End operation.<br />
<br />
6) The Year Close Routine does appear to hang at 50% but is still running be patience.<br />
<br />
<strong>Important KB to follow</strong><br />
<br />
1) KB871679 Describes how to set up an adjusting period to record adjustments that are posted to the general ledger after the year-end close process has been performed.<br />
<br />
2) KB850615 This article describes how the divisional retained earnings accounts work in General Ledger in Microsoft Dynamics GP.<br />
<br />
3) KB864913- Describes how to correct accounts that were set up to use the wrong posting type after the General Ledger year-end closing process is complete in Microsoft Dynamics GP.<br />
<br />
4) KB850741- Discusses that you receive a "Retained Earnings account not found" error message when you try to perform the year-end closing process in General Ledger in Microsoft Dynamics GP. Provides steps to troubleshoot the problem.<br />
<br />
5) KB857582- Discusses that the balances for all unit accounts roll forward after the General Ledger fiscal year has been closed in Microsoft Dynamics GP. Describes how to delete the beginning balances for the unit accounts.Sandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.com2tag:blogger.com,1999:blog-3213366531887654192.post-82092843402584076722009-11-19T10:50:00.000-08:002010-11-15T09:10:01.360-08:00Understanding Purchase Return in Dynamics GP.<div align="justify"><span style="font-family: verdana;">In Dynamics GP for Purchase Return available 4 options, which option should I select to make Purchase Return?</span></div><div align="justify"><span style="font-family: verdana;"><br />
Let see<br />
1) Return<br />
2) Return with Credit<br />
3) Inventory<br />
4) Inventory With Credit<br />
<br />
<strong>1) Return</strong><br />
Select “Return” type when you received the Item and it’s not Matched to Invoice. Vendor Credit is not applied with above type.<br />
<br />
Distribution:<br />
Inventory A/c Cr $ XXX<br />
Accrued Purchase A/c Dr $ XXX<br />
<br />
<strong>2) Return With Credit</strong><br />
Select “Return with Credit” option when Item is Received and Matched to Invoice. Vendor Credit is applied.<br />
<br />
Distribution:<br />
Inventory A/c Cr $ XXX<br />
Accounts Payable A/c Dr $ XXX<br />
<br />
Above Entry will applied to your GL as well as Vendor Balance<br />
<br />
<strong>3) Inventory</strong><br />
When should user select the above option?<br />
a) When there is No Receipt or Matched Invoiced that means if user enter Inventory Adjustment from Inventory Transaction((Transaction-->Inventory-->Adjustment) and want to make Return Entry against those Adjustment<br />
b) Variance Transaction (Transaction-->Inventory-->Variance)<br />
<br />
Again Vendor Credit is not applicable; Inventory On Hand Qty will reduce.<br />
<br />
Distribution:<br />
Inventory A/c Cr $ XXX<br />
Accrued Purchase/Wastage A/c Dr $ XXX<br />
<br />
<strong>4)</strong> <strong>Inventory w/Credit</strong><br />
On Same “Inventory” scenario for “Inventory w/Credit” option but Vendor Credit are applicable.<br />
<br />
Your Distribution will look like:<br />
Inventory A/c Cr XXX<br />
Accounts Payable Dr XXX<br />
<br />
Above Entry will affect only your GL balance to get applied against your Vendor Balance<br />
<span style="color: #660000;"><strong><em>do not forget to apply your Return with Vendor Invoice (Transaction</em></strong><span style="color: black;">--></span><strong><em>Purchasing</em></strong><span style="color: black;">--></span><strong><em>Apply Payable Documents”)</em></strong></span><br />
<br />
Option 3 and 4 i.e. “Inventory” and Inventory w/Credit can be applied for your Opening Qty return.<br />
<br />
<br />
</span></div>Sandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.com6tag:blogger.com,1999:blog-3213366531887654192.post-89293998570546572112009-11-06T08:44:00.000-08:002010-09-08T11:10:17.519-07:00Change Default Check No On Remittance for Zero Dollar CheckArticel from Microsoft about "How to Change the Default Check Number Printed on Remittances for Zero Dollar Checks in Payables Management for Microsoft Dynamics GP"<br />
<br />
here is the Partners Link : <a href="https://mbs.microsoft.com/partnersource/deployment/documentation/howtoarticles/msdgpremittzero.htm?r=5">https://mbs.microsoft.com/partnersource/deployment/documentation/howtoarticles/msdgpremittzero.htm?r=5</a><br />
<br />
Thanks<br />
SandipSandip Jadhavhttp://www.blogger.com/profile/13635241487471526299noreply@blogger.com0