Internal error (-1004) occurred [Message 131-183]

[Former Member]

Dear Expert,

I have created a formatted search to copy ship to code to my customer equipment card from Delivery Order, when I execute the formatted search, an error message " Internal error (-1004) occurred [Message 131-183] " popped up.

My formatted search message is as such "Select $[ODLN.ShipToCode]."

Please help.

Regards,

Saw Hua, Ng

[Former Member]

Hi,

Try this:

SELECT TOP(1) ShipToCode 
FROM ODLN
WHERE CardCode = $[$48.0.0]

Kind regards,

Hendri Wessels

Edited by: Hendri Wessels on Aug 7, 2009 11:43 AM

[former_member197621]

Hi Saw Hua Ng

try this

Select $[ODLN.ShipToCode]

[Former Member]

It does not work, same error message dispear.

[Former Member]

Hi!

Try it !

Select max(D0.ShipToCode) from ODLN D0 where D0.Docnum='[%0]'

Save this FMS,

Assign it as FMS.

Press ****+F2

Select the Docnum of tht Delivery

[former_member197621]

Hi Saw Hua Ng

In customer eqp card where u want ship to code UDF or default field

[Former Member]

Hi, Suraj,

Your query is workable but I need to enter the D/O number everytime Is there anyway to avoid the parameter?

Thank you.

Regards,

NG

[Former Member]

Try this

Select max(D0.ShipToCode), D0.Docnum from ODLN D0 Group by D0.Docnum

it will list all Docnum at second column, ask the user to select the approp.