As a newbie as i am… i have to ask if there is a standard function or something that let me put data (example an ordre) from one company to antoher. Description: I have two companys (c1 and c2). And when the user is making a sale in c1 i have to generate a purchase automataically in t2. So therefor i have to send the item and the qty from c1 to c2. Anybody know a way to do this without making tons of code? [:p] Regards Frode Dahl aimit as
CHANGECOMPANY. Be very, very carefull …
Possible, but the problem in your request is ‘… without making tons of code’. If you use ChangeCompany, you are not able to use the Validate function anymore. So you have to copy the code normally used by the Validate-trigger/function. As I said, possible. But not a really smart solution. Kind regards Walter
Changecompany is very unfreindly for such a large amount of development. Could you utilize a new table (Datapercompany = No) populate this table with the necessary fields and values then run a process in the new company to create the P/Orders???
I would definately not use CHANGECOMPANY, for the reasons as mentioned. We did a similar thing before and it’s along the lines of Andrew’s suggestion. There wasn’t tons of code involved. Try this! [;)]
If you can turn the logic backwards, that is, run the PO creation from within the vendor company, everything will be much easier and safer. I have a processing only report, which retrieves purchase order info by use of changecompany, and creates a sales order in the customer company. But aren’t you missing a couple of steps? 1. Sales order in C1, external customer → 2. Purchase order in C1, vendor C2 → 3. Sales order in C2, customer C1 4 Purchase order in C2, external vendor Or did I misunderstand your scenario? Pelle Your situation is similar, except that you start with the sales order. You
quote:
Originally posted by pelle
If you can turn the logic backwards, that is, run the PO creation from within the vendor company, everything will be much easier and safer. I have a processing only report, which retrieves purchase order info by use of changecompany, and creates a sales order in the customer company. But aren’t you missing a couple of steps? 1. Sales order in C1, external customer → 2. Purchase order in C1, vendor C2 → 3. Sales order in C2, customer C1 4 Purchase order in C2, external vendor Or did I misunderstand your scenario? You
Well Pelle. You did not misunderstand but i did not tell you in the first post that they will run on equally customer / vendor database. They will replicate the data each night. This is a system there the customer take out an order in norway (c1) and norway send the order to denmark (c2) for repair work or similar work. But i think we will try the table where u set “false” on the percompany [8D] Thnx for all replay [:)]
Just have a tiny piece of code in C1 or C2 to create a Purchase requisition in in t2. Then just get hte user in t2 to process the ation items.