Importing Sales Order using "Master Repeating Order"

for promotional use, we have a Master Repeating Order that has about 20 or so items (sample product, brocures ect).  when we need to send a promotion kit, we use this and just change the ship to fields: 

 

I am trying to import a list of names and adresses and create these orders. 

 

I set the SO number to Next, I assign the Master Repeating Order to the correct order, then import the ship to fields from the file.  the job runs sucessfully, but when I go to look at the orders they do not exist and I get a message that the number has been used (and nothing in history).  

 

I'm guessing I need to run the proceedure to update the rest of the order once I put in the Master Repeating Order.  has anyone done this?

 

all help is apreciated!

thank you,

 

  • MAS version?

  • sorry,  version 4.2

  • You should be importing line items and using the Link to Master Line Index.  Are you doing that?  In other words, you'll first have to export the master order line info so you'll know the index # to reference, in your import job.

  • can you elaborate on that?  I know in versions 3.X the sales order detail file was an index file, were the header had a link to the first line and each line had a link to the index of the line before and after, but I thought that changed with 4.1?  am I missing something?  

     

    when you create a new order, and put an existing number in the Master repeating order field it call a subroutine that populates the rest of the fields.  isn't there a way to call that same subroutine durring the import process?  

     

    am I way off base?

  • Come to think of it, since you are creating new lines (as opposed to changing existing ones), you shouldn't need the index number (note:  Although there's no longer the "point to previous" and "point to next" logic in the data structure, each line item has a unique index number).

     

    I don't know of a way to grab the lines from the master order at the end of the import.  I would probably try to do it on the front end, maybe in MS Access.

     

    Sorry I couldn't be more help.  Hopefully someone else will have a better answer.

     

    Chris

  • Thank you for your time, Chris.

     

    There has got to be a way to do it programaticly,  the GUI does.  

  • Got it!

     

    added the line CoBusiness'CopyFromOrder(Var$,"S",0,0)   to program logic after assign of MasterRepeatingOrder field, 

     

    notes:  I needed to add a comment line for it to save the Order.  

    after the program logic ran, then I could change the shipto fields.

     

  • Alright!  Nicely done!

     

    Chris