How to create your own serial numbers using API?
We all know how we can generate serial numbers in the system. It is governed by the the setup at the organization and item level. A the inventory organization parameters level you decide whether we want serial number generation at the organization level or item level or user defined. If you choose User Defined and at in the item master you can choose Pre-Defined as your control, you are saying you want to generate your own serial numbers. What happens here is that the the serial number generation logic is followed by the serial number pre-fix and and number that is entered in the item master. Which means you cannot truly create your own serial numbers with this approach.
In order to achieve this requirement you have to use a very obscure package called user_pkg_serial.generate_serial_number. If you put your code here, then that serial number will be generated. This is kind of a hook. The same goes with the lot number. The package is user_pkg_lot.
Who knew that there are standard database packages with names like this!!
No comments:
Post a Comment