Error to HR11 User Fields

 7 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
mil0n023
New Member Send Private Message
Posts: 0
New Member

See attached date errors I receive with the UWF for HR11 user fields...

I have tried several date formats (MMDDYY, YYYYMMDD, YYMMDD, etc) and still get this error. See attached...HELP!

Attachments
John Henley
Send Private Message
Posts: 3351
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.
Thanks for using the LawsonGuru.com forums!
John
mil0n023
New Member Send Private Message
Posts: 0
New Member
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 :-(
John Henley
Send Private Message
Posts: 3351
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.
Thanks for using the LawsonGuru.com forums!
John
mil0n023
New Member Send Private Message
Posts: 0
New Member

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 :-(

 

Attachments
mil0n023
New Member Send Private Message
Posts: 0
New Member

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

 

 

mil0n023
New Member Send Private Message
Posts: 0
New Member

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

 

 

John Henley
Send Private Message
Posts: 3351

Glad you got it working!

Thanks for using the LawsonGuru.com forums!
John