cancel
Showing results for 
Search instead for 
Did you mean: 

Item Description

former_member781837
Participant
0 Kudos

Hi Experts,

I have a quick question regarding Item master data that doesn't populate in marketing documents for ex:

I Open up a purchase order, i type in my item code and the item description populates. (Perfect, they way it should work)

Item 2 gets typed in, but the Item description, quantity etc doesn't populate at all

I noticed the items that if the item has a BOM attached to it, it populates. If there are no BOM, then it doesn't populate.

Any advice?

Thanks

Reinhardt

Accepted Solutions (0)

Answers (7)

Answers (7)

former_member781837
Participant
0 Kudos

Yes the database has recently been upgraded.

I'll log a ticket, thanks

former_member781837
Participant
0 Kudos

Hi Jitin,

First query's result is 'P'

Second query is not returning any rows

What i do see when i run select * from OITT, is that the items i have problems with is not in that table.

Edited by: R. Buytendorp on Nov 29, 2011 2:39 PM

Edited by: R. Buytendorp on Nov 29, 2011 2:44 PM

jitin_chawla
Advisor
Advisor
0 Kudos

Hi,

Has the database been recently upgraded?

Are these item 13 of those. The issue can be a database issue.

You can raise a support ticket to get the issue investigated regarding the problem.

Kind Regards,

Jitin

SAP Business One Forum Team

former_member781837
Participant
0 Kudos

Yeah, we have another live database in the domain and it's fine on that one. Even items with no BOM pulls through the item name, qty etc.

I'll keep on scratching around, not sure what the problem is, it only happens with like 13 items.

No FMS on the field, no

Edited by: R. Buytendorp on Nov 29, 2011 2:29 PM

Former Member
0 Kudos

If only those 13 items with trouble, I am afraid there are manual change in this db makes the item inconsistent. The simple solution would be creating new items for them.

former_member781837
Participant
0 Kudos

8.81 PL08

Edited by: R. Buytendorp on Nov 29, 2011 2:07 PM

Former Member
0 Kudos

Have you checked demo or test environment? Do you have any FMS set on that field?

jitin_chawla
Advisor
Advisor
0 Kudos

Hi,

If you item which does not display the item description is a not BOM then the following query :


select treetype from OITM where itemcode = 'xx' 

where 'xx' is your item code

will display treetype as 'N' as value i.e Not a BOM.

You can confirm the item to be a BOM or not by running the following detect query :



select * from OITM where itemcode = 'xx' and  itemcode not in (select itemcode from OITT)

Check this and update.

Kind Regards,

Jitin

SAP Business One Forum Team

Former Member
0 Kudos

Hi Reinhardt,

What is your B1 version and PL? It might be by bug. Check demo database to see if you got the same issue.

Thanks,

Gordon

former_member781837
Participant
0 Kudos

It only happens to items that doesn't have BOM's.

the articles that has BOM's populate the item description field. Its very weird.

former_member541807
Active Contributor
0 Kudos

hi,

check your item master data. the reason is that your item master data is set to inactive.

check this note 1622808

regards,

Fidel

Former Member
0 Kudos

Hi......

It does not happen at all that if Item has BOM that only brings Description of its Item code.

It happens in all cases.

It that happening with you for a particular Item Code?

Regards,

Rahul