Insert Item from Company A into Company B

tompynation

Hi,

I would like to achieve the following:

When there is an item Created in Company A, this item should also get Created automatically in Company B
Same when updating in Company A, the item in Company B should also be Updated...

How can i achieve this ?

matttrax

Item.CHANGECOMPANY(Other Company);
//Do you thing with the item

tompynation

How you mean ChangeCompany and then do your thing...

When i am in the OnModify function of the Item table (Comp. A), how will i know if the item exists in Comp. B ?
And how will i update it then, or if it doesnt exist insert in Comp. B

matttrax

Sorry, thought it was clear from the code.

Say you are in Company A. Item is a record from the Item table.
In OnInsert or OnModify you would need to do:

Item.CHANGECOMPANY(Company ;
IF NOT Item.GET("No.") THEN
Item.INSERT;

The CHANGECOMPANY function literally points that record variable to another company, so even though you may be operating in Company A, that record variable will only see records in the company you've changed to.

Is that more clear?

jversusj

matttrax wrote:

Sorry, thought it was clear from the code.

Say you are in Company A. Item is a record from the Item table.
In OnInsert or OnModify you would need to do:

Item.CHANGECOMPANY(Company ;
IF NOT Item.GET("No.") THEN
Item.INSERT;

The CHANGECOMPANY function literally points that record variable to another company, so even though you may be operating in Company A, that record variable will only see records in the company you've changed to.

Is that more clear?

..but remember to watch any field that validates, as the validation logic will not be impacted by the change company logic (in some cases you can get away with it (like if the validate is just a lookup to a table that contains the same data in all companies). i'd search the forum for CHANGECOMPANY and learn from that.

Alex_Chow

This process has been described my blog... :oops:

http://dynamicsuser.net/blogs/alexchow/ ... n-5-0.aspx

garak

Follow the link.

viewtopic.php?f=23&t=32588

In this post is also the link to Alex's BLOG

Regards