Solution 117345

SITUATION IDENTIFIED IN:
E-Procurement 2.1 SP1

NOTE !
First install Service Pack 1 (Solution 115897) and the Patch (Solution 117122)


SITUATION DESCRIPTION:

1. 	Budget for posting incorrect:	
	Budgets having 'Charge Type' field value as blank are applicable for posting from 
	requisitions having any value of 'Charge Type'. But the budgets having the 'Budget Type' field blank are not posted.
	
	Modified Components:
	ebudget.dll
	ebudget.dll



2. 	Budget for posting incorrect:
	Budgets having 'Administrative Office' field value as blank are applicable for posting from  
	requisitions having any value of 'Administrative Office'. But the budgets having the 'Administrative Office' 
	field blank are not posted.
	
	Modified Components:
	ebudget.dll
	ebudget.dll


3. 	'View Budget Consumption' does not display Budget Consumption for Aggregated Budgets.
	Modified Components:
	None
	
	Modified ASP Pages:
	Budget/enduser/budgetoverview_list.asp
	



4.	For a Requisition, sent for Buyer Assistance, when the buyer fills the price (cost by unit) 
	and then selects a supplier the price is set back to zero
	
	Modified ASP Page:
	e-requisition\enduser\requisitionline_detail.asp
	



5. 	The approval entries are not shown in the order of execution on the 'Submitted Requisition' 	page. 
	The entries are displayed in alphabetical order. 
	
	Modified ASP Page:
	e-requisition\enduser\requisitionline_detail.asp



6. 	The price of the item is incorrectly calculated in the 'Detailed Product View'
	Also the currency symbol is displayed incorrectly.
	
	Modified ASP Pages:
	ecatalog\enduser\product_view_procurement.asp
	


7. 	Appropriated checkbox changes after review:
	The normal procedure for rejecting or reviewing a requisition in the approval process 
	should be that in the 'ToApprove' screen, you set checkbox on 'Reject' or 'Review' and 
	then you specify a reason [review], after update approval review, the checkbox is set 
	to 'Approve' instead of staying 'Reject' or 'Review'.
	
	Modified ASP Pages:
	Erequisition\enduser\Requisitionline_list.asp
	Storefont\procur\ProcurementNaviation.asp
	

8.	Possible to order an expired date product via "Quick Ordering"
	User able to  order a  product eventhough  expiry date is over. 
	It is still possible to order this  product when going to Your Basket and using 	
	Quick Ordering
	
	Modified ASP Pages:
	erequisition\enduser\requisition_detail.asp


9. 	With the installation of SP1 also an additional field has been added to the Product_List.asp 
	and the Product_edit_main.asp. The extra colum/field is the companynumber, but this field is 
	currently displayed with error SLBCA0207. 
	Database modification script: 115975.sql ( to be applied on the ECatalog database)

=================================


SOLUTION DESCRIPTION: 
All the above described situations have been solved.

The Solution contains 12 files. 

1.	EBudget.dll:This file has to be registered in MTS

2. 	ERequisition.dll: This file has to be registered in MTS 

3. 	Einvoice.dll: This file has to be registered in the MTS

4. 	Mailapp.dll

5. 	budgetoverview_list.asp - Copy this asp file to EProc21\EE11\e-requisition\enduser\ 
	Replace the old one

6. 	requisitionline_detail.asp - Copy this asp file to EProc21\EE11\e-requisition\enduser\ 
	Replace the old one

7. 	requisition_detail.asp - Copy this asp file to EProc21\EE11\e-requisition\enduser\ 
	Replace the old one

8. 	product_view_procurement.asp - Copy this asp file to EProc21\EE11\ecatalog\enduser\ 
	Replace the old one

9. 	Requisitionline_list.asp - Copy this asp file to EProc21\EE11\ERequisition\enduser\ 
	Replace the old one

10.	ProcurementNaviation.asp - Copy this asp file to EProc21\EE11\Storefont\procur\ 
	Replace the old one

11.	115975.sql : see instructions below

12.	Readme.txt

	
	
* Instructions to apply the 115975.sql: 
This file has to be copied to the local disk where the database server is installed

Run the query:
A) Login to the database server where ECatalog database is present
B) Copy the attached file(115975.sql) to the desktop.
C) Open Query Analyser (Start--->Programs--->Microsoft SQL Server 7.0 -->Query Analyser)
D) Connect  to the database server
E) Choose the E-catalog database
F) Once connected, choose file option in the menu ---> Click open ----> Select the file(115975.sql) which was copied to the desktop in step B.
G) Now press "F5" to execute the code.



* Instructions to apply the DLL's:
Important: The above 4 dlls should be applied in the following order: EBudget.dll, ERequisition.dll, Einvoice.dll and Mailapp.dll ( mailapp.dll should not be put into the MTS)

To register the above mentioned dlls in the WinNT machine where E-Procurement 2.1 is installed you have to walk through the following tasks:

A. On the webserver, you have to stop the website and Microsoft Transaction Server processes.
To do this :
Open a  command window (start-> run -> type: cmd -> ok)
Within the command-window run the following commands:
net stop iisadmin /y
mtxstop   (run mtxstop 3 times, because that process is running more then one time on  the webserver)

B. Stop all the "Baan E-Enterprise" related services if running. For this open the services applet (Start-->settings-->control Panel --> Services).
  Following are the EProcurement Specific Services:
  1. Baan E-Enterprise CheckMail Service
  2. Baan E-Procurement Automatic Invoice Matching
  3. Baan E-Procurement Close Received Requisitions
  4. Baan E-Procurement Consolidate Send Requisitions
  5. Baan E-Procurement Export Invoices Service
  6. Baan E-Procurement Purge Invoices Servive


C. Remove all the components from the E-Enterprise package within Microsoft Transaction Server. Don't close the window after removing the components.

D. Now you have to unregister and rename all the attached dlls

Example with ERequisition.dll:
Open a command window (see step A).
Within this command window go to the folder - Program files\baan\E-Enterprise2.0\Components\ EProcurement
Type : regsvr32 /u ERequistion.dll
Now the ERequisition.dll will be unregistered. Now rename the ERequisition.dll to ERequisition.bak

E. Reboot de webserver

F. Copy the attached dlls (example: Erequisition.dll) to the own folder (example: Program files\baan\E-Enterprise2.0\components\ EProcurement) 

G. Register the attached dlls

Example with ERequisition.dll:
Open a command window (see step A).
Within this command window go to the folder - Program files\baan\E-Enterprise           
2.0\components\ EProcurement
Type : regsvr32 ERequisition.dll

H. Drag and drop first the Common MTS components (in this order: EEnterprise.dll, EECommon.dll, ECatalog.dll) into the E-Enterprise package within Microsoft Transaction Server.

I. Drag and drop the other MTS components (EInvoice.dll, ERequisition.dll, ESupplier.dll, EBudget.dll, EApproval.dll, ECollaboration) into the E-Enterprise package within Microsoft Transaction Server.

J. Reboot the webserver