tag:blogger.com,1999:blog-68321479283970068042024-02-21T12:44:45.612+08:00Acumatica SingaporeWhat is happening with web based ERP in South East Asia.
Specifically Acumatica, including cloud version deployed on MS Azure platform.
In both, SaaS and on-premise delivery methods.Sergey Vereshchaginhttp://www.blogger.com/profile/10783520078059582700noreply@blogger.comBlogger110125tag:blogger.com,1999:blog-6832147928397006804.post-18908131714484717612021-07-13T11:31:00.002+08:002021-07-13T11:31:54.985+08:00Centralized Period Management feature in Acumatica ERP<p> Dear Readers,</p><p>Some new features in Financial have such ambiguous naming that needs to get clarified.</p><p>Centralized Period Management feature, that is implemented in the latest versions can be switched on or off at the Feature Set screen:</p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNyjiNXCWlZSWVAbcpQIfumzDvfJZFmfZVi3rucNBteM-RNhnCKprSHbVk1VgPhy2cKKxI1excEL4tszXpurdaWIaBFAK2BzHt-LI8bPiunzdaiOtR6MV3KUhlOz9jTBIloVhvNkIJdUbu/s673/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="348" data-original-width="673" height="206" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNyjiNXCWlZSWVAbcpQIfumzDvfJZFmfZVi3rucNBteM-RNhnCKprSHbVk1VgPhy2cKKxI1excEL4tszXpurdaWIaBFAK2BzHt-LI8bPiunzdaiOtR6MV3KUhlOz9jTBIloVhvNkIJdUbu/w400-h206/1.png" width="400" /></a></div><div><br /></div>Not to get tricked by name it has little to do with centralized financials or centralized reporting. <div><br /></div><div>The only function of it is to synchronize fiscal period closure. Meaning in all Branches/Companies under a dedicated Tenant fiscal period will get closed at the same time if you ticked that option. You can't have say branch A GL period 01-2021 be open while in branch B 01-2021 to get closed. </div><div><br /></div><div>Actually, it was always like that before introducing Tenant-Company-Branch hierarchy in Acumatica.</div><div>You close period in a tenant, it closes everywhere. </div><div><br /></div><div>Now we have an option to close period in branch A but keep it open in branch B.</div><div><br /></div><div>So if you want it - 'untick' Centralized Period Management feature option.</div><div><br /></div><div>All the best,</div><div><br /></div><div>Sergey.</div><div><br /></div><div> <br /><p><br /></p><p><br /></p></div>Sergey Vereshchaginhttp://www.blogger.com/profile/10783520078059582700noreply@blogger.com0tag:blogger.com,1999:blog-6832147928397006804.post-85112776565027881012021-07-09T11:21:00.003+08:002021-07-09T11:21:49.466+08:00Acumatica Framework Developer Alert. Join Now or Never.<p>Dear Acumatica Developers.</p><p>If you are keen to try your skills and face new challenges coming from the Education sector - please send a message to my LinkedIn or email.</p><p>Today with the new landscape, new forms of learning, telecommunication and artificial intelligence we can take the opportunity and progress very fast. Please join the team of experienced developers.</p><p>Best,</p><p>Sergey.</p><p><br /></p><p><br /></p><p><br /></p>Sergey Vereshchaginhttp://www.blogger.com/profile/10783520078059582700noreply@blogger.com0tag:blogger.com,1999:blog-6832147928397006804.post-58987289710695769502020-08-03T12:40:00.002+08:002020-08-03T12:40:59.338+08:00Excel Based Reporting. Velixo vs GIHi Everyone,<div><br /></div><div>Please note a bright example of how OData in Acumatica can be used by Excel based reports.</div><div> </div><div>This demo also discusses a new Excel feature Dynamic Array, that is something worth to look at.</div><div><br /></div><div>So, please take a look at Velixo, which is Excel based Acumatica tailored reporter (and not only).</div><div><br /></div><div>They have recently added Single Sign On (SSO).</div><div><br /></div><div>Have fun </div><div><br /><div class="separator" style="clear: both; text-align: center;"><iframe allowfullscreen="" class="BLOG_video_class" height="266" src="https://www.youtube.com/embed/w6m5ts4rYcM" width="320" youtube-src-id="w6m5ts4rYcM"></iframe></div></div><div><br /></div><div><br /></div><div>All the Best,</div><div>Sergey.</div>Sergey Vereshchaginhttp://www.blogger.com/profile/10783520078059582700noreply@blogger.com2tag:blogger.com,1999:blog-6832147928397006804.post-83309094204942414812020-07-25T22:25:00.000+08:002020-07-25T22:26:27.700+08:00Removing List as Entry Point feature for Newer VersionsHi Everyone,<br />
<br />
If your clients are not really fond of this "new feature", especially when you open a data entry screen menu item and all of a sudden user is getting 100,500 records into your screen, with all server burden overload attached. We have an option now.<br />
<br />
<b><span style="color: red;">There is a way to switch it off. </span></b><br />
<br />
Via user interface it has to be done One by One for all the data entry screens, as shown here:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh32qG1IBKp_jFetA-mtOLt2RsZu5pHvVbFvByq1AKDN18LUx8qg1eYQDDriISrmL5rcXZ0PmzbDbU15VNaT5dynxEaZBE2n1i0pNOs2HuHAqntI8Tl1ud9U1tr3o8yUTQx7kST5IwI9nRn/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="239" data-original-width="564" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh32qG1IBKp_jFetA-mtOLt2RsZu5pHvVbFvByq1AKDN18LUx8qg1eYQDDriISrmL5rcXZ0PmzbDbU15VNaT5dynxEaZBE2n1i0pNOs2HuHAqntI8Tl1ud9U1tr3o8yUTQx7kST5IwI9nRn/s1600/1.png" /></a></div>
<br />
<br />
Note the screen name, open it, then click CUSTOMIZATION -> EDIT GENERIC INQUIRY:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWvaFiP-NUsACvHSc5MLUhxpy88c2FLKElncvp6qvhAgp3A-l-mKk7FWgtO53XzFFs3Ht7LMtCQIMh8XME_odHd3x8n-Ss704Yy3Q5qOiAKGvqVEsvydrbC-VJv7jW8lxh7t3Lri_hMF86/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="177" data-original-width="1600" height="70" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWvaFiP-NUsACvHSc5MLUhxpy88c2FLKElncvp6qvhAgp3A-l-mKk7FWgtO53XzFFs3Ht7LMtCQIMh8XME_odHd3x8n-Ss704Yy3Q5qOiAKGvqVEsvydrbC-VJv7jW8lxh7t3Lri_hMF86/s640/2.png" width="640" /></a></div>
<br />
And once opened here is the option you need to amend:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-NrwViGipILcHdw4YtOe89EitH7mhEzwjsdvoOsthiT5U4Uqo4MHYY2iw3nPg_ZXz_D_HqFRX_W1oMGWV7UeUZW0J44mFfpUYdvcY_M-ZYweNG45_E7LTZ402NUiIAPvp4KMO_quTdaa7/s1600/4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="669" data-original-width="1021" height="418" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-NrwViGipILcHdw4YtOe89EitH7mhEzwjsdvoOsthiT5U4Uqo4MHYY2iw3nPg_ZXz_D_HqFRX_W1oMGWV7UeUZW0J44mFfpUYdvcY_M-ZYweNG45_E7LTZ402NUiIAPvp4KMO_quTdaa7/s640/4.png" width="640" /></a></div>
<br />
There are two ways of doing it - complete removal of the entry list, then un-tick the option, save, done. OR you can leave entry list there but restrict the initial load to 50 records only. then amend Select Top to 50.<br />
<br />
This will guarantee no strain to your server any more.<br />
<br />
Now, for those who read it up to here, a bonus, here is a script that will do all this for all screens at once, it works for all implementations, as long as you have not modified the GI manually:<br />
<br />
<i>update GIDesign set selecttop = 50 where companyid = 1 and PrimaryScreenIDNew is not null</i><br />
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
All the best,</div>
<div>
<br /></div>
<div>
Sergey.</div>
<br />Sergey Vereshchaginhttp://www.blogger.com/profile/10783520078059582700noreply@blogger.com0tag:blogger.com,1999:blog-6832147928397006804.post-5539631317292505232020-06-01T20:18:00.000+08:002020-06-01T20:18:39.819+08:00Restricted Use of Control Accounts in Acumatica (2019R2 and up)Hi Everyone,<br />
<br />
Let me share recent Douglas Johnson video on Control Account feature in Acumatica:<br />
<br />
<iframe allowfullscreen="" frameborder="0" height="270" src="https://www.youtube.com/embed/TUa42ld5P6E" width="480"></iframe><br />
<br />
Please <b>be warned however</b>, that even though this feature was introduced with option not to choose account as a control account.<br />
It will <u>always check on certain scenarios</u> like Reversing a Bill, whether AP account is marked as control account or not.<br />
<br />
It may cause issues if your customization are sensitive to warning messages.<br />
<br />
So please take note. However in overall feature is a right one.<br />
<br />
Thank you,<br />
Sergey,Sergey Vereshchaginhttp://www.blogger.com/profile/10783520078059582700noreply@blogger.com0tag:blogger.com,1999:blog-6832147928397006804.post-36949873394436056552020-04-08T17:08:00.003+08:002020-04-08T17:08:34.906+08:00REST based WEB Service. Using the Note field Correctly.<div dir="ltr" style="text-align: left;" trbidi="on">
<style>
.code { background:#f5f8fa; background-repeat:no-repeat; border: solid #5C7B90; border-width: 1px 1px 1px 20px; color: #000000; font: 13px 'Courier New', Courier, monospace; line-height: 16px; margin: 10px 0 10px 10px; min-height: 16px; overflow: auto; padding: 10px 10px 10px; width: 90%; }
.code:hover { background-repeat:no-repeat; }
</style>
<br />
<div dir="ltr" style="text-align: left;" trbidi="on">
Hi Everyone,<br />
<br />
<br />
Here is a tutorial on how to set/update the note field for records.<br />
<br />
<b>Setting a note value</b><br />
To set a note value by the contract-based REST API, do the following:<br />
<ol style="text-align: left;">
<li>Retrieve the record in question</li>
<ol type="a">
<li>Set your contract-based REST API request with the following settings:</li>
<ul>
<li>HTTP method: <i>GET</i></li>
<li>URL: https://<entity>/Default/<endpoint version>/<endpoint name>/<record name></li>
<li>No parameters for request</li>
<li>Headers:</li>
<ul>
<li>Accept -> application/json</li>
<li>Content-Type -> application/json</li>
</ul>
</ul>
<li>Send the request. The response contains <i>200 OK</i> status. The body of the response includes the list of fields of the record in JSON format. The following is an example</li>
<div class="code">
{</br>
"id":"e72ca73d-ffcf-4b96-a07b-54988f9cd632",</br>
"rowNumber":1,</br>
"note":"",</br>
"CountNbr":{</br>
"value":"FCN000021"</br>
},</br>
"Details":[...],</br>
"custom":{},</br>
"files":[]</br>
}
</div>
</ol>
<li>Save the request</li>
<li>Update the note field</li>
<ol type="a">
<li>Set your contract-based REST API request with the following settings:</li>
<ul>
<li>HTTP method: <i>PUT</i></li>
<li>URL: https://<entity>/Default/<endpoint version>/<endpoint name>/<top-level record name></li>
<li>No parameters for request</li>
<li>Headers:</li>
<ul>
<li>Accept -> application/json</li>
<li>Content-Type -> application/json</li>
</ul>
<li>Body of the request (where NOTECONTENT should be the note):</li>
<div class="code">
{</br>
"id":"e72ca73d-ffcf-4b96-a07b-54988f9cd632",</br>
"note":"NOTECONTENT",</br>
}</br>
OR</br>
{</br>
"CountNbr":{</br>
"value":"FCN000021"</br>
},</br>
"note":"NOTECONTENT",</br>
}
</div>
</ul>
<li>Send the request. If the request is successful, the response contains the 200 OK status code and includes the list of updated records in JSON format. The following is an example</li>
<div class="code">
{</br>
"id":"e72ca73d-ffcf-4b96-a07b-54988f9cd632",</br>
"rowNumber":1,</br>
"note":"NOTECONTENT",</br>
"CountNbr":{</br>
"value":"FCN000021"</br>
},</br>
"Details":[...],</br>
"custom":{},</br>
"files":[]</br>
}
</div>
</ol>
<ul>
</ul>
</ol>
<b>Important information to remember</b><br />
<br />
<ul style="text-align: left;">
<li>Make sure to <b>always</b> specify the note parameter to the note value, even when it is not being changed, as otherwise the note will be set to a empty string. This goes for all <i>PUT</i> requests</li>
</ul>
<br />
<ol style="text-align: left;"><ol type="a">
</ol>
</ol>
<div>
<br /></div>
</div>
</div>
Evgeny Vereshchaginhttp://www.blogger.com/profile/15420571384847516770noreply@blogger.com0tag:blogger.com,1999:blog-6832147928397006804.post-3097830425150739302019-10-27T01:01:00.000+08:002020-05-15T22:32:07.926+08:00Changing Acumatica Home Landing Page in 2018R2Hi Everyone,<br />
<br />
Just noticed that in 2018 Acumatica sets landing page as a complex one with multiple links and unnecessary information for some of my customers. This is what comes as default when you click on your company logo:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzKK-xKCb1XcsU23yqohexy-c59piwXXfZWqI2JkwZJX5Nz6kJ27xG4fet5UTT17poTrK-5BXw9fBRmkEryx9gXB-eFpttZbCESam-9BDmp9ifcf0cmqgQ1Sbh6B2D76-jXY6kDxvKB1Cz/s1600/image_2019_10_26T16_26_01_481Z.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="632" data-original-width="1074" height="235" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzKK-xKCb1XcsU23yqohexy-c59piwXXfZWqI2JkwZJX5Nz6kJ27xG4fet5UTT17poTrK-5BXw9fBRmkEryx9gXB-eFpttZbCESam-9BDmp9ifcf0cmqgQ1Sbh6B2D76-jXY6kDxvKB1Cz/s400/image_2019_10_26T16_26_01_481Z.png" width="400" /></a></div>
<br />
If your customer for example does not have access to the Internet or for whatever reason wants not to see this page but instead have immediate choice of setting it - I found a way to set landing page as User's profile. So, if user did not set the Home Page for (it)self then system will suggest it for the beginning. Here is how you can do it.<br />
<br />
1. Make sure you have access to the database or can execute a script there.<br />
2. Run the following script against your database:<br />
<br />
<i>update sitemap set Url = '~/Pages/SM/SM203010.aspx' where Url = '~/Frames/Default.aspx'</i><br />
<i><br /></i>
3. Restart your IIS server.<br />
4. Check on opening the system landing page becomes now User profile:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjARZg3P6N7Ub_MHW_Ufl4BHdTpVyBOkxs9dfyIMNqgrMEyeOFtkOtij3kS9fu9hTgA8ktS52aZRqZa_14fNtJq4y78GPGY9T-IQ-sA2mrJWk0uhYJslcqZEImFmjPBKbIhHHsjM2X36Z6E/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="622" data-original-width="904" height="275" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjARZg3P6N7Ub_MHW_Ufl4BHdTpVyBOkxs9dfyIMNqgrMEyeOFtkOtij3kS9fu9hTgA8ktS52aZRqZa_14fNtJq4y78GPGY9T-IQ-sA2mrJWk0uhYJslcqZEImFmjPBKbIhHHsjM2X36Z6E/s400/3.png" width="400" /></a></div>
5. Here user may change the landing page as desired. What I did is changed to Account Summary in GL, so next time you click on Company Logo, it will navigate you there.<br />
<br />
Please note that you can technically change the page for each module or per company if you modify the above script accordingly.<br />
<br />
<span style="background-color: yellow;">Addition for 2020R1. Above method does not change the landing page so what you can do is to replace Default.aspx file in the Frames folder with the one from the older versions or use below suggestion from comments.</span><br />
<br />
All the best,<br />
Sergey.<br />
<br />Sergey Vereshchaginhttp://www.blogger.com/profile/10783520078059582700noreply@blogger.com1tag:blogger.com,1999:blog-6832147928397006804.post-68839699922549988022019-08-07T18:38:00.001+08:002021-07-13T13:13:54.326+08:00Acumatica Page Missing under Google Chrome BrowserHi Everyone,<br />
<br />
This one is a hot topic, recently chrome team released some changes to the Chrome Browser, so that some PAGES could get missing.<br />
<br />
You still see Menu, still see screen list but the page itself is gone, blank, empty.<br />
<br />
How to fix?<br />
<br />
Just change settings in the Chrome:<div><br /></div><div>1. Type <span style="color: blue;">chrome://flags/</span> in the browser address bar and press Enter.</div><div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjP8_oYuxoMWjUNU7PpfB7Kqx2Ut_dobRObBp07I7PD2ozyDcViMlX25caTitCAU7WJU2pzcD5XmHKFDXt6m4RB7w_-yEiB2I-65U0A3Dwf8Y_0qGpi-6iHwWivEiViOeah6b-BZj1CDIkh/s1600/1.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="30" data-original-width="273" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjP8_oYuxoMWjUNU7PpfB7Kqx2Ut_dobRObBp07I7PD2ozyDcViMlX25caTitCAU7WJU2pzcD5XmHKFDXt6m4RB7w_-yEiB2I-65U0A3Dwf8Y_0qGpi-6iHwWivEiViOeah6b-BZj1CDIkh/s1600/1.png" /></a></div>
<br />
2. You should see the list of options:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPxEgGMNDKEWZ797n0UMKAkQ9TIlle2i0Ccj2se2j1JUEkOJWPAh9CWH8uaEtb6hOzz_qsfH1swEaCGiqhgNnwN_EINlb_baxVM4gb1hhOvBzYfT_WYblzqPS6VS2ZDo-zc29iMOBS31hW/s1600/2.PNG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="292" data-original-width="872" height="212" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjPxEgGMNDKEWZ797n0UMKAkQ9TIlle2i0Ccj2se2j1JUEkOJWPAh9CWH8uaEtb6hOzz_qsfH1swEaCGiqhgNnwN_EINlb_baxVM4gb1hhOvBzYfT_WYblzqPS6VS2ZDo-zc29iMOBS31hW/s640/2.PNG" width="640" /></a></div><div><div>3.Enable Temporarily Unexpire M90 flags - Make it ENABLE, then restart browser:</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMEJsvxebY_HZ0PEib16xlCFXojg6vs37uCYKwdQGFex3KtJEBGIjyCX3APdZMmLmgtig6VWReUD5DG05JBC4I9yDN1kebBkbge9DBR3TCouscH__ddKKPBrsXpm4wNRJzhPEfSUSJwLac/s426/333.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="94" data-original-width="426" height="89" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMEJsvxebY_HZ0PEib16xlCFXojg6vs37uCYKwdQGFex3KtJEBGIjyCX3APdZMmLmgtig6VWReUD5DG05JBC4I9yDN1kebBkbge9DBR3TCouscH__ddKKPBrsXpm4wNRJzhPEfSUSJwLac/w400-h89/333.PNG" width="400" /></a></div><br /><div><br /></div><div>4. Repeat steps 1 and 2. In the search bar type Lazy Frame or just Lazy:</div></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjrSgoPVfze-4gtZsrKUelFq9AQgORZg7CWhlr6fvRHvJ5jhQtVq0crChsm1nZFSHoglfE5I3HNJQ4S8xOhZOdXUaI7EWNJXpVUVwF_iQNXTcoUelJBW26FLW0mWaHQHRY-jKBL9xED5T-v/s1600/3.PNG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="473" data-original-width="801" height="376" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjrSgoPVfze-4gtZsrKUelFq9AQgORZg7CWhlr6fvRHvJ5jhQtVq0crChsm1nZFSHoglfE5I3HNJQ4S8xOhZOdXUaI7EWNJXpVUVwF_iQNXTcoUelJBW26FLW0mWaHQHRY-jKBL9xED5T-v/s640/3.PNG" width="640" /></a></div>
<br />
<br />
<br />5. Under <b>Enable lazy frame loading</b> choose <b>Disabled</b>:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUerTOFDE_a30SQt3GFr5KrspurV55nvhaMADtdRfcUUZAux-Fw2Ic_numjXKcx7TT7bZcRjKwRP56HPskHf7IMhgfFav0dg_Y2lV86ND8TYzkDNk6RBKDOeoBAXMtCvuC62h1gdNVruNT/s1600/1.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="121" data-original-width="789" height="98" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUerTOFDE_a30SQt3GFr5KrspurV55nvhaMADtdRfcUUZAux-Fw2Ic_numjXKcx7TT7bZcRjKwRP56HPskHf7IMhgfFav0dg_Y2lV86ND8TYzkDNk6RBKDOeoBAXMtCvuC62h1gdNVruNT/s640/1.png" width="640" /></a></div>
<br />
<br />
<br />
<br />6. Press <b>Relaunch Now</b> at the right bottom corner:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2P_5MNyd3Ac5FbHYq6AN8As9AXjbsRN2JA1bL_feE96GMcpLmV_qRyDp-2pEYJwWOTf1n4_jFFupjYaWHlGDYsV372xakuzfs0Wl3qfW9eq1UoNzJ1vUZoKJD7wCpMfR6g9T5YqtXrXyR/s1600/5.PNG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="136" data-original-width="299" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2P_5MNyd3Ac5FbHYq6AN8As9AXjbsRN2JA1bL_feE96GMcpLmV_qRyDp-2pEYJwWOTf1n4_jFFupjYaWHlGDYsV372xakuzfs0Wl3qfW9eq1UoNzJ1vUZoKJD7wCpMfR6g9T5YqtXrXyR/s1600/5.PNG" /></a></div>
<br />
<br />
<br />
<br />
That is it.<br />
Thank you,<br />
Sergey.</div>Sergey Vereshchaginhttp://www.blogger.com/profile/10783520078059582700noreply@blogger.com0tag:blogger.com,1999:blog-6832147928397006804.post-88076991955211037672019-07-20T23:31:00.001+08:002019-07-20T23:31:59.744+08:00Acumatica SSO. Hiding login options from a login page. ADFS case.Hi Everyone,<br />
<br />
When implementing Single Sign On in Acumatica, sooner or later you may wish to remove Normal User / Password from the login screen.<br />
<br />
Login page that had User/Password fields also Sign In button:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIEeLxrADhjsUdPUSPCflmN2vc-RZmXRSdU3OwkSRXUL52A5UIvGZPfXHnQEJNHRmYhm76T0_6nlbIpHnoWoCnCIlvfLBasO1OhLXnhnhpKJu8BL22MdYeQXgNJjsr8hVsd2zKLDoKI62n/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="549" data-original-width="521" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIEeLxrADhjsUdPUSPCflmN2vc-RZmXRSdU3OwkSRXUL52A5UIvGZPfXHnQEJNHRmYhm76T0_6nlbIpHnoWoCnCIlvfLBasO1OhLXnhnhpKJu8BL22MdYeQXgNJjsr8hVsd2zKLDoKI62n/s400/1.png" width="378" /></a></div>
<br />
What I really wanted is to leave Company Choice and Blue Pyramid only:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGcyPGa0zv7bkLRzrg2MWL5qrgo-lnCrkLtT-5c7WJg0p3fnmlS32ig-cgCyWwcmMLVb13a__8ZnDy8MJd2xHG7PcAiRZnU8oAQYvAbQrvdBC0xBbRokv_5uXaOpR0Y6PezVJnkJ7a8Gq0/s1600/2.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="404" data-original-width="480" height="336" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGcyPGa0zv7bkLRzrg2MWL5qrgo-lnCrkLtT-5c7WJg0p3fnmlS32ig-cgCyWwcmMLVb13a__8ZnDy8MJd2xHG7PcAiRZnU8oAQYvAbQrvdBC0xBbRokv_5uXaOpR0Y6PezVJnkJ7a8Gq0/s400/2.PNG" width="400" /></a></div>
<br />
Well, thanks to Acumatica RnD Team, we do not have such option under Acumatica UI yet...<br />
<br />
So, have to become a little bit a "web designer" and, get to the IIS server, find Acumatica folder, where your site is installed and do a little modding on the Login.aspx<br />
<br />
Normally this is C:\Program Files (x86)\Acumatica ERP\"YourInstanceName"\<br />
<br />
There find the folder Frames, and inside will be Login.aspx file.<br />
Make a copy of it :) just in case...<br />
<br />
Now let's modify this file to hide what we don't want to show the ordinary user:<br />
<br />
Add Visible = "false" here:<br />
<br />
<i><span style="font-family: Courier New, Courier, monospace;"><asp:TextBox runat="server" ID="txtUser" CssClass="login_user border-box" placeholder="My Username" Visible="false" /></span></i><br />
<br />
And here:<br />
<br />
<i><span style="font-family: Courier New, Courier, monospace;"><asp:TextBox runat="server" ID="txtPass" Width="100%" CssClass="login_pass border-box" </span></i><i><span style="font-family: Courier New, Courier, monospace;">TextMode="Password" placeholder="My Password" Visible="false" /></span></i><br />
<br />
And here:<br />
<br />
<i><span style="font-family: Courier New, Courier, monospace;"><asp:Button runat="server" ID="btnLogin" Text="Sign In" OnClick="btnLogin_Click" CssClass="login_button" OnClientClick="login_Click()" Visible="false" /></span></i><br />
<br />
Save, Restart, Enjoy.<br />
<br />
Best,<br />
Sergey.Sergey Vereshchaginhttp://www.blogger.com/profile/10783520078059582700noreply@blogger.com0tag:blogger.com,1999:blog-6832147928397006804.post-36356742084112881212019-07-13T12:47:00.002+08:002019-07-13T12:47:34.465+08:00Info Cloud Asia receiving Partner of the Year 2018 Singapore & Malaysia award by Acumatica Software<span style="font-size: large;">5 March 2019, Kuala Lumpur (Malaysia) </span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRz7MR1WK2MT8w2P4WEimoY8i7miMP_s-j1shVuabl6RlZBRSS2B3pgTm5O7kSIOi6m-NRuUQxOxlydvdDt3ZtNySQorIkiRWVZBzyzQD7OwEwKrSp474MnWtcWUShLnxRa3x8Vk02YFQ5/s1600/20190305_132459.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="847" data-original-width="1600" height="338" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRz7MR1WK2MT8w2P4WEimoY8i7miMP_s-j1shVuabl6RlZBRSS2B3pgTm5O7kSIOi6m-NRuUQxOxlydvdDt3ZtNySQorIkiRWVZBzyzQD7OwEwKrSp474MnWtcWUShLnxRa3x8Vk02YFQ5/s640/20190305_132459.jpg" width="640" /></a></div>
<br />
Thank you.Sergey Vereshchaginhttp://www.blogger.com/profile/10783520078059582700noreply@blogger.com0tag:blogger.com,1999:blog-6832147928397006804.post-83393953956252411412018-11-30T12:15:00.001+08:002018-11-30T12:15:57.447+08:00Acumatica Partner Meeting 2018. Dear Friends,<br />
<br />
Thank you all for participating at our Acumatica Singapore Partner meeting.<br />
<br />
What was discussed:<br />
<br />
1. Acumatica Branding in Asia Pacific<br />
<br />
2. Licensing Changes in version 2018 R2<br />
<br />
3. Enterprise and Medium size customer challenges and demands<br />
<br />
4. Ways to grow in 2019<br />
<br />
5. Enhanced Implementation techniques<br />
<br />
Short quiz for the readers. Try to guess who is on the picture :)<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgolXIYaj41YlP6H60IDzQFGQuO3D7KDNrETCNCKHUYDwHwh-VT6Nz1My_SfvCKsb1ElD8CvVt5yoESJXyPEb_WIs-Ov4j7h5O45YyXYl6sn3zDFH6_5NS-nb8xrWdg6eb6DLaBAmEUc-vH/s1600/IMG-20181130-WA0000.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="733" data-original-width="1493" height="314" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgolXIYaj41YlP6H60IDzQFGQuO3D7KDNrETCNCKHUYDwHwh-VT6Nz1My_SfvCKsb1ElD8CvVt5yoESJXyPEb_WIs-Ov4j7h5O45YyXYl6sn3zDFH6_5NS-nb8xrWdg6eb6DLaBAmEUc-vH/s640/IMG-20181130-WA0000.png" width="640" /></a></div>
<br />
<br />
All the best,<br />
Sergey.Sergey Vereshchaginhttp://www.blogger.com/profile/10783520078059582700noreply@blogger.com0tag:blogger.com,1999:blog-6832147928397006804.post-55340590555856285852018-11-14T17:36:00.001+08:002018-11-14T17:36:08.306+08:00Adding Links to Notification EmailsHi Everyone,<br />
<br />
There is sometimes a task to add dynamic or static links to system generated Notifications.<br />
Here is how to do it.<br />
<br />
1. Add a field to a screen, where your dynamic link will be generated and stored.<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJ9m53tO6FBUTfujp7q6et508VTH1qqeATVZKQ8Q4DdMtu1N9Ffhy4nT1nuS59sGU_eiyrq5YZlXhdKiFid4mLdFPFvx2iGFO897gzdEJazfsy5gOMnRt2cLRL_TsySU0H6N_u9YLHjqv6/s1600/1.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="URL Field" border="0" data-original-height="386" data-original-width="1159" height="213" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJ9m53tO6FBUTfujp7q6et508VTH1qqeATVZKQ8Q4DdMtu1N9Ffhy4nT1nuS59sGU_eiyrq5YZlXhdKiFid4mLdFPFvx2iGFO897gzdEJazfsy5gOMnRt2cLRL_TsySU0H6N_u9YLHjqv6/s640/1.png" title="Adding URL Filed" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Adding URL Filed</td></tr>
</tbody></table>
<br />
<br />
2. Create a notification Template adding there a link with the content from the field above:<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNizV_QpHHob032fxbYgRDfNouyRRQh6LhTIiI-bRV20Iid1_jCcWNMQkJbXfCUqxneg7uEWeL6j24JKYAT6vVs70mNCiiQ44oXuGPcZ0K-gloRgaNGOTer20mYLJwQDUeyyIpiKTEHwph/s1600/2.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="Notification Screen" border="0" data-original-height="646" data-original-width="1107" height="372" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNizV_QpHHob032fxbYgRDfNouyRRQh6LhTIiI-bRV20Iid1_jCcWNMQkJbXfCUqxneg7uEWeL6j24JKYAT6vVs70mNCiiQ44oXuGPcZ0K-gloRgaNGOTer20mYLJwQDUeyyIpiKTEHwph/s640/2.png" title="Modifying notification" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Referencing a link in the Notification</td></tr>
</tbody></table>
<br />
As a result your notification will get the Link from the field.<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqR843nK73VznHZpLxoWXxXWA_d0z2BhyphenhyphenSdtv-68nJLzimotw7ES5YCy_4GEGh-PyP0s2OblTDeFa0i9dmkot804OPzt-8z7WYeLVG1Fdl0c4jSOxNTe7UmTcRbtLzljw7Jt18mjjbvzZk/s1600/3.PNG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="Notification with the link" border="0" data-original-height="480" data-original-width="869" height="352" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqR843nK73VznHZpLxoWXxXWA_d0z2BhyphenhyphenSdtv-68nJLzimotw7ES5YCy_4GEGh-PyP0s2OblTDeFa0i9dmkot804OPzt-8z7WYeLVG1Fdl0c4jSOxNTe7UmTcRbtLzljw7Jt18mjjbvzZk/s640/3.PNG" title="Link is added to notification" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Notification Template with the Link added</td></tr>
</tbody></table>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<br />
All the best,<br />
Sergey.Sergey Vereshchaginhttp://www.blogger.com/profile/10783520078059582700noreply@blogger.com0tag:blogger.com,1999:blog-6832147928397006804.post-26582647108168819232018-10-30T20:39:00.000+08:002018-10-30T20:41:42.683+08:00Enabling and Monitoring TLS on AcumaticaHi Guys,<br />
<br />
There is a lot of hoo-ha recently about switching to TLS 1.2....<br />
<br />
Well, mainly, the sound comes from Acumatica marketing team and also from some of those "security advisers", reviewing for us what is secure and what is not.<br />
<br />
So, here is the proposed way to <b>enable TLS 1.1 and/or TLS 1.2 on your IIS server.</b><br />
<br />
And also proposing a way to make sure (or monitor) that your dear clients are connecting their browsers using secure protocols.<br />
<br />
What we need to do first is to disable insecure protocols and enable secure ones.<br />
<br />
<h2>
Adding TLS 1.1 and/or TLS 1.2 to your server</h2>
If you wish to add just TLS 1.2 please download a file and add registry information to your IIS SERVER, here is the example of the file from <a href="https://tecadmin.net/enable-tls-on-windows-server-and-iis/" target="_blank">Rahul Kumar's</a> blog:<br />
<br />
<a href="https://tecadmin.net/wp-content/downloads/wincfg/Enable-TLS12-Windows.reg">TLS 1.2 ONLY</a><br />
<br />
You can also manually create reg file with this content. Please Note that this will also disable some less secure protocols like SSL 2.0, SSL 3.0, TLS 1.0 and TLS 1.1:<br />
<br />
<span style="color: blue; font-size: xx-small;"><i>Windows Registry Editor Version 5.00</i></span><br />
<span style="color: blue; font-size: xx-small;"><i><br /></i></span>
<span style="color: blue; font-size: xx-small;"><i>[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\SSL 2.0\Client]</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"DisabledByDefault"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"Enabled"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i><br /></i></span>
<span style="color: blue; font-size: xx-small;"><i>[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\SSL 2.0\Server]</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"DisabledByDefault"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"Enabled"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i><br /></i></span>
<span style="color: blue; font-size: xx-small;"><i>[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\SSL 3.0\Client]</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"DisabledByDefault"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"Enabled"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i><br /></i></span>
<span style="color: blue; font-size: xx-small;"><i>[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\SSL 3.0\Server]</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"DisabledByDefault"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"Enabled"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i><br /></i></span>
<span style="color: blue; font-size: xx-small;"><i>[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Client]</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"DisabledByDefault"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"Enabled"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i><br /></i></span>
<span style="color: blue; font-size: xx-small;"><i>[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Server]</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"DisabledByDefault"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"Enabled"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i><br /></i></span>
<span style="color: blue; font-size: xx-small;"><i>[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.1\Client]</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"DisabledByDefault"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"Enabled"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i><br /></i></span>
<span style="color: blue; font-size: xx-small;"><i>[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.1\Server]</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"DisabledByDefault"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"Enabled"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i><br /></i></span>
<span style="color: blue; font-size: xx-small;"><i>[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client]</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"DisabledByDefault"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"Enabled"=dword:00000001</i></span><br />
<span style="color: blue; font-size: xx-small;"><i><br /></i></span>
<span style="color: blue; font-size: xx-small;"><i>[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Server]</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"DisabledByDefault"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"Enabled"=dword:00000001</i></span><br />
<br />
If you wish to leave TLS 1.1 enabled, please use another script instead:<br />
<br />
<a href="https://tecadmin.net/wp-content/downloads/wincfg/Enable-TLS12-TLS11-Windows.reg">TLS 1.1 and 1.2</a><br />
<br />
Content would be like below, if you prefer to create .reg files manually:<br />
<br />
<span style="color: blue; font-size: xx-small;"><i>Windows Registry Editor Version 5.00</i></span><br />
<span style="color: blue; font-size: xx-small;"><i><br /></i></span>
<span style="color: blue; font-size: xx-small;"><i>[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\SSL 2.0\Client]</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"DisabledByDefault"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"Enabled"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i><br /></i></span>
<span style="color: blue; font-size: xx-small;"><i>[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\SSL 2.0\Server]</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"DisabledByDefault"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"Enabled"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i><br /></i></span>
<span style="color: blue; font-size: xx-small;"><i>[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\SSL 3.0\Client]</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"DisabledByDefault"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"Enabled"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i><br /></i></span>
<span style="color: blue; font-size: xx-small;"><i>[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\SSL 3.0\Server]</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"DisabledByDefault"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"Enabled"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i><br /></i></span>
<span style="color: blue; font-size: xx-small;"><i>[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Client]</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"DisabledByDefault"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"Enabled"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i><br /></i></span>
<span style="color: blue; font-size: xx-small;"><i>[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Server]</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"DisabledByDefault"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"Enabled"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i><br /></i></span>
<span style="color: blue; font-size: xx-small;"><i>[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.1\Client]</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"DisabledByDefault"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"Enabled"=dword:00000001</i></span><br />
<span style="color: blue; font-size: xx-small;"><i><br /></i></span>
<span style="color: blue; font-size: xx-small;"><i>[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.1\Server]</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"DisabledByDefault"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"Enabled"=dword:00000001</i></span><br />
<span style="color: blue; font-size: xx-small;"><i><br /></i></span>
<span style="color: blue; font-size: xx-small;"><i>[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client]</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"DisabledByDefault"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"Enabled"=dword:00000001</i></span><br />
<span style="color: blue; font-size: xx-small;"><i><br /></i></span>
<span style="color: blue; font-size: xx-small;"><i>[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Server]</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"DisabledByDefault"=dword:00000000</i></span><br />
<span style="color: blue; font-size: xx-small;"><i>"Enabled"=dword:00000001</i></span><br />
<div>
<br /></div>
After registry is updated please restart your server.<br />
<br />
There could be an issue with FIPS enabled in your system, if .NET throws an error that:<br />
<i style="background-color: white; color: red; font-family: Helvetica; font-size: small;"><br /></i>
<i style="background-color: white; color: red; font-family: Helvetica; font-size: small;">"This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms."</i><br />
<br />
All you need to do is to disable FIPS under Local Security Policies.<br />
<br />
<h2>
Disabling FIPS under Local Security Policies</h2>
<div>
<div>
1. Open Control Panel, click Administrative Tools, and then double-click Local Security Policy.</div>
<div>
2. Under Local Security Settings, expand Local Policies, and then click Security Options.</div>
<div>
3. Under Policy in the right pane, double-click System cryptography: Use FIPS compliant algorithms for encryption, hashing, and signing, and then click Disabled.</div>
<div>
4. Run gpupdate /force</div>
</div>
<div>
<br /></div>
<h2>
Monitoring the client communications protocol</h2>
<div>
This is the best part actually. After you enabled TLS 1.2 it is time to show the auditors that you are compliant 100% with what is called security. Today. So we may have IE, FireFox and Chrome. </div>
<div>
<br /></div>
<h3>
Check the security protocol used on Internet Explorer</h3>
<div>
First you need to connect to your Acumatica using IE. I am demonstrating customer who is using Acumatica version 3.0. And, yes, 3.0 also supports TLS 1.2. Please note it should be HTTPS protocol of course:</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj63BG48hkyzljHwfCRmW_HvVDZZd8W93ptLzUxGLSkbGjeDhvmSQQsZJzkgStRDIjNkkr88yL9jXXyUigyQWPGNAxvnJuhqnlLg1OrfoMJn4ITNilIcv84qXAGK7xvovaMdH6j7zpLRWSM/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="https protocol acumatica tls 1.2" border="0" data-original-height="761" data-original-width="1277" height="379" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj63BG48hkyzljHwfCRmW_HvVDZZd8W93ptLzUxGLSkbGjeDhvmSQQsZJzkgStRDIjNkkr88yL9jXXyUigyQWPGNAxvnJuhqnlLg1OrfoMJn4ITNilIcv84qXAGK7xvovaMdH6j7zpLRWSM/s640/1.png" title="Login to Acumatica using https" width="640" /></a></div>
<div>
<br /></div>
<div>
Secondly, right click on the header of the screen (do not right click on grid!) and you will see a choice drop down. Click Properties:</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkqvWeTndG_Xu2mofbLqPWEqcwEuLjit2dpbxwv8vXNH3Pp4Sk5dqQly1iCtgPAlSbuHF-ToNmbszbtDnOm8vQuHHqdwRFNiIsuppLpKxmbknAHr09OwlO5e4deCYGTLbrrD9eDNDAX7Ck/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="TLS Version" border="0" data-original-height="762" data-original-width="1276" height="382" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkqvWeTndG_Xu2mofbLqPWEqcwEuLjit2dpbxwv8vXNH3Pp4Sk5dqQly1iCtgPAlSbuHF-ToNmbszbtDnOm8vQuHHqdwRFNiIsuppLpKxmbknAHr09OwlO5e4deCYGTLbrrD9eDNDAX7Ck/s640/2.png" title="Choosing Properties" width="640" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
Third, check the Connection. </div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiawaQnGu2vrii6Qlf2Elb5NgsIUt7ouXOP4r1_hqbEdQWCfytbhFxCF1BsyCV4yXB3-WjNzzRwUSs_Q1n5CUGKsqc7ZiZf4rsObHSl2RzEw_IQuDzX2AlAvQnZKHQYGCJsts901Ap8CRG_/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Connection Properties" border="0" data-original-height="455" data-original-width="372" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiawaQnGu2vrii6Qlf2Elb5NgsIUt7ouXOP4r1_hqbEdQWCfytbhFxCF1BsyCV4yXB3-WjNzzRwUSs_Q1n5CUGKsqc7ZiZf4rsObHSl2RzEw_IQuDzX2AlAvQnZKHQYGCJsts901Ap8CRG_/s640/3.png" title="TLS 1.2" width="521" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<h3>
Check the security protocol used on FireFox</h3>
<div>
Login, Click on (i) option, list to second page, enjoy</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhzsnNu3X8OzSRskOEfw9snhjG1QcJFo3PXYzNvHe0Ch3OfoyZfeNY4_Zvmvhegyqo_L5nNkTD7wPHUmljtEe7yvOAkz9tATXTVGFhBGF0FuQfjgFmNlcTHlakVhQSMozqgkNUP1tUsKbmn/s1600/4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="TLS Firefox" border="0" data-original-height="326" data-original-width="713" height="291" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhzsnNu3X8OzSRskOEfw9snhjG1QcJFo3PXYzNvHe0Ch3OfoyZfeNY4_Zvmvhegyqo_L5nNkTD7wPHUmljtEe7yvOAkz9tATXTVGFhBGF0FuQfjgFmNlcTHlakVhQSMozqgkNUP1tUsKbmn/s640/4.png" title="Firefox TLS option" width="640" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
Click on this arrow > and you will see option then click More Information</div>
<div>
<br /></div>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJ2T_ZPOexmRez5b2_TR0DIStZLYhoXzqOMWyFO60TjxCRqNsdymyTnNmbY8sX9bAALMbi1UM0vTSq4tOImJOsOSYj_t7xcm2Rr0YLymQ8wWE5tMheylil0dhwzFxSw-GyqLAiYW0LAhzY/s1600/5.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img alt="More Information" border="0" data-original-height="314" data-original-width="467" height="430" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJ2T_ZPOexmRez5b2_TR0DIStZLYhoXzqOMWyFO60TjxCRqNsdymyTnNmbY8sX9bAALMbi1UM0vTSq4tOImJOsOSYj_t7xcm2Rr0YLymQ8wWE5tMheylil0dhwzFxSw-GyqLAiYW0LAhzY/s640/5.png" title="TLS Firefox" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><br /></td></tr>
</tbody></table>
<div>
Then you will see detailed info</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhyphenhyphenuVPuJbxpgoLF7VGk1OmRzAvST0ojeJ0kJ87wdWUghsyime-P1cazesnx7F8R6ZbytrIXGGNz_1cMeL_Wn5oMZGtwoGOlSOznFc5ZAnwxY6KTN33TS3pDYyjd2wwoKxATJAA2NU1pfrT/s1600/6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Firefox TLS" border="0" data-original-height="765" data-original-width="616" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhyphenhyphenuVPuJbxpgoLF7VGk1OmRzAvST0ojeJ0kJ87wdWUghsyime-P1cazesnx7F8R6ZbytrIXGGNz_1cMeL_Wn5oMZGtwoGOlSOznFc5ZAnwxY6KTN33TS3pDYyjd2wwoKxATJAA2NU1pfrT/s640/6.png" title="TLS info" width="514" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<h3>
Check Security protocols used on Google Chrome</h3>
<div>
Here you need to press F12 and then choose Security option:</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiy2mcjvLJwdjG8dsj93JHevSsEjbVz5hei-08rb752nkw7Z8bnQ5WYdxj_9x4JpqoUD-IvLMcg3JvNUk10PLUn_U6pEp7FkkaUV1KVKtV77c4ugr6mnE0bFhu_L_3VfLAqwbzYnc5cmu5E/s1600/7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="TLS Options" border="0" data-original-height="556" data-original-width="620" height="572" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiy2mcjvLJwdjG8dsj93JHevSsEjbVz5hei-08rb752nkw7Z8bnQ5WYdxj_9x4JpqoUD-IvLMcg3JvNUk10PLUn_U6pEp7FkkaUV1KVKtV77c4ugr6mnE0bFhu_L_3VfLAqwbzYnc5cmu5E/s640/7.png" title="Google Chrome TLS" width="640" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
All the best,<br />
<br />
Sergey.Sergey Vereshchaginhttp://www.blogger.com/profile/10783520078059582700noreply@blogger.com2tag:blogger.com,1999:blog-6832147928397006804.post-16220776800499298432018-09-14T14:45:00.002+08:002018-09-20T22:46:56.717+08:00Retrieving Large Volume of Data via WEB Service in Acumatica Hi Everyone,<br />
<br />
Promised to write few posts about Web Services...<br />
<br />
<h2>
<span style="font-family: inherit;">Getting large volume of data via </span>Generic Inquiry Endpoint</h2>
<br />
Prerequisite - no knowledge about Acumatica platform whatsoever :), common sense and C# as a newbee.<br />
<br />
First of all I would create a Generic Inquiry in Acumatica to get our data ready.<br />
Please note that in order to get data without timeout errors, it must be arranged in batches.<br />
<br />
Due to the fact that Acumatica <u>does not handle Rowcount in GI's well enough</u>, and we can't relay on it, so we would need to arrange our data in a table properly <b>BY OURSELVES</b>.<br />
<br />
I tried few scenarios and it looks like getting data in batches of 1000 lines works the best way.<br />
WEB service does not die out and process is not getting interrupted.<br />
<br />
So, step by step now.<br />
<br />
<h3>
1. Please create a GI (Generic Inquiry) first. </h3>
Silly example below:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWpR6V55ntZmZ90CHOj-IZfg84pqsDlnvHfz-doqIN5SECA96xPAtO7OH3Hy54h2ykp0KklauPg2A4r06k9zP0VmKnbOdLGT4_8RPGoERlIfZKTojWHIYH3Z7uMNVlxzvcjGy1ZNXCWaG6/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Generic Inquiry in Acumatica" border="0" data-original-height="442" data-original-width="879" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWpR6V55ntZmZ90CHOj-IZfg84pqsDlnvHfz-doqIN5SECA96xPAtO7OH3Hy54h2ykp0KklauPg2A4r06k9zP0VmKnbOdLGT4_8RPGoERlIfZKTojWHIYH3Z7uMNVlxzvcjGy1ZNXCWaG6/s640/1.png" title="Generic Inquiry" width="640" /></a></div>
<br />
Please take note, I have added <b><span style="color: red;">two special columns</span></b>, Processing Batch and Maximum Batch Number.<br />
This is to organize WEB service better, later you will see why do we need these two.<br />
In short - it will minimize server calls and facilitate uninterrupted data flow.<br />
<br />
<h3>
2. Look at the design screen for this GI:</h3>
<br />
a) Data in the GI must be sorted by Processing Batch. In order to appear in the orderly manner for export. This is important!<br />
<br />
b) Put some conditions in the GI so you have only that number of rows that you need. In my case getting 112 batches 1000 rows each, looks scary already... 112k records...<br />
<br />
c) create underlying View or Table in the database to reflect Processing Batch and Maximum Batch numbers correctly. Correctly means have a Primary Key, don't make table too wide to facilitate speed of data extraction.<br />
<br />
d) Convert that table into a Data Access Class (DAC) to then later use in the GI as a data source (hint - use my older blog to find how to convert view/table to DAC)<br />
<br />
e) Format GI nicely so when you look at it, you experience proud and pleasure. :)<br />
<br />
Regarding those special fields:<br />
<br />
<b>Processing Batch</b> - is a number (int), representing a chunk of lines, by 1000 lines each.<br />
<br />
<b>Maximum Batch</b> - is the last Processing Batch number (int).<br />
<br />
<b>Note:</b> "Maximum Batch" number is the same for all rows, while "Processing Batch" number is changing for every thousand of rows.<br />
<br />
In order to create such numbering in a table I used a process on SQL, in that update, LineNbr is just a Primary Key, you can use any other PK actually:<br />
<br />
<i><span style="font-family: "courier new" , "courier" , monospace;">update MYTABLE set BatchNbr = s.BatchNbr, </span></i><br />
<i><span style="font-family: "courier new" , "courier" , monospace;">[MaxBatchNbr] = (select FLOOR(count(*)/1000)+1 from MYTABLE) </span></i><br />
<i><span style="font-family: "courier new" , "courier" , monospace;">from MYTABLE p </span></i><br />
<i><span style="font-family: "courier new" , "courier" , monospace;">inner join (select BatchNbr = FLOOR(ROW_NUMBER() OVER(ORDER BY LineNbr ASC)/1000)+1,LineNbr,CompanyID from MYTABLE) s </span></i><br />
<i><span style="font-family: "courier new" , "courier" , monospace;">on p.CompanyID = s.CompanyID and p.LineNbr = s.LineNbr</span></i><br />
<br />
Again, you will see later, why we need these numbers to be IN an SQL TABLE itself.<br />
Just accept it for now, ok.<br />
<br />
<h3>
3. Give that GI Access rights in Acumatica.</h3>
So the user we use for the web service, will be able to see it. Place it somewhere on your Site Map. Important, I call our GI <b>CRMPAY</b><br />
<br />
<h3>
4. Create the Endpoint. </h3>
Insert CRMPAY there. Add fields. Please note our special fields are there too:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg84A81hYF8Vd0mxAj_kQbhnXWWahYgvteHYOXhEgHEwPKwkirvM7-Eo4E9CLUp0TQmyjIaPpxEB2lqtID2hZ1N8RpbhXUE2Al2OuyAkugZQ-uaAmxjtxOyibso1nZvNev2KMiLRO8_C9W7/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Creating an Endpoint in Acumatica" border="0" data-original-height="455" data-original-width="1231" height="236" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg84A81hYF8Vd0mxAj_kQbhnXWWahYgvteHYOXhEgHEwPKwkirvM7-Eo4E9CLUp0TQmyjIaPpxEB2lqtID2hZ1N8RpbhXUE2Al2OuyAkugZQ-uaAmxjtxOyibso1nZvNev2KMiLRO8_C9W7/s640/2.png" title="Enpoint Creation" width="640" /></a></div>
<br />
<br />
<h3>
5. Click VIEW ENDPOINT SERVICE button to get a link to the web service. </h3>
Just copy the link to somewhere to keep, from the address bar, it will be something like: https://yourserver/yourendpointname/endpointversion?wdsl<br />
<br />
<h3>
6. Open your Visual Studio and create a new template</h3>
Project type C# Console, give it a name, I called it BLOG.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEioB_w_fd2QVfIUmKLrjz1QEwErrK2w4PGhG1gsivR34MbR56ZG9rVoOvqBDdLUCqClACZWmJF8lMB5X8usMTZVmGVlOVM0xz-aJpj99ohHEjtTWFiyRXQ4cVFodYEQDJ1-NRBvYshk2rGS/s1600/3.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Creating Visual Studio Project" border="0" data-original-height="316" data-original-width="1421" height="142" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEioB_w_fd2QVfIUmKLrjz1QEwErrK2w4PGhG1gsivR34MbR56ZG9rVoOvqBDdLUCqClACZWmJF8lMB5X8usMTZVmGVlOVM0xz-aJpj99ohHEjtTWFiyRXQ4cVFodYEQDJ1-NRBvYshk2rGS/s640/3.PNG" title="Microsoft Visual Studio" width="640" /></a></div>
<br />
<br />
<h3>
7. In order to connect to your web service via https we will need to add some code to the project. </h3>
Open Program.cs in your project and add this block to it:<br />
<br />
<b>Before:</b><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnvla15-F-iVBfP7ONtOWlvPr5TznP9upOqnNZ37FHzGt2ZGGVLqStelADJpOEMNkUvhynmmlklBisjBOdjJCL6FGfKqQ5nONyiQHbINwYKQTDstCk1TZXduGtKtdr4uS48yJLo4eHftS6/s1600/4.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Adding Project" border="0" data-original-height="301" data-original-width="442" height="271" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnvla15-F-iVBfP7ONtOWlvPr5TznP9upOqnNZ37FHzGt2ZGGVLqStelADJpOEMNkUvhynmmlklBisjBOdjJCL6FGfKqQ5nONyiQHbINwYKQTDstCk1TZXduGtKtdr4uS48yJLo4eHftS6/s400/4.PNG" title="Coding the Webservice" width="400" /></a></div>
<br />
<br />
<b>After. </b>What was added is in BLUE:<br />
<br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;">using System;</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;">using System.Collections.Generic;</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;">using System.Linq;</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;">using System.Text;</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;">using System.Net;</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;">using System.Net.Security;</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;">using System.Security.Cryptography.X509Certificates;</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"><br /></span>
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;">namespace BLOG</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;">{</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> class Program</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> {</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> static void Main(string[] args)</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> {</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"><br /></span>
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> <span style="color: blue;">//This code is necessary only if you connect to the website</span></span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> //through the HTTPS connection and</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> //you need to use custom validation of an SSL certificate</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> //(for example, if the website uses a self-signed certificate).</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> ServicePointManager.ServerCertificateValidationCallback += new</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> RemoteCertificateValidationCallback(ValidateRemoteCertificate);</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> </span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> using (DefaultSoapClient soapClient = new DefaultSoapClient())</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> {</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> //Log in to Acumatica ERP</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> soapClient.Login</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> (</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> Properties.Settings.Default.UserName,</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> Properties.Settings.Default.Password,</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> Properties.Settings.Default.CompanyName,</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> Properties.Settings.Default.Branch,</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> null</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> );</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> try</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> {</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> //You will add the integration code here</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> CRMDataRetriever.ExportCRMPayment(soapClient);</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> }</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> catch (Exception e)</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> {</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> </span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> Console.WriteLine(e);</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> Console.WriteLine();</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> Console.WriteLine("Press any key to continue");</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> Console.ReadLine();</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> }</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> finally</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> {</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> //Log out from Acumatica ERP</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> soapClient.Logout();</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> }</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> }</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> }</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"><br /></span>
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> //Callback, which is used to validate the certificate of</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> //an Acumatica ERP website in an SSL conversation</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> private static bool ValidateRemoteCertificate(object sender,</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> X509Certificate cert, X509Chain chain, SslPolicyErrors policyErrors)</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> {</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> //For simplicity, this callback always returns true.</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> //In a real integration application, you must check</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> //an SSL certificate here.</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> return true;</span><br />
<span style="color: blue; font-family: "courier new" , "courier" , monospace; font-size: x-small;"> }</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"><br /></span>
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> }</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> }</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;">}</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"><br /></span>
<span style="font-family: inherit;">8. You have noticed, Visual Studio prompting that some parts of the code above are not in yet:</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8A0frd5f2y3RE2RQ_6YPT0gAOGS5CuEC_CeiceTWRfia-VpoLvBfQyUxSFASu8Rw2qz5PqzMT02b6WeCDEK6KybRi3mHkpAwpOXcpHg7CGgZRBSsENACGzA1xeWQ8BnF66Oi5ynWGcHDS/s1600/5.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="193" data-original-width="556" height="222" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8A0frd5f2y3RE2RQ_6YPT0gAOGS5CuEC_CeiceTWRfia-VpoLvBfQyUxSFASu8Rw2qz5PqzMT02b6WeCDEK6KybRi3mHkpAwpOXcpHg7CGgZRBSsENACGzA1xeWQ8BnF66Oi5ynWGcHDS/s640/5.PNG" width="640" /></a></div>
<span style="font-family: inherit;"><br /></span>
<span style="font-family: inherit;"> It is time to add web service to the Project. Click Add Service Reference:</span><br />
<span style="font-family: inherit;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-MSRvcx2MGCH25Feww58kAcGRC4KilN2ZmVAw9HBtGLMt41Bj8MZawYzQS8Plkgk_-VMa57m1uJRB051WIavP0ZDnYh3bf12LtWbrdYnpbpL5i2Wghf-Qi5iBqypBJeEa8pcwXRN7A0Wd/s1600/6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="319" data-original-width="445" height="458" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-MSRvcx2MGCH25Feww58kAcGRC4KilN2ZmVAw9HBtGLMt41Bj8MZawYzQS8Plkgk_-VMa57m1uJRB051WIavP0ZDnYh3bf12LtWbrdYnpbpL5i2Wghf-Qi5iBqypBJeEa8pcwXRN7A0Wd/s640/6.png" width="640" /></a></div>
<span style="font-family: inherit;"><br /></span>
<br />
Then indicate the link from Item 5. And give it a name. Click OK:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7w6tqUkpn-iwlknDe0cOJ4OH1q68hDxjYS-u1D0WkWR-WVuXB2s3NwBJZDvGEHkaDgfnkl2vr33hH4M1-qzn2c469d7lD9px6OybubTBueRFuVD_aSlbH2Ccywoo-8n7AvoJjvkQoY5NM/s1600/7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="519" data-original-width="637" height="520" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7w6tqUkpn-iwlknDe0cOJ4OH1q68hDxjYS-u1D0WkWR-WVuXB2s3NwBJZDvGEHkaDgfnkl2vr33hH4M1-qzn2c469d7lD9px6OybubTBueRFuVD_aSlbH2Ccywoo-8n7AvoJjvkQoY5NM/s640/7.png" width="640" /></a></div>
<br />
You may be prompted for a certificate mismatch, just accept it.<br />
<br />
9. Add a namespace to the top portion of the Program block and you will immediately notice some errors are gone:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjd0M_XICJRdrGj6g-WXh7s_N_-9Y9IHl3J-ihEnLKtnmymIDywMiquGbUYYiu-W1qxN2dsLI1DJfQzlL7BN0XdAXSU7pYrWqpEdSf0PtSfZmooLFncaXOvEIzpfPJF8f0c1NQXVhLG2tlI/s1600/10.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="451" data-original-width="609" height="472" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjd0M_XICJRdrGj6g-WXh7s_N_-9Y9IHl3J-ihEnLKtnmymIDywMiquGbUYYiu-W1qxN2dsLI1DJfQzlL7BN0XdAXSU7pYrWqpEdSf0PtSfZmooLFncaXOvEIzpfPJF8f0c1NQXVhLG2tlI/s640/10.PNG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<br />
10. Do 1,2,3,4 as displayed. Just right click at your project then do 1,2,3,4 actually:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhz-0mG96odIggM-gSsCPqARA8YNgoRl3bYbA6mghJW736ncfuz5e6FX1cB6Od9x1ySWdJ-bkw-aafgTW5BTKGYAeFpiJviLxfffKXuflql6yd7FR8SXT_eIqZ8TLkq1WJSIYNIkFrrsd2H/s1600/11.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="732" data-original-width="1029" height="454" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhz-0mG96odIggM-gSsCPqARA8YNgoRl3bYbA6mghJW736ncfuz5e6FX1cB6Od9x1ySWdJ-bkw-aafgTW5BTKGYAeFpiJviLxfffKXuflql6yd7FR8SXT_eIqZ8TLkq1WJSIYNIkFrrsd2H/s640/11.png" width="640" /></a></div>
<br />
11. Now we should provide some security references here to get logged into Acumatica. So just add four items exactly as below, then save project:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVVNCb_YWoWzhIWfNtMqqqhKR3H7euspsnH6B3g9Q3TaNwY4xoaXkPH276s1dt34m0SRIbpnF-fEHCa4tHVQp0bHSd7zckkw1kAku-av2onKX4ezL0P-l39tFtY0ZW9nFUcC73OsrDxe5X/s1600/12.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="402" data-original-width="924" height="278" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVVNCb_YWoWzhIWfNtMqqqhKR3H7euspsnH6B3g9Q3TaNwY4xoaXkPH276s1dt34m0SRIbpnF-fEHCa4tHVQp0bHSd7zckkw1kAku-av2onKX4ezL0P-l39tFtY0ZW9nFUcC73OsrDxe5X/s640/12.PNG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<br />
12. And, we supposed to get left with the only Error. Will be fixing that one then:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOSqzsGJ71iyLTbYaUoTz3fBxhB6isCfFjFiRMkZ688EMxgdMt4Rj9upbGE1K3Ie2Afi3iGgYGqWN0X2UUrDZXxEXguau8bAfrTWXxeI4h5tVFj3IejL1QBq5LvuYnOi2UDmJcStVaLzIO/s1600/13.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="159" data-original-width="517" height="122" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOSqzsGJ71iyLTbYaUoTz3fBxhB6isCfFjFiRMkZ688EMxgdMt4Rj9upbGE1K3Ie2Afi3iGgYGqWN0X2UUrDZXxEXguau8bAfrTWXxeI4h5tVFj3IejL1QBq5LvuYnOi2UDmJcStVaLzIO/s400/13.PNG" width="400" /></a></div>
<br />
13. Lets create that class CRMDataRetriever, where we are going to add the code:<br />
<br />
a) Add the class:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi4ZsUBqVIk566LwZ7DMQONL8Q-Bset_m7URVa9vcdO8ZMsKMe0Bri1XSDwQ4ZnptbIaXCRnflwefP5mnMznwb7IsTmHlnTwe2e1uD0eqDSmK-6wa6LXcnM9gF9t6QL8SLgrAPFgvDYLi-E/s1600/14.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="567" data-original-width="703" height="516" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi4ZsUBqVIk566LwZ7DMQONL8Q-Bset_m7URVa9vcdO8ZMsKMe0Bri1XSDwQ4ZnptbIaXCRnflwefP5mnMznwb7IsTmHlnTwe2e1uD0eqDSmK-6wa6LXcnM9gF9t6QL8SLgrAPFgvDYLi-E/s640/14.png" width="640" /></a></div>
<br />
<br />
b) Give it a name and Add:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizWtw9RVzwwSMkfVMY9SRVhY-cXq3xUeQ7sCZ-QQdFOV1A1b7L_N_b4PzfzG5CKq_AkWI77IHrf3Na4CwsMisyE_bBdrE-_hgP19GmD04Ja4kI3eJZnBF78aiR0N3IwQYJcH03n1Mj2enZ/s1600/15.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="669" data-original-width="972" height="440" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizWtw9RVzwwSMkfVMY9SRVhY-cXq3xUeQ7sCZ-QQdFOV1A1b7L_N_b4PzfzG5CKq_AkWI77IHrf3Na4CwsMisyE_bBdrE-_hgP19GmD04Ja4kI3eJZnBF78aiR0N3IwQYJcH03n1Mj2enZ/s640/15.PNG" width="640" /></a></div>
<br />
c) Add into the top section of the class these two namespaces:<br />
<br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;">using BLOG.BLOGSERVICE;</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;">using System.IO;</span><br />
<span style="font-family: "courier new" , "courier" , monospace;"><br /></span>
<span style="font-family: inherit;">d) Insert code into the class. In my case code will retrieve the first Batch, then one by one subsequent:</span><br />
<span style="font-family: inherit;"><br /></span>
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;">using System;</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;">using System.Collections.Generic;</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;">using System.Linq;</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;">using System.Text;</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;">using BLOG.BLOGSERVICE;</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;">using System.IO;</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"><br /></span>
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;">namespace BLOG</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;">{</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> class CRMDataRetriever</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> {</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"><br /></span>
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> public static int? processBatchNbr = 0;</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"><br /></span>
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> //Retrieving the list of CRM Payment Items</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> public static void ExportCRMPayment(DefaultSoapClient soapClient)</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> {</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> Console.WriteLine("Retrieving the list of Students...");</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> </span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> var crmPaymentsToBeFound = soapClient.GetList(</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> new CRMPAY</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"><br /></span>
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> {</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> //Specify return behavior - we are getting ALL the fields</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> ReturnBehavior = ReturnBehavior.All,</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> //Filter the items by the BatchNumber</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> BatchNbr = new IntSearch</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> {</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> Condition = IntCondition.Equal,</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> Value = 1</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> }</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> });</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"><br /></span>
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> //I am writing it into a csv file</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> using (StreamWriter file = new StreamWriter("CRMPayments.csv"))</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> {</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"><br /></span>
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> //Add headers to the file</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> file.WriteLine(</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> "BatchNbr,LineNbr,StudentCRMID,Term,Year,CourseID,PaymentStatus,");</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"><br /></span>
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> //This is maximum batch to process and writing batch one</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> foreach (CRMPAY crmPaymentsToBeFoun in crmPaymentsToBeFound)</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> {</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> processBatchNbr = crmPaymentsToBeFoun.MaxBatchNbr.Value;</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"><br /></span>
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"><br /></span>
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> Console.WriteLine("Retrieving the First Record ...");</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"><br /></span>
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> //Write the values for each item</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> file.WriteLine(string.Format("{0},{1},{2},{3},{4},{5},{6},",</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> crmPaymentsToBeFoun.BatchNbr.Value,</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> crmPaymentsToBeFoun.LineNbr.Value,</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> crmPaymentsToBeFoun.StudentCRMID.Value,</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> crmPaymentsToBeFoun.Term.Value,</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> crmPaymentsToBeFoun.Year.Value,</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> crmPaymentsToBeFoun.CourseID.Value,</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> crmPaymentsToBeFoun.PaymentStatus.Value));</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> }</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"><br /></span>
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> while (processBatchNbr != 1)</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> {</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> CRMPAY filter = new CRMPAY</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> {</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> BatchNbr = new IntSearch</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> {</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> Condition = IntCondition.Equal,</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> Value = processBatchNbr</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> },</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> ReturnBehavior = ReturnBehavior.All</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> };</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> Entity[] crmPayments = soapClient.GetList(filter);</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"><br /></span>
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> processBatchNbr = processBatchNbr - 1;</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"><br /></span>
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"><br /></span>
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> //Write the values for each item</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> foreach (CRMPAY crmPayment in crmPayments)</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> {</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"><br /></span>
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> file.WriteLine(string.Format("{0},{1},{2},{3},{4},{5},{6}",</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> crmPayment.BatchNbr.Value,</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> crmPayment.LineNbr.Value,</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> crmPayment.StudentCRMID.Value,</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> crmPayment.Term.Value,</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> crmPayment.Year.Value,</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> crmPayment.CourseID.Value,</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> crmPayment.PaymentStatus.Value));</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"><br /></span>
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> Console.WriteLine("Subsequent Rercord written into a file...");</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"><br /></span>
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> }</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> }</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> }</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"><br /></span>
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> }</span><br />
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"><br /></span>
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"><br /></span>
<span style="font-family: "courier new" , "courier" , monospace; font-size: x-small;"> }</span><br />
<div>
<br /></div>
<div>
14. Please note every time we call web service, we know what will be the next batch from the processBatchNbr variable, which we set once we retrieved the first record. Within a batch of records we follow based on the BatchNbr field condition. We do not do any calls to the web service which are redundant or unnecessary.</div>
<div>
<br /></div>
<div>
15. In order for WEB service to login correctly we have to enable cookies in the project config file. We should do it manually. </div>
<div>
<br /></div>
<div>
a) Open app.config file in the notepad</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfwrnpHWWwhbbvLIaBvr_zozsAciD1DuAfvi6RLP7MNyG5rsJK7dn2burwGY1ciZ7Da7sdINKKzabLSkShechCQu1NuG4S1fwara1YY0yDoGZUaNNeYCP79w_wKEcwHr10-w-wy7s8nnQu/s1600/16.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="402" data-original-width="726" height="354" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfwrnpHWWwhbbvLIaBvr_zozsAciD1DuAfvi6RLP7MNyG5rsJK7dn2burwGY1ciZ7Da7sdINKKzabLSkShechCQu1NuG4S1fwara1YY0yDoGZUaNNeYCP79w_wKEcwHr10-w-wy7s8nnQu/s640/16.PNG" width="640" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
b) Modify it slightly to allow cookies at the areas highlighted. Save. Close:</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEje9rlN8rc8XW3qTPCoom0zqBpApibniX7Cwk9QcYl4xGsuKRUYgVC_BVisWhX9XBNcxUiIsw75I3ojDb8AUWo51jdy1giCf1cAzCiI920NrQz5sZUOPHTMaHgqKu-IunM2-O52TlmxQroF/s1600/17.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="238" data-original-width="863" height="176" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEje9rlN8rc8XW3qTPCoom0zqBpApibniX7Cwk9QcYl4xGsuKRUYgVC_BVisWhX9XBNcxUiIsw75I3ojDb8AUWo51jdy1giCf1cAzCiI920NrQz5sZUOPHTMaHgqKu-IunM2-O52TlmxQroF/s640/17.png" width="640" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
16. Build the project, get BLOG.exe file at the bin/Debug folder and run it.</div>
<div>
<br /></div>
<div>
Enjoy csv file getting produced and endless messagess popping up at the console :)</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgC8mNHIWNVj3w76Lwi3b6WQisBAShVOHMUvdDObNNjF7RyV_495oL3kK97pLX_O8psL_N-POEtt1I5BFBb3ZIZU_onjVfti_7KRg6GL-l_QpktACum06EmSoQ5v3bVoqDPgzFdn5N2b8ak/s1600/18.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="230" data-original-width="700" height="210" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgC8mNHIWNVj3w76Lwi3b6WQisBAShVOHMUvdDObNNjF7RyV_495oL3kK97pLX_O8psL_N-POEtt1I5BFBb3ZIZU_onjVfti_7KRg6GL-l_QpktACum06EmSoQ5v3bVoqDPgzFdn5N2b8ak/s640/18.PNG" width="640" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
All the best,</div>
<div>
Sergey.</div>
<div>
<br /></div>
<div>
<h4>
P.S. Next blog will be about using OData to get the BIG DATA via WEB service of course...</h4>
</div>
Sergey Vereshchaginhttp://www.blogger.com/profile/10783520078059582700noreply@blogger.com0tag:blogger.com,1999:blog-6832147928397006804.post-27387184288331852232018-09-12T00:39:00.002+08:002018-09-20T22:49:31.507+08:00Acumatica Notification. How to Pass Empty Field Condition.Hi Guys,<br />
<br />
Today will be a short one.<br />
<br />
Just realized Acumatica is not very good at handling conditions at Notifications screen.<br />
<br />
When you need to Notify someone you create Automation Notification with the exact condition of <b><span style="color: red;">when</span></b> to do it.<br />
<br />
Potentially, there could be a case when you wish to call a notification ONLY when certain field is Empty. So, how?<br />
<br />
It is empty, does not mean NULL, because field may be not nullable, so IsNull will not work.<br />
How? ='' Does not work..... Any other ideas?<br />
<br />
After 30 mins of various tries found a solution.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhS52Q7p2WNaRnfmE_o4tXb1TdG9CzK-eYJOCsbpaU9gyBDaMLlfFbXSLtVQtsDmqR2PKxE4FjFY0p3XmDVeNbM8d1iLK9_ZNHdT7AFrx3SLm08uI7Ojl9wbd5ljXztF7dH1gFVkEm4GAAr/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Acumatica Notification Screen" border="0" data-original-height="630" data-original-width="1223" height="329" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhS52Q7p2WNaRnfmE_o4tXb1TdG9CzK-eYJOCsbpaU9gyBDaMLlfFbXSLtVQtsDmqR2PKxE4FjFY0p3XmDVeNbM8d1iLK9_ZNHdT7AFrx3SLm08uI7Ojl9wbd5ljXztF7dH1gFVkEm4GAAr/s640/1.png" title="Notifications" width="640" /></a></div>
<br />
In my case TnC field supposed to be empty. So we use:<br />
<br />
<b><span style="font-size: large;">Start With</span></b> in the Condition column, AND we just put <b><span style="color: red; font-size: large;">ONE single SPACE</span></b> into Value field.<br />
<br />
You cant see space on the picture but I tell you it is there....<br />
<br />
OMG.....<br />
<br />
Best,<br />
Sergey.Sergey Vereshchaginhttp://www.blogger.com/profile/10783520078059582700noreply@blogger.com0tag:blogger.com,1999:blog-6832147928397006804.post-1389494714618310202018-09-09T20:28:00.000+08:002018-09-09T20:28:14.792+08:00Need an Acumatica Developer in Singapore.Hi Everyone;<br />
<br />
IF<br />
<br />
You are a good developer in Acumatica framework<br />
AND<br />
Have 3 or more years of experience in developing Acumatica screens and functions<br />
AND<br />
(I know you OR (heard about you from Acumatica development team AND what I heard was positive))<br />
AND<br />
You are willing to work in Singapore<br />
<br />
THEN<br />
Please send me an email (you should know it) or just reply here with the request.<br />
<br />
ELSE<br />
Thank you, Sergey.Sergey Vereshchaginhttp://www.blogger.com/profile/10783520078059582700noreply@blogger.com0tag:blogger.com,1999:blog-6832147928397006804.post-78549515871127176912018-09-09T14:52:00.000+08:002018-09-09T14:57:24.138+08:00Automatic Updates and Apply Updates screen IssuesHi Guys,<br />
<br />
Today I have faced an issue for one of my clients when tried to publish the customization.<br />
I was trying to put the server in the Maintenance Mode.<br />
<br />
As you aware, there is an option in Acumatica to do the auto update.<br />
By default it is partially on, and pointing to the acumatica server:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirXqPFajCLCcGemPIsOEkqV7lwn_E7J5_OjYN57Lhwjh9fmV5rvPa-IVYzXmfrX9N72Qg78UApMfwKNJnYBhVU51qRJ25pKnzjmNen3Om2806Gh4J4ZkiRaf5S_0ho__BI8meOTfYEIGb8/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="457" data-original-width="613" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirXqPFajCLCcGemPIsOEkqV7lwn_E7J5_OjYN57Lhwjh9fmV5rvPa-IVYzXmfrX9N72Qg78UApMfwKNJnYBhVU51qRJ25pKnzjmNen3Om2806Gh4J4ZkiRaf5S_0ho__BI8meOTfYEIGb8/s1600/1.png" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
Please note, even if you did not check "Check for Updates" option,<br />
<b><span style="color: red;">EVERY TIME YOU OPEN THE SCREEN IT GOES TO </span><span style="color: blue;">http://update.acumatica.com</span><span style="color: red;"> JUST TO VERIFY THE SERVER IS ON.</span></b><br />
<br />
So what happened today is that Acumatica update server was down and it caused me to wait XX seconds till the timeout to see this:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgD2_Q4_m1sroVocWHTF8NS1b6Qgz-n4aFj1pB_ySB9SsZwFnYvmfmKiB4CaWvpsy5Y41O5nwZjLsnHStjHuvSoE7OPa9xunX4jb555430r58-iTyp6gaH80tSr4JcEDu1zqMf3wsbrCPmp/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="493" data-original-width="800" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgD2_Q4_m1sroVocWHTF8NS1b6Qgz-n4aFj1pB_ySB9SsZwFnYvmfmKiB4CaWvpsy5Y41O5nwZjLsnHStjHuvSoE7OPa9xunX4jb555430r58-iTyp6gaH80tSr4JcEDu1zqMf3wsbrCPmp/s1600/2.png" /></a></div>
<br />
<br />
In short, it is highly recommended, if you do not use the Auto Update feature, please do a complete cleanup till you have it like this:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglQPSjedmtck-v6LnJJyI5XjwE_dDuLCJroBbdMfRo2CDUV4eiPCf_4z3nUWRz7HokA0gmWPftUCqqn6NzU_dKa_DMuy2gEEvArtXCH8Obe1qxLMnumJAl6OAx6OYlA3t2rLZF0IReLeDQ/s1600/3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="370" data-original-width="582" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglQPSjedmtck-v6LnJJyI5XjwE_dDuLCJroBbdMfRo2CDUV4eiPCf_4z3nUWRz7HokA0gmWPftUCqqn6NzU_dKa_DMuy2gEEvArtXCH8Obe1qxLMnumJAl6OAx6OYlA3t2rLZF0IReLeDQ/s1600/3.png" /></a></div>
In this case every time you need to put the server in Maintenance Mode, there will be no timeout, as system will know there is no update server, so no need to ping it:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzlmOG4-1sioMyBmhyphenhyphenlCaAoC47VHlQNjgNkyUgbxHSgI9qmAr0Zvwc9qq6zYK90VTCDa5SJ5Bg_FABR4m-Miq9y-qTPIA2GKb_cvblhasL6F5_aul_VnLpKOrKJQtJXOb5W6r6GggUtk73/s1600/4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="383" data-original-width="928" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzlmOG4-1sioMyBmhyphenhyphenlCaAoC47VHlQNjgNkyUgbxHSgI9qmAr0Zvwc9qq6zYK90VTCDa5SJ5Bg_FABR4m-Miq9y-qTPIA2GKb_cvblhasL6F5_aul_VnLpKOrKJQtJXOb5W6r6GggUtk73/s1600/4.png" /></a></div>
<br />
<br />
No more error, just a warning and no delays.<br />
<br />
All the best,<br />
Sergey.<br />
<br />Sergey Vereshchaginhttp://www.blogger.com/profile/10783520078059582700noreply@blogger.com0tag:blogger.com,1999:blog-6832147928397006804.post-78064814949866295592018-04-17T12:14:00.000+08:002018-09-20T22:50:26.491+08:00The Learning Lab - Acumatica Customer of the YearDear Reader!<br />
<br />
I am Proud to announce:<br />
<br />
The biggest Private Primary and Secondary Learning Provider in Singapore - <a href="http://www.thelearninglab.com.sg/" target="_blank"><span style="color: #783f04;">The Learning Lab</span></a> just achieved the <b><span style="color: blue;">Customer of the Year</span></b> award at Acumatica Asia Roadshow 2018 !<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEixwtVhiWnid8ojumFc8HvUDczrxHY0FERfrSX9OAmwdCzwCWfbabA_79EuVkRQDNiYo6Dk1gCq5r2MSbNOTwoTLfT_1JLg-U30gkifYKknXj0cHj4eIcQbW-A6b9LOSFcuknxxjrlVShuc/s1600/111.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Super Powerfull Team of Professionals" border="0" data-original-height="1200" data-original-width="1600" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEixwtVhiWnid8ojumFc8HvUDczrxHY0FERfrSX9OAmwdCzwCWfbabA_79EuVkRQDNiYo6Dk1gCq5r2MSbNOTwoTLfT_1JLg-U30gkifYKknXj0cHj4eIcQbW-A6b9LOSFcuknxxjrlVShuc/s640/111.jpg" title="Acumatica TLL and Infocloud Asia" width="640" /></a></div>
<br />
Together with <a href="http://www.infocloud.com.sg/" target="_blank"><span style="color: #660000;">Info Cloud Asia</span></a> - leading consulting firm in Singapore, TLL achieved flawless implementation and integrated Acumatica with the CRM front end, Attendance Tracking Security system as well as Claim Tracking.<br />
<br />
Congratulations - it was an example of great team work!<br />
<br />
All the best!<br />
<br />Sergey Vereshchaginhttp://www.blogger.com/profile/10783520078059582700noreply@blogger.com0Singapore1.352083 103.819836000000010.8441055 103.174389 1.8600605 104.46528300000001tag:blogger.com,1999:blog-6832147928397006804.post-46537323438568618552017-12-28T12:01:00.002+08:002017-12-28T12:01:55.595+08:00Date Conversion Formats. TSQL.Hi Everyone,<br />
<br />
Hope this conversion table will help to present date and time in proper way.<br />
<br />
For example if you wish to see the current date, in MM/DD/YY please use 1 as a format:<br />
<br />
Statement:<br />
<br />
SELECT CONVERT(varchar(120),GETDATE(),1)<br />
<br />
Will return you 12/28/17<br />
<br />
In general, using SELECT CONVERT(varchar(120),GETDATE(),FORMAT)<br />
<div>
<br /></div>
Where FORMAT is just a number from the list will provide you respective output:<br />
<br />
<pre class="lang-sql prettyprint prettyprinted" style="background-color: #eff0f1; border: 0px; color: #393318; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; font-size: 13px; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: inherit; margin-bottom: 1em; max-height: 600px; overflow: auto; padding: 5px; vertical-align: baseline; width: auto; word-wrap: normal;"><code style="border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: inherit;"><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">output style
Apr </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">2014</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">9</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">31</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">AM </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">0</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">04</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">/</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">/</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">14</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">1</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">14.04.28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">2</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">/</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">04</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">/</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">14</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">3</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28.04.14</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">4</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28-04-14</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">5</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> Apr </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">14</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">6</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
Apr </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">14</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">7</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">09</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">31</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">8</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
Apr </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">2014</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">9</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">31</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">580</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">AM </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">9</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">04-28-14</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">10</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">14</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">/</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">04</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">/</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">11</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">140428</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">12</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> Apr </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">2014</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">09</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">31</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">580</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">13</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">09</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">31</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">580</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">14</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">2014-04-28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">09</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">31</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">20</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">2014-04-28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">09</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">31</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28.580</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">21</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">04</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">/</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">/</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">14</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">9</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">31</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> AM </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">22</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">2014-04-28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">23</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">09</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">31</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">24</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">2014-04-28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">09</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">31</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28.580</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">25</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
Apr </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">2014</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">9</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">31</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">AM </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">100</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">04</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">/</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">/</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">2014</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">101</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">2014.04.28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">102</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">/</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">04</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">/</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">2014</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">103</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28.04.2014</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">104</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28-04-2014</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">105</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> Apr </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">2014</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">106</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
Apr </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">2014</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">107</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">09</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">31</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">108</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
Apr </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">2014</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">9</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">31</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">580</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">AM </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">109</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">04-28-2014</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">110</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">2014</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">/</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">04</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">/</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">111</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">20140428</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">112</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> Apr </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">2014</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">09</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">31</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">580</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">113</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">09</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">31</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">580</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">114</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">2014-04-28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">09</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">31</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">120</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">2014-04-28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">09</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">31</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28.580</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">121</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">2014-04-28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">T09</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">31</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28.580</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">126</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">2014-04-28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">T09</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">31</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28.580</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">127</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">جمادى</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">الثانية</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">1435</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">9</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">31</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">580</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">AM </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">130</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">
</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">/</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">06</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">/</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">1435</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">9</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">31</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">28</span><span class="pun" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">:</span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">580</span><span class="pln" style="border: 0px; color: #303336; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">AM </span><span class="lit" style="border: 0px; color: #7d2727; font-family: inherit; font-size: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">131</span></code></pre>
All the best,<br />
Sergey.Sergey Vereshchaginhttp://www.blogger.com/profile/10783520078059582700noreply@blogger.com0tag:blogger.com,1999:blog-6832147928397006804.post-64838937816645859382017-09-13T01:19:00.002+08:002017-09-13T01:19:45.287+08:00Amount to Words conversion at Acumatica ReportsHi Everyone,<br />
<br />
As we do not yet have Amount to Words function inside our top notch Report Designer, let me share one created to print cheques from AR module.<br />
<br />
Same logic applies and can be reused anywhere inside Acumatica Report Designer. I did it for up to 10,000 amount, but you can easily extend it upwards.<br />
<br />
1. First of all lets create few Variables on top of the Reporting Group where we are going to use A2W conversion.<br />
<br />
a) AmountCents - that will be total amount converted to Cents. I used ARPayment.CuryOrigDocAmt but you can use ANY other numeric field as a SOURCE<br />
b) AmtThousands - that will be just how many thousands we have<br />
c) AmtHundreds - displays number of hundreds only<br />
d) AmtOnes - Ones only<br />
c) AmtCents - Cents only<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimBP4W-j46uVte-WHiZGlOQmq6W838DefkT5BwtcQZx3e0oRoeMUXyhec-cVx0QGR1J2R6wuzZ5NragDN7nz7H5Q7XbK4yUfk1sjZ-1fnLdw-3Lq8hDWMeDd4r7dURmsRF-UCqmvF0QMRP/s1600/1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="760" data-original-width="1261" height="384" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimBP4W-j46uVte-WHiZGlOQmq6W838DefkT5BwtcQZx3e0oRoeMUXyhec-cVx0QGR1J2R6wuzZ5NragDN7nz7H5Q7XbK4yUfk1sjZ-1fnLdw-3Lq8hDWMeDd4r7dURmsRF-UCqmvF0QMRP/s640/1.png" width="640" /></a></div>
<br />
Below are all the formulae:<br />
<br />
<span style="color: blue; font-family: Courier New, Courier, monospace; font-size: x-small;">AmountCents:</span><br />
<span style="color: blue; font-family: Courier New, Courier, monospace; font-size: x-small;">=CInt([ARPayment.CuryOrigDocAmt]*100)</span><br />
<span style="color: blue; font-family: Courier New, Courier, monospace; font-size: x-small;"><br /></span>
<span style="color: blue; font-family: Courier New, Courier, monospace; font-size: x-small;">AmtThousands:</span><br />
<span style="color: blue; font-family: Courier New, Courier, monospace; font-size: x-small;">=Floor($AmountCents/100000)</span><br />
<span style="color: blue; font-family: Courier New, Courier, monospace; font-size: x-small;"><br /></span>
<span style="color: blue; font-family: Courier New, Courier, monospace; font-size: x-small;">AmtHundreds:</span><br />
<span style="color: blue; font-family: Courier New, Courier, monospace; font-size: x-small;">=Floor(($AmountCents-$AmtThousands*100000)/10000)</span><br />
<span style="color: blue; font-family: Courier New, Courier, monospace; font-size: x-small;"><br /></span>
<span style="color: blue; font-family: Courier New, Courier, monospace; font-size: x-small;">AmtTens:</span><br />
<span style="color: blue; font-family: Courier New, Courier, monospace; font-size: x-small;">=Floor(($AmountCents-$AmtThousands*100000-$AmtHundreds*10000)/1000)</span><br />
<span style="color: blue; font-family: Courier New, Courier, monospace; font-size: x-small;"><br /></span>
<span style="color: blue; font-family: Courier New, Courier, monospace; font-size: x-small;">AmtOnes:</span><br />
<span style="color: blue; font-family: Courier New, Courier, monospace; font-size: x-small;">=Floor(($AmountCents-$AmtThousands*100000-$AmtHundreds*10000-$AmtTens*1000)/100)</span><br />
<span style="color: blue; font-family: Courier New, Courier, monospace; font-size: x-small;"><br /></span>
<span style="color: blue; font-family: Courier New, Courier, monospace; font-size: x-small;">AmtCents:</span><br />
<span style="color: blue; font-family: Courier New, Courier, monospace; font-size: x-small;">=CInt(Right(CStr($AmountCents),2))</span><br />
<br />
2. Secondly add quite long formula into the field itself, here it is:<br />
<br />
<span style="color: blue; font-family: Courier New, Courier, monospace; font-size: x-small;">Your Field: =Iif($AmtThousands<>0,Switch($AmtThousands=10,'Ten',$AmtThousands=9,'Nine',$AmtThousands=8,'Eight',$AmtThousands=7,'Seven',$AmtThousands=6,'Six',$AmtThousands=5,'Five',$AmtThousands=4,'Four',$AmtThousands=3,'Three',$AmtThousands=2,'Two',$AmtThousands=1,'One') + ' Thousand ','') + Iif($AmtHundreds<>0,Switch($AmtHundreds=9,'Nine',$AmtHundreds=8,'Eight',$AmtHundreds=7,'Seven',$AmtHundreds=6,'Six',$AmtHundreds=5,'Five',$AmtHundreds=4,'Four',$AmtHundreds=3,'Three',$AmtHundreds=2,'Two',$AmtHundreds=1,'One') + ' Hundred ','') + Iif($AmtTens<>0,Switch($AmtTens=9,'Ninety',$AmtTens=8,'Eighty',$AmtTens=7,'Seventy',$AmtTens=6,'Sixty',$AmtTens=5,'Fifty',$AmtTens=4,'Forty',$AmtTens=3,'Thirty',$AmtTens=2,'Twenty',$AmtTens=1,'') + ' ','') + Iif($AmtTens=1,Switch($AmtOnes=9,'Nineteen',$AmtOnes=8,'Eighteen',$AmtOnes=7,'Seventeen',$AmtOnes=6,'Sixteen',$AmtOnes=5,'Fifteen',$AmtOnes=4,'Fourteen',$AmtOnes=3,'Thirteen',$AmtOnes=2,'Twelve',$AmtOnes=1,'Eleven',$AmtOnes=0,'Ten') + ' ','') + Iif($AmtTens<>1,Switch($AmtOnes=9,'Nine',$AmtOnes=8,'Eight',$AmtOnes=7,'Seven',$AmtOnes=6,'Six',$AmtOnes=5,'Five',$AmtOnes=4,'Four',$AmtOnes=3,'Three',$AmtOnes=2,'Two',$AmtOnes=1,'One',$AmtOnes=0,''),'') + Iif($AmountCents=$AmtCents,'Zero','') + Iif($AmtCents=0,' Only',' and ' + CStr($AmtCents) + '¢ Only')</span><br />
<br />
3. Let see what we got:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj75oF7HHmJ8YMjpFq9y2dnEukg96U9efKUiAUqH7DWcS5vc2L7OXWvT0fy1hzStJq3vqRzguT1JLH5cBm3mfIYTvUxAbXWSHB8m8UCRGm0HBZnA5Lvu9lkYpsXYhSIZ2QCVFX8n-Io70i2/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="391" data-original-width="850" height="294" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj75oF7HHmJ8YMjpFq9y2dnEukg96U9efKUiAUqH7DWcS5vc2L7OXWvT0fy1hzStJq3vqRzguT1JLH5cBm3mfIYTvUxAbXWSHB8m8UCRGm0HBZnA5Lvu9lkYpsXYhSIZ2QCVFX8n-Io70i2/s640/2.png" width="640" /></a></div>
It works only up to 10k, but if you wish, you can add in front of the formula further parsing.<br />
<br />
All the Best,<br />
Sergey.Sergey Vereshchaginhttp://www.blogger.com/profile/10783520078059582700noreply@blogger.com3tag:blogger.com,1999:blog-6832147928397006804.post-77074238975431002862017-07-27T16:36:00.004+08:002017-07-27T16:37:30.747+08:00Acumatica is on Gartner Magic QuadrantCongratulations Everyone!<br />
<br />
We have finally made it, now Acumatica is on Gartner.<br />
You request for a copy here: <a href="http://www.acumatica.com/analyst-reports/gartner-magic-quadrant-for-cloud-core-financial-management-suites/" target="_blank">Request Gartner Report</a><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhs1-Ia5zhtXFKesIx3fOOsOYybcsGFCrtcjpF19fhbFPlycSCVfgu0BsEPNwn9uoRzJCPy_xUjI1XD6v77QF_iynDTYMP_dYosb1fDKug_IRFBHXBiZBu-ybgyQDLQkjE3zrJ2x5ms28zA/s1600/318580_0001.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1393" data-original-width="1393" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhs1-Ia5zhtXFKesIx3fOOsOYybcsGFCrtcjpF19fhbFPlycSCVfgu0BsEPNwn9uoRzJCPy_xUjI1XD6v77QF_iynDTYMP_dYosb1fDKug_IRFBHXBiZBu-ybgyQDLQkjE3zrJ2x5ms28zA/s400/318580_0001.png" width="400" /></a></div>
<br />
At the same time, PC Magazine made us top brands. I can not believe it :)<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVfk91lec9SupmqZPNO7EEWm9v8Ah6pLWLK1YS0HZ9Y-tyrgtpaT1rM6QFBGnPFYW-JVUpDDunwaT8kr1Q2CoN7o4DPlEeeEjl6LWtuzielDFA-5J1PJ2jjGZsllzf0y0GkuAR6gOprjZG/s1600/PCM.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="684" data-original-width="1063" height="256" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVfk91lec9SupmqZPNO7EEWm9v8Ah6pLWLK1YS0HZ9Y-tyrgtpaT1rM6QFBGnPFYW-JVUpDDunwaT8kr1Q2CoN7o4DPlEeeEjl6LWtuzielDFA-5J1PJ2jjGZsllzf0y0GkuAR6gOprjZG/s400/PCM.PNG" width="400" /></a></div>
<br />
Full article here:<br />
<br />
<a href="http://sea.pcmag.com/cloud-services/15793/guide/the-best-erp-software-for-2017" target="_blank">PC Magazine 2017</a><br />
<br />
All the best,<br />
Sergey.<br />
<br />Sergey Vereshchaginhttp://www.blogger.com/profile/10783520078059582700noreply@blogger.com0tag:blogger.com,1999:blog-6832147928397006804.post-46068375535526458722015-11-11T19:59:00.001+08:002015-11-11T20:01:30.649+08:00Reporting - Excel simple format support.Hi Guys,<br />
<br />
As you aware, Export in Excel Simple format is deprecated.<br />
It is not available from version 5 onwards.<br />
<br />
What you are not aware, probably.<br />
For those who were using it in earlier versions, please take note.<br />
<br />
If you are going to open and edit your old version report with the new version Report Designer.<br />
It is going to kill your Excel Simple Export settings irreversibly.<br />
<br />
Therefore, please make sure using Old Report designer to correct/edit Older versions reports.<br />
<br />
Other words, there is no compatibility in the future versions of report designer with the older versions of the software. You can not edit and save reports of version 3.00 by report designer from version 5.00<br />
It will spoil the report.<br />
<br />
All the best,<br />
Sergey.Sergey Vereshchaginhttp://www.blogger.com/profile/10783520078059582700noreply@blogger.com0tag:blogger.com,1999:blog-6832147928397006804.post-49644957541198010692015-11-04T12:59:00.001+08:002015-11-04T16:15:54.707+08:00Login Page Customization.Hi Guys,<br />
<br />
Some time ago, there was a post on how to change the login pictures if you have access to Acumatica web site folder. But nowadays we all go cloud, heh, so no more access to IIS folders directly.<br />
<br />
Well, so THIS POST is about How To Change the Login Pictures for your customer, without directly changing the files in the folder.<br />
<br />
We can accomplish it by using simple customization technique. It proven on version 5.1 onwards, but should work on earlier as well.<br />
<br />
What we are going to do is - by using a customization we will replace the files, located at the web site folder :)<br />
<br />
Let's make it very simple, sorry, experienced C# developers, I will go step by step, so everyone can follow.<br />
<br />
1. Make sure you can connect to Acumatica as a Customizer.<br />
<br />
2. Place your picture files, resolution 1500 x 1000 pixels, in jpg format in a local folder on your working PC or laptop.<br />
There should be max 6 pictures.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgce8BwbZdISExiyDKU93IMHUDqR6cgx1f1GSPfxGzY_KboqRGRi_vhZTq4_0_7cyI1vGZEXZLejVkJRdt0FTIGco94al7zopgUsvKJE0Ofbnneg84HRMJ8fECot8FinQwWbDtqqTJHuunm/s1600/1.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="204" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgce8BwbZdISExiyDKU93IMHUDqR6cgx1f1GSPfxGzY_KboqRGRi_vhZTq4_0_7cyI1vGZEXZLejVkJRdt0FTIGco94al7zopgUsvKJE0Ofbnneg84HRMJ8fECot8FinQwWbDtqqTJHuunm/s640/1.PNG" width="640" /></a></div>
<br />
3. Login to Acumatica. Say goodbye to this guy. You are seeing him the last time...<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgn9puP8TGj-_LJh9yJs2FcHiddyHFm1s3p2yMKz2oD09u9CGpbi3YFJZqqg_fjB17gAfCRYEwHAhERfid7bNeAPHLZpR2RFWi-BV6-YGXlFSWm5c6T1w1SAweyv-bouGjCepyjKjH8pWTb/s1600/2.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="83" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgn9puP8TGj-_LJh9yJs2FcHiddyHFm1s3p2yMKz2oD09u9CGpbi3YFJZqqg_fjB17gAfCRYEwHAhERfid7bNeAPHLZpR2RFWi-BV6-YGXlFSWm5c6T1w1SAweyv-bouGjCepyjKjH8pWTb/s200/2.PNG" width="200" /></a></div>
<br />
<br />
<br />
4. Navigate to: Configuration->Common Settings->Site Preference<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6AbvjEsOJfpk8j7My_50D9SzolinQzdz5_9hXYQjY_z-wAFXaIiaqkifvom9n2O38sw_IuJg4NZj3fdpZeBsTsexQ5N4G2YGzg-O4E6DGuNcYwVG_ZuIXMoZwUywUQgl9WuX3ifLL2Zv6/s1600/4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="412" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj6AbvjEsOJfpk8j7My_50D9SzolinQzdz5_9hXYQjY_z-wAFXaIiaqkifvom9n2O38sw_IuJg4NZj3fdpZeBsTsexQ5N4G2YGzg-O4E6DGuNcYwVG_ZuIXMoZwUywUQgl9WuX3ifLL2Zv6/s640/4.png" width="640" /></a></div>
<br />
<br />
5. Upload here all your 6 files. Just Press Files->Then drag and drop all the files into upload screen.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2K97aDQlGNNFXSAVyg32VKVCWFMzpg6yTuqJ5RDbsqc-SX3QxdZt0-p75SEi7TlHJqbKSzjZA6WbpNknyOvkAIwJCEA8gvBpURw8y-EwCW28pWwBXo1R7xNnoZv3nMGpo7JPdnuYfhgVm/s1600/5.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="507" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2K97aDQlGNNFXSAVyg32VKVCWFMzpg6yTuqJ5RDbsqc-SX3QxdZt0-p75SEi7TlHJqbKSzjZA6WbpNknyOvkAIwJCEA8gvBpURw8y-EwCW28pWwBXo1R7xNnoZv3nMGpo7JPdnuYfhgVm/s640/5.PNG" width="640" /></a></div>
<br />
6. Close the Files upload screen. Refresh the Site Preference screen. Click on FILES menu again. Now let's see all those files one by one in the browser. We need it to get ReferenceID for each file.<br />
Just click on each file link, it will open you a tab in the browser.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIFNZzX_IoIRBirCTmLqiduQgnUqg99fyTqQleNzkd2eHu2VEam-xEtZw8jQCIaHFeFUYVYxcuCxYdIdIWygSuN8RxvjBn25cYgzRPCDOllPBwhFLqdIWhC9B-JmyWAEQvtLy-UeQZZh4h/s1600/6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="330" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIFNZzX_IoIRBirCTmLqiduQgnUqg99fyTqQleNzkd2eHu2VEam-xEtZw8jQCIaHFeFUYVYxcuCxYdIdIWygSuN8RxvjBn25cYgzRPCDOllPBwhFLqdIWhC9B-JmyWAEQvtLy-UeQZZh4h/s640/6.png" width="640" /></a></div>
<br />
Please note the number you need to record is highlighted. Please pull all 6 numbers for all 6 files into your notepad for future reference.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiH4EZtR_GBa9PL_eFzfBSXUU7_jYvkkqOyrOHffUj84j6tGYGqmMU3UJ_3sksZ3pLUo6cftPXx2uHbG5lP79vEldLXRIxRpRUrJeroFXSTO9dAymgrETTsxFiki71AAPIyIfTgvcpgndl-/s1600/8.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="205" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiH4EZtR_GBa9PL_eFzfBSXUU7_jYvkkqOyrOHffUj84j6tGYGqmMU3UJ_3sksZ3pLUo6cftPXx2uHbG5lP79vEldLXRIxRpRUrJeroFXSTO9dAymgrETTsxFiki71AAPIyIfTgvcpgndl-/s400/8.PNG" width="400" /></a></div>
<br />
7. Now we are ready to hack Acumatica and insert our files directly into WEB site folder :) by customization. Go to System->Customization->Customization Projects. If you have one, select it, if you do not have existing customization, just create a new project. Then click on it. It will open a screen. There choose File->Edit Project XML<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgbW_Z4SO0Bjmm5krEaa4fBpbw9mNHzB6sfO43tsBjiYoEo7pOYDqCzrvkIwpANAFKlbYQNP9SOtl0afAlBjQdYJPZvQt-4gUx2rorbY4z7lJQmI6hGeSi3eZFyDDKoKPk36JyACfy31hXr/s1600/9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="348" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgbW_Z4SO0Bjmm5krEaa4fBpbw9mNHzB6sfO43tsBjiYoEo7pOYDqCzrvkIwpANAFKlbYQNP9SOtl0afAlBjQdYJPZvQt-4gUx2rorbY4z7lJQmI6hGeSi3eZFyDDKoKPk36JyACfy31hXr/s640/9.png" width="640" /></a></div>
<br />
<br />
8. Now manually add the following records right after first line:<br />
<br />
<i><span style="font-size: x-small;"><File AppRelativePath="Icons\login_bg1.jpg" FileID="42acd25f-b952-46a2-aae8-35a802d1d47a" /></span></i><br />
<i><span style="font-size: x-small;"><File AppRelativePath="Icons\login_bg2.jpg" FileID="ac45d04a-7c4a-4cf1-bf42-3cdb517eecc6" /></span></i><br />
<i><span style="font-size: x-small;"><File AppRelativePath="Icons\login_bg3.jpg" FileID="28ee3171-e330-4de4-83bf-750e31eb2168" /></span></i><br />
<i><span style="font-size: x-small;"><File AppRelativePath="Icons\login_bg4.jpg" FileID="8d6876f9-5721-45e1-b481-9ca36e5eff49" /></span></i><br />
<i><span style="font-size: x-small;"><File AppRelativePath="Icons\login_bg5.jpg" FileID="809703c6-a689-4218-8347-a6d78f563ae0" /></span></i><br />
<i><span style="font-size: x-small;"><File AppRelativePath="Icons\login_bg6.jpg" FileID="b11ad862-1ef2-47d4-8c8b-f398383552b1" /></span></i><br />
<br />
Please note last part is the reference from out Notepad.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgra_0OSSUnm5pssgy-1G70Pb5soyFgJIteNHHW9Qd3c00NHygUVTZ2e4ohRhJehNsKrsk8retHujq98b0wM3F462_IdD1NHTb8x_J4v7HTuM8H0csItDTnX0qFP_EtDr6kihwI0vu24rZh/s1600/10.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgra_0OSSUnm5pssgy-1G70Pb5soyFgJIteNHHW9Qd3c00NHygUVTZ2e4ohRhJehNsKrsk8retHujq98b0wM3F462_IdD1NHTb8x_J4v7HTuM8H0csItDTnX0qFP_EtDr6kihwI0vu24rZh/s640/10.PNG" width="640" /></a></div>
<br />
<br />
9. Press button Save to database. Screen will refresh and your records will be moved somewhere down to the file body, you can find them by scrolling down, no worries, they are NOT gone.<br />
<br />
10. Now from the menu on top choose Publish->Publish Current Project. Validation will start and prompt you a message:<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjziG3wqd_zoeGgVmoYXuq6NhB546CMFoy69ZkTLAGNJkZ7P_IIUm_Bit-KHVl-s1CdLdzVCMv4KSfuYdSCV1Ma4ULLqy5p_ygP2Xh-6uiPyJ8NBpksWZLAjWcA8mu_LEJsGGtGq9XmmarC/s1600/11.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="230" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjziG3wqd_zoeGgVmoYXuq6NhB546CMFoy69ZkTLAGNJkZ7P_IIUm_Bit-KHVl-s1CdLdzVCMv4KSfuYdSCV1Ma4ULLqy5p_ygP2Xh-6uiPyJ8NBpksWZLAjWcA8mu_LEJsGGtGq9XmmarC/s640/11.png" width="640" /></a></div>
<br />
Ignore it :). Press Publish.<br />
<br />
11. Enjoy your brand new Acumatica system<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjG1arAoYnYr84WsJdHFtjdlq33v_XddKhLLaL_FkQqVa6wnLzReCdklDRwkd_1uoupnlUcMErRIDn9uprpQfPIV830iV1GBGHvTDdaNjMxLi7u1SNMHa7XsyBmEr-0yEe-UuwBSpfl9xrM/s1600/12.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="91" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjG1arAoYnYr84WsJdHFtjdlq33v_XddKhLLaL_FkQqVa6wnLzReCdklDRwkd_1uoupnlUcMErRIDn9uprpQfPIV830iV1GBGHvTDdaNjMxLi7u1SNMHa7XsyBmEr-0yEe-UuwBSpfl9xrM/s200/12.PNG" width="200" /></a></div>
<br />
All the best,<br />
<br />
Sergey.Sergey Vereshchaginhttp://www.blogger.com/profile/10783520078059582700noreply@blogger.com2tag:blogger.com,1999:blog-6832147928397006804.post-27421771647919051212015-08-07T16:18:00.001+08:002015-08-07T16:20:28.096+08:00Urgently Require Acumatica Consultant and Support Engineer in SingaporeHi Guys,<br />
<br />
Please let me know if anyone from Singapore is keen to work as a consultant and support engineer.<br />
<br />
Location: Singapore<br />
<br />
I am really shorthanded and looking for a bright candidate. Please drop me an e-mail if interested.<br />
<br />
Thanks,<br />
<br />
Sergey.<br />
<br />
P.S. Agents/Hiring Agencies please do not bother, I am looking for direct candidates.Sergey Vereshchaginhttp://www.blogger.com/profile/10783520078059582700noreply@blogger.com0tag:blogger.com,1999:blog-6832147928397006804.post-82099687293107027612015-07-21T14:01:00.000+08:002015-07-21T14:01:53.260+08:00Major change in Cash Sale Document Numbering in version 5.Hi Everyone,<br />
<br />
If you were using Cash Sale screen in AR module in versions below 5.XX, you may have noticed that running number for the Document was generated based on <i>AR Payment ID</i> sequence.<br />
<br />
Starting from version 5 the numbering sequence had changed to be <i>AR Invoice ID</i> Numbering for that type of document.<br />
<br />
However, if you still wish to retain the existing order for your document numbers, you need to apply а customization below.<br />
<br />
1. Create public class under your customization project for CashSales screen:<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMQa7TNpV9_zBd2kLiTZnvbOI2li5gG_k6ucPPqXSzmT9xQt3LYR_3GRnfyR26Qx2-4luIEHoo04azm6UbSHB7MqbI4cyqKFtvv21aLuM2UfH9jQSt3pVaFw44tf04aqIsbNrwepoipH5T/s1600/1.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjMQa7TNpV9_zBd2kLiTZnvbOI2li5gG_k6ucPPqXSzmT9xQt3LYR_3GRnfyR26Qx2-4luIEHoo04azm6UbSHB7MqbI4cyqKFtvv21aLuM2UfH9jQSt3pVaFw44tf04aqIsbNrwepoipH5T/s640/1.PNG" width="564" /></a></div>
<br />
<br />
2. Change the field attribute to use the above class:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhrWarEsO85OSiYUDVOvhuwYR84Os6TA0Ay1BUc8oHcMxDt-tKL_3XN6Qjd50Nzf04UBh9SSpEYpL6Di2nOC2w86nd87jJ4OKOVV_Sg3nyQf9s2QJ71fVhVixROmySONTo_nuHDvs8ZCf4m/s1600/2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="280" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhrWarEsO85OSiYUDVOvhuwYR84Os6TA0Ay1BUc8oHcMxDt-tKL_3XN6Qjd50Nzf04UBh9SSpEYpL6Di2nOC2w86nd87jJ4OKOVV_Sg3nyQf9s2QJ71fVhVixROmySONTo_nuHDvs8ZCf4m/s640/2.png" width="640" /></a></div>
<br />
3. Save and Publish the customization.<br />
<br />
From now on, Cash Sale Numbering will be taken from ARPayment sequence, as it was before.<br />
<br />
<br />
Please note the same approach can be used for any AutoNumbering customizations in Acumatica.<br />
<br />
All the best,<br />
<br />
Sergey.Sergey Vereshchaginhttp://www.blogger.com/profile/10783520078059582700noreply@blogger.com0