I don't believe you need to create two orders for this.  You can create one order and have different warehouses for each line item on the sales order.  Each warehouse can print this order and ship the items that come from their warehouse.  I believe this will result in two different invoices for the order.  

Will that work for you?

I have asked several different sources about exactly what you are talking about and have been told that it is not possible.

I am with you, because it seems to me that this should be possible, but no one else seems to think so.

Are there any specific processes or actions that need to take place to make this work correctly?

nbirkes,

I would think you can test this yourself by doing the following.  Open up sales order entry and input an order and input two line items and change the warehouse for one of the line items to be a different warehouse.  Then process the order by invoicing it once for the one line item from the first warehouse and then invoice again for the second line item from the second warehouse.  I can't imagine why it wouldn't work.  

Are you perhaps worried about creating the sales order using eBusiness Web Services?  If so, I can't comment knowledgeably on that process, but we use a product called InSynch to receive orders from multiple web sites and import these as sales orders into Sage 100.

It will not work for them because they will attempt to do shipping data entry on the same sales order from two different warehouses and at present Sage 100 will not allow you to do that. As you noted you must post one invoice before you can start on the other and in their case this is not really possible.

BigLouie,  

Thanks for pointing that out.  I didn't think about the need to simultaneously ship on the same sales order, but you are right that Sage doesn't allow that currently.  I guess they are better off doing 2 warehouses.  Maybe they could create two sales orders but link them using the same number in the Customer PO field or perhaps they could use the same sales order number and use a A or B at the end of the order number so they know they are linked somehow.

Thanks for the response Louie. I just wanted to ask the guys with a little more Sage knowledge before I tore into some code.

Tyler, I really like the A B idea for related sales orders. I think I will use that!

Nathan, the problem with using the A and B idea is that you  now go from having 9,999,999 possible sales orders to having 999,999 possible sales orders

One suggestion I gave Trey was that you use the Pack feature of shipping data entry.  At warehouse 0001 you open shipping data entry for the sales order and pack everything from that warehouse into Package 1. Close Shipping Data Entry, print out the packing list and check the box to print out Additional Packing List. This will give you everything shipped out of warehouse 0001. Next warehouse 0002 goes into shipping data entry and packs everything they ship into Package 2. They then close Shipping Data Entry and print out the packing list and check the box to print out the Additional Packing List. This will give them a packing list for Package 2.  I am not sure how StarShip would work, that you will have to test on your own. MAS errr Sage 100 does not know and does not care that the two warehouses are not physically in the same location. You can then update the single invoice that was created. Note that you can have tracking number by package!

BigLouie,

You are correct that the A/B suggestions limits the number of orders possible, but you have far more options that the 999,999 you suggest.  Because the sales order field is alphanumeric, you have "A"-"Z" available as well as "0-9" available so you have at least 36 options per character.  This doesn't include all the special characters like "#" and "$" either.  The correct number of possibilities is beyond 36 to the 7th power.  Of course, if you limit the seventh character to A or B, the options are now 36 to the 6th power x 2 = 4,353,564,672.  That should support a very large number of transactions.  

However, let's say you want to restrict the options to numeric only, then you would still have 1,000,000 x 2 (10^6 x 2 available numbers.  Even if you did a thousand orders per day, you would have 2,000 days available or roughly 8 years (at 250 business days per year) before you would need to start over again.  

This sounds like a terrific idea.  I like it a lot.  I have not used this feature so I am not as familiar with it.  Is it standard Sage 100 meaning all this is included out of the box?

I will test out these solutions. Thanks for your input guys!

I will test out these solutions. Thanks for your input guys!