Sage 100

When importing Purchase Orders, we can't get past "The Warehouse Code is required".  Every header record fails. Running it as a test is fine, it's only when importing for real. The line records seem fine. The log file record detail shows Pass for all fields.  We even tried assigning the Warehouse Code, but it didn't make a difference. We thought maybe a customization is preventing the import, So we disabled customizations(*ESC), and the renamed the links folder. No difference. Anyone have any ideas? 

Sage 100 2023 Premium

------------------------------
Bill Pfahnl
Nims & Associates
------------------------------

UDF with that field name, also marked as required?

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

The warehouse code changes when you change the ship-to Code. Could that be causing it? If you look at that ship-to code 050, does it have the warehouse code filled in?

try assigning the warehouse code before you assign the ship-to code and see if that makes any difference? 

------------------------------
David Overholt
DWD Technology Group
------------------------------

@David Overholt and @Kevin Moyes ideas seem promising.  If neither of those solve it you may try taking it down to the studs.  Start with the minimum fields and build it up one or two fields at a time until the error appears.  Here's one that works:

------------------------------
Doug Higgs
Midwest Commerce Solutions, Inc
(312) 315-0960
Chauffeur, Chef, and Personal Assistant to Sprinkles
------------------------------

Thanks everyone for the suggestions. Turns out the header warehouse field was the culprit. If I imported the header warehouse, it failed. If I removed the field from the job and let it default, it succeeded. Not sure if this is a bug in 2024, since it worked fine in earlier versions.

------------------------------
Bill Pfahnl
Nims & Associates
------------------------------