Technical and Installation Discussions

[ridgeback]

Hello, Forum - I am hoping to get some insight / help on doing something I have not done before.

Need to write a VI import job that will bring in PO Receipt of goods, and the VI job must be able to accommodate situations where there are hundreds of serial numbers being received in.  Not all receipts will involve serial numbers, but when this siutation happens, there are instances where hundreds of serial numbers are involved for one line item, or many line items.

I have tried doing this in reverse....ie, entering a PO receipt of goods that has several serials numbers in it, then writing an export job to push that data out to a csv file to see what it looks like.  Then, I dumped my receipt of goods data and tried to write a VI import job to match the file I created before.   But, on the import side, I am doing something wrong...is there some sort of logic that I am not understanding on the import?

Appreciate any insight that anyone can give me.  Thank you! 

[BigLouie]

This is a particularly difficult import because the serial numbers are kept in the Receiving Tier Distribution file which is linked to the line detail by the line index. After importing into the header and detail you have to do a second import into the tier using the Line Index from the Detail.  You best option is to use the Bar Code module which allows you to import the line with serial numbre, if they have it, Hey a new sale!

[ridgeback]

Big L....THANK YOU!!  This is pretty much what I was suspecting...I knew I had to be missing something along the way.  OK...back to the drawing board. 

I am guessing that the BOM job will have the same challenges then too, right?  Multiple VI jobs using line indexes etc??