Dynamics Community Forum Thread Details

How to update Actual Tax amount in Sales Order programmatically ?

Hi all,

This is about Sales Order question, specifically on Actual tax amount. I'm trying to programmatically update actual tax amount during Sales Order creation which also create by code.

I'm using this part of code :

            SalesTotals salesTotals     = SalesTotals::construct(salesTable,SalesUpdate::All);
            salesTotals.calc();

            if (!CustParameters::find().EnableSingleLineTaxAdjustment)   // need this parameter activated
            {
                throw Error(/@TaxEnableSalesOrderSingleLineAdjustment:EnableSingleLineTaxAdjustment/);
            }

            TaxRegulationDetail taxRegulation = TaxRegulation::newTaxRegulation(salesTotals.tax());
            TaxRegulationDetail taxRegulationDetail = taxRegulation as TaxRegulationDetail;
            TmpTaxRegulation    tmpTaxRegulationDetail = taxRegulationDetail.tmpTaxRegulationDetail();

            select tmpTaxRegulationDetail
                where tmpTaxRegulationDetail.SourceRecId            == salesLine.RecId
                    && tmpTaxRegulationDetail.SourceTableId         == tableNum(SalesLine)
                    && tmpTaxRegulationDetail.TaxAdjustmentType     == TaxAdjustmentType::Detail
                    && tmpTaxRegulationDetail.OverrideCalculatedTax == NoYes::No;

            if (tmpTaxRegulationDetail && tmpTaxRegulationDetail.SourceRegulateAmountCur != <myActualTaxAmount> )
            {
                taxRegulation.updateTaxRegulationAmount(tmpTaxRegulationDetail, <myActualTaxAmount>, true);
                taxRegulation.saveTaxRegulation();
            }

My question now, does this Actual Tax Amount sign should follow the sign of the sales amount or not ?

Or is the amount should be the opposite sign of the sales amount ?

When posting invoice I have discrepancy which looking at the message it looks like it is because the sign is not correct, or even it is actually not reflected by the actual amount.

Thanks,

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL