Microsoft Dynamics AX (Archived)

Copy item to another company in coding

(0) Share

Report

Posted on by Anton Tjiptadi

2,013

Hi,

May I know how to copy item (InventTable, InventTableModule, InventItemLocation) to another company / dataarea.

How to change the dataarea because after I copied my InventTable, changecompany, and try to insert, the dataarea will follow the first company which is will produce error because duplicate record.

Thanks,

Axl

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Community Member on at

Like (0)

Report

Hi,

Use this code to insert the records in another company:

changecompany('dmo')

{

//Place your code here of insertion or any operation.

}

Regards,

Yousef Shawareb

Was this reply helpful? Yes No
Ivan (Vanya) Kashperuk on at

Like (0)

Report

Just make sure to assign a null to the table buffer variable you will insert inside your changecompany statement:

InventTable itFrom;

InventTable itTo;

itFrom = InventTable::Find("OL-1000");

changeCompany("OTH")

{

    itTo = null;

    buf2buf(itFrom, itTo);

    itTo.insert();

}

Note, that I wrote it right here inside the editor, so I am not sure this compiles.

Was this reply helpful? Yes No
Anton Tjiptadi 2,013 on at

Like (0)

Report

Hi,

Thanks for the reply.
I've found one good example code for this... Thanks for the original author :)

static void Transfer_Rec(Args _args)
{
    DictTable         dicttable;
    DictField         dictfield;
    Common            common,common1;
    int               fieldcnt,i;
    fieldId           fieldid;
    UserTable    TempTable,TempTable1; // UserTable is the table, whose data u want to copy

    ;

    while select TempTable
    {
        common = TempTable;
        dicttable = new DictTable(common.TableId);
        changeCompany("tst")
        {
             TempTable1 = null;
             common1    = TempTable1;
             fieldcnt   = dicttable.fieldCnt();
             for (i = 1; i <= fieldcnt; i++)
             {

                fieldid   = dicttable.fieldCnt2Id(i);
                dictfield = new dictfield(common.TableId,fieldid);
                if (dictfield.id() == fieldname2id(common.TableId,identifierstr(dataareaid)))
                    continue;
                else
                    common1.(dictfield.id()) = common.(dictfield.id());

             }
          common1.insert();
         }

     }
     print strfmt('done');
     pause;
}

Again, Thanks :)

Was this reply helpful? Yes No
Ivan (Vanya) Kashperuk on at

Like (0)

Report

Sorry, but this example is not actually good.

I suggest you use the one I suggested above. It does absolutely the same, but without the tons of redundant code.

Was this reply helpful? Yes No
Rola Halabi 135 on at

Like (0)

Report

hi Ivan,

how about if i want to import the entire table, not just that one row with the Id? lets say i want to copy the employee table from an AX company to another?

Was this reply helpful? Yes No
Ivan (Vanya) Kashperuk on at

Like (0)

Report

If you are on an AX installation which has the crosscompany keyword, you can do insert_recordset emplTable (EmplId, ....) select crosscompany : YourCompanyContainer EmplId, ... from emplTableSelect; If not - row by row with changeCompany()

Was this reply helpful? Yes No
Anton Tjiptadi 2,013 on at

Like (0)

Report

Hi Ivan,

YOU'RE THE MAN !!!!!!!!!!!

I've tried using your method and it works. Thanks a lot.

regards,

Was this reply helpful? Yes No
user5555 7,437 on at

Like (0)

Report

Hi,

I have item X and would like to create item Y which is similar except of the item no (SKU). Does anybody have a piece of sample code to share? I think a copy function with a modal dialog for the new name of a GUID would be great.

J.

Was this reply helpful? Yes No
Ivan (Vanya) Kashperuk on at

Like (0)

Report

Do you really need to code? What about the standard record template? I think that's exactly or almost exactly what you need

Was this reply helpful? Yes No
user5555 7,437 on at

Like (0)

Report

Hi,

It does not copy the dimensions (in our case: sizes) and the item coverage. If I could change this, that would be great.

J.

Was this reply helpful? Yes No