VERSION(S):

E-Procurement 2.1

SITUATION IDENTIFIED IN:

E-Procurement 2.1 

SITUATION DESCRIPTION: 

E-Procurement 2.1

Budget Postings not correct. If a requisition meets with a document rule which says "Consolidate", post CONSOLIDATION, the budget postings are not correct. The budget posting under the Approval head does not get reversed after the "Consolidate and Send".

When copying an existing requisition line, the resulting new requisition line field (at table level) "Received" contains the same "Received" (quantity), as in the original requisition.

Too many lines while searching.

Complete basket information. The Costcenter information is not available in generated XML file of the Requisition

Requisition already matched - false signal
When doing matching the following signal appears:
Requisition already matched.
This signal is not true. It appears if you enter information in the Delivery Note when doing desk top receiving.

 
SOLUTION DESCRIPTION:

The solution can be found on the Support FTP Site. It contains 5 files. 


1.	 FIXDN.sql  - This file has to be copied to the local disk where the database server is installed
       Run the query:

Login to the database server where EProcurement database is present
Copy the attached file(FIXDN.sql) to the desktop.
Open Query Analyser (Start--->Programs--->Microsoft SQL Server 7.0 -->Query Analyser)
Connect  to the database server
Once connected, choose file option in the menu ---> Click open ----> Select the file(FIXDN.sql) which was copied to the desktop in step 2.
Now press "F5" to execute the code.


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

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

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

5.   Mailapp.dll

Important: The above three dlls should be applied in the following order: ERequisition.dll, Einvoice.dll and Mailapp.dll


 

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. Remove all the components from the E-Enterprise package within Microsoft Transaction Server. Don't close the window after removing the components.

C. 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

D. Reboot de webserver

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

F.  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

G. 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.

H.  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.

I. Reboot the webserver