Saturday, May 18, 2019

Update SalesTable Taxgroup


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