Item code

[former_member193355]

Dear All,

We have inventory settings as follows:

1. Group

Fruit

2. Name

Pineaple

3. Code

P001

4.Grade

value : 24 -> Grade A, Grade B, Grade C

5. Price List

Grade A, Grade B, Grade C

I am really confusing whether I have to create itemcode P00124A or just P001, but I create UDF contains grade value 24, price list grade A, B, C and warehouse code A, B, C.

But if the item have to downgrade because of quality decrease, I have to change its level to grade B or even C. If the quality is more and more decrease (not B or C), I have to change the item code.

Pls give advice. Thx

Rgd,

Edu

(Georgia will win)

[Former Member]

Hi,

If I understand you correctly, your itemcode should not include 24A. Price List is there to help you sell the item with different prices. Since your item is Pineapple, you just need to define the different pineapple as different item code. Hope this answers your question.

Thanks,

Gordon

[former_member193355]

Tks for your answer.

However, I do not know how to change price list (unit price) from grade A to grade B in the sales order where the customer actually have grade A price list. Is it manually ?

the purchase price for each grade is also different. If I have to define different last purchase price, will I be able to use it in the gross profit calculation ?

Rgd,

Edu

(Georgia will win!)

[Former Member]

Price list is mainly used for sell. You need to design the list which can be linked to sales order easily. However, that link is fixed as soon as you created the order. Which means you need to change them manually in case of the price change.

If your purchase prices are different all the time, you may need to create more than one item code for the items with relative stable purchase price associated with them. BTW, what is your inventory valuation method?

Thanks,

Gordon

[Former Member]

Steve,

There are a few ways to handle this.

If you want the change the price at the Sales Order level you could tie the warehouse that the item is being selected from on the Sales Order and pick the price from the Pricelist associated with the Warehouse by using a formatted search.

In this case there is not need to manully change the price and the price will change with the warehouse.

Let me know if you have any other thoughts to handle it differently

Suda

[former_member193355]

Tks for your answer.

I really get headache how to resolve this problem.

I can't imagine what will be in the future. what I mean is that if I received the goods from supplier, where the grades are different, how to treat it ?

We use lot number. Will it the lot number made as same as batch number ? or made it become serial number ?

Could you help me to prepare the FMS ?

I also create UDF that stores the grade. So, when receiving, the warehouse staff can assign lot number.

Rgd,

Steve "Edu" Andre

(Georgia will win)

[former_member193355]

Tks a lot for your answer.

The valuation is moving average. What do you think ? Will it better to create item P00124A or still P001 ? Pls help soon.

Rgd,

Edu

[Former Member]

Hi Edu,

Before seeing the whole picture, it is really hard to give you a solid answer. However, in my opinion, the P001 is too short for your item coding convention. You need to reduce the link for your item code with the property of your item. You will find it is very hard to maintain in the future. You can have some basic category such as using all letters as you first item code letter. It is better to keep your code the same lenth. There are item groups, item properties, item warehouses, item types. All of those can give you lots of powers to control item management.

Thanks,

Gordon

[Former Member]

Managing the Items by Lot / Batch is what I was going to propose. It definitely is a good option to look at.

Are you lots correspond to your Grades like the ones shown below. Give me a sample of your Lot numbers for my understanding.

LOTS

-

---

GRADE A

GRADE B

..

..

Where have your created the UDF?

Please explain the business process in a little more details from Purchase Receiving to Sales

[former_member193355]

I am happy to hear your answer.

I suggest to use batch no. as lot number for the item. I create UDF in category : inventory --> batch number for items named grade and then I link it to a grade value table.

I agree with your idea :

lots

__________

grade A

grade B

but lot number required by user is the date of the fruit receiving. So, it is important and it will be a main criteria to assess the grade value in making downgrade decision.

Anyway, in administration module --> general settings --> tab inventory --> unique serials number by field : I choose none. What will be I choose so that the above can be applied ?

However, what about the price list ? do you have the automation to make the unit price change automatically when the warehouse code change ?

Pls give advice.

Rgd,

Steve "Edu"

[former_member193355]

Tks for your answer.

However, the current situation, the user use P001 and then grade values (24, grade A) and then lot number.

So, it means you ask me to create P00124A. if I want the item code be downgraded, do you want me to create new item code, example P00124B and then issuing all the P00124A and after that, receipt all the P00124A quantities in the P00124B warehouse ? actually beside P00124A, there is also similar code i.e. P00124B and C

