TotalTaxAmount SetTaxAmountByRow not working

Question

Hi, 
 
 I am trying to update invoice's total tax using below code 
 TaxSummaryInfo taxSummaryInfo = journal.GetTotalTaxAmountInfo(); if (taxSummaryInfo.GetCount() > 0) { double totalTax = 10; taxSummaryInfo.SetTaxAmountByRow(1, totalTax); taxSummaryInfo.Save(); } 
 But it's throwing error, field you are trying to update is not accessible. 
 Is there anything wrong or any suggestion to make it working? 
 Thanks in advance.

Richard S. Ridings · Accepted Answer

As i said, I don't use the SDK so I don't know all the methods. I'd have to read the help files just like you do. 
 So I am going back to the logic of why you need to update only the total of the invoice without updating the tax on the line items. 
 eg. 
 Line 1 Amount $100 HST @ 13% = $13 
 Line 2 Amount $150 HST @ 13% = $19.50 
 Total tax should be $32.50 
 
 But if for some reason, the original invoice has a total tax of $32.51, is this your situation? 
 If so, then you may have a line item like the following 
 
 Line 1 Amount $81.75 HST @ 13% = $10.63 
 Line 2 Amount $149.66 HST @ 13% = $19.46 
 Total tax should be $30.09 
 
 But if you calculate the total tax on the total of each line items then 
 $81.75 + $149.66 = $231.41 @ 13% = $30.08 
 
 If this is your scenario, I think you should be updating the tax on the line and I would hope the total tax would be updated as well. A couple of quick tests should be able to show you what happens. 
 
 If not, then you will have to use SQL commands to do the update of the total tax once you validate the total tax based on each line. 
 And yes I know the total tax in the program can be updated with Ctrl + Shift + Y but in sales invoices, this also results in a dumb line at the bottom of the customer invoice printout indicating the tax not included in the lines. So why would there be tax not included in the lines when the tax is supposed to be calculated on the amounts on the lines? 
 You don't see this on the purchase invoice side because you can't print a purchase invoice.

Richard S. Ridings · Answer

I may not be able to help because I don't use the SDK and I don't read C# very well. 
 However, if you are getting the Total Tax Amount, is this the total tax for an invoice found in table titlutot? Is this the amount you see in the Ctrl-Shift-Y dialog in Sage 50? 
 If so, then this is not the same as the line item rows of each invoice. It looks like SetTAxAmountByRow is attempting to set the tax you see on each record of an invoice that you see in the Ctrl-Y dialog in Sage 50. eg. 
 Nil said: taxSummaryInfo.SetTaxAmountByRow(1, totalTax); 
 is the first row of the invoice, not the total tax of the invoice. 
 If so, is it possible the SDK allows for updating the rows and will calculate the Total Tax for the invoice for you? In this case GetTotalTaxAmountInfo fields might be read-only or you need a SetTotalTaxAmount method? 
 Just a guess!

Richard S. Ridings · Answer

That is exactly what I thought you were doing. But I thought you would be changing the amounts in Sage 50 to match your own application. 
 The problem looks like you have programmed the other application to calculate the tax based on the total of all items that are applicable for that tax, while Sage 50 has always calculated the sales tax by line, rounded to two decimal places and then add up the amounts. This causes the confusion between programs. Both methods are acceptable to the CRA as long as the one used, is used consistently. 
 Before you post your invoice to Sage 50, I thought you could just run a quick calculation of the invoice sales tax the way Sage 50 will calculate it, compare it to your's and then just add/subtract the difference if applicable, from one of the line items that has that tax code on it (yes I know that I just made it sound simple but that programming is likely a few hours work plus testing). 
 I just took a look at the 2020.2 SDK help file. It looks like the the TaxSummaryInfo Class might be used on entries that are already posted. Are you trying to use it before it is posted?

Richard S. Ridings · Answer

Nil said: Yes, I am already using 2020.2 SDK and TaxSummaryInfo class is there and its returning Total Tax info but there is method to SetTaxAmountByRow but its not working. 
 Are you posting the entry first, then asking for the Total tax? If so, are you getting the total tax from the correct entry? Or is it the total tax from a vendor invoice or a different customer invoice? 
 If it is the correct amount, then I am guessing the error is on the SetTaxAmountByRow. So you would need to check to see what the full error indicates (maybe there is something in the InnerException message). I would suspect you are not referencing the proper invoice when setting the row tax. Based on your sample as well, you are trying to set the total tax to be the same as the row tax and I don't think that is what you really want.

Sage 50 Canada

TotalTaxAmount SetTaxAmountByRow not working

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING