Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

no tax schedule or detail exists

(0) ShareShare
ReportReport
Posted on by 110
Hi We have an error message in the GL Transaction Edit List, Error: " no tax schedule or detail exists for one or more distributions" There was no problem previously but it happened suddenly, we tried to run check links and also verified the Tax schedule setup but it didnt help. Please suggest if any one has a solution. Thanks Krishna

*This post is locked for comments

  • Krishna M.Bhupathi Profile Picture
    Krishna M.Bhupathi 110 on at
    Re: no tax schedule or detail exists
    Hi Dencio Thanks for your help on this, it is now solved. We found that one tax schedule has been accidentally deleted by the user while there are some unposted transactions in the batch, due to this even though we create a new batch or new transaction with new tax ID and run the edit list GP is validating for all transactions and throwing the error. We created the deleted tax ID then there is issue. As you mentioned probably this is the issue in GP. It would be good if GP dont allow user to delete the Tax Details Card when there are transactions posted or unposted. Best Regards Krishna
  • Dencio Profile Picture
    Dencio 2,172 on at
    Re: Re: Re: Re: Re: no tax schedule or detail exists

    Hi Krishna,

    Just to be sure, is this happening also even in new journal entry saved in a new batch?  (Please observed while creating this entry whether Tax Entry window will pop-up and fill-in the details)

    Please ensure that all records in GL10300 has Tax Detail ID.  There is a bug in the validation of this table which I need to report to Microsoft.

    Cheers,

    Dencio

     

  • Krishna M.Bhupathi Profile Picture
    Krishna M.Bhupathi 110 on at
    Re: Re: Re: Re: no tax schedule or detail exists

    Hi Dencio,

     Since I need to calculate Taxes in GL Journals I can not disable this option. I have tried disabling and enabling back and tried to print edit list. Also I have tried entering a new transaction, still I am getting the same error.

     I have checked GL10300 table and verified rows which are captured correctly for GL Journal which I have entered.

    Do you think there any option that I can use under Maintenance-->SQL to troubleshoot or any other option to try out?

     Thanks for your help.

    Regards,

    Krishna

  • Dencio Profile Picture
    Dencio 2,172 on at
    Re: Re: Re: no tax schedule or detail exists

    Hi Krishna,

    Assuming you enable the Calculate Taxes in General Ledger (Microsoft Dynamics GP>>Tools>>Setup>>Company>>Options) and this is occuring to all journal entries saved in batch (old transactions and new transaction), then your General Ledger Tax Work (GL10300) table structure is corrupted.

    Otherwise, just disable the options I mentioned above (Company>>Options) and everything in GP should be fine.

    Let me know how it goes!

    Cheers,

    Dencio

     

  • Krishna M.Bhupathi Profile Picture
    Krishna M.Bhupathi 110 on at
    Re: Re: no tax schedule or detail exists
    Hi Dencio Thanks for your reply, please take note of the following: 1. This happening for all the unposted transactions in GL Journals, there are about 30 journals unposted, the error is occurring for all. 2. We tried creating new Tax ID with new transactions but still the same error exists. 3. This is not happening for SOP, AR and AP modules transactions. Only in GL. 4. We tried check links on Company, Sales Tax/Purchase Tax, Financial transactions work . No change the error still exists. Please advice if any suggestions. Best Regards Krishna
  • Dencio Profile Picture
    Dencio 2,172 on at
    Re: no tax schedule or detail exists

    Hi Khrisna,

    Is this occuring to all unposted journal entry or to only few?

    If this is occuring to only one journal entry, I would recommend to just delete and recreate it again.

    The tax details assigned to the tax component of that entry may have been corrupted.  This is assuming you enable the Calculate Taxes in General Ledger.  Otherwise, let us know so we can assist further.

    Cheers,

    Dencio

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,904 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,605 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans