crossCompany from update_recordset

(0) Share

Report

Posted on by Community Member

How can i use crossCompany from update_recordset? I want to update my temptable record with custTrans table
My temptable, I already inserted records using crosscompany.

Relation
MyTempTabel.voucher == custTrans.voucher

I nead to update MyTempTabel.invoiceid=custTrans.Invoice

both tables I need to get all crosscompany records. I used the following script but I am getting blank

ttsBegin;
while select crossCompany custTrans

{
changecompany(custTrans.dataAreaId)
{
TmpTaxTransactionRDP = null;

select forUpdate TmpTaxTransactionRDP
where TmpTaxTransactionRDP.voucher == custTrans.Voucher;
if (TmpTaxTransactionRDP)
{
TmpTaxTransactionRDP.SourceInvoiceNo=custTrans.Invoice;

TmpTaxTransactionRDP.update();
}
}
}
ttsCommit;

Thanks & Regards

Avinash Moosa

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Mea_ 60,284 on at

Like (0)

Report

Hi Avinash Moosa ,

If TmpTaxTransactionRDP has "savedatapercompany" property = "No" then you can use next script:

ttsBegin;

while select crossCompany custTrans

{

select forUpdate TmpTaxTransactionRDP

where TmpTaxTransactionRDP.voucher == custTrans.Voucher;

if (TmpTaxTransactionRDP)

{

TmpTaxTransactionRDP.SourceInvoiceNo=custTrans.Invoice;

TmpTaxTransactionRDP.update();

}

}

ttsCommit;

Was this reply helpful? Yes No