Skip to main content
Question

Import Scenario Error Message 'Location ID is Null'

  • May 7, 2025
  • 0 replies
  • 16 views

Forum|alt.badge.img+1

I am trying to create an import scenario, 

 

Using the QMS module, I want to create an ADHOC QC Order automatically, but my import scenario is getting an error that the Location ID is null.

 

This is the full error:

“0 records of 1 have been processed. The last error was An error occurred during processing of the field Qty: Location ID is null.”

 

 This error is weird, I have the LocationID mapped and I don’t see any reason that the Location ID is having issues. 

 

I would expect that my QC Location would be the thing to cause issues. My QC Location is an expression that checks if the location starts with a Q, and if so, Removed the Q and leaves the rest of it, or else leaves it alone.

=IIf(Left(CStr([INLocation.LocationCD]), 1) = 'Q',        

 Replace(CStr([INLocation.LocationCD]), 'Q', ''),        

 [INLocation.LocationCD])

 

This process is supposed to be for releasing items out of our ‘Q’ or ‘Quarantine’ locations.

 

Can anyone help me figure out why my location ID might be null? I tried using the Action: SaveLoc for both start location and QC location, however the error I received was that it could not find Action: SaveLoc  which was really odd.