'Field cannot be blank' despite being filled

9.01.12 on premise. I'm seeing something very strange with a form I'm working on. Given how this form is operating, I'm having a user populate fields & then creating a new entry & manually copying the data into the new record (Yes; I know.... sometimes the straightest path is through the mud and I *just* want this project over with. I digress.).

I have a bunch of mandatory fields (NOT NULL) and some optional. One of the required fields is a Location (NOT NULL and type LocType in SQL). In my Form Script, I have a section like this:

ThisForm.PrimaryIDOCollection.CurrentItem["DeliverTo"].SetValue( ThisForm.Components["editQMDeliverTo"].GetValueOfString(null) );
ThisForm.PrimaryIDOCollection.CurrentItem["DeliveryType"].SetValue( ThisForm.Components["dropListQMDeliveryType"].GetValueOfString(null) );
ThisForm.PrimaryIDOCollection.CurrentItem["Item"].SetValue( ThisForm.Components["comboBoxQMItem"].GetValueOfString(null) );
//ThisForm.PrimaryIDOCollection.CurrentItem["Location"].SetValue( ThisForm.Components["dropListQMItemFromLocation"].GetValueOfString(null) ); <------------------
ThisForm.PrimaryIDOCollection.CurrentItem["Location"].SetValue("FIFTEEN"); <-----------------------------------------
ThisForm.PrimaryIDOCollection.CurrentItem["Quantity"].SetValue( ThisForm.Components["editQMQuantity"].GetValueOfString(null) );
ThisForm.PrimaryIDOCollection.CurrentItem["RequestedBy"].SetValue( ThisForm.Components["editCurrentUsername"].GetValueOfString(null) );
ThisForm.PrimaryIDOCollection.CurrentItem["RequestType"].SetValue( ThisForm.Components["dropListRequestType"].GetValueOfString(null) );
ThisForm.PrimaryIDOCollection.CurrentItem["QuantityMoveToLocation"].SetValue( ThisForm.Components["comboBoxQMToLocation"].GetValueOfString(null) );

For some reason, no matter what I do to my Location field, I always get: The Location entered cannot be null in METHOD_NAME. INSERT rolled back.

Deliver To, Delivery Type, and Item are all required as well & none have this problem. I've verified that the component does have a value. Please help.

Find more posts tagged with

General Discussions

Accepted answers

All comments

Stephen Cena

Well that got interesting....I added some debug statements and so far the ONLY field being set is "Item". All the other fields are blank. This makes no sense to me.

Infor Nexus_SC_DQ_Mar18_2021_DischargeDwellUpdate.mp4

mtolliver

Is there another component or field in that table that is required before the location? Warehouse or Rank or something else?

mtolliver

The only thing i can think is the order of which you set the values may matter? I know sometimes in a Paste Rows Append for new records if they aren't entered into a specific order you can get errors even when the value is valid. Not sure if that is helpful but thought I would mention it.

Stephen Cena

I guess I would say yes. I didn't think order of the properties would matter. In the code I have listed, only the Quantity Move location is not required.

Stephen Cena

I do. Item Description is one. I have a few JOINs in place for ease of access. Right now, I *think* I may have fixed my original problem of having the Properties bound to the From Components and so far so good. we'll see what happens when I move onto the next screen LOL.

unknown

Do you have additional "Read Only" fields in the IDO that are from joined IDOs? I vaguely remember having a similar situation. I removed them and was able to save.

0911060553270289.pdf

Copyright © 2025 Infor. All rights reserved.