|
|
|
|
|
|
| Re: How to make new item code automatically [message #448704 is a reply to message #448593] |
Wed, 24 March 2010 20:51   |
westwolf2009
Messages: 14
Registered: March 2010
|
Junior Member |
|
|
first :define a item code rule ,the item codes combined with sequence and characters.
second:you open the item define form ,open the form-level trigger
'POST-DATABASE-COMMIT',in there to add your custom code
eg: select xxx_seq.next_val||'item code rule'
into XXXX.XXXX FROM DUAL
|
|
|
|
| Re: How to make new item code automatically [message #448708 is a reply to message #448704] |
Wed, 24 March 2010 21:53 |
baonam
Messages: 5
Registered: February 2010
Location: Incharge
|
Junior Member |
|
|
Hi,
Thanks you for you reply.
To make new item code, we have a form to make it.
But, now, every day, I have to make 100 items/day by using a form make new item code. It take many time.
So, I want to write a program which I can make many item as the same time.
I have the begin data to make item (catagory, catalog, UOM, item type, organization_id...), but Idon't know the process of data to make item
Please help me.
Thanks
baonam.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
