Sage 100

 View Only
  • 1.  I'm trying to write a VI import in 4.50 that will

    Posted 03-03-2015 11:56
    I'm trying to write a VI import in 4.50 that will allow my client to lock and unlock random user's accounts. I can lock the user, no problem, but I can't get it to unlock. The data file shows blank if the user is not locked. I have tried leaving the field blank and entering an N. The import log shows no error. Am I missing something? (Import includes User Key and User Code.) @AlnoorCassim


  • 2.  RE: I'm trying to write a VI import in 4.50 that will

    Posted 03-03-2015 12:09
    I did with a BOI script but never with a V/I import. Are you importing into Sy_User? If so which field are you referring to that you're leaving blank? The only field I believe you need to set or clear is InactiveDate - the business object should take care of the rest.


  • 3.  RE: I'm trying to write a VI import in 4.50 that will

    Posted 03-03-2015 12:46
    I am using the Locked Field. I haven't tried the inactive date, so I can test that. Thanks!


  • 4.  RE: I'm trying to write a VI import in 4.50 that will

    Posted 03-03-2015 14:06
    Alnoor is right. That date needs to be cleared along with the Lock field to N or blank.