Importing Orders into MAS90 - Newbie Question

[gadgetgal]

Hello Everyone:

My company buys product from a vendor who drop ships for us using the MAS90 program. Due to the volume of our orders (sometimes more than 100 separate orders a day), our vendor has requested that we send our orders via a flat file that can be imported so they don't have to type them in.

We are pretty tech-savvy folks, but since we don't use the program at all, we need a template for the order import. Can anyone point me to a flat file template?

Is there a module that we should suggest to our vendor for importing the orders? Any and all information is appreciated.

Thanks in advance...

Gadget

 

[Blorf]

Sounds to me like they are asking you to send them data so they can import into Their system. The fact that they are asking for a flat file just suggests they want a format anything at all can read.

I would ask them to provide the specs for the flat file, and you provide the data in that format.

ChaZ


There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[gadgetgal]

Blorf - thanks for your reply. I think I need to clarify my question a bit.

Yes, they definitely need us to create a file to import into their system. I'm hoping that someone in this forum has done this before so that we can get the format specs from here.

Unfortunately, our vendor isn't quite up to the job - they've lost their internal person so they don't know how to export a sample file for us to look at.

Has anyone already created a file import for MAS 90? Please let me know if you're willing to share the info...

 

[Blorf]

Yes, I am quite proficient with Mas's visual intigrator module and could likely help you.

Here are some reasons though, that with out specs from them you can not really proceed.

Mas 200 supports options for their sales order module (I am guessing your purchase orders would go to their sales orders) that with out knowing which are in use, I could not begin to help.

For example, work orders - are your PO's fulfilled by a sales order then a work order?

Say they have multiple warehouse - which warehouse should your file call out?

Are they using Job Cost instead of Work Order? Or neither?

With out these questions being answered, any advice anybody gives you would just be a guess.

Lets say though that it is really simple. They provide you with no custom items, it's just a garden variety merchandizing style transaction.

In that case, a part number and a quantity, and a PO number would likely be all you needed to send them. But I don't know that.

Sorry I can't be more help, but there just isn't enough information.

Further, I know nothing about your system. My advice would have to include how you get the data out of your systems into the format they need for their system.

We just don't have enough information to offer any more advice.

ChaZ



There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[gadgetgal]

Blorf:

Thanks so much! Now I have a much better idea of the scope of this little project, and some guidance as to what questions I should ask our vendor.

Sheesh...the easiest thing to do would be to have them export a couple of our orders from their system so we can then map our own file to match, but I don't think they know how to do that.

You have been extremely helpful, and I hope you're around for more pearls of wisdom when we get this rolling.

Thanks again...

 

[Blorf]

Glad to help. Only regret is that I can't help you move your project along.

Post if you have additional questions and I will do my best to answer.

Thanks,
ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[BigLouie]

Actually do you really do not need much. Here is my take on it.

Since they already know who you are you do not need to give them a customer number or billing address information.

If you ship to more than one location they you would need to give them address, city, state and zip code information of where you want it shipped to.

Your purchase order number.

Next would be the item number. You would need to give them their item number. Is there a way in your system to set up alias item numbers so that when you export you have their item number in the flat file.

Quantity

Price that you will pay for the item.

This is all they need to build their import. The rest such as tax schedule, terms they setup on their end. I once helped a company do an import where all the customer sent them was a file with just two fields, item and quantity.

 

[BigLouie]

Forgot to list the fields in order.

1. Ship To Address (if needed)
2. Ship To City (if needed)
3. Shipt To State (if needed)
4. Ship to Zip (if needed)
5. Your purchase order number
6. Ship Date (Date you want it to ship)
7. Item Number (your's or their's)
8. Quantity
9. Price

This is all you need to give them for them to be able to build a succesful import.