I know this is possible using multiple files, but is it possible to set two (or more) different lots to a single line on an SO (or any doc for that matter) using a single file? In my testing import file, all header and line item information is the same for the two lines in my spreadsheet, with the exception of Issuing Lot and Lot Qty. It is not working.

For a single file you would need to make multiple columns for each lot and qty Lot1, Qty1, Lot2, Qty2, Lot3, Qty3. And so on

I found a SA article stating that (I had forgotten about that functionality tbh), but Inventory Detail (Lots) doesn't have one of those little multi-column indicator things like Gift Certs does in my screenshot. I don't think you can make one of those appear if it's not there by default can you?

Oh yeah. I don’t think you can I think you can use the same file in a multiple file import though. I feel like I’ve done that in the past

Yeah you can for sure do it with multiple files. I've done that too. It's just that we have an automated process that currently uses only a single file and changing that to use two would be painful, so I'm seeing if there's some way we can use one. Thanks.

So is the problem you don't want to make 2 separate files? Or that your automated process can't do a multiple file upload?

I'm sure the automated process could do a multi-file upload, but not without some work on it. My team built and controls that automation, so it's not an access thing or relying on a 3rd-party vendor. But part of the automation builds the CSV files used, so we'd have to modify it to both build two files and link them. Probably not a super huge lift, but it's a lift nonetheless we could avoid if we could just add columns to our existing import mapping. 🙂

I was just saying that I think you can use the same file twice in a multiple file upload...so you don't need to create two files....

Oh I see. That's an interesting idea, thanks @MGBC. I'll have to think through that.