Search results for query: *

Cracked it, I think the batch number anomaly must have been a red herring (hope this is not an English only phrase?). Problem was that I included the [H.ShipperID] and [H.CommentText] in the data definition with Replace operators and refereces to columns that were the wrong format / didn't...

Thanks, I'll have a look at that. Any idea what could be causing my error message?

D'oh - didn't know that! Yes I have it set up currently so that a user can assign a batch number if they like but it's not essential functionality. Is there is a way of automatically assigning the next batch number to the whole import?

Hi All Here's a quick update on this - I decided to try using MS access as a intermediary vehicle to make this work. The database sits on the server & I import my shipping data text file. Sage's live order info is then exported via a VI export. A simple query brings the two together & is the...

MASGuy - sorry, I should have mentioned this earlier! I have two chained imports running that pickup the same text file for their import. The first is importing into SO_InvoiceHeader and the second is importing into SO_InvoiceTracking. It's only the one importing into SO_InvoiceHeader that's...

Hi All Not sure if anyone can help here? I'm trying to finalise a visual integrator import in MAS 200 (version 4.30). This VI job will import shipping information from our 3rd party fulfilment operation via a simple delimited text file the pass to us. The aim is to automatically populate...