Purchase Receipt Creation skips every other line with Import Scenario

I would change the first save into a <dialog answer> = ‘OK’ . I think the first save is a problem and I think a dialog answer is usually required with these types of imports.

You should also connect via the line nbr rather than inventory item if possible. With inventory ID, it will only update the first record with that inventory ID and not update the 2nd or 3rd.

Thank you!

The good news is that after adding the Dialog OK, the process finishes. The bad news is that it doesn’t actually add the lines.

Would you mind elaborating on the setup for connecting on the line numbers? I guessed it was like this:

Should be @@LineNbr not Line Nbr., same as how you have @@InventoryID. I don’t think you need the 2nd order nbr key, but you will need to add the order nbr again if you leave as is.

That key was added for LineNbr, so as soon as I took it way it was gone, thankfully. Unfortunately this falls into the same issue. Adds an empty purchase receipt.

I feel like I’m missing something entirely. There’s gotta be a way to just upload these in, right?

I think the issue is your data source. Typically, you have a list containing all of your purchase receipt line numbers to connect to. These would exist in an external field. Right now, you are mapping to the internal field (ex. [poLineSelection.LineNbr]) rather than something that exists in your spreadsheet (an external field). 

If in your spreadsheet, all you have is the PONbr, then you may need to design this process differently. 

The way I would design this would be to have my spreadsheet import scenario update a UDF/attribute checkbox on the POOrder. When the POOrder exists in my spreadsheet I would then update that checkbox. That would be the only thing this import scenario does.

From there, I would create a GI that lists out all POLines. It would have the LineNbr, order type, and order nbr fields listed in my GI. These are the fields that the “add purchase line” import scenario needs to have available in order to run correctly.

When that checkbox is marked as true, then a GI business event import scenario automation would update create the PO Receipt and add the lines. This 2nd import scenario would look similar to what you created but would use a GI as a data provider.

This GI would be filtered to only show PO lines not completed.

That suggestion made a lot of sense and I went down a fun rabbit hole of how to add numbers to groups, but, I got the Data Provider squared away.

Unfortunately I’m still getting no data on my detail lines from the scenario routing through Add PO Lines
 

You will need to add a 2nd line for Line Nbr = Line Nbr. Not sure if order nbr is necessary

If this does not work, you could try this…

Goodness, that seems like it should work. I’m starting to wonder if something is wonky on our end because it doesn’t.

Thank you so much, unfortunately my department hit the point of frustration over this that we’re asking our VAR to help. I’ll try to come back around and post what they do.