Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

no tax schedule or detail exists

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
  • 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

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,263 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,112 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans