cancel
Showing results for 
Search instead for 
Did you mean: 

item code being replace to nearest item from item master data

SuHsiang
Explorer
0 Kudos
274

Hi,

In item master, there are item code ABC & DEF.

When user key in AB, SAP automatically filled up to ABC.

When user key in DE, SAP automatically filled up DEF.

Customer is using copy table and it will filled up a lot of wrong item code.

Any setting to turn off or it is system behavior? Any idea to over come other than key in the correct item code in SAP master data?

Please help.

Thank you.

Best regards,

Tan Su Hsiang

View Entire Topic
Johan_H
Active Contributor
0 Kudos

Hi Tan Su Hsiang,

This is system behavior, and cannot be turned off. If the customer has items ABC, DEF, ABF and DEC, typing in DE will open a list with DEF and DEC, for the user to choose from. If the customer has only ABC and DEF, then the system will automatically assume that DE means item DEF. This system only works from left to right. That means that when the user types in EF the system will not show DEF.

"Customer is using copy table"

Do you mean, for example, from Excel to SAP Business One? In this case copying only a partial value like AB from Excel and pasting it into SAP Business One, will not work reliably. The source values should be complete, i.e. ABC or DEF.

For items an alternative is to use barcodes / EAN codes, if the Excel tables contains this information.

Regards,

Johan

SuHsiang
Explorer
0 Kudos

Hi Johan,

I have test with using barcode such as item ABC with barcode ABC.

When i key in barcode AB it will auto fill up ABC.

Thank you.

Best regards,

Tan Su Hsiang