Is running a Navision company with one “Company” and multiple locations, whereby one company is in Manchester (a Navision location) and orders from Birmingham (a Navision Location). The Birmingham Location then sees the demand and ships to Manchester. I would be interested to know if anyone has got this system working, and how they have accomplished it, or if they have accomplished something similar setting the two locations up as seperate companies and dataporting information between the two. Thanks Steve
Hi, We did this several times. You should create Purchse order in one Company and Sales Order in other. When one Location Ship goods you post Sales order when other receive goods you post Purchase Order. We create function that create SO from PO in other company. Also we create a lot of additional functionality around this becouse we have clients with 30…125 companies in one database.
quote:
Originally posted by SBWEAVER: Is running a Navision company with one “Company” and multiple locations, whereby one company is in Manchester (a Navision location) and orders from Birmingham (a Navision Location). The Birmingham Location then sees the demand and ships to Manchester. I would be interested to know if anyone has got this system working, and how they have accomplished it, or if they have accomplished something similar setting the two locations up as seperate companies and dataporting information between the two. Thanks Steve
Valentin Gvozdev BMI Inc.
Hi, The Commerce Gateway (BizTalk) which is going to be released (hopefully) soon will handle this. Lars Strøm Valsted Head of Project and Analysis Columbus IT Partner A/S
Valentin, I think you missed my point, there is only ONE company from a Navision perspective, but there are two “Locations” that buy and sell seperately but also buy and sell from each other, rather than simply doing an Inventory adjustment, you load orders and invoice seperate locations. I cannot see it working for a variety of reasons and prefer the later option whereby we have seperate companies and as you have, electronically transfer purchase orders from one company into sales orders in another. On this point, where you bought and sold from seperate companies, did your companies have to follow the produce invoice (Co 1), put invoice on purchase ledger (Co 2), Pay invoice (Co 2) and receive Payment (Co 1) or did you automate this process. This could feasibly be done because although they are seperate companies they are one legal entity and ultimately payment is rolled up into one bucket. Anyway, thank you for your input. As for Lars, thank you also, I was aware of the “imminent” release of Commerce Gateway, but I was just seeing if anyone had handled anything previously, and there is the fact the release may be some months off yet! But thank you anyway. Steve Steven Weaver XONITEK Systems (UK) Ltd +44 (0) 23 80641175 (Tel) +44 (0) 23 80641173 (Fax)
Hi Steve, I also missed the point regarding only one company 
However, I don’t think the Commerce Gateway release is several months away. This I base on the following argumentation: 1. NavisionDamgaard has previously said that they will release Commerce Gateway 4 weeks after Microsoft releases the BizTalk 2000 Server. 2. On December 12, 2000 Microsoft announced that the BizTalk 2000 Server was released to Manufacturing (see http://www.microsoft.com/presspass/press/2000/Dec00/ManfReleasePR.asp). 3. After release to Manufacturing the GA (General Availability) is normally max. 8 weeks away, meaning a GA Date no later than Feb. 12 (oops, they’re already late ) 4. That makes me conclude that Commerce Gateway will probably be released no later than April 1, 2001. But then again, It’s just my guess Lars Strøm Valsted Head of Project and Analysis Columbus IT Partner A/S
You can modify tableno 14 (warehouse) including in fields from direction. When you validate field 28 (warehouse) in tableno 38 (Cab. purchase). You can Modify it transfering direction fields from warehouse
As Valentin said, we (Business Management International) did this for serveral of our bigger clients with many locations and warehouses all over the US. So I don’t think Val missed the point The Item Transfer Journal is what could be used to solve this by means of standard Navision only, but the standard functionality isn’t far enough, if you have a lot of these transfers. Additionally we needed the following:
- To see what transfer has been planned for each location, expected shipping/receipt, in-transit etc.
- To add Landed Costs (transport etc.) to the items
- To do a correct inventory valuation for items in-transit
Basically we have been utilizing the functionality Item Transfer Journal (means a lot less programming work), and we have created the different locations as both customers and vendors. Additionally we have a “in-transit” location. If you don’t have these extended requirements, then the standard Item Transfer Journals can be used. But AFAIK most companies with distribution and manufacturing would require more than standard. Best regards, Erik P. Ernst, webmaster Navision Online User Group
Hi Steven Hope I’ve interpreted your question correctly 
I’m told that we are the first company in the UK to implement Navision’s advanced distribution module. It delivers a great deal of functionality, as well as the multiple location control that you speak of. Using advanced distribution, you simply create an inbound/outbound transfer, which generates a sales & purchase order but tags them as inter-company transfers, therefore making them zero-valued. Once the goods are despatched from the issuing location, the items are moved to an “in transit” location, meaning they remain on inventory as they should. Once the items are received at their destination, the transaction is complete. At the same time, the correct shipment and receipt notes are created. We’ve used this on our system and I’m generally pleased with it’s integrity. Regards Kurt Caravell (UK) Limited
Kurt Cheers for the reply. I reallly must be more careful how I express myself as you can cut the sarcasm with a knife at times! Anyway I have looked at the literature surrounding Advanced Distribution, but avoided going down this line simply because (i) Solutions 3.0 contains a lot of the functionality as standard and is released later in 2001 (ii) My problems are more complicated than originally stated. I thought I would start simply and see if anyone had done this simply. Further to my original question I also need multiple costing and reordering functionality by location (incorporated in Solutions 3.0 with “Stockkeeping Units”) and planning over multiple locations (MRP and MPS) (kind of incorporated in Solutions 3.0 i.e. I cannot yet get it to form a “Transfer” recommendation although the flag is there!) However, the discussions have certainly been interesting so thanks to one and all for the contributions. Steven Weaver XONITEK Systems (UK) Ltd +44 (0) 23 80641175 (Tel) +44 (0) 23 80641173 (Fax)