Error message 20151 doesn’t exist

Error message 20151 doesn’t exist

Microsoft Dynamics GP error message 20151 doesn’t exist occurs when posting an inventory batch.

error message 20151 doesnt exist

error message 20151 doesn’t exist

 Resolution:

0) Take backup

1) Identify the items in the batch.

  1. Print the batch edit report
  2.  Check the IV10001 table

2) Remove the entries from Inventory work table of the company database

  1. IV100001
    DELETE IV10001 where IVDOCNBR in (SELECT IVDOCNBR from IV10000 where BACHNUMB = ‘batch id’)
  2. IV00000
    DELETE IV10000 where BACHNUMB = ‘batch id’
  3. SY00500
    DELETE SY00500 where BACHNUMB = ‘batch id’ and DEX_ROW_ID=??????

3)  Conduct  inventory reconcile for the items noted at point 1 above.

 

 

 

 

 

 

 

 

Azox Microsoft Dynamics GP windows and menus not loading.

Azox Microsoft Dynamics GP windows and menus not loading.

Users started informing the Credit Card process menu’s and windows got disappeared.  Not being aware of any configuration change to Microsoft Dynamics GP client installs, the investigation started by checking the URL for e Payment web service.

The URL configuration for Azox e-Commerce website is configured at :

Azox e-Commerce e Payment Webservice setup

Azox e-Commerce e Payment Webservice setup

Azox e-Commerce e Payment Webservice setup url

Azox e-Commerce e Payment Web service setup

To test the URL configuration, added ccservice.asmx to the web service location configured above and opened the link in a browser.  This should bring the CC-service functions as follows:

CCService

In this instance the service link would not open. Further investigation  it was found that the DNS entries for the e-payment site was changed.  The DNS change was updated at the web services configuration window.  Logged out of Microsoft Dynamics GP and logged in back, the Credit Card Menu’s were back again.  This process had to be done for every GP user using the  CCE plugin.

Cheers!

 

 

 

 

Azox / Dynamics GP shipping combinations.

Azox  / Dynamics GP shipping combinations.

Spent lot of time in figuring out how the freight for e commerce shipments are getting computed or not getting computed.  For setting up shipping in Azox shipping methods needs to be configured at Azox as well as at Microsoft Dynamics GP.  The combination can be an  very large matrix.  For this post the a combination of single carrier with one shipping method  and one shipping service was tested and the results were …

GP Azox Azox Azox Freight
Shipping Shipping Rate Amount Results
Carrier Code Uplift Uplift
UPS None 20 0 TBD
UPS None 0 10 Azox uplift Amount
UPS None 20 10 Azox uplift Amount
UPS 03 20 0 UPS + 20 %
UPS 03 20 10 UPS + 20% + Azox   uplift
UPS 03 0 10 UPS + Azox Uplift
None 20 0 TBD
None 0 10 Azox uplift Amount
None 20 10 Azox uplift Amount
03 20 0 Cannot compute   freight
03 20 10 Azox uplift Amount
03 0 10 Azox uplift Amount

This post together with my previous post on how to setup of fixed shipping rates can be set up at Azox should explain how to configure shipping at Azox ecommerce suite.

Cheers!

Sales pad pre save script – at least one field of line items should be filled.

Sales pad pre save script – at least one field of line items should be filled.

Sales pad allows to add unlimited user defined fields to  supplement Microsoft Dynamics GP.  Apart from adding user defined fields, sales pad allow limited validated of these field while data entry through pre save scripts.  The pre save scripts are c# scripts and the data base object are provided by sales pad SDK.

Below is the sample script to validate at least one of the line item is updates.

if (sd.val_Sales_Doc_Type.Equals(“SD”, StringComparison.CurrentCultureIgnoreCase))
{
string y;
y = “”;
foreach (SalesPad.Bus.SalesLineItem sli in sd.LineItems)
{
if (String.IsNullOrEmpty( sli[“xUDF”].ToString()       ))
{
}
else
{
y =  sli[“xUDF”].ToString();
}
}
if (String.IsNullOrEmpty(y.ToString() ))
{
e.Cancel = true;
Messenger.Show(“The xUDF field needs to be filled in.”);
}
else
{
Messenger.Show(“UDF test passed.”);
}
}

Where   SD would be Microsoft Dynamics GP Sales Document Type and xUDF would be the Sales pad user defined field.

Cheer!

 

 

 

Setting up fixed rate shipping at Azox e-Commerce web site.

Setting up fixed rate shipping at Azox e-Commerce web site.

Azox ecommerce solution allows setting up of variety of way how the freight can be computed for any web orders being check out from the ecommerce site. Setting up fixed rate shipping at Azox e-Commerce web site should be preceded by setting up of shipping method at Microsoft Dynamics GP.  This article shows how Setting up fixed rate shipping at Azox e-Commerce web site is accomplished.

Step 1 – Log on to the Azox e-commerce web portal as administrator.

azox ecommerce admin console

Azox  e-Commerce admin console

Step 2 – Navigating to shipping information by following e-Source Setting, Setting, Order fulfillment, check out and shipping information.

Step 3 – At the shipping information window select site which needs be configured for fixed rate shipping.

Step 4 – At the Allow Order Shipping Method Change window, which can reached by clicking the details button ensure the shipping method which is be assigned a fixed rate is assigned “None” code.

