Sage 100

We are trying to import Work Order Routing Header Record (WOC). The problem that we have run into is that the Key should be written out for 24 characters. 20 characters for the Routing Number and 4 characters of blanks for the step number. The first data element should be written out for 100 characters: 20 characters for the Routing Number, 4 characters of blanks for the step number, 30 characters for Description, and 46 characters for open string. The result we are getting is that the Key is written out for 20 characters. 20 characters for the Routing Number. The first data element is written out for 100 characters: 20 characters for the Routing Number, 4 characters of blanks for the step number, 30 characters for Description, and 46 characters for open string. Any insight or solutions would be appreciated.

Are you doing 2 different imports - one for the header record and a second one for details? If not, I'd try that first - I have successfully imported in that manner.

Do you have a 3rd party solutions? I encountered similar issues attempting to import into one of the other work order tables a while back for a client that had a bunch of scanco add-ins like work order efficiency, multi-bin, and woscan. Somewhere along the lines, something got messed up that determines how VI sees the table definition. I don't think we ever got it fixed.

@BethBowers I tried 2 different imports and it didn't work. @DavidSpeckII customer doesn't have any 3rd party solutions. Any other ideas?

And are you doing an Assign of <blank> in that Step Field for the first import (header)?

We use two imports for routings, both to the WO.ROUTING file- First one has the Routing Number, Blanks that are assigned and a Routing Description. Second import job has the Routing Number, Step Number, Work center, Operation Code and Step Description, Ignore Queue, Standard Run Type, Parent Item Type, Sytext Description, Parent Qty Factor and Run Time.

I just joined 90minds and I have been working on this with Shannon. The key is being written with the 20 character routing number but no step number. The problem seems to be with the field name BLANKS or with the field STEP. I have attempted Assigning the field with 4 blanks in both cases. I am changing the operation to assign and in the default field I am hitting the space bar 4 times. This does not seem to work.

Are you also choosing the Header Record on the Records tab?

That worked! Thank you Beth.