VERSION:
E-procurement 2.1 SP1


SITUATION IDENTIFIED IN:
E-Procurement 2.1 SP1

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


SITUATION DESCRIPTION:


1. In the quick invoice entry, the Invoice date  gets defaulted in the same format as mentioned in the supplier settings.
Create an invoice with this and send it to the finance person. 
While importing the invoice, the system says "Invoice Date is in future" if the regional settings of this user is different. This is incorrect. The comparison of the invoice date with the current date should be carried  out correctly.


So you may simulate the problem like this:


* Change the supplier's regional  settings to dd-mm-yy(for ex., U.K)
* Change the finance person's regional settings to mm-dd-yy.(for ex., U.S)
* Create an invoice and send it.
* Try to import the invoice in the finance role. It will give an error as "Invoice date is in the future"

2. Its not possible to change the Transaction Date of the invoice created in the backend before exporting it from E-Procurement.

So you may simulate the requirement like this:

* Export the Approved Invoice to the backend ERP
* Check the details of invoice created in the backend
* The transaction date is current date and the periods are based on the current date.


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

SOLUTION DESCRIPTION:  The solution can be found on the Support 
FTP Site. It contains the following:

1. Readme.txt: The Solution Description

2. invoicelineoverview.asp - Copy this asp file to EProc21\EE11\e-invoice\enduser\ 
		Replace the Old One
3. labelsinvoice.asp - Copy this asp file to EProc21\EE11\e-invoice\include\ 
		Replace the Old One
4. quickinvoice.asp - Copy this asp file to EProc21\EE11\e-invoice\enduser\quickinvoice.asp
		Replace the Old One
5. 114997.sql Run the content of this file on E-Procurement database.

6. EInvoice.dll: This file has to be registered in the MTS

7. Folder containing Class files for BaanIV, BaanV-Grieg and BaanV-C
		These class files need to be replaced in the machine running the web server, in the same path as of the present proxies.
These files has to be placed in the path winnt/java/classes/com/baan/tech/bois/ccacprecpurinv/

	Content of folder ClassFiles:
	i) Folder BaanIV
	ii) Folder BaanGrieg
	iii) Folder BaanVc

		Content of folder ClassFiles\BaanIV:
		a) ccacprecpurinv.class
		b) SeqRecpurinv.class
		c) SeqRecpurinvKeyFields.class
		d) StructError.class
		e) StructRecpurinv.class
		f) StructRecpurinvKeyFields.class

		Content of folder ClassFiles\BaanGrieg:
		a) ccacprecpurinv.class
		b) SeqRecpurinv.class
		c) SeqRecpurinvKeyFields.class
		d) StructError.class
		e) StructRecpurinv.class
		f) StructRecpurinvKeyFields.class

		Content of folder ClassFiles\BaanVc:
		a) EprocBoiPack.dll
		b) PurchaseInvoices.dll


8. Folder containing BOI dumps for BaanIV, BaanV-Grieg and BaanV-C
		BOI dumps need to be installed in the same existing path as of the present BOI installation
	Content of folder BOIdumps:
	i) Folder BaanIV
	ii) Folder BaanGrieg
	iii) Folder BaanVc

		Content of folder BaanIV:
		a) Folder ccB50_b_boi1
		b) list

			Content of folder ccB50_b_boi1:
			a1) components
			a2) dump.e
			a3) dump.l
			a4) dumpd01.Z
			a5) dumpf01.Z
			a6) dumpl01.Z
			a7) dumpo01.Z
			a8) dumpr01.Z
			a9) dumps01.Z
			a10) dumpt01.Z

		Content of folder BaanVGrieg:
		a) Folder ccB50_b_boi1
		b) list

			Content of folder ccB50_b_boi1:
			a1) components
			a2) dump.e
			a3) dump.l
			a4) dumpd01.Z
			a5) dumpf01.Z
			a6) dumpl01.Z
			a7) dumpo01.Z
			a8) dumpr01.Z
			a9) dumps01.Z
			a10) dumpt01.Z


		Content of folder BaanVc
		a) Folder tfB50_c_boi1
		b) list

			Content of folder ccB50_b_boi1:
			a1) components
			a2) dump.e
			a3) dump.l
			a4) dumpd01.Z
			a5) dumpf01.Z
			a6) dumpl01.Z
			a7) dumpo01.Z
			a8) dumpr01.Z
			a9) dumps01.Z
			a10) dumpt01.Z

				
		

7. Readme.txt: The Solution Description

========================================
			Instructions for applying the solution:

	*	The  asp page can be applied directly.
	*	To apply the dlls:

To register the above mentioned dll 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 EInvoice.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 EInvoice.dll will be unregistered. Now rename the EInvoice.dll to EInvoice.bak

D. Reboot de webserver

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

F.  Register the attached dlls

Example with E-Invoice.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 E-Invoice.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


	* Instructions to apply the 114997.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 EProcurement database is present
B) Copy the attached file(FIXDN.sql) to the desktop.
C) Open Query Analyser (Start--->Programs--->Microsoft SQL Server 7.0 -->Query Analyser)
D) Connect  to the database server
E) Once connected, choose file option in the menu ---> Click open ----> Select the file(14997.sql) which was copied to the desktop in step 2.
F) Now press "F5" to execute the code.

PATH TO SOLUTION: 

ftp://ftp.support.baan.com/updates/E-Enterprise/E-Procurement/2.1/Sol_After_SP1/2.1.1.117524