Prev
Next
Forums Lawson Add-Ins for Microsoft Office

Blanking Out a Field (GL20.7)

Sort:
You are not authorized to post a reply.
Author
Messages


Dave Mitchell











Advanced Member



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











    Senior Member



    Posts: 3348




    Senior Member



    5/30/2012 6:04 PM
      Try *BLANK
      Thanks for using the LawsonGuru.com forums!
      John


      Dave Mitchell











      Advanced Member



      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



        Posts: 52




        Veteran Member



        6/19/2012 8:24 PM
          What exactly are you trying to do?


          JonA











          Veteran Member



          Posts: 1162




          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



            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
              You are not authorized to post a reply.