| Quick way to create a PO with multiple lines in Financials [message #182419] |
Fri, 14 July 2006 13:24  |
dreamkatcha
Messages: 11
Registered: July 2006
|
Junior Member |
|
|
Hi,
I was just wondering if anyone knows of an efficient way to create 20 identical distribution lines within a single PO. I'm raising orders for temporary staff wages and would rather not have to raise a separate PO for each invoice.
I know you can press shift and F6 to copy the line above, but this doesn't duplicate the behind the scenes info i.e. the cost code, staff requester details etc.
Any info would be greatly appreciated, thanks.
|
|
|
|
| Re: Quick way to create a PO with multiple lines in Financials [message #182606 is a reply to message #182419] |
Mon, 17 July 2006 05:27  |
David.K.Dickson
Messages: 413
Registered: October 2005
Location: Surrey, England
|
Senior Member |
|
|
I don't know enough about the detailed workings of Purchasing to say for certain, but if nobody gives you an answer that you are comfortable with, then you might want to coinsider this.
In my job implementing and supporting the Oracle Financials, I frequently have the need to load large numbers of records, and frequently need to load the same (or slightly modified) data into multiple environments for Development, Testing, User Acceptance Testing, Data Migration, Training and Production. To do this, I make extensive use of DataLoad, which is a free download from http://www.dataload.net/
DataLoad has a spreadsheet-style user interface and anybody who has used a spreadsheet will be able to use DataLoad in minutes, and should be able to test their first load (in a TEST environment) within an hour.
DataLoad does not have all of the formulae and functions available in Excel, so what I do is build an Excel spreadsheet containing all of the data that I want, making use of all of the power and facilities available in Excel, then use the DataLoad "Import from Excel" button to copy the data into DataLoad. In your case, your spreadsheet would contain the 20 distribution lines, each with the appropriate cost code, staff requester details etc.
The steps involved in loading data are:
1.) build your data in Excel,
2.) highlight all of that data,
3.) ALT+TAB to DataLoad ,
4.) click the "Import from Excel" button
5.) from the drop-down list, select the window that you want to load the data to (e.g. Oracle Applications),
6.) click on the "Send Data to Form" button.
Now, sit back and watch as DataLoad loads all of your data through Oracle Forms with all of the normal validation that would be done just as if you had keyed it in yourself.
Note that you select the window that you want to send the data to. This need not be Oracle, so DataLoad can be used for entering data into any application that has a Windows GUI interface.
As well as the free version, there is also a Professional version, which uses the Oracle Forms "Record" and "Playback" functionality, which runs on the server and is a lot faster than the Classic version (which uses Windows Cut and Paste). Using the Professional version, I have loaded Cross-Segment Validation Rules at the rate of just over 7,100 elements per hour (or almost 2 elements per second).
Although I have no commercial connection with DataLoad , I am a moderator on the DataLoad Forum, and I will do my utmost to help any new users to get started.
 HTH
David
|
|
|
|
| Re: Quick way to create a PO with multiple lines in Financials [message #182628 is a reply to message #182419] |
Mon, 17 July 2006 07:18 |
vin_odks
Messages: 153
Registered: July 2006
Location: -
|
Senior Member |
|
|
Hi,
There is an option in Purchasing to set default values to the PO
1) Make use of Tool-->preferences in your PO setup
Preferences can be used to set default values for the following :
a) Destination Type
b) Requestor
c) Ship to
d) Sub inventory
e) Charge account
f) need by date
g) Tax code
And much more ..
2) Some of the information also get defaulted form the supplier info.
After setting up the above info, only minimal info needs to be supplied.
Does this solves you requirement?
Regards
Vinod
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
