item code being replace to nearest item from item master data

[SuHsiang]

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

[EunSeok_Bang]

Hello,

Would you try if the following solve your problem?

Regards
EunSeok

[SuHsiang]

Hi EunSeok,

I have tested for copy table it will not work. If user key in manually, the suggestion will prompt.

Thank you.

Best regards,

Tan Su Hsiang

[Johan_Hakkesteegt]

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]

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