Who's On?

	Membership:
	Latest: Zac Shields
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5211

	People Online:
	Visitors: 215
	Members: 0
	Total: 215

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1372
Roger French	1315
mark.cook	1244

Blanking Out a Field (GL20.7)

5 Replies

0 Subscribed to this topic

1 Subscribed to this forum

Sort:

Author

Messages

Dave Mitchell

Advanced Member

Posts: 18

5/30/2012 5:56 PM

I've tried everyting I can think of, excepting any "special characters", from a space, to multiple spaces, to a hyphen, and nothing seems to work. We're on Lawson 9.01 with Lawson S3 Add-In's (version 9.0.3.1) using Excel 2010 on Windows XP. If anyone has an idea, my email is Mitchell.D@ghc.org

John Henley

Posts: 3353

5/30/2012 6:04 PM

Try *BLANK

Dave Mitchell

Advanced Member

Posts: 18

5/30/2012 6:22 PM

Thanks John. Just tried *BLANK, and *blank. No joy, received "Value not within validation list" message.

dcaiani

Veteran Member

Posts: 52

6/19/2012 8:24 PM

What exactly are you trying to do?

JonA

Veteran Member

Posts: 1163

6/20/2012 12:10 PM

Just leave the cell blank. Don't have anything in it. But leave a column header so the column is available to the upload wizard.

Dave Mitchell

Advanced Member

Posts: 18

6/21/2012 1:22 PM

Thanks Jon. Between Lawson Support & I, we finally figured out we could only blank out 1 field at a time (I was trying to blank out 3 at a time). Appreciate everyone reponding. Dave