I'm running this -------------------------------------------------------------- select custbody_fob_factory, custbody_fob_port from transaction where type = 'SalesOrd' and id = 2587456 ---------------------------------------------------------------- without any problem but if I remove the 'and id = 2587456', I'm getting the following error -------------------------------------------------------------------------- You have attempted an invalid sublist or line item operation. You are either trying to access a field on a non-existent line or you are trying to add or remove lines from a static sublist. ____________________________________________________________ Any of you have an idea why it's happening ?

Does this work?

select
	custbody_fob_factory, 
	custbody_fob_port 
from 
	(
		select
			*
		from
			transaction 
		where
			type = 'SalesOrd'
	)

Do

custbody_fob_factory

and

custbody_fob_port

exist on all transaction types?

@tdietrich I don't understand but it worked. Kind of strange. Thanks

That's good. I've seen that bug several times before. I think I know why it happens, but still... it shouldn't.