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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.