Error to HR11 User Fields

There are a couple of possibilities here. First, are you using locales on your system, and if so, are you using a locale which doesn't format dates that way? You should probably be able to upload CCYYMMDD without dashes. Another is that since you are not mapping to the first row of the form, the row which HR11 is actually trying to update is actually a date field, not an alpha user field. Please see https://www.lawsonguru.co...th-Excel-Add-In.aspx which will show you what I consider to be the best way to update a header/detail form via Addins--which includes mapping to the underlying user field dictionary field number.

This was sort of helpful - I did find the Field Number: 2069 and used WS_FLD_NBR1 = 2069 and f591:3_HRU_FLD_NBR4 = 2069, and get "Date must be 6 or 8 digits" on the first record then on rows 2 thru 10 I get "Cannot add blank user field"

?? Ugh :-(

I guess I didn't make this clear enough in the previous post. When you are maping to a complicated form, *always* use a separate spreadsheet row for each form detail, and *always* map to ROW ONE. In other words, you should be mapping to WS_FLD_NBR1 = 2069 and HRU_FLD_NBR1 = 2069. Rows 2 thru 10 should be completely blank.

I just cannot seem to get this to work. One row, WSFLDNBR1=2069, HRUFLDNBR=2069, Date Format CCYYMMDD, and still get Date must be 6 or 8 Digits...UGH! Frustrating.

Attached is my latest futile attempt :-(

 

Pay no attention to my Date format in this example - I was just trying different formats...

 

 

Ok, I GOT IT! I am an idiot... wasnt paying attention to the line nbr's ... thanks John! You da man!

 

 

Glad you got it working!