Author Topic: Downloading from Handheld Error  (Read 1536 times)

mbargman

  • Newbie
  • *
  • Posts: 5
    • View Profile
    • http://www.jaair.com
Downloading from Handheld Error
« on: March 22, 2010, 11:39:36 am »
I started downloading info from our PT-40 to Stockroom today and I'm getting this error "The field "Inventory by Location.Lot" can not contain and Null value because the Required property for this field is set to True.

I have no idea what that means or how to solve the issue. Anyone have any ideas?
 

Dan Sullivan

  • Administrator
  • Hero Member
  • *****
  • Posts: 663
    • View Profile
Re: Downloading from Handheld Error
« Reply #1 on: March 23, 2010, 09:54:34 am »
This message means you have an inventory record that you are trying to upload that has a "NULL" value in the lot field.  The Lot field in our inventory table cannot contain a "NULL" value we normally place a default value of "---" in this field, but for whatever reason that default value is not being written to the table.  You will need to look through your upload data and find the offending record and put a value in the Lot field.  This value can either be a valid Lot value if you are using Lots in your system or our default value of "---".

Dan