Tax Schedule ID error message

(0) Share

Report

Posted on by Sharon Burley

We use AvaTax and recently we've started getting an error message when trying to post invoices from sales transaction entry. After posting a batch, the Sales Posting Journal will show message:

ERROR: No tax schedule or detail exists for this ID.

Transactions with this error message do not post. I found that if i reselect the tax schedule ID, I can then post the transactions. But I'm wondering what is causing the message in the first place. Tax appears to be calculating just fine. Has anyone else been dealing with this?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Community Member on at

Like (0)

Report

I am having the same problem but when i re-select the tax schedule it is still not posting.

Was this reply helpful? Yes No
L Vail on at

Like (0)

Report

I use Avatax and have not experienced this. Each of our tax schedules are simply AVATAX. I have seen it on other clients. The error cleared after running check links on the Sales Tax master. For AVATAX, do you have the tax detail AVATAX assigned to the AVATAX tax schedule?

Are you posting To or Through GL?

Are you posting the SOP transactions normally, or are you using an automated solution?

Kind regards,

Leslie

Was this reply helpful? Yes No
Sharon Burley on at

Like (0)

Report

Sorry for not responding earlier. For some reason, I didn't get notified that anyone else had posted to the thread. Anyway, we post through to the GL. We are not using an automated solution. For Avatax configuration, we have the Tax Schedule ID as AVATAX and that is the Default Tax Schedule in the Tax Calculation screen of the Configuration. Within GP, we have a Tax Detail ID AVATAX and we have a Tax Schedule ID AVATAX. When I go into the Tax Schedule Maintenance window and select the Tax Schedule ID AVATAX, it shows that the Selected Tax Detail IDs is AVATAX. So I think we have everything set up correctly. Let me know if anything sounds incorrect though.

The problem is basically fixed now though. It turned out that the connector software needed to be reinstalled. Apparently there had been an update to it or something. It fixed the problem except that they only updated the version on our terminal server (we use Citrix) and not on the SQL server so that caused another problem. Whenever I would do a remote desktop connection to SQL and get in to GP as "sa" when no other users were in, it would want me to re-install Avatax. And then I would have to run the installation wizard again when logging in through Citrix. Turned out this was due to having two different versions. Now they've re-installed the Connector software on our terminal server and our SQL server, but we're running into other issues that I'm not sure if they are a coincidence or if they are related. For example, any list that has Business Analyzer makes GP go haywire when logging into GP through Citrix. The same list is fine when going into GP on SQL. And today I saved a smart list as a favorite (to user id) and set a reminder and GP completely shuts down. I can't log in because it shuts down immediatley, regardless if I'm going through Citrix or SQL. I log in as 'sa' and it is fine. And it doesn't seem to be happening to anyone else (thankfully). I've got an email out to Avalara about it. These two issues weren't happening prior to the re-installation, so I can't help but think it is somehow related. I've also noticed that address validation isn't working when we save an address even though I have it set to do that in the Configureation. Also, everytime we print an edit list in Sales, we get a message about recalculating tax amounts. I think I will try running check links tonight and see if it helps. Thank you for the suggestion. Also, I did notice some settings that I don't remember seeing before. Do either of you know if these are new to the Tax Calculation Options?

AvaTax integration for Receivables Transaction Entry

Tax Amount Adjustment functionality via Receivables Transaction Entry

Enable Item Tax Option Override - Sales Transaction Entry

If either of you have any issues like the ones I described above and know of anything that would help, please let me know!

Thanks!

Was this reply helpful? Yes No
Suggested answer

JodeRuiter User Group Leader on at

Like (0)

Report

I was able to get past this error by using Line Sequence numbers in my source data and mapping that sequence number in both the SOP Lines and the SOP Tax Lines. Header level taxes set to 0.

Was this reply helpful? Yes No