IMPORTANT - PO # Not Visible when database is upgraded from lower version

1. nopCommerce 1.9 and 1.8
2. Any private modifications you made to your nopCommerce - NO
3. The version of MS SQL database you're running nopCommerce with - 2008
4. Upgraded database from 1.4 to 1.9

Description:

There is a strange Bug in payment method "Purchase Order" which have been encountered by few members here but never highlighted here or given attention.

In 1.8 or 1.9version if anyone installs a fresh database- if an order ir placed by PO number - PO# is mentioned in the Order Details from admin's side (which means it works fine).

BUT - If database is being upgraded from lower version like 1.4 -to- 1.9 - If anyone places an order on the website and admin tries to see the order details in admin section - PO# is missing.

I have tested this bug in many way and finally came to the conclusion that yes indeed PO# in missing in order details when database is upgraded from 1.4v - 1.9v.

Here are few screenshot that i took after testing this bug many times:

screenshot 1: http://img607.imageshack.us/img607/5592/po1s.jpg

screenshot 2: http://img203.imageshack.us/img203/1598/po2zo.jpg

OK I somehow found the fix

When database is upgraded from lower version to higher version (like 1.4 to 1.9) - It doesn't add/upgade the SYSTEMKEYWORD for PurchaseOrder.

So who so ever is facing this bug- Here's the fix

Go to admin section >  Configuration > Payment > Payment Methods

Choose Purchase Order (EDIT)

In System keyword:: PURCHASEORDER (<- Add This, if it is empty)

Now SAVE and you're good to go.

Now PO# will be visible in order details.