This content has been marked as final. Show 7 replies
There are open interfaces and/or api's, have a look at irep1 person found this helpful
On the actual steps, you have also to consult with functional or somebody with knowledge of the setup to determine/configure templates for items. Also, be aware of the use of lots and serials. For on hand quantity you usually create receiving material transactions, setup may be needed for the accounts to use. Maybe costing information will be also needed.
Hi,1 person found this helpful
Make proper format of items in excel file and use dataloader . This will reduce your work .
You may also use record and play depending upon your requirement.
I need help..
The accounting issues of a new inventory organization for WIP items are not quite clear.
How can i replace the profit and loss accounts Sales and Cost of Goods Sold wth Capital Stock and WIP accounts respectively?
The profit and loss accounts of an inventory organization have no effect as we are not implementing Order Mangement and actual sales transactions are not made through Oracle Applications.
Thank for your answer.
Can you provide me with more advice please . I need guidance in uploading the categories , items and the items opening balances as well.
Inventory Items categories are implemented in my company as a 7 segments flexfield
1. Group-Independent value set
2. Sub-Group - dependent on Group
3. Sub-Sub-Group-depending on Group
4. Others - independent
5. Stock Type- independent
6. Future Use1-independent
7. Future Use2-Independent
You have sample macro:
http://dataload.net/downloads/spreadsheets/index.html ( INVENTORY )
If you want create own macro you have to create item, category etc. you should map your steps in application in dataloader using DataLoad Commands.
An alternative to using Dataloader is to use the Oracle Open Interfaces described here:
Chapter 7 describes the Transaction Open Interface, Item Open Interface, and Category Interface. The interfaces are a little more technical to use than Dataloader but, in my opinion, much faster once you get the hang of it.