ERPstuff - Oracle EBS Community

We have an inventory to save the cable. We have total length of cable is 1000m but actually it have many part of cables, it part is 5m, 10m,... and total is 1000m. Now we want to know how many part of the cables, how long of each part. How can we do? Thanks for help.

Hoang Anh

[quote]We have an inventory to save the cable. We have total length of cable is 1000m but actually it have many part of cables, it part is 5m, 10m,... and total is 1000m. Now we want to know how many part of the cables, how long of each part. How can we do? Thanks for help.

Hoang Anh

<i><div align="right">Originally posted by hoanganhlongan

Ah, like this:

When we import cable (A type), we import many roll of cable, each roll 1000m, ex: 2 roll -> 2000m. After that, each time we need the cable we issue it outside (50m, 60m... each time), then now in my storage i have many section of roll of cable is left, that system report 1000m total, but now it not in 1 roll of cable so in two roll of cables. How can I know how many roll of cable is left and how lenght of it?

Dear you can define Item UOM Conversion such as Roll = 1000m its a primary uom. here you need to create conversions for this Item & other meter5 = 5 meter10 = 10 n soon on meter50 = 50 so u can easily issue in meters.

Hi,

Yes it is now clear.

You can use cable with "Lot Controlled"

If it is lot controlled, every time you receives cable from supplier you will put into a "Lot number"

Now when you issue it to for work, system will ask you to provide the lot from which you will issue.

So if some cutpiece of cable remains, it will show on the specific lot only.

You may have stock of 1000 Mtr of total but you can find which lots are abailable with how much qty (cut piece).

Lot 1 = 110 Mtr
Lot 2 = 50 Mtr
Lot 3 = 60 Mtr


-------
Lot n = 100 mtr
---------------------------

Total = 1000 mtr

Hope it will sove your issue

Regards