Stock card Management

Chika

Hi All,

I'm handling a new project of a retail company.
This company sell flat glass.
When a purchaser buy a new flat glass, the measurement that is used is roll.
This flat glass has 2 dimensions [width * length] and has unique serial number.
Let's say one roll has width = 150 cm and length = 3000 cm.

Everytime their customer order the flat glass, the warehouse officer will cut it,
and then send the remaining back to the warehouse.

This is one of Scenario that might be happen:

Suppose a customer wants a flat glass that has width = 130 cm and length = 100 cm.

The warehouse officer will cut the big flat glass into two pieces
1. 150 * 100 cm
2. 150 * 2900 cm

And then warehouse officer will cut the 150 * 100 cm flat glass into
1. 130 * 100 cm
2. 20 * 100 cm

From this scenario, everytime the warehouse officer cut a flat glass,
system will insert new stock card for the remaining.

My question is :

Is there anyone of you that have ever faced a similiar case like this?
Should I insert new item code for the remaining flat glass?
If I insert a new item code for this remaining flat glass,
my database performance will be very slow [Since there will be so many
rows just to handle one item everytime the warehouse officer cut the flat glass].

If I insert new item code for this remaining item, how should I manage the item costing?


Any advice will be very helpful.

Thanks in advance

David_Singleton

Chika wrote:

Hi All,

I'm handling a new project of a retail company.
This company sell flat glass.
When a purchaser buy a new flat glass, the measurement that is used is roll.
This flat glass has 2 dimensions [width * length] and has unique serial number.
Let's say one roll has width = 150 cm and length = 3000 cm.

Everytime their customer order the flat glass, the warehouse officer will cut it,
and then send the remaining back to the warehouse.

This is one of Scenario that might be happen:

Suppose a customer wants a flat glass that has width = 130 cm and length = 100 cm.

The warehouse officer will cut the big flat glass into two pieces
1. 150 * 100 cm
2. 150 * 2900 cm

And then warehouse officer will cut the 150 * 100 cm flat glass into
1. 130 * 100 cm
2. 20 * 100 cm

From this scenario, everytime the warehouse officer cut a flat glass,
system will insert new stock card for the remaining.

My question is :

Is there anyone of you that have ever faced a similiar case like this?
Should I insert new item code for the remaining flat glass?
If I insert a new item code for this remaining flat glass,
my database performance will be very slow [Since there will be so many
rows just to handle one item everytime the warehouse officer cut the flat glass].

If I insert new item code for this remaining item, how should I manage the item costing?


Any advice will be very helpful.

Thanks in advance

Yes I have done almost the identical.

In this case we have added new fields to Navision for Length and Width, and modifed the applies to function so that you can only apply to a panel that is wider and longer than the one you are cutting from.

The client manufactures the product and uses reservations, so we had to modify a number of areas. they are running for years and it works fine.

Their old system had one part number per lxw dimension, and was becoming handleable. This scenario has worked much better for them.

Chika

David, thanks for your reply

Honestly I don't really understand about the panel that you said.

David, if you don't mind can you please give a more detail scenario related to inventory management for this remaining item?
Do you insert the remaining item as a new item?

And how do you manage the item costing for the remaining item?

Thanks in advance.

Deep

Hi,

Once I encountered such a case.
My client used to Purchase iron sheets and sell them in peices.
For this, we followed the below simple solution :

1. Created an Item say Iron Sheet.
2. Entered the Measurements in remark field (created field) say, 50*100
3. Base Unit of measure was SQFT (Square Feet)
4. Purchase Unit of measure was ROLL with qty per BUOM=5000. One Serial No. field was attached at Material receipt which updated at the time of Posting the receipt, in ILE. For these 10 quantities, the Sr. no. updated say S1,S2,S3....S10.
5. Purchased the item in ROLL. say 10 qty. ILE updated in SQFT=50000 SQFT
6. Sold the quantity of 20*100 in sqft= 2000 with Serial No.=S1 and Dimensions 20*100 in remarks.

This process generated exact results, with exact costing. When stock ledger was generated for the item, it shows like:

Item No. Serial No. Remaining Quantity
Iron Sheet S1 3000
Iron Sheet S2 5000
...
... and So on.

Check if this can be of any help to you.

David_Singleton

Chika wrote:

...
Honestly I don't really understand about the panel that you said.
...

Does it matter if you call it a Roll or a Sheet or a Piece, or a Panel?

selece28

Hi i also having the same problems.
I can only think of modify the Item card,
Maybe add some field like : Width, Lenght and second UOM.
I use the standard UOM to keep the SQFT (Square Feet) of my item.
And the new UOM (2nd UOM) to keep the qty (how many sheet do i have)
So, this way i can have, example : Item A with many different size.
But this Item A can be cut into 2 new item. (meaning my client can cut the Item into smaller piece to sell)

Can i use Lot No. so that the new Item A still have the same Item Code, Same Lot No. but different size?

I just do some update on ILE, minus the first Item A (the one big size)
Then plus 2 lines of Item A with the new Width and Length, and same Lot No.

Can this idea work? I still trying to find the best solution for this.
Any other suggestion?

Thanks in advance,

Deep

This truly depends on the requirement. But I believe that in such kind of business, there may be an item of any kind (mean cutting og a specific sheet into any measurement). I dont think feasible to create a new item everytime their is a need to cut the sheet.

Since the bililing is done over weight or area, the same item can be billed areawise or weightwise, which truly eliminates the need of keeping different items. Moreover , this helps in keeping track of originally bought inventory and the inventory consumed in cutting it into desirable sizes.