• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums User Experience Lawson Add-Ins for Microsoft Office

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 Send Private Message
Posts: 18
Advanced Member
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
Send Private Message
Posts: 3351
5/30/2012 6:04 PM
Try *BLANK
Thanks for using the LawsonGuru.com forums!
John
Dave Mitchell
Advanced Member Send Private Message
Posts: 18
Advanced Member
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 Send Private Message
Posts: 52
Veteran Member
6/19/2012 8:24 PM
What exactly are you trying to do?
JonA
Veteran Member Send Private Message
Posts: 1163
Veteran Member
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.
Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
Dave Mitchell
Advanced Member Send Private Message
Posts: 18
Advanced Member
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