Prerequisite - regarding [message #280320] |
Tue, 13 November 2007 03:44 |
ramansrivathsan
Messages: 24 Registered: January 2006 Location: chennai
|
Junior Member |
|
|
Hi,
What are the pre requisites need to be considered while importing the open POs / uninvoiced receipts from the legacy system during implementation.
Thanks and regards
Raman A V
00966 563745536
|
|
|
Re: Prerequisite - regarding [message #280327 is a reply to message #280320] |
Tue, 13 November 2007 04:24 |
arunkp76
Messages: 16 Registered: August 2007 Location: Chennai
|
Junior Member |
|
|
Raman,
1. Purchasing Setup should be completed
2. Currency conversion rates needs to be defined in GL(Check your Conversion types)
3. Purchasing Period should be opened. Inventory period also needs to be opeen for receiving interface if you are opting for direct delivery
4. Need to collect the data from customer with Mandatory interface columns
5. to validate the data and populate interface tables program needs to be written. Conventional data loading method needs can be followed.
a) Data file to Staging Table(SQL Loader script needs to be prepared)
b) Staging Table to Interface Table(Data Validation, Deriving data & Population of Interface table using a customer program)
c) Calling Import program with parameters
Regards... Arun
|
|
|