Step 5 – Similarly, at the Shipping Rate Setup window, handling charge tab,  update the shipping method with the fixed rate for “Amount” type setting.  Also update the shipping method with “0” for the “Rate” type setting.

These setting should setup a fixed rate charge for the shipping method.

Cheers!

 

 

 

 

 

 

 

 

Shipping method not calculating at Azox check out page.

Shipping method not calculating at Azox check out page.

When implementing the Axoz ecommerce solution for Microsoft dynamics GP, one the issue which arise is Shipping method not calculating at Azox check out page. This is mostly because the Shipping method data collection is generally not used per se at Dynamics GP hence the shipping method screen is not always filled up.

When the user complete the adding items to shopping card and is ready to check out.  The view card button is clicked to reach the process order page.  The shipping is not calculated, instead a shipping icon is presented at the order summary.

azox order summary

Azox order summary

Root cause and resolution:

Azox e-Commerce is unable to identify the carrier for shipping.  The carrier for the shipping method is defined at Microsoft Dynamics GP Shipping methods window.

The shipping method window at Microsoft Dynamics GP can be reached at

shipping_methods_gp

Navigating to  shipping method window at Dynamics GP.

Ensure the carrier field is filled in the shipping method window.  For example if the carrier is United Parcel service, the carrier code would UPS.

UPS SHIPPING METHOD

Setting up shipping method in Dynamics GP for Azox

Note: In order to complete the process, shipping method should also be configured at Azox which is out of scope for this post.

Cheers!

Sanjay

 

Force change of default email and password at Azox

Force change of default email and password at Azox

This how to article show how to force change of default email and password at Azox e-Commerce  web site.  When an e-Commerce user logs into Azox e-Commerce web site linked to Microsoft Dynamics GP with a default user name and password, the user needs to be re-directed to the change password email and password.  Below is the procedure on how to configure the Azox e-Commerce web site to enforce change user name and password.

1) Login to azox e-Commerce web site as an administrator.

2) Click on eSource Settings:

eSource Setting

Azox administration console eSource setting menu

3) Click on Settings, Administration, User Administration, Automatic Logins – b2b/b2c

azox automatic login setup

Azox automat login setup

4) Navigate to the Compare Values tab:

New Login Defaults

New Login defaults

5) The setting  to force a user to change  email address and password if they are matching the default values are defined here.

6) Check mark the compare this email value at login check box to force user to change  email address if the email address matches the default email address defined at this page.

7) Check mark the compare the password value at login  check box to force the user to change password if the password matches the default password defined at this page.

8) Also check mark hide menu until email address and password is updated check box.

9) Type the message the user would be served  when forced to change email address and password.

10) Click on save.  Notice there are two save buttons on this page.  Click on the save button, not the save changes button.

These setting should force the user update their email address and  password if either of them are matching the defaults configured on the next login attempt.

 

US Canada Zip code regular expression for validation

US Canada Zip code regular expression for validation for use at cForms II plugin for word press

Regex US or Canada zip code validation test
  1. (required)
 

cforms contact form by delicious:days

(^\d{5}(-\d{4})?$) US
| or
((^[ABCEGHJKLMNPRSTVXY]{1}[0-9]{1}[A-Z]{1}\s[0-9]{1}[A-Z]{1}[0-9]{1}$)|(^[ABCEGHJKLMNPRSTVXY]{1}[0-9]{1}[A-Z]{1}[0-9]{1}[A-Z]{1}[0-9]{1}$)) Canadian

Regular expression for validation of Canada zip code

Regular expression for validation of Canada zip code

Test the regular expression for validation of Canada zip code at work at the below form.  Upon submission you should get a validation passed or failed message based on validity of zip code entered.  The regular expression considers both scenarios, a space exists between zip codes parts or omission of the space between zip code parts.

Canada zip code validation test
  1. (required)
  2. Captcha
 

cforms contact form by delicious:days

Regular Expression:

(^[ABCEGHJKLMNPRSTVXY]{1}[0-9]{1}[A-Z]{1}\s[0-9]{1}[A-Z]{1}[0-9]{1}$)|(^[ABCEGHJKLMNPRSTVXY]{1}[0-9]{1}[A-Z]{1}[0-9]{1}[A-Z]{1}[0-9]{1}$)

Explanation on how the regular expression is formed.:

( Group start
^ Start
[ABCEGHJKLMNPRSTVXY]{1} First a character in upper case matching the list
[0-9]{1} Next a digit
[A-Z]{1} Next  any one character in upper case
\s Next a space
[0-9]{1} Next a digit
[A-Z]{1} Next any one character in upper case
[0-9]{1} Next a digit
) Group end
| or
( Group Start
^[ABCEGHJKLMNPRSTVXY]{1}[0-9]{1}[A-Z]{1}[0-9]{1}[A-Z]{1}[0-9]{1}$ Same as above except no space between the two zip parts.
) Group end

Variations in forming regular expressions for validating Canadian zip code:

\d{1} [0-9]{1}
* The (*) star can be used to construct the first part zip to be with or without a space at end.

Instead of [0-9], the code can be shortened buy using \d to represent all digits.  The Regular expression stated above duplicate the code, one with a space and other without a space.  The * command can be used to repeat the search.

Usage of regular expression to validate Canadian Zip code at CFORMS II:

regular expression canada zip code cform II

regular expression canada zip code

 

At cforms add a single line form field. Enter the regular expression codes at the field validation section for validating the data enter by the user matches with the Canadian Zip code format.

Cheers!