static void
OGSUpdateSOTaxGroup(Args _args)
{
SalesTable salesTable;
CustTable custTable;
int
updated,all;
while
select forupdate
crossCompany salesTable
{
changeCompany(salesTable.dataAreaId)
{
custTable =
salesTable.custTable_CustAccount();
if
(salesTable.TaxGroup != custTable.TaxGroup)
{
ttsBegin;
salesTable.TaxGroup =
custTable.TaxGroup;
salesTable.modifiedField(fieldNum(SalesTable, TaxGroup));
salesTable.update();
ttsCommit;
updated++;
}
}
all++;
}
info(strFmt("%1 records processed. %2 updated",all,updated));
}
No comments:
Post a Comment