Invalid Job Number when pasting into Subcontract Shipment Entry

Epicor ERP 10
1

Due to the volume of Subcontract Shipment Entry items, we are looking to semi-automate the process. Using a dashboard we collect the relevant upcoming shipments, sent to Excel, update, copy to Lines>List tab.

We are finding that it will work 90% of the time then gets cranky and throws an invalid job number error constantly (re: the error is constant for an extended period of time).

We have verified that the columns match (between Excel and Lines>List tab). Even more odd - jobs that worked previously no longer work (re: when there are multiple subcontract operations).

Anybody experience this previously? How did you avoid this “random” error?

2

Have you done any traces or server logs/event logs to try and see any similarities in the data, or more detail about the error?

How many rows are you trying to paste in at a time?

3

I haven’t tried traces yet. It doesn’t matter how many rows 1 or 15. I’ve had as many as 18 rows upload no problem! But once the error triggers it doesn’t matter.

I will see what the log tells me when it shows up again.

4

What’s the error? What is the trigger to resume processing, just waiting, closing the client, recycling the app pool?

1 Like
5

While it may appear to be random, does a record it failed on work, if pasted by itself?

To be clear, say you have 20 records (20 rows in Excel), and when you use Paste Insert, it errors out at row 13.

Try the following:

  1. Delete the incomplete row that was created. Usually, the Paste Insert first makes a new blank row, then copies the clipboard to it. If it fails, it will leave that “incomplete” row in the grid.
  2. Copy just record 13 from the Excel file
  3. Paste Insert into the grid

If that works, then I’d say that there is something happening in the background that gets out of whack with the newly added records.

Perhaps try doing the Copy and Paste Insert in small batches (like 10 records at a time).

Scrub the data in the excel file to make sure it is free of control characters (char 0 - 31), “web” chars (likem em-dashes), and others. Also do a replace Non-breaking spaces (CHAR 160) ) with regular ones (CHAR 32) .

1 Like