Digi-Key Total » Digi-Key Requirement

KD Salesorder Search Enhancement

To better clarify, when Flora enters “101-161470-7275379” in SO search field, we want the actual search to be something like (but not exactly like) this:

SELECT * from EAS_USER.T_SD_SALEORDER

where FNUMBER = replace('101-161470-7275379', '-','')

I’m not sure if EAS searches against more than the FNUMBER field, so might not be able to use that exact format… That’s just an example to try to explain what we are looking for…

Thanks,

Steve

Hi Robert,

The Salesorder Number format on the web includes hyphens to make it more readable, but when we load to KD (T_SD_SALEORDER FNUMBER), we only load the number, to keep the back-end data cleaner. However, this creates a challenge when Flora’s team tries to search for an order number as formatted from the web (101-161470-7275379), for example via copy \ paste.

How much effort to ignore the hyphens when Flora searches in Kingdee for an Order Number formatted with hyphens?

Thanks,

Steve