Service
Pack 1 for Baan E-Sales 2.2 (required for E-Sales 2.2 iPack)
General
This Service Pack is for Baan customers that are using Baan E-Sales 2.2.
Service Pack 1 for E-Sales 2.2 contains bug fixes reported for E-Sales
2.2 GA and for newly found problems. Additionally it includes integration with
BaanERP 5.0c SP6 and the ‘Needs Analyzer’.
BaanERP 5.0c SP6 - OpenWorld BOI integration:
This includes:
-new serverside BOI components for E-Sales 2.2 - BaanERP 5.0c SP6
(installed by the E-Sales 2.2 iPack for Baan ERP5.0c)
-new COM components for every new serverside BOI component (installed by
the E-Sales 2.2 iPack for Baan ERP5.0c)
-changes in existing E-Sales components
-changes in tax calculation logic in E-Sales 2.2 (only for BaanERP 5.0c
SP6) in order to seamlessly link with BaanERP 5.0c SP 6 backend tax
calculation.
Needs Analyzer:
The ‘Needs Analyzer’ functionality involves an extra way of using E-Configurator.
Now the user does not have to select the parts, but just has to give
answers on a list of questions.
Eventually this will lead to a list of standards items that can be added
to the basket in E-Sales.
The service pack includes the
following languages:
English
To install the service pack
The procedure below assumes that you have installed
the E-Sales components on separate machines.
A typical configuration can be as follows:
n An E-Sales
Database Server machine.
n One or more
E-Sales Web Server machines.
n You can
have multiple Web servers forming a Web farm to load-balance page requests.
The service pack must be installed on all machines
where E-Sales components are installed.
Briefly, the procedure is as follows:
1 Install the
service pack on each Web Server.
2 Reconfigure
the service pack on each Web Server.
To install the service pack on the Web Server
Install
the service pack on each of the E-Sales Web Server machines as follows:
1 On the Web
Server machine, , unzip the file E-Sales22SP1.zip in a temporary folder and run
the file setup.exe.
2 On the
first screen, click the Install button.
3 The Log
on to SQL Server dialog box appears. Enter the name of the database server
machine and the password for the SQL Server sa user.
4 When the
program asks Do you want to start the installation of the service
pack now, answer Yes. The installation process will begin.
5 A message
box appears when the installation is complete.
Click the OK button to close the message box.
6 Configure
the service pack on each of the E-Sales Web Server machines. The Reconfigure
option allows you to change installation parameters after the service pack has
been installed.
7 On the Web
Server machine, run Setup.exe from the Service Pack 5 Installation
folder (C:\TEMP).
8 On the
first screen, click the Reconfigure button.
9 The Log
on to SQL Server dialog box appears. Enter the name of the database server
machine and the password for the SQL Server sa user.
10 The User
Account for the E-Enterprise MTS package dialog box appears.
This user account will be used to
run both the E-Enterprise MTS package and the E-Enterprise NT services.
You must use an NT account with administrative
privileges on the Web Server machine. The user must have Password never
expires selected in the Windows NT User Manager.
11 On the next
screen, enter the password for the SiteServer Membership Administrator user.
12 On the next
screen, enter the name for your Web site (optional).
13 When the program
asks Do you want to start the reconfiguration process now, answer
Yes. The configuration process will begin.
14 A message
box will appear when the reconfiguration is finished.
Click the OK button to close the message box.
The installation of the Web Server is now complete.
Solutions for known problems in E-Sales 2.2 and Service Pack 1 for
E-Sales 2.2
The following known problems are solved in Service Pack 1 for E-Sales
2.2.
|
Problem |
Solution description in E-Sales 2.2 |
Solution Service Pack1 Modified components\pages |
|
Integration between E-Sales 2.2 and BaanERP 5.0c SP 6 |
An integration has been build with BaanERP 5.0c via OpenWorld Adapter.
Also the error handling is improved for Pricing and Tax BOI backend calls. The
user now gets a warning when something goes wrong and in the event log the
backend error and the argument values are logged. |
|
|
The order discount percentage should not be shown when there isn't any
discount. |
The customer discount has been removed from the web order when the
value is zero |
|
|
When integrated with BaanIVc and an item is stored in multiple units,
the Basket page (order_list.asp) displays the wrong unit price. |
The correct unit price is being displayed in the current basket |
|
|
When an order was exported in XML two orderlines where created for the
freight cost. |
Only one freight cost line will be created for each order |
|
|
The product description and unit code are not displayed in the basket
part of the quick order entry page. |
Product description and unit code are added |
|
|
When the Multiple Ship-From zones parameter is set on 'yes' then the
Ship-from zone parameter should be disabled |
When the Multiple Ship-From zones parameter is set on 'yes' then the
Ship-from zone parameter should be disabled. It is not possible to enter a Ship-from zone when the Multiple
Ship-from zones parameter has value ‘yes’, but when you click on the
ship-from zone link, you will see the first possible ship-from zone
'grayed-out'. |
|
|
The Ship-from zone field must be sorted. |
The Ship-from zone field is sorted |
|
|
When a stored basket is opened (that was saved before the current
date) and a product hyperlink is clicked to view the product details, the
"Requested Date" on the product details page displays the original
date. |
The requested date displays the current date |
|
|
Tiltle of page should be "Checkout Basket" |
Title has been changed |
|
|
Sales Orders lines are not written to the table When reading in a single file message, generated by E-Sales, the
conversion setup that is used ( WWW-OR) gives problems. When there is an
orderline that has a mistake in it (for example the costprice of the item is
not calculated) EDI will report this in Errors in received messages (this is
correct). But all other orders (in the same batch) that follow will go wrong.
Even if these orders are correct then still the lines aren't written to the
table tdsls041 (only the header is written to the table tdsls040). This only
happens when the order before these correct orders is wrong (and they are all
in the same batch). |
EDI envelop functionality has been added |
|
|
When the table 'FREIGHTPRICE' is empty (this is the case when there
are no 'FreightCost' records defined), clicking on the 'proceed to checkout'
button (from the 'current basket') results in an unclear error. |
Error handling has been improved |
|
|
UpdateOrderStatusBOI action is logged in event log, while no credit
card order is present in database |
The BOI should not be called when no orders are present |
|
|
Tax Amount and Freight cost are cleared after start of product remarks
in Check Out Basket Page. When Order Now or Get Quote first is done these fields are empty also
in the page which is send to the user by email. |
Fields do not lose their value anymore |
|
|
When a credit card order has two order lines and one order line has
been (allocated and) billed, the order header is set to 'billed' while the
second order line has not been billed yet. |
An order header is ‘billed’ when all lines are ‘billed’ |
|
|
When the Sales Parameter "Home Organisation" is changed this
error pops up: "Commerce.MessageManager.2 error '80004005' Message "" in language "1033" does not exist in
this MessageManager instance. \esales22sp1_local\include\General.asp, line 1636". |
Error message does not occur anymore |
|
|
When Ecommon Parameter "SELFREGBP" is empty a Cint error
pops up when checking out the basket. |
Error message does not occur anymore |
|
|
When a BIS Instance does not exist anymore in E-Dashboard but still is
referenced in E-Sales Manager Order Export File a ODBC error occurs when
starting the page Order Export Files |
Error message does not occur anymore |
|
|
When the ISO country was not filled for a country in E-common a credit
card transaction could not be done. It resulted in Cybersource error
Country_billed not found. |
Now a warning is given: Iso Code not filled for Country … |
|
|
When E-Sales parameter freight is set to ‘no’ still a check on carrier
is done although a carrier cannot be selected. When order now is executed, an
error pops up: Submit order, Cannot submit an order without carrier, shipping
address, or billing address information. |
The parameter freight is used in the carrier check |
|
|
Adding a product not being linked to a freight group in the current
basket gives an error message. |
The system returns freight = 0 in this case. |
|
|
When the user goes back from CheckOut basket screen to current Basket
the freight tax is included in the total basket amount |
Freight tax is not included when returning |
|
|
When for a business partner a BIS customer of 7 characters is being
used (which does not exist in Baan) and the first 6 characters do form a
valid BIS customer this valid one is used to calculate the BIS price. This only happens for BaanIVc. |
Correct check on BIS customer is done |
|
|
When E-Sales Parameter Tax is set from Baan Tax to No Tax for old
submitted confirmed orders the normal tax is not displayed anymore. |
Normal tax is shown for old orders even when tax parameter is set to
‘No’ |
|
|
When the SSLMODE is set to "MIXED" and a web order is copied
from the submitted orders list the copy page becomes unsecure and after the
copy also the submitted order list page becomes unsecure. |
Pages remain secure |
|
|
Unclear error if the web order processing service cannot write to the
order export file |
Correct error message created |
|
|
When the failed orders are open, click on an order and scroll through
the orders. At that time an ODBC error occurs. |
Error message does not occur anymore |
|
|
When FreightTax is calculated in the EPipeline.dll and the sales
parameter HomeOrganization is not filled no logging was done. |
Logging is being done. Also end user errors made more clear. |
|
|
When in the table MerchantIDByCurrency (E-Sales) there is a currency that is not available in the Currencies table (E- Common) and the user clicks on the link ' Merchant ID's by Currency ' in the E-Sales manager pages, a SQL-error occurs: ' Either BOF or EOF....' |
Error message does not occur anymore |
|
|
Multibyte fix: formatdatetime(now) replaced by Date() |
|
|
|
After Copy Order action from Submitted Order List, select Your
Favorites the system crashes, orderform is corrupt. The browser needs to be
closed to continue in a normal way. |
The crash does not occur anymore |
|
|
The cancel button did not work for IE 5.5 |
The history.back statement did not function correctly for IE 5.5. |
|
|
When, after copying an existing order, a billing or shipping address
is selected the following error pops up: Type mismatch Error Number:D Error Help File:0 Error Source:Microsoft VBScript runtime error Error Help Context:\esales22sp1\E-Sales\CurrentOrder\CC_Address_Info.asp |
Type conversion added |
|
|
Check out the basket, select another carrier then the default carrier. Change the billing address. Now the carrier is reset to the default value. |
Now only the default carrier is set if no carrier was yet selected
else the default carrier is always set back to the default e.g. after an address change |
|
|
It is possible to store an empty basket. |
It is no longer possible to store an empty basket a warning 'Current
Basket cannot be stored and There are no products in your basket' is given. |
|
|
When clicking in the current basket on store as the basket is stored
twice. |
Technically it is not possible to change this without changing the
table definition. But the following topics are solved: Copy to field is now default filled with the copied from field. Stored as functionality has been improved. The old order name was used
as stored order name and the stored as name was used as current order name. Copy from stored baskets did still use the current order. When new is pressed the existing current basket will not be stored
anymore. |
|
|
Problem with acknowledgment file: Steps to reproduce: -create credit card order -have order exported to edi file -run EDI session to import into backend -print acknowledgement -run EDI session to export acknowledgement -ftp acknowledment file to webserver (appl_from) -wait until WOP service 'confirms' the order -wait until order has been billed -again ftp the 'old' acknowledment file to webserver Now the WOP service will again read the 'old' acknowledgement and put
the status on 'confirmed' |
The Orderstatus is now only set to confirmed if the orderstatus was
lower then confirmed else the status can be set back from e.g. billed to
confirmed if e.g. the order acknowledgement file is read twice |
|
|
When a box with 10 items of an item is ordered which has default unit
pcs, a wrong price is calculated. In the backend the price per piece is
shown, via EDI the price per box is given. |
Solved by changing the EDI settings. Now tdsls401.cups (Sales Price Unit) is now also filled with the
e-sales unit. In the past it was not filled from EDI and therefor automatically
filled by the default product unit. |
|
|
Quantity 0 is allowed on the basket page |
This is not allowed anymore |
|
|
When an item is ordered with a CC payment transaction and the
commitment policy from the item in Baan is set to "BATCH" or
"MANUAL" and the inventory for the item is 0 there should be no
billing transaction. In ESales the billing takes place. However the status in submitted orders remains "confirmed"
in stead of "Billed". The fact that there is really a billing transaction is only visible in
the administration screen from ESales. |
The orderliness with this item are only allocated and billed after
manual or batch-wise inventory commitment. After all line are billed the
order header status should be billed. |
|
|
Although they are present in the EDI file telephone and Fax numbers
are not inserted in the generated Baan Address in the backend. |
Mapping for field tccom130.telp (level 3-15) and for field
tccom130.tefx (level 3-16) added. |
|
|
When the Configurator 98 is used the EDI setup does not read the
product variant structure. The EDI lines starting with VAR and VOP are not set\read in the EDI
setup |
Product variants are to be picked up by Baan EDI. Extra column (11) in EDI File added on variant line with the variant
item with 9 leading spaces. This column is necessary for Baan V. Because Baan
V uses item segmentation. |
|
|
Some buttons do not contain tooltips, others have capitals in the
tooltip. E.g. cancel button in copy order page does not have a tooltip. Remove button in stored basket does not have a tooltip. Change Address button on address page has a tootip with upper cases. |
Several tooltips added or changed |
|
|
When ordering a product for which multiple unit types were defined
(pcs and box), then for the pcs type the prices and discounts returned from
the backend were OK, but for box the prices and discounts were wrong. (with
BaanVc or BaanIVc as backend) |
For every unit type that is available for a certain product in E-Sales
(E-Enterprise) the prices and discount retrieved from the backend should be
the right ones. |
Solved in the boi dll
‘ccslspricetax’. |
|
Performing an ATP from the Product_view_sales.asp page on configurable
items leads to strange info. |
ATP not possible for configurable items. Should return ‘unknown. |
Product_view_sales.asp |
|
Basket details not refreshed after removing a basket line when
Netscape 4.72 was used a |
After removing a basket line, the link ‘current basket’ should not
display the removed basket line, when using Netscape 4.72 |
Using Netscape 4.72: -go to menu Edit -go to menu item Preferences -go to Advanced -go to Cache Then: -change Memory Cache and Disk
Cache on 0 Kbytes -click on the buttons Delete
Memory Cache and Delete Disk Cache -click the radio button Every
Time Now it should work. |
|
When connected to a BaanVc system, after the billing of a sales order,
the status of the order did not change to ‘billed’, while in the e-sales
administrator screens you can see that the billing for that order had been
done. |
When the whole sales order is billed, the status of that order in
‘submitted order list’ should show ‘billed’. |
Changes in EEOrderProcess.dll . |
|
Copying a basket with a configurable item (not configured) went wrong. Error: Cannot get the configured product's pricing information:
ConfigData.GetPrice failed. If the item was configured, error: ‘Invalid use of null’. |
Copying a basket with a CONFIGURED configurable item should be
possible. If the item is not yet fully configured, then the user should get a
message that (s)he must first complete the configuration. |
Several components and pages. |
|
Error ‘Type mismatch error’: After clicking on the button ‘remove’ in the current basket without
checking a basket line and then clicking on the button ‘cancel’ an error
occurred. |
This should not lead to a ‘type mismatch error’. |
Item_delete.asp |
|
Some tooltips have been added/changed. |
Tooltips should be correct. |
E.g.: -‘configure now!’ -‘cancel’ button on
‘order_copy.asp’ -‘remove’ button on
‘savedorder_list.asp’ -‘change address’ button on
‘cc_address_info.asp’ -and
more…. |