Using DTW to Clear Values

[Former Member]

Hi,

I am trying to clear the values in the order interval field in our item master. I have removed each stock cycle that was set up, but it has left a value in the field on each item.

With 8000+ items we don't want to update manually, so I've tried using the DTW but haven't had any luck. Someone told me to use a '/' but it didn't work, I've tried leaving it blank in the upload file, I've also tried 'NULL' and '0'.

If anyone knows of a quick way to clear this value from all items your help would bemuch appreciated!

Thanks,

Michael

[Former Member]

Dear

The root cause for this issue is when updating Order Interval, B1 will

check table OCYC to see if the value is a valid one. In this scenario,

we set Order Interval to 0, while value 0 cannot be found in table

OCYC, thus the update cannot continue.

Only when Order Interval is set to empty, this check will be passed.

However currently we have no way to set it to empty in DI API. If we set

it to ""(empty string) in DI, it will also be converted to 0.

So currently this issue will be treated as future version candidate.

The workaround is to update it manually in SBO client.

Best Regards,

Xiaodan AN

SAP Business One Forum Team