How to transfer a salesorder or multible recods from one company to another .

Hi…

How to transfer a record or insert a record from sales table of one company to sales table of another company in ax2009 .Actually i have managed to to send the salesorder, but unable to send the items related to the salesorder,Can any one help me

thanks regards

Hi,

I use a simple job for that.I transfer all data from one object to another of same type, except field “DataAreaId”.

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;
}

Rajkumar ,

Hi

Sir

When i am trying this code.i can post details to another company.But When i am opening SalesOrder details That shows below error

"numberseq for the refrence. dimension no.in parameter in inventory management module has not been setup’

thnks&regards

pv narasimharao

Hi pv,

Try this code .

salestable s,s1;

str Company;

;

company = curext();//stores the company name;

while select s where ((s.Updated == noyes::No) &&(s.migrated == noyes::Yes))

{

if((s.SalesType == SalesType::Sales) && (s.SalesStatus == salesstatus::Backorder))

{

// info(s.SalesId);

ChangeCompany(“PVK”)

{

// ttsbegin;

s1.SalesId = Company + “_” + s.SalesId;

s1.CustAccount = s.CustAccount;

s1.CustGroup = s.CustGroup;

s1.InvoiceAccount = s.InvoiceAccount;

s1.ShippingDateRequested = s.ShippingDateRequested;

s1.SalesType = s.SalesType;

s1.CurrencyCode = s.CurrencyCode;

s1.LanguageId = s.LanguageId;

s1.DlvMode = s.DlvMode;

s1.insert();

}

}

s.Updated = noyes::Yes;

}