I just try to design the item code is still P001 and if it must be downgraded to B, I just create transfer order to warehouse grade B from warehouse grade A. Can I change batch no. when performing transfer order ? I just want that when transfer to grade B, the grade A can be leveled to grade B.

Rgd,

Steve "Edu"

[Former Member]

Hi Steve,

In your case, P001 may not work as you wished. From you context, you try to virtually move P001 from one warehouse to another without any physical move, right?

However, the total P001 on hand and item cost is a overall number which is not changed by your warehouse.

If your total item number is not huge, more item codes might be better for you to control.

Thanks,

Gordon

[former_member193355]

Dear Gordon,

Tks a lot for your answer.

Are you sure that it will be difficult to use the batch management to do that ? Isn't it a theory only ?

Rgd,

Steve "Edu"

[Former Member]

Batch management is suitable for manufacture who creates product with series number. It seems quite difficult to apply it to food unless you can assign them series number.

Thanks,

Gordon

[former_member193355]

I am so confusing with your answer. Nevertheless, tks

Rgd,

Steve

[Former Member]

Steve,

Batch Management will SURELY WORK and Formatted search to change price when Warehouse Changes will also Work.

Please do not worry much. I will help you through this and we should be able to make it work.

I will think through this and reply you later.

Suda

[former_member193355]

Tks for your help. I really wait for it.

Rgd,

Steve "Edu"

[marcella_rivi]

Dear Mr Andre,

If you want to downgrade the items and assign them a new lot it is possible to use the functionality update in the Item Management for Batches (that is in the Stock Management module).

Kind Regards,

Marcella Rivi

SAP Business One Forums Team

[Former Member]

I withdraw my comments on batch method or any other work arounds. What I mean is:

Your industry has very special case that almost no available match from any big ERP solution providers.

The problem is due to that your product can't be defined in normal way.

A regular item by its definition has to be:

1. Unique with same property

2. Countable with consistent measurement

3. History can be maintained in relative stable fashion

Since your item "fresh food" is so difficult to fill in those categories, compromise has to be given to minimize the impact to your business. My suggestion to create more item codes is for your long term business grows. You may know more when you face new challenge to solve any other hidden problems.

Thanks,

Gordon

[Former Member]

Please provide the exact Batch Numbers you have setup for this

Is it GRADEA or GRADE A

Also send me the Warehouse Codes

[former_member193355]

The batch here means lot. We did not provide its number to be grade A or B, but we use date. the date at first the fruit arrived in the warehouse, will become its batch. Then QC staff will classify the fruits to be grade A or grade B or grade C coz sometime farmer can deceive, where they mix grade A 99% and grade B 1% meanwhile we buy 100% grade A in the purchase order.

So, in the UDF of batch, I use a UDF linked to a grade table.

In the batch number field I use 16082008 as the fruit lot number.

I know admission date but it won't reflect the lot number when the fruit is moved to branch whse.

The warehouse code is Grade_A, Grade_B, Grade_C, Branch, Good in Transit, Repack, Rental, HQ, QC and Production for banana Ca2C3 (calcium carbide) process.

When the fruit like banana transfered to the production warehouse, it is a raw batch number. After carbide process finished, it will be directly lot renumbering.

So, pls help me to provide the solution for the 4 paragraphs above.

Rgd,

Steve "Edu"

[former_member193355]

The batch here means lot. We did not provide its number to be grade A or B, but we use date. the date at first the fruit arrived in the warehouse, will become its batch. Then QC staff will classify the fruits to be grade A or grade B or grade C coz sometime farmer can deceive, where they mix grade A 99% and grade B 1% meanwhile we buy 100% grade A in the purchase order.

So, in the UDF of batch, I use a UDF linked to a grade table.

In the batch number field I use 16082008 as the fruit lot number.

I know admission date but it won't reflect the lot number when the fruit is moved to branch whse.

The warehouse code is Grade_A, Grade_B, Grade_C, Branch, Good in Transit, Repack, Rental, HQ, QC and Production for banana Ca2C3 (calcium carbide) process.

When the fruit like banana transfered to the production warehouse, it is a raw batch number. After carbide process finished, it will be directly lot renumbering.

So, pls help me to provide the solution for the 4 paragraphs above. if you could, do not give an unspecific solution. Give me with example. Thx

Rgd,

Steve "Edu"

[former_member193355]

Tks for your answer. I am sure your answer resolved one problem.

Rgd,

Steve "Edu"

[Former Member]

Please let me know what value you enter in the UDF for the Grade.

[former_member193355]

Standard one i.e. A, B, C.

Rgd,